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 to group multiple datasets into single table in RTF template for HCM Global report extract?Hi I am trying to create RTF template from global report data model for HCM. there are 15 data sets into this data model. I need only 4 attributes from 2 data sets Basic… -
Retrieving Recruitment and Offer Details in HCM Extract for Pending Workers Hired via ORCWe have an HCM Extract that includes employee assignment, demographic details, etc. We would like to retrieve Recruitment and Offer pages from Oracle Recruiting Cloud (O…
-
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… -
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… -
How to add Job EFF fields in HCM ExtractHi, We are designing a new payroll extract and unable to find any DBI for pulling the Job extensible flexfields like jei_information1, jei_information2 etc. Please help.…
-
Custom attribute in oracle delivered / seeded HCM extractSummary: Hi experts, Working on Payroll Interface for ADP Global Payroll V2, requiring a pay group field. Pay group field is a DFF stored in attribute 12 of the "per_all…
-
Custom Balance Group not extracting any dataSummary: I have created a HCM extract and Trying to pull balance information by attaching a balance group usage. Once the extract is run, its not returning any data from…
-
PAY_EXTRACT_RUN_RESULT_VALUES_UE is not showing up when trying to add as a UE in HCM extractsSummary: When trying to add PAY_EXTRACT_RUN_RESULT_VALUES_UE as a child DG UE we are not able to see it as an option in both Full file and payroll interface type hcm ext…
-
User Entities used in the seeded Extracts are not available to use in newly custom created extractsI am creating a Payroll Costing related HCM Extract. I referred the oracle seeded HCM extracts, there is one named 'Payroll Costing Report', this extract has all my requ…
-
Are there any delivered integrations/extracts for Benefits?Summary: Are there any delivered integrations/extracts available for any of the 3rd party benefit vendors ? If yes, where can we see the list of supported vendors and mo…
-
How can we fetch History data for Contract , Element and Salary details through HCM ExtractSummary: We have used PER_EXT_SEC_PERSON_NOW_FUTURE_UE to fetch history data alongside this the requirement is to pick the history changes for Contract Details, Salary D…
-
How to display sysdate in an excel template. I am using an HCM Extract.Summary: I want to display the sysdate in one of the columns of an excel output. I am using an excel template. Content (please ensure you mask any confidential informati…
-
Conditional Actions greyed outSummary: I am creating some HCM Extracts and I noticed something interesting: In the enviromments using 24A the Conditional Actions inside an attribute in HCM Extract ar… -
HCM Public View Objects ?We are planning to use "Oracle Data Integrator Cloud Service" to extract data out of our HCM cloud by means of using PVO's. I found the list of available PVO's via "KB26… -
ORA-00920: invalid relational operator when running a copied extractSummary: Receiving an ORA-00920: invalid relational operator when running a copied extract I didn't change anything in the extract. Click Copy > Compile the related fast…
-
How to display data in Proper format using eText templatesSummary: How to display data in Proper format using eText templates? Content (required): We have a requirement for displaying the output data in Proper format for a fiel…
-
Help to extract usersSummary: I need help to extract the following information: Person Number Email Username User Status (active or inactive) Does anyone know the query to do this? Thanks, A…
-
Configuration Package ErrorHello Experts We have a requirement to migrate TRU using Configuration Package. When we create the package a message error is showing when we try to add the TRU "fun-720…
-
Which User Entity to pick to get the balance value of a particular custom balance createdHi, I need to fetch the balance value of a particular custom balance created in the HCM Extract. This Balance is created to record total number of hours worked in a mont…
-
Get Business Unit Name using PER_EXT_SEC_HISTORY_ASSIGNMENTS_UETeam, We have created an extract and using PER_EXT_SEC_HISTORY_ASSIGNMENTS_UE. Attributes: Business_Unit_ID - Extract Historical Assignment Business Unit ID (DBI) Busine…
-
Updated DBI, user entity list provided by OracleSummary: Hi experts, I need to see the updated DBI,user entity list provided by Oracle with each upgrade. Could someone please provide this list and also guide me throug…
-
Cannot add a HCM Extract Conditional ActionI am adding Email to an HCM Extract. Previously, I would add the Person E-Mail Address Database Item Group and then add a Conditional Action where the data would not dis…
-
ADP Payroll Interface.Summary: We are doing POC to use ADP Payroll Interface. We are not using payroll. We are not using Organization payment methods. We are not using personal payments. My q…
-
Why do we get JBO-27123: SQL errorSummary: Why do we get JBO-27123: SQL error Content (please ensure you mask any confidential information): Hi Team, Greetings! We have observed that the payroll flow (us…
-
Is there any defined root cause for JBO-27123: SQL errorSummary: Is there any defined root cause for JBO-27123: SQL error Content (please ensure you mask any confidential information): Hi Team, Greetings! We have observed tha…
-
is it possible to get LRG_OBJ attribute found in a UE in a Rule FF used by Changes only Extractis it possible to get LRG_OBJ attribute found in a UE in a Rule FF used by Changes only Extract? My customer thinks we can fetch Comments via a FF. HRA_EVAL_RATINGS_LRG_…
-
Unable to modify JobOfferLetterDM as it is giving the error ORA-01719.Summary: I would like to add the candidate's preferred language column in the OfferRecipient data set Cand.CAND_PREF_LANGUAGE_CODE but when saving the data model, it thr…
-
cannot add Any *LRG_OBJ_UE View Entities to extract - Need CommentsSummary: Hi: Attempting to pull in "Comments" into hr_archive changes-only extract in DEV environment. ( See below ) What IF anything is my extract missing in EVALUATION…
-
How to identify assignment EFF fields in extract user entitySummary: I wanted add assignment EFF fields for existing extract, Can any one help me to identify assignment EFF fields in user entity details. Content (please ensure yo… -
Moving to PER_EXT_PAY_EMPLOYEES_V2_UE from PER_EXT_PAY_EMPLOYEES_UESummary: Moving to PER_EXT_PAY_EMPLOYEES_V2_UE from PER_EXT_PAY_EMPLOYEES_UE Content (please ensure you mask any confidential information): Hi Team, Greetings! As we kno…