Approval history SQLSELECT txnd.transaction_id, txnd.status, txnd.state, txnd.created_by, txnd.creation_date, txnd.last_update_date…Dec 27, 2024Dec 27, 2024
List the various ESS Jobs for HCM SecurityIn Oracle HCM Cloud Implementation, when there is a new job role, data, or security profile modification, several Enterprise Scheduler…Sep 1, 2024Sep 1, 2024
Allocated Journey -SQL QuerySELECT DISTINCT PAPF.person_number, ACT.checklist_name, ATT.task_name, CASE WHEN AC.checklist_status = ‘COM’ THEN ‘Completed’ WHEN…Dec 1, 2023Dec 1, 2023
Steps to Retrieve Document Records Attachments using REST and SOAP ServicesFor demo purpose, loaded Birth Certificate type document for a fictitious person in the Fusion as shown below:Aug 4, 2023Aug 4, 2023
How to format data in HCM Cloud using Autocomplete RulesWhen entering data into a field, the ability to format or validate the data string from the user is required. Examples could be:Aug 4, 2023Aug 4, 2023
ORC: Fast Formula — Calculate a rescaled test score based on raw score and exam weightBelow is the Fast formula I have developed to calculate a rescaled test score based on raw score and exam weight and dispositioning the…Aug 4, 2023Aug 4, 2023
SQL to extract Assessment Data from Oracle LearningBelow is the SQL which I have developed and can be used to create a data model for BIP report to extract the Assessment Data.Aug 4, 20231Aug 4, 20231
How to Revoke User Access to Seeded OTBI Content in Oracle HCM CloudUsers have the ability to revoke user access to shared folders and their underlying seeded content by eliminating any of the folder…Aug 3, 2023Aug 3, 2023
ORC: Fast Formula to Reject internal candidate from specific BU— — Fast Formula declares three variables: l_candidate_id, l_business_unit, and l_rejected_bu. — — The l_candidate_id variable is used to…Jul 15, 2023Jul 15, 2023