R12 Oracle General Ledger Setup
r12-oracle-general-ledger-setup
Read MoreOracle EBS – Archive the file with Script
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 MoreSERVICE CONTRACT – Oracle External Table
This 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 OEM
Deploying 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 MoreSplit Sales Order Line using script.
Shipment 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
Integrated 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
APPS_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 MoreAP Invoice To GL Link Query with additional attribute values
This 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 MoreAP Bank details query with additional attributes values
The 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 MoreWorkflow Script Deassign user from role
Oracle 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 More