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
-
Unable to change the Parent root data group in 24DSummary: Unable to change the Parent root data group in 24D. Content (please ensure you mask any confidential information): We have multiple UE (User Entities) in a extr… -
what is the user entity for per_period_of_service tableSummary: User entity for per_period_of_service table Content (please ensure you mask any confidential information): I have Assignment ID and Person ID. Need to find the …
-
Known issues with PER_EXT_PAY_EMPLOYEES_V2_UESummary: Known issues with PER_EXT_PAY_EMPLOYEES_V2_UE Content (please ensure you mask any confidential information): Hi Team, Greetings! As we know - PER_EXT_PAY_EMPLOY… -
Unable to see the header record type option, while building custom extractWhile replicating the Ceeded extract, to create custom extract. I am unable to find the option "Header record type" and also process type as "Custom logic" in the record…
-
Need inputs to use :{PARAMETER.P_TIMEZONE} in the Value set from clause.Summary: Need inputs to use :{PARAMETER.P_TIMEZONE} in the Value set from clause. Content (please ensure you mask any confidential information): In the custom HCM Extrac…
-
Unable to extract Assignment tax unit information in balance groupSummary: I am trying to extract a balance group using an HCM extract which contains both assignment and relationship tax unit dimensions. I have been able to extract the…
-
Fast Formula with FF type "Extract Criteria" is not working when we are trying to add it in extract.Summary: Hi Team, We have designed extract to pull the employee assignment details but it was picking the multiple records for an employee. We used fast formula in "Filt…
-
HCM Extract ErrorSummary: Extract failed with below error, ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "FUSION.PAY_REPORT_PROCESS", line 21…
-
Key considerations to decide BICC over HCM ExtractSummary: Dear Experts, I am looking for key considerations for us to decide to bulk extract the HCM data using BICC over HCM Extract? Thank you. Regards, Krishna Content…
-
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…
-
The route text for database item GLB_PAY_BAL_EXCP_PER_PAYROLL_RELATIONSHIP_ID is empty or too longI have a HCM Extract working good till last 2 weeks. Error: ORA-20001: The EXT_PAYROLL_RECORDS_300000020284428 formula can't be run because it isn't compiled. Details: A…
-
oracle.as.scheduler.RequestNotFoundException: ESS-01012 Request -1 not foundSummary: oracle.as.scheduler.RequestNotFoundException: ESS-01012 Request -1 not found Content (please ensure you mask any confidential information): Hi Team, Greetings! …
-
Unable to edit the extract in advance mode in 24DSummary: Is it possible to edit HCM extract in Advance mode? If yes how we can do it? Even after adding below lookup as well, still we are not able to edit HCM extract i…
-
Assistance Needed for Extracting Users from Oracle HCMSummary: I need help with extracting user data from Oracle HCM, including active and inactive users, email addresses, start dates, end dates, and associated roles. I’m e…
-
Do we need to run baseline extract when we make changes to RTF or fast formulaSummary: This is changes only extract and we have changes in RTF template related to output of extract and also in fast formulas associated with the attributes of the ex…
-
Enable Advanced Edit on 24ASummary: Content (please ensure you mask any confidential information): Hi experts, From the 24A release notes, the Advanced Edit UI would be deprecated in favour of the…
-
How to Enable Extract Advance Edit option in 24D Fusion ApplicationSummary: How to Enable Extract Advance Edit option in 24D Fusion Application . Advance edit option not visible. Content (please ensure you mask any confidential informat…
-
Unable to edit the extract in advance mode in 24D.Tried the below steps but still not able to edit the extract 1. Navigate to 'Setup and Maintenance' 2. Search - 'Manage Common Lookups' 3. Search for Lookup Type - 'ORA_…
-
How to get Database item for Descriptive flexfield.we are looking for Database item for descriptive flexfields (PER_DRIVERS_LICENSE_TYPES_DFF). we got to know a process to create DBI for flexfield. These are the steps we…
-
I want to schedule a custom HCM Payroll Extract for every 15 days. What is the best approach?I want to schedule my custom HCM Payroll Extract to run after the Payroll Run is completed which runs for every 15 days. What the best approach to achieve this? Is it be…
-
HCM Extract is not starting immediately, takes about 30 minutes to start the extract executionRecently observed a strange behaviour. On submitting an HCM Extract, it doesn't start immediately, but takes almost 30 minutes to start. Post that, the execution is comp…
-
User Entity for individual compensationSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Need SQL to find Extacts which does not generated any output filesSummary: Hello Everyone, I need a SQL query to display HCM Extract details which did not generate any output files(XML/.CSV/Text/.dat) at the time of successful run with…
-
Absence balance to ADP payrollHi All, We are implementing absence management module in fusion hcm and the payroll system is ADP. We have a requirement to show absence balances on ADP payslip (earned,…
-
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…
-
to trigger an alert when an exception error occurs in the logs from the extract runSummary: Content (please ensure you mask any confidential information): There is a requirement to detect HCM Extract Instance which went to success without any alerts/Wa…
-
HCM Extract BIP report delivery handling of special XML CharactersHello All, We have a requirement from a client to pull all of the Talent Profile items from the HRT_PROFILE_ITEMS table. when creating the extract we noticed that in the…
-
Need SQL query to display HCM Extract results and output file namesSummary: Need SQL query to display HCM Extract results and output file names Content (required): We developed custom HCM Extract and it is having multiple delivery optio…
-
HCM Extract- Position Costing informationSummary: Hi Folks, I've need to fetch the position costing details from pay cost allocations table. Also need the concatenated string of values of Entity + Cost Centre +… -
Extract gives an error in work relationship for terminated employeesSummary: We are using this extract from a couple of months ago. It works for all other employees. Now the client requirement to add terminated employees is in the extrac…