By using the bleow script, we can archive the file from specific folder to back up folder in the server location. # =============================================================================+ export ora_login=$1 export ora_userid=$2 export login_name=$3…
Read MoreThis is the sample script to create the oracle external table to access the data from the file. prompt prompt creating TABLE XX_SC_EXT ….. CREATE TABLE “XX”.”XX_SC_EXT” (…
Read MoreDeploying plugin on Oracle Enterprise Manager (OEM 13c) Introduction Greetings! This blog is all about deploying Oracle E-business suite (EBS) plugins on OEM and is your go-to guide for…
Read MoreShipment is happening from third party system and if partial shipment is happening then sales order line should be split based on balance quantity and with shipped quantity line should…
Read MoreIntegrated SOA Gateway – A Guide Introduction to Integrated SOA Gateway Oracle E-Business Suite Integrated SOA Gateway (ISG) is a complete set of service infrastructure to provide, consume, and…
Read MoreAPPS_DDL package issues in fs_clone This blog is intended for DBA’s who have issues in completing fs_clone. We applied a critical patch for one of the client and afterwards executed…
Read MoreThis query to Trace an AP Invoice to the GL. There is an Invoice in AP which is correctly Validated, Accounted, Approved etc. This will useful To find the GL…
Read MoreThe supplier (or External) bank account information are stored in the table called ce_bank_accounts. The bank and bank branches information are stored in CE_BANK_BRANCHES_V This script used to get bank…
Read MoreOracle Workflow delivers a complete workflow management system that supports business process based integration. Its technology enables modeling, automation, and continuous improvement of business processes, routing information of any type…
Read MoreGL module used to maintain credit and Debit details in oracle. Gl code combinations are used maintain details of company with respect to legal entity level. This script used to…
Read More