Oracle ERP Cloud Instance Clone/Refresh Guidelines
Here is the article on the process to create a clone/refresh request and the guidelines to consider for a better planning P2T – PROD as… Read More »Oracle ERP Cloud Instance Clone/Refresh Guidelines
Shailender Thallam
ESS Request History with Time took to Run
/********************************************************* *PURPOSE: SQL Query to find ESS Job History * *AUTHOR: Shailender Thallam * *********************************************************/ SELECT p.requestid parent_request_id, m.requestid request_id, NVL(p.name, substr(p.DEFINITION, instr(p.DEFINITION, ‘/’, -… Read More »ESS Request History with Time took to Run
Payload to Update AR Invoice DFF in Oracle ERP Cloud
We have REST Service “receivablesInvoiceDFF“to Create an AR Invoice DFF, but unfortunately we cannot update DFF with REST Service. We have a SOAP Service “ERP… Read More »Payload to Update AR Invoice DFF in Oracle ERP Cloud
Emails generated by Oracle ERP are delivered to customer/Supplier with from email address as “no-reply@oracle.com” instead of no-reply@client-DomainName.com
Sometimes you may observe that emails sent out to customers or suppliers from oracle are with from address as “no-reply@oracle.com” instead of your client domain… Read More »Emails generated by Oracle ERP are delivered to customer/Supplier with from email address as “no-reply@oracle.com” instead of no-reply@client-DomainName.com
Oracle ERP Cloud SQL Query to find Bank Accounts Associated with a Supplier
/******************************************************************* *PURPOSE: ERP Cloud SQL Query to find Bank Accounts Associated with a Supplier * *AUTHOR: Shailender Thallam * *******************************************************************/ SELECT ps.segment1 AS vendor_num ,… Read More »Oracle ERP Cloud SQL Query to find Bank Accounts Associated with a Supplier
SQL Query to Validate Email Address
/******************************************************************* *PURPOSE: SQL Query to validate email address * *AUTHOR: Shailender Thallam * *******************************************************************/ SELECT EMAIL_ADDRESS FROM HZ_CONTACT_POINTS WHERE EMAIL_ADDRESS IS NOT NULL AND NOT… Read More »SQL Query to Validate Email Address
How to find Oracle Fusion Instance Name through SQL
We can find instance name using FUSION.ASK_DEPLOYED_DOMAINS table. /******************************************************************* *PURPOSE: SQL Query to find Oracle FUsion Instance name * *AUTHOR: Shailender Thallam * *******************************************************************/ SELECT… Read More »How to find Oracle Fusion Instance Name through SQL
SQL Query of Manage Data Access along with Security Context
SELECT * FROM ( SELECT gl.name , ROLE.role_name , pu.username FROM fusion.fun_user_role_data_asgnmnts ROLE , fusion.gl_access_sets gl , fusion.per_users pu WHERE gl.access_set_id = ROLE.access_set_id AND pu.user_guid… Read More »SQL Query of Manage Data Access along with Security Context
Process to Upload Public/Private Key for File Transmissions in Oracle ERP Cloud
Refer to Blog Post for generating Public/Private Key combination Through File Import and Export wizard, Private key should be uploaded to UCM Account “fin/payments/import“ Note:… Read More »Process to Upload Public/Private Key for File Transmissions in Oracle ERP Cloud
Oracle ERP Cloud – SQL Query to get Organization Structure along with Legal Entity, Business Unit, Ledger and Flex Values
/******************************************************************* *PURPOSE: SQL Query to get Org Structure along with LE, BU, Ledger and Flex * *AUTHOR: Shailender Thallam * *******************************************************************/ SELECT horg.name enterprise ,… Read More »Oracle ERP Cloud – SQL Query to get Organization Structure along with Legal Entity, Business Unit, Ledger and Flex Values