-
-
HRHD – Unable to view worker in Resource Directory
For using workers in HRHD, they should be added as resources. However, there are certain cases post worker data load where the workers are not available in the resource directory to be added as resources. Check the below post on adding workers as resources: HRHD – Create Worker as Resource This is mainly due to…
-
HRHD – Create Worker as Resource
Post Worker HDL load, the workers should be created as Resources in resource directory so that they can assigned various HR Help Desk roles like Service Admin, Agents etc. Navigation to Resource Directory: N -> Others -> Resource Directory Click on view resources to view the already created resources or create a new resource: Click…
-
HDL – Sample File to Load Document Type Security Profile
Manage Document Type security profile can be used to define a security profile with a list of various documents tagged to it. The documents can either be included or excluded in this security profile. HDL can be used to mass create and update the document type security profiles. Check the below post on how to…
-
-
-
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…