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
-
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… -
Key considerations to decide BICC over HCM ExtractSummary: Dear Experts, I am looking for key considerations for us to decide to bulk extract the HCM data using BICC over HCM Extract? Thank you. Regards, Krishna Content… -
Multiple Extracts ending in error JBO-27123: SQL error during call statement preparationSummary: Multiple Extracts ending in error JBO-27123: SQL error during call statement preparation Content (please ensure you mask any confidential information): Hi Team,… -
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…
-
- You need to enter a valid data group hierarchy structure in the extract definition name.Summary: Created an HCM Extract with various data group one of which is a root data group and was able to connect properly the other data group. However, when I validate…
-
The route text for database item GLB_PAY_BAL_EXCP_PER_PAYROLL_RELATIONSHIP_ID is empty or too longI have a HCM Extract working good till last 2 weeks. Error: ORA-20001: The EXT_PAYROLL_RECORDS_300000020284428 formula can't be run because it isn't compiled. Details: A…
-
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…
-
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…
-
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…
-
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…
-
How to customise seeded Payroll Register Report for the Latest Process Extract?Hi All, Please suggest, The Business wants to add one Attribute in the seeded Extract i.e., Payroll Register Report for the Latest Process Extract. I have reviewed that …
-
SQL query to fetch employee details which are confidentialSummary: SQL query to fetch employee details which are confidential in Oracle cloud Content (please ensure you mask any confidential information): Version (include the v…
-
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…
-
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 … -
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…
-
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 … -
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…
-
HCM Position extract from EPBCS not generating records in HCM view extractWe have downloaded the HCM extract from EPBCS and uploaded the extracts to HCM. When we run data extract for Position in HCM, there is no data being generated in HCM. We…
-
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…
-
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…
-
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…
-
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…
-
Payslip is not sending to FTP through Payslip ExtractHello Team, Greetings of the day!! In seeded Payslip Extract, we have an additional delivery option which will send the Payslip XML data to FTP and it is working fine ea…
-
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…
-
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… -
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!
-
Are there user entities from HCM Extract that can be used to create Oracle learning ReportsSummary: Are there user entities from HCM Extract that can be used to get Person Learning details such course and offering and Completion, status etc. Content (please en…