Introduction: This blog has the script to get the Non po invoice details in Oracle Cloud application for Audit purpose. Cause of the issue: Auditor wanted to see the Non-PO invoice details. How [...]
Introduction: This blog has the script to get the credit memo application details in Oracle Cloud application for Audit purpose. Cause of the issue: Auditor wanted to see the credit application [...]
Introduction: This blog has the SOAP Webservice details that can be used to update the customer send statement and send dunning flag into Oracle Cloud application. Cause of the issue: [...]
Introduction: This blog has the SOAP Webservice details that can be used to update the customer statement delivery method into Oracle Cloud application. Cause of the issue: Business wants [...]
Introduction: This blog has the SQL query that can be used to pull the HR Contingent Worker details per country for EBS to Cloud data migration. SQL Query : SELECT DISTINCT [...]
Introduction: This blog has the SQL query that can be used to pull the lease assets details per asset book for EBS to Cloud data migration. SQL Query: SELECT fb.book_type_code asset_book [...]
Introduction: This API will create Item categories in EBS. SET SERVEROUTPUT ON; DECLARE v_return_status VARCHAR2(1) := NULL; v_msg_count NUMBER := 0; [...]
Introduction: This script will used to extract the AR partial credit memo’s with reference invoice details. select c.trx_number CM_Number, c.trx_date CM_DATE, (select a1.account_number from [...]
Introduction. This API will used to adjust the Fixed asset details like life_in_months and etc. declare l_trans_rec FA_API_TYPES.trans_rec_type; l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type; [...]