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
-
Client is able to view the output of HCM Extract run by other users?Customer Problem Description --------------------------------------------------- Problem Summary --------------------------------------------------- Client is able to vi… -
Can We Write With Clause in oracle HCM Extract filterSummary: Hi, Can we write 'WITH CLAUSE' in HCM Extract Filter? Content (please ensure you mask any confidential information): Version (include the version you are using,…
-
After 24A patch upgrade our HCM Extracts (Payroll Custom Extracts) are running long time.Hi All, After 24A patch upgrade our HCM Extracts (Payroll Custom Extracts) are running long time. Before patch it was completed in 5 mins now its running more then 6hrs.…
-
Changes only HCM extract parameter to be available in XML even when there is no data changeSummary: We have a requirement where extract takes an input parameter - Email ID. When the extract completes running the file has to emailed to the email ID in parameter…
-
Supervisor Hierarchy in Extract ruleSummary: Supervisor Hierarchy in Extract rule Content (required): Can someone share the sample fast formula to get Supervisor Hierarchy in Extract rule ? Version (includ… -
Changes only extract is giving the full employee data along with the changed personSummary: I have created an extract but when I am running the extract in changes only mode it is giving me the full employee data rather than changed only data. Any help …
-
HCM Extract Notification - Email Generic User AccountSummary: Hi, We have a requirement for a HCM extract to email a generic 'service user' user account when the job fails in error or warning. The generic user does not hav… -
Need simple query to fetch all the active positions created in cloud without position treeCan anyone help me to modify the filter criteria of oracle delivered EPBCS_Position_Metadata_2002 extract to fetch all the positions without position tree. Current filte…
-
How to Schedule Extract on last day of the every month using Flow Schedule Fast formulaHi Team, We need to Schedule the Extract using flow Schedule fast formula on last day of Every month.Any one has formula to achieve this requirement as we need to consid…
-
PER_EXT_EMAIL_ADDRESSES_UE need primary emailWe need help in achieving the below filters using HCM extract. HCM extract current scenario: Employees/contractors with Work email will be pulled. What we need is: to pu…
-
SPECIAL_CEILING_STEP_ID is not getting populated in the assignment tableHi, We have a fast formula in the extract, and the SQL query is: SELECT * FROM PER_ALL_ASSIGNMENTS_M WHERE SPECIAL_CEILING_STEP_ID is not null AND ASSIGNMENT_NUMBER LIKE…
-
Adding new attribute to existing changes only extractSummary: Adding new attribute to existing changes only extract leads to full volume run Content (please ensure you mask any confidential information): Hi Team, Greetings… -
Changes Only Extract is not Picking up New Hires , Terminations and Changes for Some RecordsSummary: Changes Only Extract is not Picking up New Hires , Terminations and Changes for Some Records. Can any body give some Inputs to debug this and what could be the … -
Inbound interface issue 24CHI Experts, After 24C patch upgrade in our instances we tested inbound interfaces what we saw is after all the steps completed (2/2) the generated HDL is failed to load … -
Deleted objects in Assignment Supervisor via HDL cannot be retrieved in the HRC_EVT_OBJ_CHANGES_UEHello Experts, We have created an HCM extract that make use of the HRC_EVT_OBJ_CHANGES_UE to extract the deleted object details. We do not use any of the event object ch…
-
HCM Extract reference root data group attribute in child nodeSummary: I have a custom extract to pull payroll balance for employees. It has 2 data groups. The first data group has balance values and child data group has employee d…
-
UE to fetch Department GL Code along with employee's department nameI have a requirement to fetch GL Department code along with employee department in a HCM extract. I am using the PER_EXT_PAY_EMPLOYEES_V2_UE user entity for department a…
-
Benefits Extract listing dependents once for each enrollmentSummary: I am using the HCM Extract to create a file for Blue Cross Blue Shield. BCBS uses the 834 format which requires that the dependent biographical data is only lis…
-
How to tune archive step in Extract RunSummary: How to tune archive step in Extract Run Content (please ensure you mask any confidential information): Hi Team, Greetings! We have been observing the slowness o…
-
Set Custom Context Values for Child UESummary: Content (please ensure you mask any confidential information): Hi team, On an extract with the structure as below, I'd like to understand if there's a way to ov…
-
HCM Extract Department Details-Past, Future, and Current Dates(PER_EXT_SEC_HISTORY_ORGANIZATION_UEWe have to create an HCM extract that extracts department details created either past-dated, future, or current dates, and these should be picked in each incremental run…
-
Changes only Extract is not Picking up Terminated Employees New Hires and Promotions and TransfersSummary: Changes only HCM Extract is not Picking up some Terminated Employees, some New Hires and also some Promotions and Transfers. Please advise what could be the roo…
-
I am looking for the UE and DBI for pulling Period name from the Person Results Page.I am looking for the UE and DBI for pulling Period name from the Person Results Page. Thanks in Advance!
-
Unable to add "Job Title" to Run deduction payroll flow.Summary: Unable to add "Job Title" to Run deduction report in HCM payroll flow. Created a FF to extract the job title and added this to the HCM Extract "Run Deduction Re…
-
Unable to get the values of pension scheme details for the employees enrolled through PAE processWe are unable to get the pension scheme details (Pension Scheme Name, Pension Scheme Joining Date, Pension EE and ER percentages) for the employees who are automatically…
-
Extract Definition: Difference Between Extract Attribute and Normal AttributeHi Experts, I am creating a Change Only Extract Definition to pull some basic assignment/personal information. Does anyone know what is the difference between Extract XX…
-
PER_EXT_PAY_EMPLOYEES_V2_UE won't retrieve INACTIVE person information regarding salary informationSummary: Hello, Customer Connect! I had developed an HCM Extract that fetch employee data such as some person/assignment information(person_name, assignment number, lega… -
User Entity and Data Base item for getting Period Name from person results page after a payroll runPlease help me with the User Entity name and Data Base item for getting 'Period name' from person results page after a payroll run in an extract. Please find the screen …
-
Sending non top of stack records and later using ExtractsSummary: In the event of a change, looking for the extract to send the changed assignment and later records. Content (please ensure you mask any confidential information…
-
How to define a custom role to integrate with EPM CloudSummary: Customer is looking for the minimum set of duties and privileges required to integrate with EPM Cloud. Published documentation suggests the Human Capital Manage…