SQL
Discussion List
-
Fix duplicate records using PER_EXT_SEC_ASSIGNMENT_NOW_FUTURE_UESummary: Including both the latest and reinstatement (‘DS_AFFECTATION’) records using an OR condition works in BIP but produces duplicates in the HCM extract using PER_E… -
How to fetch the calculation card association details TRU for a specific assignmentSummary: I am currently working on fetching the TRU for Tax withholding calculation card. The calculation card has association and association details. It uses US taxati…
-
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… -
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…
-
SQL query to display HCM Extract flow and output file sizeSummary: Does anyone have a query that displays the size of file generated for flows completed? sometimes files are empty or very small like 1kb, this would help for fas…
-
Unable to fetch retro time card adjustments from the HCM backendHi All, We have a requirement to pull retro time card adjustments through the Changes Only HCM Extract. However, we are unable to fetch these adjustments from the HCM ba…
-
Query for Acknowledgement / Approve section for Overall Performance EvaluationHello! I would like to build a query which will receive the approval/acknowledgment of a specific section. Unfortunatelly in the ratings or section tables we cant corela…
-
HCM Extract takes more time when bind parameters included in Process config groupSummary: Hi Team, We have built a HCM Extract which fetches Core HR Data. I am using Use bind variables during action creation phase. - Y_ALL. We are running HCM Extract…
-
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…
-
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… -
HCM Extract: Filtering XML Records based on Attribute ValueWe have an HCM Extract with multiple attributes, including BalanceValue, which is populated by a Fast Formula. We need to generate XML records only where BalanceValue is…
-
Incremental file for Payroll PVO -HcmTopModelAnalyticsGlobalAM.HcmBalancesSetupAM.PayrollBalancesPVOWe are currently facing challenges with the use of this BICC Payroll PVO Offering: HcmTopModelAnalyticsGlobalAM.HcmBalancesSetupAM.PayrollBalancesPVO. It appears to gene…
-
HCM user entities to pull published schedule details for group of employeesWe are working on an integration where we need to extract published schedule details for a group of employees within a time period (past 3 months). We also need to track…
-
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…
-
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…
-
User Entity to get deleted Absence Records - HCM ExtractHi, I have a requirement to extract deleted Absence Records using HCM Extract and send it third party payroll. Could someone suggest the appropriate User Entity?
-
Position Extract - Fast formula to get parent position NameSummary: Summary: Hi Experts, I need your assistance. I'm currently working on the position object task. I'm unable to search the parent position DB item in the entity (…
-
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… -
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 186 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…
-
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…
-
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…