Data Models
Discussion List
-
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…
-
Identifying appropriate user entity to use for HCM extractSummary Looking for guidance regarding identifying the appropriate user entity to use for a HCM extractContent Hi Looking for guidance regarding identifying the appropri…
-
Need HDL to load results of a BI report regularlyContent Hi, Is it possible to schedule an HDL ran regularly, wherein the file it processes is the output of a BIP report that is sent over to webcenter? I have seen this…
-
Need table name which store the fields : Threading Database item, Root Data Group and Threading ActiSummary Need table name which store the fields : Threading Database item, Root Data Group and Threading Action.Content Need table name which store the fields : Threading…
-
CSV Extension File from HCM extractSummary CSV OutputContent Team, Could someone please let me know if we can generate CSV from HCM extract using XSL template ? I did refer one document from Oracle CoE bu…
-
Use of :flowInstanceName PARAMETER6 Output File Name - in Bursting SQL of globalReportsDataModel?Summary Use of :flowInstanceName PARAMETER6 Output File Name - in Bursting SQL of globalReportsDataModel?Content Hi forum: We would like to pass the :flowInstanceName to… -
UCM Tables listSummary UCM TablesContent Hi Iam looking for UCM table names. One of the requirement is I wanted to see where employee pictures are stored in UCM tables and if it can be…Naveen Jayaraman-48236 174 views 6 comments 0 points Most recent by User_2025-02-05-02-13-33-765 HCM Integrations -
HCM Extract Office Hours Session on Payroll Costing pleaseSummary Session covering how HCM Extracts be used to provide Payroll Costing information pleaseContent Please can you hold an HCM Extract Office Hours session on how to …User_2025-01-29-20-31-56-400 56 views 8 comments 0 points Most recent by Raghavendra M HCM Integrations -
Passing parameters to BIP from Inbound HDL FF - or- passed from UDT table valuesSummary Passing parameters to BIP from Inbound HDL FF - or- passed from UDT table valuesContent Hello Forum: Follwing this approach i posted the original note from SM. A…
-
MAIN HCM SQL with 2 UDT columns (Nested JOINs)Summary MAIN HCM SQL with 2 UDT columns (Nested JOINs)Content Hello Forum friends:My goal is to have one line per Person_number and am successful with a couple of record…
-
SQL Join of HCM and UDT tables togetherSummary SQL Join of HCM and UDT tables togetherContent Hello: How can i create a SQL join of HCM and UDT tables together in a BIP report? Can i and do i have to use this…
-
PER_EXT_PERSON_ADDRESSES_UE not fetching address of type 'MAIL' but its fetching address of type 'HOSummary PER_EXT_PERSON_ADDRESSES_UE not fetching address of type 'MAIL' but its fetching address of type 'HOME'Content I am building hcm extract with Assignment UE as ro…
-
Dynamic File Name and Bursting output using HCM ExtractContent Hello Everyone, I am creating an HCM Extract for the employee element entries. My requirement is to split the output file based on a flexfield attribute present … -
HSDL error "The values ****,****,Reason aren't valid for the attribute InputValueId.Content Hi All, I am trying to load a basic element with 2 values Amount and reason. Now when I create an HSDL with the only Amount as input value it works. Now I try to…
-
Can we modify standard process "Make EFT Payments" in fusion?Summary Can we modify standard process "Make EFT Payments" in fusion? we need to add some fileds so want to understand if we cand modify and what is the data source link…
-
BI Publisher SOAP error: FailedAuthentication : The security token cannot be authenticated.Summary Problem trying to run RunReport operation.Content Hi everyone, I'm testing an HCM Cloud report call using the BI publisher web service: https://[YourDomain]/xmlp… -
Using payroll flow to run BIP report that has an excel input fileSummary Using payroll flow to run BIP report that has an excel input fileContent We have created a BIP report that makes use of a RTF template style sheet. The underlyin…User_2025-01-25-04-02-13-126 41 views 7 comments 0 points Most recent by User_2025-01-25-04-02-13-126 HCM Integrations
-
How to execute the PLSQL in Oracle cloud HCM?Content Hi, How to execute the PLSQL in Oracle cloud HCM: https://oraclecloudhcmtechfunc.blogspot.com/2020/06/how-to-execute-plsql-in-oracle-cloud-hcm.html Thanks Sainath -
HDL PayrollInterfaceInboundRecord.dat issue with deriving TimePeriodIdSummary HDL PayrollInterfaceInboundRecord.dat issue with deriving TimePeriodIdContent Hi experts, We are using PayrollInterfaceInboundRecord.dat to load external pay res…Volodymyr Faranosov 98 views 4 comments 0 points Most recent by Volodymyr Faranosov HCM Integrations -
Regarding the Loading of Involuntary deductions using HDLSummary Loading using HDL for Involuntary deductionsContent Hi Everyone, I am trying to load involuntary deductions for US LDG and receiving the "Logical date error" (as…
-
HCM Extract Error when changing RTF TemplateSummary HCM Extract Error when I uploaded a new rtf templateContent Hi all, I am working on a HCM extract with RTF template (excel output) and using seeded globalreports…
-
Data Exchange Screen not working in 19CSummary Data Exchange Screen not working in 19CContent Data Exchange Screen not working in 19C. No matter what I type in the search box nothing appears and I can't impor… -
How to create custom XML extract output?Content Hi, Can someone help me on custom XML output format for HCM extracts? We have multiple data groups in the extracts. How do we customize the XML ? Or how can use …Nivya Mathire 84 views 19 comments 1 point Most recent by User_2025-01-28-00-10-14-788 HCM Integrations -
Location Tables PER_LOCATION_DETAILS_F_TL & PER_LOCATIONS are not in SyncSummary When Update a Location, Locations Tables are not in SyncContent I have added a Location , below table are same Location Code . When I update manually then Locati…
-
HDL Error capturingSummary HDL Error capturing in Co-existence modelContent I am into a co-existence Model with PS and HCM Cloud - while we are leveraging HDL Toolkit to send dat files and…User_2025-02-05-00-01-16-603 106 views 5 comments 1 point Most recent by Mani P-Oracle HCM Integrations
-
Person Business ObjectSummary I need to migrate the existing employees from the legacy system to the Oracle HCMContent As mentioned in the summary, I am in the process of testing the upload o…