Introduction: This Post illustrates the steps to Update the schedule ship date in Order Lines using API. Script to Update the Scheduled Ship Date in Order Lines DECLARE p_scheduled_ship_date DATE…
Read MoreUsing the below query we can track the DML operations made on Supplier’s.It is useful script for Auditing and Tracking purposes. select DISTINCT a.segment1 vendor_number,A.VENDOR_NAME,c.name org_name,a.creation_date supplier_creation_date, (select user_name…
Read MoreORA-02082: a loopback database link must have a connection qualifier Such error occurs when there is a db link which is a loop back database link i.e. points to itself…
Read MoreFix — ORA-19505: failed to identify file in RMAN RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of backup command on ch00 channel at 01/17/2011…
Read Moresolution: ORA-65086: cannot open/close the pluggable database — Unplug a pluggable database SQL> ALTER PLUGGABLE DATABASE VELDB close immediate; Pluggable database altered. SQL> ALTER PLUGGABLE DATABASE VELDB UNPLUG INTO ‘/u01/DB/bkp_pdb/VELDB.xml’;…
Read MoreIntroduction: This is used to fix the invalid revenue account for AR invoice Auto accounting is used to determine the accounts when the distribution table is not populated. When Auto…
Read MoreThe below query extracts the Tax Registration details such as Tax Regime Code, Registration Number of Suppliers from Fusion Applications. SELECT HP.party_name supplier_name ,SUP.segment1 supplier_number ,ZR.TAX_REGIME_CODE ,ZR.REGISTRATION_NUMBER tax_registration_number ,ZR.EFFECTIVE_FROM…
Read MoreI am trying to start EM on my newly created database, while starting EM, getting failed with OC4J Configuration issue… while diagnosed there is no OC4J_DBConsole_localhost directory exist in ORACLE_HOME.…
Read MoreAfter Completion of oracle clone , faced issue while running autoconfig. ERROR : ——– ERROR at line 1: ORA-04091: table APPLSYS.FND_PROFILE_OPTION_VALUES is mutating, trigger/function may not see it ORA-06512: at…
Read MoreError : ======= Bad header found during buffer read Data in bad block: type: 2 format: 2 rdba: 0x21008dd0 last change scn: 0x0006.12114f8e seq: 0x37 flg: 0x04 spare1: 0x0 spare2:…
Read More