SQL
Discussion List
-
HCM Extract Scheduled - Unable to execute previous datesSummary: Hi Everyone, We have scheduled HCM Extracts in Fusion to run daily/weekly based on vendor frequencies. To increment the input parameter - effective date automat… -
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 63 views 1 comment 0 points Most recent by Anca Andronic-Oracle Payroll and Global Payroll Interface (GPI)
-
SPECIAL_CEILING_STEP_ID is not getting populated in the assignment tableHi, We have a fast formula in the extract, and the SQL query is: SELECT * FROM PER_ALL_ASSIGNMENTS_M WHERE SPECIAL_CEILING_STEP_ID is not null AND ASSIGNMENT_NUMBER LIKE…
-
How to tune archive step in Extract RunSummary: How to tune archive step in Extract Run Content (please ensure you mask any confidential information): Hi Team, Greetings! We have been observing the slowness o… -
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 88 views 3 comments 0 points Most recent by Jennings Mendes Human Capital Management
-
Extract Error JPS-00027: There was an internal error: java.io.IOException: Connection resetSummary: oracle.security.jps.service.keystore.KeyStoreServiceException: JPS-00027: There was an internal error: java.io.IOException: Connection reset Content (please ens…
-
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… -
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…
-
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 23 views 1 comment 0 points Most recent by Keerthi Masireddy-Support-Oracle Human Capital Management
-
-
Extracting ORC Responsibilities and Qualification in Custom ExtractSummary: Extracting ORC Responsibilities and Qualification in Custom Extract Content (please ensure you mask any confidential information): Hi Team, Greetings! This ques…
-
FND_TIMEZONES_PVT error in extractsSummary: FND_TIMEZONES_PVT error in extracts Content (please ensure you mask any confidential information): Hi Team, Greetings! We have got below error in 24A for the ex…
-
Can seeded flow Run Element Results Register be run secured by Business Unit ?Summary: Can seeded flow Run Element Results Register be run secured by Business Unit ? We have requirement to generate the output Run Element Results Register based on …
-
can we add filters for checklists tasks also in hcm extractswe wan to create DOR if the termination/resigantion checlists tasks are completed. Can we add filters for those also in HCM extracts. which bussiness object we need sele… -
Rollback of extract flow is not workingSummary: Rollback of extract flow is not working Content (please ensure you mask any confidential information): Hi Team, Greetings! We have a flow run which we want to r…
-
Talent HCM Extract - How to fetch only first 3 latest records of employee's work experience?In filter criteria of HCM Extract using 'HRT_EXT_PERSON_PREV_EXP_UE' this user entity but need to restrict only first 3 latest records of employee's work experience. How…
-
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 89 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 82 views 2 comments 0 points Most recent by Claudio Marini-Oracle HCM Integrations
-
How to search for future approvers in an approval process in Oracle HCM Cloud by query?Good morning! How are you? I have a question, exists any VIEW objects or table (Im creating a bi publisher) that I can use to get the information of all the approvers of…
-
Performance Issue in Extract in HCM CloudSummary: Hi Folks, We're facing the performance issue in the extract even after the increase of Chunk size and thread size using payroll process configuration. I've trie…Sowmiya Velusamy 46 views 5 comments 0 points Most recent by Ram Manoj Reddy Bala-Oracle HCM Extract -
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 72 views 4 comments 0 points Most recent by Marius Voicu-Oracle HCM Data Loader (HDL)
-
can we add checklists completion status in hcm extract filtersIs it possible to add checklists filters in the hcm extract. Is there any user entity specific to checklists data or can we modify the user entities. we want to get the …
-
Resource to learn Extract.Summary: Hi All, I am complete beginner to Extracts. Would like to have standard and simple resources to learn. Thanks in Advance! Version (include the version you are u…
-
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…