SQL
Discussion List
-
Oracle HCM Extract - Department - GL Cost Centre informationSummary: Hi Experts, I need to fetch the department GL cost center information details. Also need to fetch multiple rows or all existing rows. like we have two row for c… -
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 11 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…
-
Issue with Seniority Date V3 entitySummary: We are are using the user entity PER_SENIORITY_DATES_V3_UE to get the enterprise seniority date and legal entity seniority date. At one point, we had to put a f… -
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… -
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…Parag Hiremath 11 views 1 comment 0 points Most recent by Madalina Danis-Support-Oracle HCM Integrations
-
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…
-
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 42 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… -
Archive Information and Generate Report Takes longer time to completeSummary: Archive Information and Generate Report Takes longer time to complete Content (please ensure you mask any confidential information): Hi Team, Greetings! This qu…
-
Need SQL query to display HCM Extract results and output file namesSummary: Need SQL query to display HCM Extract results and output file names Content (required): We developed custom HCM Extract and it is having multiple delivery optio…
-
HCM Extract BIP report delivery handling of special XML CharactersHello All, We have a requirement from a client to pull all of the Talent Profile items from the HRT_PROFILE_ITEMS table. when creating the extract we noticed that in the…
-
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 11 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 71 views 2 comments 0 points Most recent by Clare Murtagh - new 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 81 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…