Query for API to Update Profile Value – SSO to Local
Introduction This Post illustrates the steps required to update the profile value –SSO to LOCAL through API in Oracle EBS R12 Script to through API Update Profile Value – SSO to…
Read MoreAbout How to Delete Stuckked/corrupted Lock Box Transmission format.
Introduction This Post Is About How to Delete Stuckked/corrupted Lock Box Transmission format. Script to Delete Stuckked/corrupted Lock Box Transmission format :- select * from APPS.AR_TRANSMISSIONS_ALL where TRANSMISSION_NAME=’IMCC161107′;…
Read MoreOracle Sql to get Profile Option Values at Responsibility level
Introduction This Post illustrates the steps required to get Profile Option Values at Responsibility level in Oracle EBS R12 Script to get Profile Option Values at Responsibility level SELECT frv.responsibility_name, fpo.profile_option_name, fpot.user_profile_option_name,…
Read MoreHow to Convert Comma Separated Values into Table using ‘REGEXP_SUBSTR.’
Introduction This Post is about to Convert Comma Separated Values into Table using WITH CSV’ REGEXP_SUBSTR.’ AS (SELECT ‘AA,BB,CC,D33D,EE,FFDD,MM,GG’ AS csvdata FROM DUAL) SELECT REGEXP_SUBSTR (csv.csvdata, ‘[^,]+’, 1, LEVEL) pivot_char…
Read MoreAPI to Update Customer Account in TCA R12
Introduction This Post is about to Update Customer Account in TCA R12. Script to Update Customer account in TCA R12. DECLARE p_cust_account_rec HZ_CUST_ACCOUNT_V2PUB.CUST_ACCOUNT_REC_TYPE; p_object_version_number NUMBER; x_return_status …
Read MoreReport Will Fetch All Vat Details In The Ap Module
Introduction This Post is about to Report Will Fetch All VAT details in the AP Module in Oracle EBS-R12. <dataTemplate name=”IRNGLBFRTVAAP” version=”1.0″> <parameters> <parameter name=”P_ACCT_FROM_DT” dataType=”DATE”/> <parameter name=”P_ACCT_TO_DT” dataType=”DATE”/>…
Read MoreQuery for Employee data extraction based on business group
Introduction This Post illustrates the steps required to Extract the employee data based on business group in Oracle EBS R12 Script to Employee data extraction based on business group SELECT hou.name business_unit,…
Read MoreQuery for PO Blanket details along with receipt and Indian tax details
Introduction This Post illustrates the steps required to PO Blanket details along with receipt and Indian tax details in Oracle EBS R12. Script to PO Blanket details along with…
Read MoreREVENUE TRANSFER REPORT (FUSION)
Introduction This Post illustrates the steps required to get the Revenue Transfer Report in Fusion Application. Script to REVENUE TRANSFER REPORT (FUSION) Purpose of this report is to derive all projects…
Read More