SQL Query to get the type of supervisor or manager created in the system
Select * from HR_LOOKUPS WHERE LOOKUP_TYPE = 'PER_SUPERVISOR_TYPE'
SQL Query to get the Department name and Assignment number
select pd.name department_name , paaf.assignment_number from per_all_assignments_m paaf , per_departments pd where pd.organization_id(+) = paaf.organization_id
Get the number of days excluding weekends using SQL
SELECT COUNT(*) FROM ( SELECT TRUNC(SYSDATE,'MM') + LEVEL - 1 AS day FROM dual CONNECT BY LEVEL <= ADD_MONTHS(TRUNC(SYSDATE,'MM'),1) - TRUNC(SYSDATE,'MM')
SQL to find the manager and their direct reportees
select papf_Reportee.person_number, to_char(pasf.EFFECTIVE_START_DATE,'yyyy/dd/mm') start_dt_spr from per_all_people_f papf, per_All_assignments_m paam, PER_ASSIGNMENT_SUPERVISORS_F pasf,
Database table where learning community members are held
The members are stored in WLF_ASSIGNMENT_RECORDS_F table where all other course/offering/specialization assignments are kept.
SQL Query to get the department hierarchy
WITH ORG_TREE AS ( SELECT /*+ materialize */ DISTINCT * FROM ( SELECT ( SELECT p.name FROM hr_all_organization_units_vl p WHERE p.organization_id = ot.parent_organization_id AND rownum = 1
How to identify the Seniority Date Version
SELECT SeniorityDateSetUp.seniority_date_code, HcmLookup.MEANING,SeniorityDateSetUp.SENIORITY_VERSION FROM fusion.per_seniority_dates_setup SeniorityDateSetUp, fusion.HCM_LOOKUPS HcmLookup
For List of Bank Branch and bank name, branch number & Swift Code
SELECT BANK_BRANCH_NAME, BANK_NAME, BRANCH_NUMBER , EFT_SWIFT_CODE FROM CE_BANK_BRANCHES_V WHERE BANK_HOME_COUNTRY = 'GB' ORDER BY BANK_NAME, BANK_BRANCH_NAME
Query to get the List of Bank Name
SELECT BANK_NAME FROM CE_BANKS_V WHERE HOME_COUNTRY = 'GB' ORDER BY BANK_NAME
Query to get the List of Grades and codes
SELECT PG.GRADE_CODE , PGT.NAME FROM PER_GRADES_F_TL PGT, PER_GRADES_F PG WHERE PGT.SOURCE_LANG = 'US'
Query to get List of Positions with all the required details
SELECT HAPFT.NAME , (SELECT HOUFT.NAME FROM HR_ORGANIZATION_UNITS_F_TL HOUFT, HR_ALL_ORGANIZATION_UNITS_F HAOU WHERE HAPF.BUSINESS_UNIT_ID = HAOU.ORGANIZATION_ID AND HAOU.ORGANIZATION_ID = HOUFT.ORGANIZATION_ID
Build the BI report for performance rating and comment provided by employee and line manager
Select distinct papf.person_number, ppnf.FULL_NAME Employee_name, ppnfm.display_name appraiser_name,
Build the BI learning community report
SELECT (Select MEANING from fnd_lookup_values_tl where LOOKUP_CODE = asg.status and LOOKUP_TYPE = 'ORA_WLF_ASSIGN_RECORD_STATUS') status, offical_email.email_address Email,
Identify Active Job Codes using SQL Query
SELECT JOBS.JOB_ID, JOBS.EFFECTIVE_START_DATE, JOBS.EFFECTIVE_END_DATE, JOBS.JOB_CODE, JOBS_TL.NAME,
SQL Query to get the profile code, content type name, content type id, content section id and much more
SELECT HPB.PROFILE_CODE,papf.person_number,HRT_CONT_TYPE.CONTENT_TYPE_NAME, HRT_PROF_ITEMS.* FROM
Query to get the List of Job name and job codes
SELECT PJFT.NAME, PJF.JOB_CODE FROM PER_JOBS_F_TL PJFT , PER_JOBS_F PJF WHERE PJFT.LANGUAGE = 'US'
How can I get the attachment details of the files uploaded for a Document Record?
SELECT papf.person_number ,ppnf.full_name ,fdv.file_name ,fdv.dm_document_id ,hdpr.date_from ,hdpr.date_to FROM per_periods_of_service ppos
Get the List of username, person no, role name, role code, department
select distinct papf.person_number,pu.username,prdt.role_name Role_Name,prd.role_common_name ,dept.name Department from per_All_people_F papf, PER_USER_ROLES pur, per_users pu,
Get the count of person records those who don't have work email id
select COUNT(1) FROM PER_ALL_PEOPLE_F papf where papf.person_id in ( SELECT ppos.person_id FROM per_periods_of_service ppos )
Query to get the List of Legal Employer and Legal employer Organization id
SELECT hauft.organization_id, hauft.NAME, houcf.classification_code FROM HR_ORG_UNIT_CLASSIFICATIONS_F houcf,
Categories
- All Posts
- 01. Common for all modules
- 02. Questionnaire For Client
- Absence Management (DEFINITION)
- Absence Management (HDL Templates)
- Absence Management (ISSUES)
- Absence Management (REQUIREMENT)
- Benefit Management (DEFINITION)
- Compensation Management (DEFINITION)
- Compensation Management (FAQ)
- Compensation Management (ISSUES)
- Fast Formulas (FF)
- Global Human Resource (DEFINITIONS)
- Global Human Resource (FAQ)
- Global Human Resource (HDL Templates)
- Global Human Resource (ISSUES)
- HDL Templates (Data Loader)
- Human Resource Helpdesk (DEFINITION)
- Journeys (FAQ)
- Oracle Learning Cloud (DEFINITION)
- Oracle Learning Cloud (FAQ)
- Oracle Learning Cloud (HDL Templates)
- Oracle Learning Cloud (ISSUES)
- Oracle Payroll Cloud (HDL Template)
- Oracle Recruiting Cloud (DEFINITION)
- Oracle Recruiting Cloud (FAQ)
- Oracle Recruiting Cloud (ISSUES)
- Oracle Time and Labor (DEFINITION)
- Oracle Time and Labor (ISSUES)
- OTBI Report
- Redwood_Visual Build Studio_RWPHT (DEFINITION)
- Redwood_Visual Build Studio_RWPHT (FAQ)
- Redwood_Visual Build Studio_RWPHT (ISSUES)
- Spreadsheet Loaders (HSDL)
- SQL Queries (SQLQ)
- SQL Queries + HDL Template
- Talent Management (DEFINITION)
- Talent Management (FAQ)
- Talent Management (HDL Templates)
- Talent Management (ISSUES)
- Technical Contents (DEFINITION)
- Touchpoints (DEFINITION)
- Touchpoints (FAQ)