AP 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 MoreGL Flexi ield Query with additional details
GL 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 MoreAP PO Vendor Creation interface with additional attributes
Payables modules are used to create supplier related information in oracle. In this module we can create supplier invoice bank etc will be maintained. This script used to create Supplier…
Read MoreInventory Lot Creation Interface
Inventory module used to create items in oracle. This module will link with AP, PO, GL modules. In inventory we have lot concepts where we will create lots , so…
Read MoreAutoinvoice 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 MoreAutoinvoice 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 MoreAutoinvoice 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 MoreOracle 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