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
-
How do you get the step rate values from the Grade Ladders?Summary: I need to get the Step name and values for Grades on our grade ladder. Content (please ensure you mask any confidential information): I have used PER_EXT_SEC_GR… -
PGP Encryption is producing a .tmp file at vendor's endWe are using the public key provided by the vendor to encrypt the file being sent to the SFTP using the HCM Extracts vis BIP delivery. When the vendor is decrypting the … -
Regarding Extract DBI of work-schedule asisgnment when assigned at Enterprise levelSummary: Hi Folks, When I assigned work schedule at assignment level then I got the value in HCM extract of WS and the Pattern as well but if i remove the assnment level… -
Which User Entity can be used to get the Employee Work Schedule details?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
HCM user entities to pull published schedule details for group of employeesWe are working on an integration where we need to extract published schedule details for a group of employees within a time period (past 3 months). We also need to track…
-
Balance Feed Usage DetailsWe are conducting a review of all balance feeds and associated elements and element classifications, in a effort to ensure we have all elements mapped to the appropriate…
-
Pass Absence dates value to a value set as parameters in Add Absence ScreenSummary: I need to filter a value set created in Add Absence screen with the absence start and end date the user choose in Oracle Fusion Redwood Content (please ensure y…
-
Unable to load Value sets in BulkSummary: We are unable to upload value sets in bulk, whereas we are able to load for single data but failing for mass load. Feature used to load was ''File Export & Impo…
-
Our HCM Extract with Changes Only repeats exact same data if the child data is in a different orderSummary: If the order of the child records is different in the changes only run vs. the baseline, it reports this as a change even though none of the attributes are diff…
-
How to export all HCM extracts in one goSummary: How to export all HCM extracts in one go Content (please ensure you mask any confidential information): Hi All, Greetings! We typically export the XML for a giv… -
How can we find out, what is exactly behind a "Database Item Group" in an Extract DefinitionSummary: Within the extract definition the selected attributes are linked to a "Database Item Grup" which is a drop down list. Often it is more or less clear what is beh…
-
Add Business Unit as an additional parameter in the Run Gross-to-Net ReportWe have a requirement to include Business Unit as an additional parameter in the Run Gross-to-Net Report (Gross to Net Summary Archive) so that the report can be generat…
-
Duplicate rows are appearing in the Historical Assignment User EntitySummary: Duplicate rows are appearing in the Historical Assignment User Entity Content (please ensure you mask any confidential information): We are using the PER_EXT_SE…
-
Oracle HCM Extract - Department - GL Cost Centre informationSummary: Hi Experts, I need to fetch the department GL cost center information details. Also need to fetch multiple rows or all existing rows. like we have two row for c…
-
after adding this attribute name GLB_PAY_COST_DETAIL_SEGMENT1 extract not runningSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Redwood UI – View Extracts Page Performance Issue (Very Slow Load Times)We’ve recently been testing the Redwood version of the View Extracts page and are experiencing significant performance issues. The page is taking approximately 3–4 minut…
-
how to pass dynamically the flow name and instance Id from HCM Extract to SFP FileSummary: In an HCM EXTRACT, We enabled SFTP bursting need to save the file name with flow instance name and flow instance Id dynamically in SFTP server when we ran the e…
-
Need a query to pickout the balances details in Oracle HCM fusionHi All, Our requirement is to get the balance details of the following balances based on the employee details for a pay period. can you please share the code for that. '…
-
HCM Extracts: How do I get the resulting SQL Statement of the extract?Summary: I want to get the SQL(s) my HCM Extract definition is using when it gets executed. Is there any logfile which traces SQL information? Content (please ensure you…
-
how to extract absences that were withdrawn and then deletedHello, We have an HCM extract that runs continuously in changes only and it generates absence data. However, when an absence is withdrawn and then "Withdrawn Record Dele… -
How to fetch the calculation card association details TRU for a specific assignmentSummary: I am currently working on fetching the TRU for Tax withholding calculation card. The calculation card has association and association details. It uses US taxati…
-
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…
-
how to merge data from 2 different data sets into Etext template in one line?Hello, I am creating a Etext template using seeded data model globalreportsdatamodel. I am adding fields from 2 different datasets so in the output it is not showing in …
-
List of all seeded HCM Extracts and User EntitiesWhere can we download a list of all the available seeded HCM Extracts and User Entities? Docs.oracle.com provides a list of seeded reports/analytics/subject areas, but n…
-
How to extract deleted records from - PAY_COST_ALLOCATIONS_F table?Summary: I am using UE - HRC_EVT_OBJ_CHANGES_UE to extract deleted records in HCM Extracts. We have a requirement to extract records deleted from - PAY_COST_ALLOCATIONS_…
-
HCM Extract with strange results for related dataSummary: We're running an hcm extract for assignment data. The row data seems to be correct but related information like assignment department name always shows the curr…
-
HCM EXTRACT | EXCEL TEMPLATE | PARENT CHILD TRAVERSE LOOPING IN TEMPLATESummary: Hi, I am working on HCM extract where excel template is being used. XML Structure: My requirement is to fetch the attributes across the different records. For e…
-
The ‘Run Regional Pay Data Report’ does not appear in the Extract Definitions section.Summary: The ‘Run Regional Pay Data Report’ does not appear in the Extract Definitions section. Content (please ensure you mask any confidential information): The flow ‘… -
Fetch Enterprise seniority date in HCM extracts for Seniority Dates v3 setupSummary: Recently, we have moved to Seniority Dates v3 setup from the earlier v1 setup. The seniority dates are now stored in table PER_SENIORITY_DATES table in multiple… -
HCM Extract Seniority Dates V3Summary: We need include in HCM extract seniority dates v3 from table per_seniority_Dates_F. Does anyone has example how to do it or create formula of using UE PER_SENIO…