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
-
24A Parent Data Group Database Item not showingSummary: 24A Parent Data Group Database Item not showing instead I see a list of DBI in the current scope. Content (please ensure you mask any confidential information):… -
SWP Extract is not fetching the Parent Organization details for few of the Departments.Summary: Hi Team, SWP Extract is not fetching the Parent Organization details for few of the Departments. We are using standard user entity 'PER_EXT_SEC_ORGANIZATION_UE'. -
Where are the output files from HCM Extracts are stored and how to purge them?Summary: Content (required): Hi Team, I have an HCM Extract which delivers output to user email. However, when I open the HCM Extract results, I can download the attachm… -
Not able to view the files on UCM which are loaded in account hcm$/extracts$/export$Summary: Not able to view the HCM extract files on UCM which are loaded in account hcm$/extracts$/export$ Does the user need any permission/roles to view them on UCM. Pl…
-
Can we use Get_Abscence_Count formula function in extract rule?Hi All, We are trying to get the absence occurrences in an extract for that we are trying to build a extract rule using a formula function "Get_abscence_counts" but we a…
-
ASSESSMENT QUIZSummary: Need information of assessment name for Learning Assessment Quiz report. Content (please ensure you mask any confidential information): Version (include the ver…
-
PROGRESS AND COMPLETIONSummary: Need to know how to get PROGRESS AND COMPLETION PERCENTAGE for Learning activity progress report. Please show me what table, field or user entity to get Content…
-
LEARNER RECONCILIATION FOR INITIATIVE REPORTSummary: Need to know how to get learner reconcilation for initiative ongoing report in learning module. What table, field and user entity ? Content (please ensure you m…
-
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…
-
Extract Delivery Options - Warning after the 24D update.Hi, After the 24D update, a warning popped up: "Warning: You need to configure the same values for the Print Header Record, Delimiter, and Print Default Attributes field…
-
Issue in HCM Extract outputs retention period - files are not properly deletedSummary: Issue in HCM Extract outputs retention period - files are not properly deleted Content (please ensure you mask any confidential information): I am facing an iss…
-
Document of record - config ignored + inconsistent behaviourSummary: Document of record is attaching even though configuration states that document name is required and relevant. HCM Extract has an output item that points to a BI…
-
Replacing ASCII characters to Hyphen on the eText extractI'm using REPLACE(PER_LAST_NM,'''','-') and it's not working . I want this name O'Hara to be changed to O-Hara i want that Single Quote removed and change it to Hyphen .…
-
Delivery option to remove from Report Categories in HCM ExtractWe used to update end date thru "Advance Edit" in case of testing the extract data. With the effect of 24A I understand this option is not available. Refereeing the orac… -
HCM Cloud Export File Guide - Sailpoint IntegrationLooking for guidance on adding more attributes to a provided predefined template from Sailpoint to extract from Oracle HCM. The user entity we are using is PER_EXT_PAY_E…
-
I am getting this error while submit Extract definition in HCMSummary: I am doing HCM Integration for Workforce, as of that process I had downloaded my HCM Extracts from EPBCS instance and uploading in HCM Extract definitions, impo…
-
Using chunk size and threading to improve the Historical Assignment hcm extract performance issueSummary: I have created an HCM Extract for assignment that retrieves historical data for employees. There is no date filter, it picks up past, future and present.There a…
-
Extract gets stuck with few pending recordsSummary: Extract gets stuck with few pending records Content (please ensure you mask any confidential information): Hi Team, Greetings! We have been observing an issue w… -
Oracle HCM Extract, function XDO_SKIPROW not working in excel template with multisheetsI need to hide/skip some rows in each sheets with different conditions for each sheet. Instead i am using : XDO_GROUP_?XDOG2? but it is limited to 1 condition. What is…
-
connect User Entities PER_EXT_PAY_EMPLOYEES_V2_UE and PER_EXT_DEPARTMENT_TREE_UE in HCM ExtractsSummary: I am trying to connect Data groups of 2 User Entities PER_EXT_PAY_EMPLOYEES_V2_UE and PER_EXT_DEPARTMENT_TREE_UE in HCM Extracts to get employees' department hi…
-
I am creating an HCM extract in which my root UE is PER_EXT_SEC_ASSIGNMENT_BASIC_UE and the child daSummary: I am creating an HCM extract in which my root UE is PER_EXT_SEC_ASSIGNMENT_BASIC_UE and the child data group is PER_EXT_SEC_ASSIGNMENT_RANGE_UE and its child da…
-
Post 24C HCM extracts are not effectively multi-threadingExperts, We are observing a curious case when even after giving PROCESS CONFIG GROUPS with 16 and 32 threads, when actually subprocesses fire, almost all of them finish … -
How can I extract fields from the recruitment module? All the fields of the job application, job offHello, How can I extract fields from the recruitment module? All the fields of the job application, job offer etc... thank you
-
Issue with Seniority Date V3 entitySummary: We are are using the user entity PER_SENIORITY_DATES_V3_UE to get the enterprise seniority date and legal entity seniority date. At one point, we had to put a f… -
HCM Extracts - Split/chunk the HCM Extract output fileSummary: We have created a custom HCM extract, and the delivery option is of type XML. We are sending the output file to UCM. The file is huge and we need to split the f…
-
Hello experts, We have a requirement to rollback HCM extract for one or a set of employees.Basically the requirement is we need an utility/page with Person number and HCM Extract name as parameters and a button, on which when clicked it need to perform rollbac…
-
Output and Log Not in View Flows but count of Total records showing up new extractHello, I have created an HCM Extract from scratch and also associated a BI report with - globalreportdaramodel and post execution of Payroll flows, when I try to check f…
-
Associate Business unit with legal employer is not working as expectedSummary: Hi Team For one of our clients, we have 4 ledgers each with one legal employer and associated business unit. We have enabled "Associate business unit with legal…
-
Person E-Mail Address Database Item fetching Primary AddressSummary: We have a DBI Person E-Mail Address which fetches the Primary Email Address of the person but is there a DBI to fetch the Work Email of the person. I could not … -
How to add milliseconds to HCM extract file name in SFTP deliverySummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…