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
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
HCM Extract
Discussion List
-
DELETE Work Pattern using HDLHi, Can someone share sample HDL file for deleting existing work pattern, shifts and breaks. Thanks -
HCM Extract for COBRA Benefits for Terminations not returning correct assignmentsSummary: HCM Extract using history enrollments UE is not picking correct assignment record for terminations. Content (please ensure you mask any confidential information… -
Only show a row when the Child Data Group retuns value for the rowSummary: Hello again! After the previous help on my Extract I find another issue on another. I need to make an extract that return information about a person and its enr… -
Locations Child Data Group returning records at unexpected eventsWe've a changes only extract to retrieve person, assignment data. In assignment DFF, we've utilized 1 for Site-location(Attribute1) which LOV is retrieved as internal_lo…
-
How to search for future approvers in an approval process in Oracle HCM Cloud by query?Good morning! How are you? I have a question, exists any VIEW objects or table (Im creating a bi publisher) that I can use to get the information of all the approvers of…
-
Remove duplicate rows in HCM ExtractSummary: Hello again, Customer Connect! I am developing an HCM Extract for retrieving Benefit data. Currently I am using these two UE: PER_EXT_SEC_PERSON_UE as Root BEN_…
-
Extract Error The payroll relationship action ID isn't valid.Summary: A system error ORA-20001: The payroll relationship action ID isn't valid. Contact your help desk. ORA-06512: at "FUSION.PAY_REPORT_BALANCE_GROUP", line 2462 ORA… -
Can we have Mail Triggers, once Extract has run successfully,Full Profile, Extract has been created to do HDL Upload Query : Mail trigger to happen once Extract has run to know how many cases have been failed.
-
Loading multiple attachments to Document of Record via HDLSummary: We regularly use HDL to bulk load Document of Records with attachments, but this time we want to include multiple attachment in one Document Of Record. When I t…
-
How to get Job offer details using HCM ExtractSummary: I have requirement to extract Job Offer Details like Offer Name, Designation, Person Name, Recruiter etc. using HCM Extract. Would like to Know How can we get H…
-
Performance Issue in Extract in HCM CloudSummary: Hi Folks, We're facing the performance issue in the extract even after the increase of Chunk size and thread size using payroll process configuration. I've trie… -
Changes Only Extract returns values in OLD fields when record is new.Summary: Changes only extract using only PER_EXT_SEC_ASSIGNMENT_UE as root group and returns values in the _OLD even though the record is new since last run. Content (pl…
-
Can I put " in the beggining and the end of an attribute value in the HCM Extract?Summary: I need to know if its possible to put an attribute value in a HCM Extract between " when it's a text attribute. For Exemple, if I have the attribute Full_Name I…
-
HCM Extract changes only with different parameterHi We have are requirement to create a changes only extract with legal entity parameter, so that customer will first load the data into 3rd party system for one legal en…
-
Email blocking problems? SPF SetupSummary: Hi, Are any other UK customers experiencing problems with emails from HCM being blocked recently? We are starting to get emails (delivered as part of HCM Extrac… -
What is the DBI for getting the latest payroll frequency start dateSummary: What is the DBI for getting the latest payroll frequency start date Content (required): Hi Team, Greetings! What is the DBI for getting the latest payroll frequ…
-
Request to provide the PVO and VO attribute name corresponding to the Fusion Table and ColumnHi Team, I need the column "Newly Separated Veteran Discharge Date" from to OTBI to FAW. I am trying to achieve it by Data Augmentation route by extending dimension. The…
-
Getting Job offer details in HCM ExtractsHello, I am trying to bring Job offer letter comments in an HCM extract as an attribute, but job offer comments does not appear anywhere in the core. Can anyone please s…
-
Report to show Employees serving Probation PeriodSELECT Command for extracting Employees that are serving probation period.
-
Migrate update to extract definitionHi Experts, We have a case where the report Extract Definition is already in production and has been used but we need to update the extract definition with additional de…
-
How to Create Custom User Entity for HCM ExtractNeed to create Custom User Entity for Custom HCM Extract, please provide your inputs on how to create custom UE.
-
Oracle HCM Extract Custom Schedule with Custom Effective DateHi, My requirement is to schedule payroll extract to run every 15th of the Month with Effective Date as 14th of that month, how can we achieve that? -
Moved: Balance value not showing in the - Statutory Deduction RegisterThis discussion has been moved. -
Need to identify the logic of seeded LookupVO in flow pattern -Run Type|RuntypeLookupVOSummary: WE need the table or Query to identify the LookupVO in flow pattern -Run Type|RuntypeLookupVO. Flow Pattern: Calculate Payroll Flow parameter -> Run Type: Run T…
-
can we add checklists completion status in hcm extract filtersIs it possible to add checklists filters in the hcm extract. Is there any user entity specific to checklists data or can we modify the user entities. we want to get the … -
Need query/Table details to fetch the Status details like the Number of a Task of Flow patternwe used the following query but its showing only the Total count, but not the details like success/error count . attached the screenshot showing the same. Query ===== SE…
-
What UE is Working Hours located?Summary: We are not able to find the field "Working Hours" in the UE's. We have looked at PER_EXT_SEC_ASSIGNMENT_BASIC_UE & PER_EXT_SEC_ASSIGNMENT_UE and cant find this …
-
Error on Submitting ExtractSummary: I created a Extract and when i submit it, it throws below error. Please find the screen shot. How to solve this? Content (please ensure you mask any confidentia…
-
-
Can we Use Deprecated UEs in HCM Extract?Hi, We are using PER_EXT_PAY_EMPLOYEES_UE UE in our HCM Extracts and in the latest Update this UE is deprecated so can we Use this UE or we need to change the UE to PER_…