SQL
Discussion List
-
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… -
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… -
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_… -
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…
-
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… -
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… -
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…
-
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… -
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 +…
-
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… -
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…
-
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… -
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 …
-
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 48 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 46 views 3 comments 0 points Most recent by Mandeep Gupta 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 79 views 8 comments 0 points Most recent by Kishore Padala-Support-Oracle Applications Security
-
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 …
-
HDL Transformation Fast formula and PayrollInterfaceInboundRecordSummary: Hello: I need to write a HDL Transformation Fast formula to receive Garnishment Payment information from ADP and was reviewing the whitepaper "Loading_Payroll_I… -
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…Bianca Lei Villareal 57 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle HCM REST APIs
-
Custom API.Summary: Hi Expert, Good afternoon! Could we create job applications with the help of a custom API. Can someone refer me to any documents on how to create a custom API? …
-
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…
-
Security on HCM ExtractWe have created a extract and the customer want to implement security. Business Unit Security Need To Be Applied. The extract output should show only the records as per …