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
-
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… -
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… -
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… -
Tag not in the xmlSummary: Can anyone help me with this? I am trying to a field through extract definitions. Once after running the report, I couldn't able to see the tag being populated … -
Get the description of a value in a valueset using HCM ExtractSummary: Hi, I need to extract the field description from the value set for each value and I need to insert the description as an attribute in the HCM extract Content (p… -
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 .… -
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… -
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… -
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 … -
unable to send US PPD Audit Report to user on emailSummary: unable to send US PPD Audit Report to user on email Content (please ensure you mask any confidential information): We are trying to send US PPD Audit Report whi… -
Suggest to restrict empty file sending from extract to ServerSuggest to restrict empty file sending from extract to Server -
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… -
Concat in HCM ExtractSummary: How can I concat 2 or more fields in HCM Extract? Content (please ensure you mask any confidential information): I need to extract in HCM Extract a field which … -
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… -
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…
-
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 … -
Is it possible to retrieve deleted technical talent profile competencies in HCM extracts?Hi if we are deleted technical competencies for particular person in talent profile, Is it possible to retrieve deleted technical talent profile competencies in HCM extr… -
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… -
How to get the status of HCM Extract ESS job status in details using Webservice in OIC?Summary: Hi All, We have built an HCM Extract which is integrated to third party via OIC and third party system pass parameter values based on the requirement. Extract D… -
Base line not happening properly in HCM Extract.How to check the Employees in Baseline run. do we have any SQL to check. We have an existing extract and made the changes at attribute mapping. Now , I have baselined th… -
Need DBI value for Tax District field from AddressHi Experts, We are creating a Changes Only extract for Address changes. I am unable to find the correct DBI for Tax District field. Please advise, if you know the way to… -
Hi Team, How to enable password protection for the file extracted in HCM Data exchange?we need security to be enabled for the file extracted by using extract definitions in data exchange , can anyone tell us how to enable password protection? -
Enabling Increased Length Limits for Data Group Filter CriteriaSummary: Guidance around enabling the increased character limit on the data group filter criteria's for extracts. Content (please ensure you mask any confidential inform… -
Report on Vacation TimeDoes anyone know how to run a vacation report that would include the total vacation time given, the vacation used, and the balance for each employee? -
Equivalent way to get running query for different processSummary: Equivalent way to get running query for different process Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there a way to g… -
Unable to find Global Payroll Interface v3For an integration with Alight payroll, they recommend using Global Payroll Interface v3. But we cannot find it as HCM Extract. We have tried with different LDG, etc. We… -
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… -
Extract Definition - Migration Error: JBO-27023 & JBO-27024Hi, We're experiencing error when trying to migrate extract definition from one pod to another. Error message: Review and report the errors for this object to product HC…