Category 203
Discussion List
-
How to skip a task based on condition in a Payroll flow pattern.Summary: There are 2 task defined for one payroll flow pattern. First task is report, second is dummy Extract which initiate the Data loader and third is HDL load. But w… -
How does extract pick latest record if that does not have latest timestampSummary: How does extract pick latest record if that does not have latest timestamp Content (please ensure you mask any confidential information): Hi Team, Greetings! We… -
Does anyone knows how to query current task in Performance Document?Summary: I need the select statement to fetch this value Content (please ensure you mask any confidential information): I'm trying to write a query that selects this fie…Stefano_Mazzocca 204 views 4 comments 0 points Most recent by RahulMore Reporting and Analytics for HCM -
pay_range_items_f table VALUE1 is empty.Summary: The VALUE1 column for a calculation card element is coming out to be '-999999999' in this table even though the value exists in the front end. The same value is…
-
Integration for sending ORC Requisition details to third partyWe are building an integration using OIC that sends requisition details based on the following trigger points: When the requisition is in Draft or In Progress status. Wh…
-
changes Only hcm extract fetching all data in child groupSummary: Hi All, I created one changes only hcm extract with Person as parent data group and absence_data as child data group. Whenever there is a change in any absence …
-
How to set up secure File Transfer ProtocolHello all, I am trying to configure a secure file transfer protocol in a custom HCM Extracts, when I was configuring the File Transfer Protocol, under the security secti…
-
What is the user entity name for PER_PERSONS in HCM FusionWe have a custom DFF based on PER_PERSONS table on Person screen. I want to access this field in the HCM extract. Is there a user entity defined to access this table and…
-
HCM Extract Run as a flow with all attribute parameter doesn't return data in Production PODI have a situation where a data extract created using HCM extract and template done using BI was migrated from UAT pod to Production pod and while running the extract as…
-
How to get the the latest balance from HCM ExtractHi, I have created a balance group HCM extract to retrieve the custom balance value. I have selected the UE - PAY_INTERFACE_PAYROLL_REL_UE and selected the process type …
-
Value Set passing two parameters for ExtractSummary: Hello, Customer Connect! I have some value sets(and respective Fast Formulas), that I use to get some attributes/fields that the User Entity I'm using don't hav… -
Extract flow schedule is not incrementing the effective date parameter valueSummary: Extract flow schedule is not incrementing the effective date parameter value Content (please ensure you mask any confidential information): Hi All, Greetings! T…
-
unable to view edit option in hcm extract in 24aSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to convert calculated fields into measures OTBISummary: We're using data from the Recruiting - Recruiting Real Time subject area. We need to create a performance tile to display Total Openings Left to Fill however th…Mark kristan De los Reyes 189 views 2 comments 0 points Most recent by Abhishek Bagh HCM Integrations -
HCM Extract Filter issueSummary: I need to filter employees with "Active-Payroll Eligible" status in my extract, but this value isn’t directly available in my DBI. Right now, I'm using "Assignm… -
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…
-
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… -
Fusion Application BI Publisher - SSH Public Key authenticationSummary: How to setup FTP connection to a vendor, using SSH public key authentication? Content (please ensure you mask any confidential information): The FTP server setu…
-
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…
-
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 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…User_2025-07-18-01-28-01-258 104 views 4 comments 0 points Most recent by Lasya Priya Seelam HCM Extract
-
OIC Integration call from HCM CloudSummary: Call OIC Integration form Oracle HCM Cloud Content (please ensure you mask any confidential information): We have created one lookback integration using OIC. In…
-
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…
-
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…
-
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…