SQL
Discussion List
-
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…Bianca Lei Villareal 101 views 3 comments 0 points Most recent by Bianca Lei Villareal HCM REST APIs -
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… -
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 352 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 42 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 362 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 51 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? …
-
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 …
-
Flow Schedule to have next schedule just after earlier runSummary: Flow Schedule to have next schedule just after earlier run Content (required): Hi Team, Greetings! We have a requirement to have the next flow submitted just af…
-
Bulk sending of notifications of records with errors in integration by mailHi, In the integration we have prepared, a notification has been prepared for the records that have fallen into error, but how is it possible to send the wrong person re… -
Getting below exception while calling a REST API using GROOVY script from Application Composergroovy.lang.missingpropertyexception : no such property: result for class: java.lang.string Code Snippet: def ModeSelection = [ ModeSelection :SelectMode_c, ] def respon…