SQL
Discussion List
-
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…
-
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 34 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 31 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- 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 +…
-
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… -
23c has destroyed my ability to research UE and DBISummary: Content (required): Does anyone have backend SQL to research the UE and which DBI are attached to each? Version (include the version you are using, if applicabl…
-
To capture Personal Payment method changesSummary: To capture Personal Payment method changes Content (required): Planning to develop a extract to capture personal payment method changes . My question is , how t…
-
HCM Extract| How to include Active User Account in HCM ExtractSummary: Hi Experts, We have built an extract which pulls the Employees by their User Category. We wanted to include the Active User Account in the HCM extract. We could… -
We need to use Per_Jobs.attribute1 DFF to identify Manage role provisioning rulesSummary: We have a custom per_Jobs.attribute1 DFF that identifies the classification of workers (office, field, field supervisor). Can we setup Role Auto provisioning ru… -
Added new delivery options at Element Result Report but output is not available once we runSummary: Added new delivery options at Element Result Report but output is not available once we execute Run Element Result Register flow Content (required): Added new d…
-
Is there any query/table/report that shows the list of published sandboxes and the changes madeSummary: Required to get the list of published sandboxes in the application and the changes done as part of the sandbox Content (required): Required to get the list of p…Nisha_Hegde 163 views 1 comment 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM
-
Does exist a way to know which database tables gets modified when user inserts data from UI?Summary: Does exist a way to know which database tables gets modified when user inserts data from UI? Content (required): Does exist a way to know which database tables …Stefano_Mazzocca 41 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
How to bulk reset the password using REST APISummary: I have gone through the documentation from Oracle Doc ID 2346455.1, Application used Postman, and this is the error I have received: Error 403--Forbidden …Sumbul Salim 86 views 8 comments 0 points Most recent by Kishore Padala-Support-Oracle Applications Security