SQL
Discussion List
-
Extract Definitions Delivery - Output Name OverrideSummary: Basically, does the Extract Definition Deliver Output Name override Busting SQL output names? Or is there a way to use the bursting output name? Content (please… -
How to bring history data using PER_EXT_SEC_ASSIGNMENT_NOW_FUTURE_UE in HCM ExtractWe are using PER_EXT_SEC_ASSIGNMENT_NOW_FUTURE_UE in our HCM Extract to fetch "Full Time or Part Time" field along with other fields. The requirement is to fetch for fut…
-
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… -
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…
-
How to get the the latest balance from HCM ExtractHi, I have created a balance group HCM extract to retrieve the custom balance value. I have selected the UE - PAY_INTERFACE_PAYROLL_REL_UE and selected the process type …
-
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 180 views 2 comments 0 points Most recent by Abhishek Bagh HCM Integrations -
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… -
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…
-
Help to extract usersSummary: I need help to extract the following information: Person Number Email Username User Status (active or inactive) Does anyone know the query to do this? Thanks, A…
-
Unable to modify JobOfferLetterDM as it is giving the error ORA-01719.Summary: I would like to add the candidate's preferred language column in the OfferRecipient data set Cand.CAND_PREF_LANGUAGE_CODE but when saving the data model, it thr…
-
Moving to PER_EXT_PAY_EMPLOYEES_V2_UE from PER_EXT_PAY_EMPLOYEES_UESummary: Moving to PER_EXT_PAY_EMPLOYEES_V2_UE from PER_EXT_PAY_EMPLOYEES_UE Content (please ensure you mask any confidential information): Hi Team, Greetings! As we kno…
-
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…
-
HCM Extract filter takes longer than same sql in BISummary: I verified the performance of the UE plus custom filter by running a BI report with the same SQL, but HCM Extract takes hours to complete whereas BI takes minut…
-
Known issues with PER_EXT_PAY_EMPLOYEES_V2_UESummary: Known issues with PER_EXT_PAY_EMPLOYEES_V2_UE Content (please ensure you mask any confidential information): Hi Team, Greetings! As we know - PER_EXT_PAY_EMPLOY…
-
Need inputs to use :{PARAMETER.P_TIMEZONE} in the Value set from clause.Summary: Need inputs to use :{PARAMETER.P_TIMEZONE} in the Value set from clause. Content (please ensure you mask any confidential information): In the custom HCM Extrac…
-
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 +… -
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… -
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…
-
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 56 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