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
-
After 24D Advanced Edit Option is not working in Extract DefinitionSummary: In Extract Definitions the Advanced Edit option is not available post 24D upgrade Content (please ensure you mask any confidential information): Before Screen s… -
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…
-
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 …
-
Is there a list of Oracle deprecated UEsIs there a list of Oracle deprecated UEs with the date that deprecated UE will no longer be supported?
-
What is the user entity for the table PER_ALLOCATED_TASKS.I want to update a PDF file to employee's DOR. I need to create an extract for this based on the table PER_ALLOCATED_TASKS, hence I need the user entity I should use for…
-
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 … -
Payment Source and positon costing Column QueryHi, I am currently working in a requirement to get the below column However, I couldn't find the payment reference, source, and position costing and tax reporting unit i…
-
Changes Only - ignore change in countSummary: Regarding HCM EXTRACT Changes mode. The requirement is to pick up new absences. The extract contains ABS_EXT_ABSENCES_ENTRY_UE with absence entry id as a key. D… -
Extract run error: ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS5'Summary: We have some Extract runs completed with the status "Completed with Alerts". No output files have been generated. Under "Instance Details" section, the task "Ar… -
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…
-
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 …