Data Models
Discussion List
-
Error while trying to use EXTRACTVALUE function on FILE_FRAGMENTSummary Error occurred in XML processing LPX-00229: input source is empty ORA-06512Content Hi Experts, I am trying to use EXTRACTVALUE function on a XMLTYPE and encounte… -
Unable to fetch changes only data in ExtractSummary Unable to fetch changes only in ExtractContent Hi, Can anyone please tell me what needs to be done here to fetch changes only data? I have ticked all check boxes…Aloka Bhattacharya 36 views 5 comments 0 points Most recent by Rachel Martorelli-Oracle HCM Integrations -
Need to use 2 stand-alone data groups in an extract without any connect clauseSummary Need to use 2 stand-alone data groups in an extract without any connect clauseContent Hi, We need to display the business unit details and location details in a …
-
PER_EXT_SEC_PERSO_UE is returning duplicatesContent Hi All, We have an interface where we are using PER_EXT_SEC_PERSON_UE as Root data block as well as we are also using threading on this data block. We have used … -
Extract Getting Into Error due the DBI 'Time in Current Job'Content Hello Everyone, Hope everyone is doing great! My requirement is to pull out the Job and Department Change Date Using HCM Extract. I have an extract based on the …
-
Generating Sequence Number for all active assignment of a person using Fast FormulaContent Hello All, We have a requirement where we need to generate sequence number for each active assignment record of a person through HCM Extract. We were thinking if…
-
Need Information on few HCM Extract Attribute fields!Content Hello All, Hope you all are doing great! I am working with HCM Extract and wondering if someone can provide few field's information related to HCM Extract Attrib…
-
Payroll Batch Loader Error ReportSummary Payroll Batch Loader Error Report with Line DetailsContent Hi, Can any one please share Payroll Batch Loader Error report if you have? I am building a report to …Visveswara Chemuduri 61 views 3 comments 2 points Most recent by Sricharan Monigari HCM Integrations
-
How to view reports by using schedule processContent Hi, How to view report by using schedule process I have tried catalog->edit->properties->enterprise schedule job definition name and package name have given.chec… -
Automating UDT uploadContent We have a requirement where we need to upload the data present in .csv format to the UDT in HCM Cloud. Is there a way by which we can automate this process? Can … -
Work Structure LoadingSummary Work Structure LoadingContent Can we load all the work structure .dat files together in one go. If we can than what name shoudl I give that file containing all t… -
Need to check if an employee is a Line Manager or notContent I have a requirement in HCM Extracts where I need to check if an employee is a Line Manage or not. I am using an Extract Rule Fast Formula to check if the employ…
-
Need HDL template for Skills & Qualifications & LearningContent Hi Guys, We are looking to record the completion of courses in either Skills & Qualification section of each employee or either through Learning. Would anyone ha… -
Needed .dat format in the outputContent I am using a HCM Extract for Integration and the requirement is to generate the output file with the extension as .dat . Can anyone please suggest if it is possi…
-
Termination HCM Extract Reassign Line ManagerSummary Extract Proposed Manager information for terminated extractionContent I am working on a Termination Work Relationship HCM Extract and would need to extract the P… -
HDL Integration Key Map TablesSummary HDL Integration Key Map TablesContent Hi Experts, Do anyone of you have a formal documentation with a step-by-step explanation of what happens and which all of t…
-
Way to find WorkTermsNumberSummary Looking for a way to find the active worktermsnumber on employees for HDL loadsContent Has anyone found a way to get the WorkTermsNumber for employees to use in …
-
Changes only behavior in ExtractContent Hello All, How extract is picking up the changes, is it according the effective of data or the last update date of the data? For Example: 1. Last update date 12/…
-
Advance Condition on Attribute level in ExtractContent Hello Everyone, I have never used Advance Filter Condition(Condition Action part before) so today I tried it out but it seems like its not working or I am using …
-
Integration with Ascentis PayrollSummary Looking for examples of where Oracle HCM Cloud is integrated with AscentisContent We have a customer who is looking to integrate with Ascentis payroll in the US.… -
HCM Extract - Extract Employee Contact Details when multiple contactsSummary HCM Extract - How to Extract Employee Contact Details when multiple contactsContent Hi In one of the HCM Extracts we are extracting Employee Contacts. The user e… -
HCM Extracts - How do i Write Decode in HCM ExtractsSummary HCM Extracts - How do i Write Decode in HCM ExtractsContent Hi I am working on HCM Extract where the template is xslt. I have some fields on which i need to tran…
-
Job to refresh workforce structure names and descriptions?Summary Is there a job that needs to be ran to refresh the names and descriptions of the different workforce structures after you load or update new values via FBL?Conte… -
Changes Only is not workingContent Hi All, I am facing a strange issue in the extract while running it. The extract is picking the full data even if I am running the extract in Changes Only Parame…
-
Is there any way to track changes made in the extract?Content Hi All, I was just wondering if there is any way to track the changed made in the extract from Oracle tables. I am facing issues in the tracking changes of the e…Puja Bharati-27866 81 views 1 comment 0 points Most recent by Naveen Jayaraman-48236 HCM Integrations
-
HCM Extracts by Business UnitSummary HCM Extracts by Business UnitContent Hi I am working on a HCM Extract where i need to extract the data for employees only from two Business Units. I have added t…
-
FBL error while attempting to load a ProfileItemSummary FBL error while attempting to load a ProfileItem: "You must provide a value for the attribute Evaluation Type."Content When attempting to load a Profile and a Si…
-
Getting Error (HR_6881_HRPROC_ORA_ERR ORA-06512)Content I have an extract where I had to write a fast formula to find out rehire date as per customer's requirement: The Formula which I have written is given below: ---…
-
HDL/HSDL Update for employee who has blank values in history rowSummary HDL/HSDL Update for employee who has blank values in history rowContent Hi Team, Earlier when we update/correct a mandatory field for employee using HDL/HSDL loa…
-
Do you want to Bulk update contact names of employee contacts?Summary Want to Bulk update contact names of employee contactsContent Hi I was helping on of our friends to correct the contact names of employee contact. Hope this woul…