Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Need SQL to extract Individual Compensation entries prior to approval
Summary:
Need SQL to extract Individual Compensation entry values prior to Approval
Content (please ensure you mask any confidential information):
We need to report on Individual Compensation Entries when submitted (prior to Approval). These are not stored in any tables since this is prior to approval. These entries are in the XML_DATA_CACHE column of the HRC_TXN_HEADER table. I am looking for a SQL to extract these individual compensation entries (screen entry values for different input values) using the utility package call per_bipntf_utility
Version (include the version you are using, if applicable):
Oracle 25B
Code Snippet (add any code snippets that support your topic, if applicable):
Tagged:
0