SQL
Discussion List
-
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 22 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 73 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 83 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 33 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 40 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…
-
Is there a way to extract filter criteria for multiple extracts in one goSummary: Is there a way to extract filter criteria for multiple extracts in one go Content (required): Hi Team, Greetings! We are checking for the HCM extracts which use…
-
Is there a SQL query to get employees processed in extract run?Summary: Is there a SQL query to get employees processed in extract run? Content (please ensure you mask any confidential information): there a SQL query to get employee…
-
How to get person extra information field value in fast formulawe have a requirement to compare two values one is element input value and another one is from person extra information field value and give maximum value into an elemen…
-
HCM extract pulling changes several days after change was madeSummary: Content (please ensure you mask any confidential information): Hi, we have a series of HCM extracts that pull various data pieces in order to be fed to a 3rd pa…
-
Position Details Extract ChangesSummary: Hi All, We need return only changes records not all historcial lines of position, only expected to see changed/update records in the position file Let us know f…
-
PER_EMP_TERMINATION_REASON_CODE is coming out as BlankSummary: PER_EMP_TERMINATION_REASON_CODE is coming out as Blank Content (please ensure you mask any confidential information): Hi Team, We have the DBI usage of PER_EMP_…
-
Export Specific Common Lookup Codes with translationSummary: Export Specific Common Lookups Content (please ensure you mask any confidential information): How to export SPECIFIC Common Lookup Codes with translation from D…
-
Beginning Balance of Accrual in Absence Plan WrongSummary: Hello, I have an extract that uses the UE ABS_EXT_PER_ACCRUAL_UE. We have people getting an adjustment of 22 in their absence plan every 16th of June. This is d…
-
HCM Extract completing with Alerts with no output generated when using aggregate conditionSummary: Hi Team, We have a requirement to get the sum of the attribute conditionally in HCM extract by using it as a summary element. When I am trying to make use of th…