SQL
Discussion List
-
Assistance Needed for Extracting Users from Oracle HCMSummary: I need help with extracting user data from Oracle HCM, including active and inactive users, email addresses, start dates, end dates, and associated roles. I’m e… -
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…
-
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- Position Costing informationSummary: Hi Folks, I've need to fetch the position costing details from pay cost allocations table. Also need the concatenated string of values of Entity + Cost Centre +… -
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… -
Replacing ASCII characters to Hyphen on the eText extractI'm using REPLACE(PER_LAST_NM,'''','-') and it's not working . I want this name O'Hara to be changed to O-Hara i want that Single Quote removed and change it to Hyphen .…
-
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… -
Enabling Increased Length Limits for Data Group Filter CriteriaSummary: Guidance around enabling the increased character limit on the data group filter criteria's for extracts. Content (please ensure you mask any confidential inform…
-
Equivalent way to get running query for different processSummary: Equivalent way to get running query for different process Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there a way to g…
-
How to identify which element is a salary elementSummary: I have an HCM Extract that extracts all the elements, and i have to do further processing based on if the element is a salary element or not. How do i identify …
-
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…
-
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…
-
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…
-
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 21 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…
-
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
-
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… -
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…