SQL
Discussion List
-
HCM Extracts - Using Secure Views in Data Group Filter CriteriaSummary: Queries around secured views in data group filter criteria Content (required): Hello, We have an HCM extract to fetch demographic and payroll information. The e… -
SQL Query to get the Balance dimensions and corresponding context valuesSummary: SQL Query to get the Balance dimensions and corresponding context values Content (required): We are looking to get the balance dimension names and context value…
-
Parse JSON data in HRC_ATOMPUB_ENTRIES.ENTRY_XML fieldSummary: For reporting purposes we need to read and parse the JSON payload that is present in Atom Feed Table. The field ENTRY_XML contains an XML which tag //entry/cont…Claudio Marini-Oracle 22 views 0 comments 0 points Started by Claudio Marini-Oracle HCM Integrations
-
Time Entry report to get updates and deletion of time entrySummary: Need a report for time entry to pull all new creation, updated and deleted records. Content (required): We have a requirement for integration where we need to g…Raghavendra M 7 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Oracle HCM Integrations -
Data Extract - Most RecentSummary: Is it possible to create a data extract an only get the latest relavant information for a given person whether the person is PWK, EX_PWK, CWK, EX_CWK, EMP or EX…
-
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 2 views 0 comments 0 points Started by Mark kristan De los Reyes HCM Integrations -
Testing a REST API in POSTMANI am testing this Workers API from Oracle HCM Documentation and the requirement is to update data in Workers API by schedule. For example, I have updated a user's Date o… -
Difference between ViewAllPVO and 'Parent'PVO in BICCSummary: Difference between ViewAllPVO and 'Parent'PVO in BICC? Example HcmTopModelAnalyticsGlobalAM.PersonAM.GlobalPersonPVOViewAll and HcmTopModelAnalyticsGlobalAM.Per… -
On Boarding e-signature forms?Summary: I am creating e-signature form report that report path should should attach the UI LEVEL Content (required): as of now i have created e-signature report that re…
-
Why the Fast formula pick up only primary phones?Summary: Hello, we have the following FF that pickup only the primary phones (we understand it launching the extract). How to pickup all the phones without the constrain…
-
Change Only HCM extract for Recruiting/Job RequisitionSummary: Hi Team, We have a requirement to send the Job Requisitions changes using the HCM extract to the third Party system. Kindly share the code pack if anyone had co…
-
HCM Extract | How to find current difference FTE, Incumbent FTE of position in fusion hcmContent Hi All, I am working on a HCM extract and I need to fetch the position details like difference FTE, current Incumbent FTE of position. I am able to get current p… -
HCM Extract| How to include Active User Account in HCM ExtractSummary: Hi Experts, We have built an extract which pulls the Employees by their User Category. We wanted to include the Active User Account in the HCM extract. We could…