-
-
-
Configuration – Using User Interface Text
User Interface Text is a tool provided with Oracle Fusion Applications which can be used to replace any words/sentences across the application. For example, you want to rename Worker to Employee, then you can make use of this tool. To make use of this tool, you have to first create a sandbox and then add…
-
Reports (BIP) – Main tables in Oracle Recruiting Cloud (ORC)
Below are some of the main tables and views in ORC: Table Name Description IRC_REQUISITIONS_VL Details of Requisitions and Requisitions Templates IRC_CANDIDATES Basic Details of Candidate IRC_SUBMISSIONS Information of Candidate Job Application HRT_POOLS_VL Candidate Pools Information IRC_DESCRIPTIONS_VL Information of Content Library Items IRC_REC_SEC_PROFILES Job Req secuirty profiles information
-
Reports (BIP) – Query to extract Manage Person Name Styles
Manage Person Name Styles is a task that can be used to configure additional Name attributes for a country if required. Also, a name component can be made required as per requirement. In multi country implementations, it is required to know the setup for technical developers as it is hard to check the setup for…
-
-
Approvals – Designing approval based on Probation Period
There is a common requirement for Resignation approval workflows where the approval is triggered based on a condition by checking whether the worker has completed the probation period or not. The probation end date attribute is not exposed in BPM. So it becomes little tricky to get the probation end date. In such cases, days…
-
Reports (BIP) – Query to get Content Item Details
Use below sample queries to get details of loaded/created content items like – Languages, Degrees etc. Query to get language details: Query to get Degree Details:
-
-
-
HCM Infolets – Enable HCM Infolets on Home screen (Part – 1)
HCM Infolets are hidden out of the box. These can enabled using configuration. Follow the below steps to enable HCM Infolets: Navigate to Configuration -> Structure: Click on “Go to the Manage Sandboxes Page” and click on Create Sandbox button. Give a name and choose ‘Structure’ and ‘Page Composer’ from available tools: And click on…
-
HDL – Load Goal Library Data
Goal Library is loaded as Content items using ContentItem.dat. The various attributes and their mapping can be found using GoalLibraryAttributes.xlsx which can be found on metalink using below note id: Query To Get Goal Library Goals (Doc ID 2228128.1) How to Load Library Goals (Doc ID 2201757.1) Please note that ItemText2 (Priority Code) and ItemText12…
-
HDL – Query to find sectionId for Talent Profile Item load
With enhanced profiles (v2), sectionId is a required attribute while loading the Profile Items to a worker’s profile. Section Id can be found using below query:
-
-
Value Set – Table Value set to get list of courses
*FROM Clause wlf_learning_items_f wlif, wlf_learning_items_f_tl wlift Value Attributes Table Alias *Value Column Name SUBSTR(wlift.name,1,150) Value Column Type VARCHAR2 Value Column Length 150 Description Column Name Description Column Type Description Column Length ID Column Name TO_CHAR(wlif.LEARNING_ITEM_ID) ID Column Type VARCHAR2 ID Column Length 40 Enabled Flag Column Name Start Date Column…
-
Value Set – Table Value set to get list of departments
Use below setup to create a table based value set which will show the list of all departments: *FROM Clause HR_ORG_UNIT_CLASSIFICATIONS_F HOCF, HR_ORGANIZATION_UNITS_F_TL HOUT Value Attributes Table Alias *Value Column Name SUBSTR(HOUT.NAME,1,150) Value Column Type VARCHAR2 Value Column Length 150 Description Column Name Description Column Type Description Column Length ID Column…
-
HRHD – Query to get Service Request Details
Use below query to get service request details from Fusion BIP: SELECT ssr.sr_id,ssr.title,ssr.problem_desc,to_char(ssr.open_date,’RRRR/MM/DD’) sr_opening_date,ssr.primary_contact_party_id,ssr.sr_number,ssr.status_cd,(SELECT flv.meaningFROM fnd_lookup_values flvWHERE flv.lookup_code = ssr.status_cdAND flv.lookup_type = ‘ORA_SVC_SR_STATUS_CD’AND flv.LANGUAGE = ‘US’) sr_status_meaning,ssr.severity_cd,(SELECT meaningFROM fnd_lookup_values flvWHERE flv.lookup_code = ssr.severity_cdAND flv.lookup_type = ‘ORA_SVC_SR_SEVERITY_CD’AND flv.LANGUAGE = ‘US’) sr_severity_meaning,sc.category_name category,sq.queue_name queue,to_char(ssr.last_resource_assign_date,’RRRR/MM/DD’) sr_last_resource_assigned_onFROM svc_service_requests ssr,svc_queues sq,svc_categories scWHERE ssr.queue_id = sq.queue_idAND ssr.category_id = sc.category_id–AND ssr.status_cd in…
-
-
Reports (BIP) – Query to get Adjustments in Absences
select papf.person_number,ppnf.full_name,absence_plan.name ,apaed1.value,apaed1.type,to_char(apaed1.procd_date,’DD-MON-YYYY’) processed_date,apaed1.created_byfrom anc_per_acrl_entry_dtls apaed1,ANC_PER_PLAN_ENROLLMENT apaed,per_all_people_f papf,per_person_names_f ppnf,(SELECT aapf.absence_plan_id, aapft.NAMEFROM anc_absence_plans_f_tl aapft,anc_absence_plans_f aapfWHERE aapft.absence_plan_id = aapf.absence_plan_idAND aapf.plan_status = ‘A’ — added to pick only Active Absence PlansAND trunc(SYSDATE) BETWEEN aapf.effective_start_date AND aapf.effective_end_dateAND trunc(SYSDATE) BETWEEN aapft.effective_start_date AND aapft.effective_end_dateAND aapft.language = ‘US’) absence_planwhere apaed.plan_id = absence_plan.absence_plan_idand apaed.plan_id = apaed1.pl_idAND ppnf.name_type = ‘GLOBAL’AND ppnf.person_id = apaed.person_idAND ppnf.person_id…
-
Reports (BIP) – Query to get Legislative Data group associated with Legal Entity
select ple.name legal_employer, pldgt.name legislative_data_groupfrom per_legislative_data_groups pldg,per_legislative_data_groups_tl pldgt,Hr_Organization_Information_F Psu_Inf,per_legal_employers plewhere 1=1and pldg.legislative_data_group_id = pldgt.legislative_data_group_idand pldgt.language = ‘US’and psu_inf.Org_Information_Context = ‘PER_PSU_PAYROLL_INFO’and psu_inf.Org_Information1 = pldgt.legislative_data_group_idand Psu_Inf.Organization_Id = ple.Organization_Idand TRUNC(sysdate) BETWEEN ple.effective_start_date AND ple.effective_end_date