OracleAppsDNA

Oracle ERP Cloud Instance Clone/Refresh Guidelines

Shailender Thallam — Fri, 25 Mar 2022 17:23:59 +0000

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 a source instance and TEST as target Instance clone. TEST can be any NON PROD instances like DEV, SIT and TEST T2T – TEST to TEST instance clone. This is… Read More »Oracle ERP Cloud Instance Clone/Refresh Guidelines

The post Oracle ERP Cloud Instance Clone/Refresh Guidelines first appeared on OracleAppsDNA.

ESS Request History with Time took to Run

Shailender Thallam — Sun, 07 Nov 2021 10:50:28 +0000

/********************************************************* *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, '/', - 1) + 1, length(p.DEFINITION))) parent_job_name, NVL(m.name, substr(m.DEFINITION, instr(m.DEFINITION, '/', - 1) + 1, length(m.DEFINITION))) job_name, FLV1.MEANING parent_request_state, FLV2.MEANING child_request_state, TO_CHAR(m.processstart, 'DD-MM-YYYY HH24:MI:SS') START_DATE, TO_CHAR(m.processend, 'DD-MM-YYYY HH24:MI:SS') END_DATE, ( m.processend -… Read More »ESS Request History with Time took to Run

The post ESS Request History with Time took to Run first appeared on OracleAppsDNA.

Payload to Update AR Invoice DFF in Oracle ERP Cloud

Shailender Thallam — Thu, 17 Jun 2021 07:06:39 +0000

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 Object Descriptive Flexfield Update Service” to update DFF. This is a generic service to update DFF of several entities. Below is the sample payload: SINGLE Receivables Invoice #NULL 73003 300000019480136… Read More »Payload to Update AR Invoice DFF in Oracle ERP Cloud

The post Payload to Update AR Invoice DFF in Oracle ERP Cloud first appeared on OracleAppsDNA.

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

Shailender Thallam — Tue, 15 Jun 2021 16:09:39 +0000

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 “no-reply@ClienDomain.com”. This happens even if from email address is configured properly in the setup or hardcoded in the bursting query. This is because oracle is not authorized to send email… 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

The post 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 first appeared on OracleAppsDNA.

Oracle ERP Cloud SQL Query to find Bank Accounts Associated with a Supplier

Shailender Thallam — Thu, 21 Jan 2021 09:59:26 +0000

/******************************************************************* *PURPOSE: ERP Cloud SQL Query to find Bank Accounts Associated with a Supplier * *AUTHOR: Shailender Thallam * *******************************************************************/ SELECT ps.segment1 AS vendor_num , hzp.party_name AS vendor_name , pssm.attribute20 AS legacy_vendor_number , pssm.vendor_site_code , bank.party_name bank_name , branch.party_name branch_name , ieb.bank_account_name , ieb.bank_account_num , ieb.currency_code , ieb.Bank_Account_Name_alt AS TRANSIT_NUMBER , ieb.Secondary_Account_Reference AS ROUTING_NUMBER FROM… Read More »Oracle ERP Cloud SQL Query to find Bank Accounts Associated with a Supplier

The post Oracle ERP Cloud SQL Query to find Bank Accounts Associated with a Supplier first appeared on OracleAppsDNA.

SQL Query to Validate Email Address

Shailender Thallam — Mon, 30 Nov 2020 13:44:58 +0000

/******************************************************************* *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 REGEXP_LIKE(email_address,'^[a-zA-Z0-9._%-]+@[a-zA-Z0-9._%-]+\.[a-zA-Z]{2,4}$')

The post SQL Query to Validate Email Address first appeared on OracleAppsDNA.

How to find Oracle Fusion Instance Name through SQL

Shailender Thallam — Mon, 09 Nov 2020 06:22:57 +0000

We can find instance name using FUSION.ASK_DEPLOYED_DOMAINS table. /******************************************************************* *PURPOSE: SQL Query to find Oracle FUsion Instance name * *AUTHOR: Shailender Thallam * *******************************************************************/ SELECT external_virtual_host, SUBSTR (external_virtual_host, 1,instr(external_virtual_host,'.') -1) FROM fusion.ask_deployed_domains ad WHERE ad.deployed_domain_name='FADomain'

The post How to find Oracle Fusion Instance Name through SQL first appeared on OracleAppsDNA.

SQL Query of Manage Data Access along with Security Context

Shailender Thallam — Mon, 07 Sep 2020 14:55:51 +0000

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 = role.user_guid union select bu.bu_name , role.role_name , pu.username from fusion.fun_all_business_units_v bu , fusion.fun_user_role_data_asgnmnts role , fusion.per_users pu where role.org_id = bu.bu_id and pu.user_guid = role.user_guid union select led.name ,… Read More »SQL Query of Manage Data Access along with Security Context

The post SQL Query of Manage Data Access along with Security Context first appeared on OracleAppsDNA.

Process to Upload Public/Private Key for File Transmissions in Oracle ERP Cloud

Shailender Thallam — Fri, 17 Jul 2020 02:49:18 +0000

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: To run any bank related integrations, wallet has to be created and wallet is something specific to an instance. Wallet cannot be cloned from one instance to another instance. Also,… Read More »Process to Upload Public/Private Key for File Transmissions in Oracle ERP Cloud

The post Process to Upload Public/Private Key for File Transmissions in Oracle ERP Cloud first appeared on OracleAppsDNA.

Oracle ERP Cloud – SQL Query to get Organization Structure along with Legal Entity, Business Unit, Ledger and Flex Values

Shailender Thallam — Fri, 03 Jul 2020 05:57:46 +0000

/******************************************************************* *PURPOSE: SQL Query to get Org Structure along with LE, BU, Ledger and Flex * *AUTHOR: Shailender Thallam * *******************************************************************/ SELECT horg.name enterprise , horg.organization_id enterprise_id , xep.legal_entity_id , xep.name legal_entity , glev.flex_segment_value , gll.name ledger_name , gll.ledger_id , xr.registered_name , xr.alternate_registered_name , xr.registration_number , xr.place_of_registration , xr.effective_from , xr.effective_to , xep.name "LEGAL_ENTITY_NAME" ,… Read More »Oracle ERP Cloud – SQL Query to get Organization Structure along with Legal Entity, Business Unit, Ledger and Flex Values

The post Oracle ERP Cloud – SQL Query to get Organization Structure along with Legal Entity, Business Unit, Ledger and Flex Values first appeared on OracleAppsDNA.