SQL
Discussion List
-
Generate Data Loader File is stuckSummary: Generate Data Loader File is stuck Content (please ensure you mask any confidential information): Hi Team, Greetings! We have a flow for inbound time entry data… -
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 213 views 2 comments 0 points Most recent by Abhishek Bagh HCM Integrations -
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… -
while loading hdl as Participant Enrollment for Person getting errorSummary: while loading hdl as Participant Enrollment for Person getting error as 'the message is unable to find a started life event'
-
Primary City/County while loading address - Vertex CodeSummary: Need a way to identify primary city/primary county for given Zip code Content (please ensure you mask any confidential information): We receive City and Zip cod…
-
Query to fetch Court Orders and Student Loans informationSummary:I need to fetch court order information from calculation card for eg order reference number etc Content (please ensure you mask any confidential information): Ve…Rafee Patnam 81 views 1 comment 0 points Most recent by Anca Andronic-Oracle Payroll and Global Payroll Interface (GPI)
-
what is purpose of menton in HDL 'SET PURGE_FUTURE_CHANGES N'Summary: Hi Team, I observed in most of the files above condtion but I don't why applied on each file and what is the use on ? Thanks, Ajay Content (please ensure you ma… -
Value set table result empty but not the SQL statementSummary: Hi All, In fast formula for compensation, we calling a value set by using GET_VALUE_SET function, but it is not returning any data. When I execute the SQL state…Jennings Mendes 219 views 3 comments 0 points Most recent by Jennings Mendes Human Capital Management
-
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…
-
Updating recurring element entry with Surrogate ID HDLSummary: Hi Team, Can anyone please provide working HDL template from updating recurring element entry with Surrogate ID. Content (please ensure you mask any confidentia… -
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… -
HDL - Uploading Manager Details - Assignment as BlankHi, I'm try to do HDL update where Manager Details need to be blank as they sit on top of hierarchy. Together with WorkTerms and Assignment, I'm passing below [Assignmen… -
TYPE field on HR_ALL_ORGANIZATION_UNITS_FSummary: There is a field called "TYPE" in the HR_ALL_ORGANIZATION_UNITS_F table. As per the table reference documentation… "This is a user defined type for differentiat…Kammasavala Ramadevi 93 views 1 comment 0 points Most recent by Keerthi Masireddy-Support-Oracle Human Capital Management
-
BIP Report to Get Last 30 Days User Login DetailsSummary: The Import User Login History Ess Job is scheduled and we tried ASE_USER_LOGIN_INFO table to fetch the last 30 days users login history but it only gives last l…Chainsyssupport 111 views 2 comments 0 points Most recent by Clare Murtagh Reporting & Analytics for Fusion Service
-
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 84 views 2 comments 0 points Most recent by Claudio Marini-Oracle HCM Integrations
-
Hdl Template for loading answers to a question for each employeeSummary: Hi, I am looking for a HDL template to load answers for questions with respect to each employee. Which attribute should I take that so that different answers ge…Aviral Tripathi 142 views 4 comments 1 point Most recent by Marius Voicu-Oracle HCM Data Loader (HDL)
-
Alerts Composer - Can we filter only Employee's current and active HR Representatives?Summary: We have custom alert 'Visa Validation after Termination' - and this current filter that we have sends the notification to these HR Representatives that are both…Bianca Lei Villareal 112 views 3 comments 0 points Most recent by Bianca Lei Villareal HCM REST APIs -
We need to use Per_Jobs.attribute1 DFF to identify Manage role provisioning rulesSummary: We have a custom per_Jobs.attribute1 DFF that identifies the classification of workers (office, field, field supervisor). Can we setup Role Auto provisioning ru… -
How to bulk reset the password using REST APISummary: I have gone through the documentation from Oracle Doc ID 2346455.1, Application used Postman, and this is the error I have received: Error 403--Forbidden …Sumbul Salim 423 views 8 comments 0 points Most recent by Kishore Padala-Support-Oracle Applications Security -
How to bulk reset the password using REST APISummary: I have gone through the documentation from Oracle Doc ID 2346455.1, Application used Postman, and this is the error I have received: Error 403--Forbidden …
-
HDL Transformation Fast formula and PayrollInterfaceInboundRecordSummary: Hello: I need to write a HDL Transformation Fast formula to receive Garnishment Payment information from ADP and was reviewing the whitepaper "Loading_Payroll_I… -
Alerts Composer - Can we filter only Employee's current and active HR Representatives?Summary: We have custom alert 'Visa Validation after Termination' - and this current filter that we have sends the notification to these HR Representatives that are both…Bianca Lei Villareal 51 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle HCM REST APIs
-
Custom API.Summary: Hi Expert, Good afternoon! Could we create job applications with the help of a custom API. Can someone refer me to any documents on how to create a custom API? …
-
Bulk sending of notifications of records with errors in integration by mailHi, In the integration we have prepared, a notification has been prepared for the records that have fallen into error, but how is it possible to send the wrong person re… -
Getting below exception while calling a REST API using GROOVY script from Application Composergroovy.lang.missingpropertyexception : no such property: result for class: java.lang.string Code Snippet: def ModeSelection = [ ModeSelection :SelectMode_c, ] def respon…
-
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…
-
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…