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,
Query to get the List of Business Units and Business Unit id
SELECT hauft.organization_id business_unit_id, hauft.NAME, houcf.classification_code FROM HR_ORG_UNIT_CLASSIFICATIONS_F houcf, HR_ALL_ORGANIZATION_UNITS_F haouf, HR_ORGANIZATION_UNITS_F_TL hauft
Query to get the list of departments with department (organization id)
SELECT hauft.organization_id, hauft.NAME FROM HR_ORG_UNIT_CLASSIFICATIONS_F houcf, HR_ALL_ORGANIZATION_UNITS_F haouf, HR_ORGANIZATION_UNITS_F_TL hauft WHERE haouf.ORGANIZATION_ID = houcf.ORGANIZATION_ID AND haouf.ORGANIZATION_ID = hauft.ORGANIZATION_ID
How to identify in which environment rich media is enable by using SQL Query
select * from FUSION.ASK_DEPLOYED_APPLICATIONS where NAME in ('ORA_VIDSTORAGESERVICEAPP' ,'ORA_VIDTRANSCODINGSERVICEAPP', 'ORA_STREAMINGCONTENTDELIVERYAPP',
How to get the compensation plan id and option id using SQL Query
Go to Tools a Reports and Analytics a Click on Browse Catalog a Click on New a Select Data Model a click on + icon a select SQL Query a enter any name a select ApplicationDB_HCM a write the query in the SQL Query box a click on OK
How to get the active employees using SQL Query
Solution/Workaround We need to run the below query to get the require data
Categories
- All Posts
- Absence Management
- Absence Management - Issues
- Benefit Management
- Common for all modules
- Compensation Management
- Compensation Management - Issues
- Global Human Resource
- Global Human Resource - Issues
- Human Resource Helpdesk
- Oracle Learning Cloud
- Oracle Learning Cloud - Issues
- Oracle Recruiting Cloud
- Oracle Recruiting Cloud - Issues
- Talent Management
- Talent Management - Issues
- Technical Contents
- Technical Contents - Fast Formula
- Technical Contents - HDL Templates
- Technical Contents - OTBI Reports
- Technical Contents - Spreadsheet Loader
- Technical Contents - SQL Query
- Technical Contents - SQL-HDL
- Time and Labor
- Time and Labor - Issues