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
-
Error while creating delivery option in HCM ExtractSummary: I receive below error after set values on Report and Template Name fields Content (please ensure you mask any confidential information): Report value is the fol…
-
Transformation Formula list not appearing in the flow - Load Data from FileSummary: Transformation Formula list not appearing in the flow - "Load Data from File" for users with custom HR Specialist role. But appearing for admins users. Content …
-
We want to create a Bar graph in OTBI analysis for acquiring the headcount trend for the past years.Summary: We want to create a Bar graph in OTBI analysis for acquiring the headcount trend for the past years on monthly basis. For which we need to get active headcount …
-
How to get “Payroll Name” of the terminated employees in HCM Extract?Summary: We built a HCM Extract to generate the date from Fusion, to integrate with an outsourcing Benefits system. The issue is, for the terminated employees, DBI "Payr…
-
Need to do a Conditional Replacement on HCM Extract with EText TemplateSummary: Hello! I have 5 Value Set/Fast Formula for attributes in HCM Extract. 4 of them have some conditions to change a information showed on the 5th(The 5fth one is a…
-
Does Oracle have an API available to get the Benefit Balances information?Summary: Does Oracle have an API available to get the Benefit Balances information? Navigation: Benefit Administration → Enrollment → Search a Person → Benefit Balances …
-
How t submit HCM extract using a linkSummary: Is it possible to create a link in Employee Self service whcih triggeres a HCM Extract on click ? Content (required): Version (include the version you are using…
-
IS it possible to extract performance ratings along with assignment and personal data in an extract?Summary: IS it possible to extract performance ratings along with assignment and personal data in an extract? Content (please ensure you mask any confidential informatio…
-
Extract Inbound Integration - HDL load on User business object is failingSummary: While loading user.dat HDL through Extract inbound integration, HDL is failing with below error "You dont have permissions to bulk load security related data wi…
-
Which UE to use to extract Performance Ratings for the employeesSummary: Which UE to use to extract Performance Ratings for the employees? Content (please ensure you mask any confidential information): Version (include the version yo…
-
Is it possible to create an extract to fetch new hire employee details, employment changesIs it possible to create an extract to fetch new hire employee details, employment changes (if there is an change in employment then only it will come in the extract) an…
-
Convert whole number to Decimal in fast formulaHi Team, We have a requirement to convert the number with two decimal positions. I am able to do with Round/Round_up function for decimal numbers. However, if it is a wh…
-
Extract output file name concat with the extract parametersSummary: Hi All, I am working on a HCM extract where requirement is to generate the output file name which contains the interface name concats with the parameter as ment…
-
How to add threading database item to existing root data group?I have an extract with performance issue and the suggested resolution is to add a threading database item. Bit I could not find an edit button to modify the root data gr…
-
I want to create one UDT for range for handling below condition.When BIRTHDATE < '1946-01-01' THEN 'Traditionalist' • When BIRTHDATE between '1946-01-01' AND '1964-12-31' THEN 'Boomer' • When BIRTHDATE between '1965-01-01' AND '1980…
-
Retro employees missing in PAYROLL REL ACTIONS RANGE UEHi All, We would like to know if we have any UE as like PAYROLL REL ACTIONS RANGE UE and not having "pra.retro_component_id is null" in it. By using above UE we are miss…
-
sql to get the HCM extract failure list for specific datesSummary: Need to create report which gives extract failure details. Code Snippet (add any code snippets that support your topic, if applicable): Im trying below sql to g…
-
Submitting Extract with Parameter Date for output file name not working as expected.Summary: Submitting Extract with Parameter + Date for output file name not working as expected. Please see attached for detail screenshots. It should have file name with…
-
How to set {$SYSDATE()$} into Effective Date on Scheduled Extract ?Summary: How to set {$SYSDATE()$} into Effective Date on Scheduled Extract ? Content (please ensure you mask any confidential information): How to set {$SYSDATE()$} into…
-
Delivered report to identify unpaid third party checksWe are looking for any delivered report to identify unpaid third party checks that requires us to run generate check payments. Run Third-Party Payment Register Report is…
-
Custom balance group showing data in application but not pulling in extract.Summary: We have used this dimension "Relationship Tax Unit, Reference Code Run " in LOAN 403B custom balance group. The underlying element feed is Loan 403B Results. Pl…
-
How can I resolve an HCM Extract validation problem?Summary: HCM Extract definition does not pass validation. Content (please ensure you mask any confidential information): After clicking the Validate button, I receive th…
-
DataTerrain PreBuilt Report : Balance Adjustment ReportingSummary Balance Adjustment ReportingContent This is part of a series of sample PreBuilt reports created by DataTerrain. You can copy the setup for this report and add it…
-
-
What UE is effective date for marital change, gender change, name change located?Summary: We are not able to find Effective Date for the fields: Marital Status, Gender, Name changes or salary changes. We're able to find the field for these, just not …
-
control the FTP/NON FTP delivery option at run time in the seeded HCM ExtractSummary: we are usin the seeded extract and would like to control the FTP/NON FTP delivery option at run time, Kindly let us know how to achieve this?
-
PER_EXT_SEC_ASSIGNMENT_NOW_FUTURE_UE giving duplicate outputSummary: We have a requirement to fetch future, past dated current effective records. I am using the UE PER_EXT_SEC_ASSIGNMENT_NOW_FUTURE_UE As child and root is PER_EXT…
-
Multiple report cat isn’t possible from 24A in HCM Extract. How is dynamic delivery option achieved?We have a requirement to execute delivery option based on run time parameter. We had been achieving this using report category so far. As addition of report category is …
-
I want to generate CSV and deliver it to SFTP from HCM Extracts with Only the Attribute HeadersThere is an option HCM Extract WebCenter Content delivery option to print only Attribute Headers. We want the same kind of file delivered to SFTP. Is there any way to ac…
-