Get Started with Redwood for Oracle Cloud HCM Begin Now
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
-
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…
-
HCM Extract: initiate HCM data loader is generating files but it doesn't affect the absence screenThe extract runs successfully and generates the PersonAccrualDetail.dat files but nothing happens in the absence screen, and when I took the output files results and upl…
-
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… -
Archive Information and Generate Report Takes longer time to completeSummary: Archive Information and Generate Report Takes longer time to complete Content (please ensure you mask any confidential information): Hi Team, Greetings! This qu… -
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…
-
How to zip multiple output files from HCM Extract and FTP to third partySummary: How to zip multiple output files from HCM Extract and FTP to third party Content (please ensure you mask any confidential information): We have a requirement to…
-
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…
-
Custom Email Notifications for TouchpointsSummary: Possibility to have custom notifications Content (please ensure you mask any confidential information): Hi, I understand that we have a standard list of email n…
-
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
-
Suggest to restrict empty file sending from extract to ServerSuggest to restrict empty file sending from extract to Server
-
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 … -
What causes the scheduled extract to randomly error at Archive and Generate XML and correct itself?Summary: What causes the scheduled extract to randomly error at Archive and Generate XML and correct itself? The log states the following errors for two runs and then it… -
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…