Oracle Application Blog

MTL Material Transactions Interface

Solution : This blog explains the technical approach for creating an automated interface to accept user supplied material transactions from External Systems and to import these transactions to Oracle as…

Read More

Daily Exchange Currency Rates Interface

Solution : URL will be passed as parameter where we can identify the currency rate conversion amount. FROM_CURRENCY , TO_CURRENCY and the date for when it has to be run…

Read More

Oracle Order Management Setup Document in R12.2

Definition: Oracle Order management is one of the most important part of the oracle EBS. The Order Management Application provides many flexible features enabling you to set up your system…

Read More

IR & ISO – Internal Sales Order Cycle with Setup Steps in R12.2

Definition: Internal Requisition/Internal Sales Order provide the mechanism for requesting and transferring material from one inventory organization to other inventory organization. Below is the process flow which has to be…

Read More

RMA – Return Material Authorizations in R12.2

Return Material Authorizations in OM Order Management provides sophisticated tracking of your return material authorizations (RMA). Returns from a customer occur for a variety of reasons including damage, shipment error,…

Read More

PO Return/Cancellation Issue – Primary quantity XX exceeds available subinventory quantity YY

Issue and Resolution Document for PO Returns and Cancellation Issue 1. Issue: Buyers are created the Purchase Orders with wrong items and they have submitted for Approval process. Then the…

Read More

BSA – Blanket Sales Agreement and Releases in Oracle R12.2

Definition: Blanket Sales Agreements are used when you have specific characteristics related to a purchasing agreement between a customer and a supplier. These characteristics include the date range of the…

Read More

Back 2 Back and Dropship Order Process in Oracle R12.2

This order type applies when customer orders a product which you do not stock or manufacture. In turn customer places the order, you place the order with supplier and after…

Read More

ADC – Automatic Document Creation in Oracle Purchasing R12.2

Concept: ADC is created for the documents like Blanket Purchase Agreement, Approved Quotes, and Contract Purchase Agreements to Release the Purchase Orders automatically. Below is the process flow for reference:…

Read More

Physical Counting in Oracle Inventory – R12.2

PHYSICAL COUNTING IN ORACLE EBS R12.2 Counting is used to verify the System On hand Quantity with Actual (Physical Qty) Quantity of the item and perform the adjustments in System…

Read More