Data Models
Discussion List
-
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 … -
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…
-
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 … -
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…
-
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…
-
HDL for new hiringSummary I am looking for a HDL model to hire people in the systemContent Hi everybody, I am looking for a model file to hire people. We are implementing an RPA between O…Mathilde Mortelecque 71 views 6 comments 0 points Most recent by Misael Gutiérrez-Oracle HCM Integrations
-
Co-existence - Fusion to EBS R12Summary Co-existence - Fusion to EBS R12Content We are in process of implementing Fusion Core HR. Our Finance will stay in EBSR12. We need to send data from Fusion to EB…
-
Checking to see if a report or extract like this happensSummary Looking for a report at person level, to show balance total and element feeds for the balanceContent Looking for a report at person level, to show balance total …
-
Date filter - Format issueContent Hi, In my BI report I'm using guide me report editor, when i export it to excel I'm unable to filter year wise. Is there any other way to achieve this? I have at…
-
Traversing up the department hierarchy fast formulaContent I need to get the traverse up the department hierarchy using the fast formula in HCM Extracts Rule. Can anyone please share some light on this or a sample fast f…
-
develop an extract that captures the details of EMP as on effective date and also capture 2 years ofSummary develop an extract that captures the details of EMP as on effective date and also capture 2 years of history for only those employees who have been terminatedCon… -
Integrations ScheduleSummary Integration ScheduleContent Hi experts, please provide steps for canceling schedule of hcm extract integrations. And how do we check weather if BI Publisher Repo… -
HDL Error while loading DivisionsSummary HDL ERROR : A logical start date is required.Content Hi All - I tried loading Divisions using HDL. Majority of them were loaded but few of them were kicked out w…
-
Unable to compile HCM ExtractContent I am not able to compile the one of the record fast fast formula in HCM Extract. When I opened this fast formula in "Manage Fast Formula" section I saw it is giv…
-
HCM Cloud UserDetailsService findSelfUserDetails operation is returning no responseSummary HCM Cloud UserDetailsService findSelfUserDetails operation is returning no responseContent Hi, I'm doing PaaS ADF integration with SaaS HCM Cloud using page inte… -
Usage of interlocking Database item in HCM extractsSummary Usage of interlocking Database itemContent Can someone please elaborate on the usage of Interlocking Database item in HCM extracts?