EBS Technical

Onhand Inventory by Revision Report

Onhand Inventory by Revision Report Introduction This Query will help to generate the On-hand Inventory by Revision Report Script: Step 1: Create Package Spec CREATE OR REPLACE PACKAGE xxxx_inventory_pkg AS…

Read More

OPMNCTL startall Fails with “unexpected exit: status 4200”

While trying to start the opmnctl services in idm we are getting 4200 error code as below applmgr@*****:~ $ applmgr@*****:~ $ /*****/fmw/idm/instances/IDM_inst1/bin/opmnctl startall opmnctl startall: starting opmn and all managed…

Read More

Autoinvoice Program Error correction Script on Duplicate Invoice Number

Header : Load data into oracle receivables transactions Usage of Heading : Useful to collect amount from customers that has been consumed through invoice number/Trx Number Description of post :…

Read More

Autoinvoice Program Error correction Script on Offset Account and Revenue Account

please_complete_offset_account_ra_interface_lines_all Header : Load data into oracle receivables transactions Usage of Heading : Useful to collect amount from customers that has been consumed through invoice number/Trx Number Description of post…

Read More

Autoinvoice Program Error correction Script on Rule Start date

Header : Load data into oracle receivables transactions Usage of Heading : Useful to collect amount from customers that has been consumed through invoice number/Trx Number Description of post :…

Read More

Oracle GL Transaction Register Report

Header : Outbound details from oracle general ledger Usage of Heading : Useful to get General ledger transaction details information data Description of post : This query is very useful…

Read More

Form Personalization on Purchasing Receipt Standard Form

Header : How to apply Form Personalization on Purchasing Receipt Standard Form Usage of Heading : Useful in the purchasing module in receipt of goods Description of post : Form…

Read More

How to Enable DFF in Bank Account Transfer Page

Header : How to Enable DFF in Bank Account Transfer Page Usage of Heading : Useful in the cash management module in banking page Description of post : DFF means…

Read More

SQL Query to Extract the Corporate Card Inter-Company Accounting Details in Oracle APPS R12

SQL Query to Extract the Corporate Card Inter-Company Accounting Details in Oracle APPS R12 Introduction This script will help to extract the complete Corporate Card Inter-Company Accounting Details in Oracle…

Read More

Understanding XML Bursting in BI Reports

XML Bursting is used to split a single XML file in to multiple XML blocks as the per the defined XML Element. Below are the Steps involved. Generate the XML…

Read More