Data Models
Discussion List
-
Legal Reporting Unit Registration NumberSummary: Query to get Legal Reporting Unit Registration Number of a Legal Entity? Thank you! Content (please ensure you mask any confidential information): Version (incl… -
Adding BIP report in custom resource alerts message bodySummary: Hi Everyone , We have a requirement to add a BIP report in custom Alerts message body. Please let me know if there is any possibility. Content (please ensure yo…L.G.M Manikanta 4 views 1 comment 0 points Most recent by Deaconu Constantin Valentin-Oracle Human Capital Management -
Get Business Unit Name using PER_EXT_SEC_HISTORY_ASSIGNMENTS_UETeam, We have created an extract and using PER_EXT_SEC_HISTORY_ASSIGNMENTS_UE. Attributes: Business_Unit_ID - Extract Historical Assignment Business Unit ID (DBI) Busine…
-
a way to add additional person numbers to PER_EXT_SEC_PERSON_UE filter AND w/ SQLSummary: Hi forum: Cannnot remember SQL syntax to APPEND additional person numbers to PER_EXT_SEC_PERSON_UE filter without using 'IN' clause so extract XML file breaks o…
-
With Root = Person DG or Assign DG to get Comp DG ( to get Comp DBIs from PER_EXT_CMP_FEED_PLAN_UE)Summary: Hi forum Looking to pull these DBI attributes into /add to HCM Extract where root DG = 'PER_EXT_SEC_PERSON_UE' Or Assignment DG 'PER_EXT_SEC_ASSIGNMENT_UE' belo…
-
HCM Extract - Need help to get 'Previous' Job code / Job name SQL for VS/FFSummary: Hi I need to add these 2 columns in an HCM Extract (Assignment DG) that is sub to Person DG, Work Relationships, Work Terms hierarchy above Assignment DG Lookin…
-
Facing issue while configuring E-mail PayslipSummary: I'm facing issue while configuring Payslip through E-mail. I have copied the seeded data model and payslip report. When i tried to create a delivery option in P…Rahul Saini 1 view 0 comments 0 points Started by Rahul Saini Payroll and Global Payroll Interface (GPI)
-
How event changes being tracked in HCM cloud HRC_EVT_OBJ_CHANGES table?Summary How event changes being tracked in HCM cloud HRC_EVT_OBJ_CHANGES table?Content Hi Team, Am trying to understand how an event change is being tracked in Oracle HC…
-
How to populate multiple time event attributes within the REST API timeEventRequestsSummary How to populate multiple time event attributes within the REST API timeEventRequestsContent Hi gurus, I faced an issue with populating multiple time event attrib… -
Need help with Loopback IntegrationsWe are exploring the option of "Loopback Integration" previously known as "Inbound Interface" which got decommissioned since 22B. We have received a step by step guide f…
-
Get employee information that has been modified since a specific date using SQL queriesSummary: Get employee information that have been modified since a date by using SQL queries and not API nor ATOM fields. Content (please ensure you mask any confidential…
-
Adding a Common Sequence to Filename in Bursting Report Triggered via ESS JobHi everyone, I'm working on a bursting report in Oracle that generates filenames with a date and timestamp, like Grade_01012024_928282.csv. I have two different reports …
-
Replace Grade in a Job Code using job.dat HDL loadSummary Replace Grade in a Job Code using job.dat HDL loadContent I want to replace a grade in an existing job code using HDL. Below is a sample. I want to replace E04 w… -
How to Display current TIME STAMP in HCM extract that Uses an eText Template to generate the fileSummary How to Display current TIME STAMP in HCM extract that Uses an eText Template to generate the fileContent Hi Experts, Can anyone please help me as to how to displ… -
Can we burst multiple templates in BI Publisher?Summary Can we burst multiple templates in BI Publisher?Content Hi Team, I have a requirement where I am having two different templates based on a single data model. Eac…
-
Want to do a Bulk update on Work Email to stop notifications or Data Masking reasonsSummary NOT Licensed for data masking want to update email address for everyone please use this sql to create a HDL file and import into HCM.Content Here you go! select … -
Using SUM function in Table Type Value setContent I am trying to perform the SUM function in a Table Type value set, but it is not fetching results. I have tried various ways like using inline query in the ID Co… -
Debug HCM Extract - Extract Rule Type Attribute (Fast Formula - Without DBI)Content Hello, the use of pending workers requires us to update to an existing HCM Assignment Extract. Currently we use the DBI PER_PERSON_ENTERPRISE_HIRE_DATE. However …
-
Create direct depositSummary Create direct deposit report to third party banksContent Hi All, I am looking to send create direct deposit deposit file that gets generated as part of payroll r…User_2025-01-30-18-22-06-612 43 views 4 comments 0 points Most recent by Hardik_User2023 HCM Integrations -
Need inputs to find the Report Name/HCM Extract Name based on the Bursting emailSummary: Need inputs to find the Report Name/HCM Extract Name based on the Bursting email Content (required): We got bursting email notification but we need to know on w…
-
Reverse Termination - Comments stored?Summary: Reverse Term Comments for custom report Content (required): Which HCM table stores Comments from Reverse Termination UI Version (include the version you are usi…User_2025-02-12-15-41-59-245 22 views 1 comment 0 points Most recent by Rambabu Laveti-Oracle HCM Integrations
-
HCM Extract failure notification email content customizationSummary: Is it possible to customize the HCM extract failure notification email content? Content (required): We have a requirement to customize the HCM Extract failure n…Venkateswaran Murali-Oracle 33 views 0 comments 0 points Started by Venkateswaran Murali-Oracle HCM Integrations
-
Table Info Alert Composer NotificationHello everyone, we need to see the history of when notifications created with Alert Composer have been changed, does anyone know if there is a table where this informati…User_2025-02-07-06-30-13-200 254 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Sample HDL or Spreadsheet file for Competency Talent profileContent Does any body have any dat file or sample file for Competency load in talent profile ? We are trying to load competency to Talent profile but it not working. We … -
Need Connection/Join between Business Unit and Legal Employer User EntitySummary: Grouping and summation by Legal Entity and Business unit I am trying to develop a Payroll Balance related HCM Extract where I need to group the data based on Le… -
HDL for Terminate and Re-HireSummary We have a requirement to Terminate & Re-Hire An Existing EmployeeContent We have a requirement to Terminate & Re-Hire An Existing Employee with All The Details E…
-
LTRIM Function in eText templateSummary LTRIM Function in eText templateContent Hi Experts Select LTRIM('0012345', '0') from dual; is working as expected and result '12345' in BI Publisher Data Model. … -
HDL Questionnaires with Conditional Questions failsContent Hi all, I have been loading questions with HDL to Fusion which in the main works but fails when I have conditional questions and answers. The Oracle documentatio… -
HCM Extract: How to generate custom file extension like file_name.xyz?Summary HCM Extract: How to generate custom file extension like file_name.xyz?Content hi All, I need to generate output from HCM extract with custom file extension. Curr…
-
Procedure Element in HCM ExtractContent Can anyone explain what is a Procedure element and where I can see the list of PROCEDURE ELEMENT? And any white paper introduces how PROCEDURE ELEMENT works? Ver…