Blog / Category
Order Management
26 articles in this category
Personalization for Order Type in Oracle Apps R12
Introduction: In Oracle Apps R12 Order Management, users create Sales Orders using the Sales Order Form (OEXOEORD). By default, the form allows users to select…
Query to get Shipping and Inventory Material Transactions in fusion.
SELECT dha.source_order_number, dha.order_number, dfla.status_code, dfla.source_line_number FROM fusion.doo_headers_all dha, fusion.doo_fulfill_lines_all dfla,…
Shipment Tracking Number Update using API
procedure xxdm_upd_ship_num_in_orcl(p_delivery_detail_id NUMBER, p_thirsd_party_tracking_number VARCHAR2) is l_index NUMBER; l_msg_return NUMBER; x_return_statu…
Ship Confirm of multiple deliveries Using API in EBS
PROCEDURE XDM_SHIP_CONFIRM(p_delivery_id_s NUMBER, p_shipping_method VARCHAR2, p_trip_id number, p_close_trip_flag VARCHAR2) IS –Standard Parameters. p_api_vers…
Split 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 ship…
Back to Back Sales Order Cycle Setups and Process Flow in R12
Back to Back Sales Order Cycle Setups and Process Flow in R12 back-to-back-sales-order-cycle-setups-and-process-flow-in-r12
Updating Unit List Price in Blanket Sales Agreement in R12
Updating Unit List Price in Blanket Sales Agreement in R12.2 updating-unit-list-price-in-blanket-sales-agreement-in-r12
Blanket Sales Agreement with Approvals and Release in Oracle R12
Blanket Sales Agreement with Approvals and Release in Oracle R12 blanket-sales-agreement-with-approvals-and-release-in-oracle-r12
Sales Order Update
Below is the standard API to update sales order deliver to information based on shipment method. Shipment method & deliver to information are maintaining in cus…
Blanket Sales Agreement with Approvals and Release in Oracle R12.2
Setups Required: 1. Transaction Type: Create an order transaction type. Sales Document type should be “Sales Agreement“. Fulfillment flow: Sales Agreement – Gen…
Back to Back Sales Order Cycle Setups and Process Flow in R12.2
Back to Back Orders in Oracle Setups Required: Step1: Create Transaction type. Use Order Fulfillment flow as Order Flow – Generic. Use the Line flow and validat…
Unable to View or Add any Items in Sales Orders
&nbs…
Sale Quote Configuration with Creation and Approval process in R12
Oracle Sales Quote – Approval – Setup Oracle Sale Quote is the system that offers excellent opportunity for the sales guys to create/follow up and play with the…
Allow Negative Quantity functionality in Shipping Process
Purpose: The purpose of this Document is to provide some troubleshooting guide for issue where sales orders are not getting backordered even though insufficient…
Order Management Under Shipment Tolerance functionality while splitting the order lines in R12.2
Remained Order Line gets cancelled after we split the Order line in shipping tranasaction form and ship the line. This document makes you understand the…
Updating Unit List Price in Blanket Sales Agreement in R12.2
Updating Unit List Price in Blanket Sales Agreement Exercise 1: Firstly we will try to create a Blanket Sales Agreement. Responsibility: Order management Super…
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 enabli…
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 in…
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 occu…
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…
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 suppli…
MANUAL SHIP CONFIRM PROCESS IN ORDER MANAGEMENT ORACLE EBS R12.2
MANUAL SHIP CONFIRM PROCESS IN ORDER MANAGEMENT ORACLE EBS R12.2 Concept: Once the pick release and pick confirm process is over, the details will be assigned t…
Order Import Issue – Item with inventory_item_id=XXXXXX is not defined in Item validation Org XXX
IR-ISO – Order Import Issue Issue: Approved Internal Requisitions are not converted into Internal Sales Orders. Description: In Purchasing Responsibility, an In…
Credit Check Functionality in Order Management
1) Overview: The ultimate goal of Credit Management processes is to minimize the financial risk that your organization assumes as a result of day-to-…
How to Resolve the Shipping Exception Issue – Schedule Date has been Postponed – Exception Name "WSH_CHANGE_SCHED_DATE"
Issue: Sometimes, we may change the Schedule Ship Dates in the Sales Orders. When we try to do the Ship Confirm for those changed orders, system will not allow…
How to Add or Assign the Printer to a desired Reports
How to Add/Assign the Printer to a desired Report Responsibility: Order Management Super User Navigation: Setup > Shipping > Documents > Choose Printers “Choose…