SQL
Discussion List
-
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… -
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… -
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…
-
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… -
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 24 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 44 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 71 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? …
-
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 …
-
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…
-
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 61 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle HCM Integrations -
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…Cansel Karasoy 41 views 5 comments 0 points Most recent by Murthy Kodavati Integrations and Extensions -
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…
-
HCM Extracts - Using Secure Views in Data Group Filter CriteriaSummary: Queries around secured views in data group filter criteria Content (required): Hello, We have an HCM extract to fetch demographic and payroll information. The e…
-
SQL Query to get the Balance dimensions and corresponding context valuesSummary: SQL Query to get the Balance dimensions and corresponding context values Content (required): We are looking to get the balance dimension names and context value…
-
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 41 views 0 comments 0 points Started by Claudio Marini-Oracle HCM Integrations
-
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…Raghavendra M 23 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle HCM Integrations -
Data Extract - Most RecentSummary: Is it possible to create a data extract an only get the latest relavant information for a given person whether the person is PWK, EX_PWK, CWK, EX_CWK, EMP or EX…