Order Management

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, fusion.wsh_delivery_assignments wda, fusion.wsh_new_deliveries wnd, fusion.wsh_delivery_details wdd, fusion.inv_material_txns imt  WHERE dha.header_id=dfla.header_id    AND dfla.fulfill_line_id=wdd.source_shipment_id    AND wdd.delivery_detail_id=wda.delivery_detail_id    AND wda.delivery_id=wnd.delivery_id(+)…

Read More

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_status VARCHAR2 (1); x_msg_count NUMBER; x_msg_data VARCHAR2 (32767); l_changedattributetabtype wsh_delivery_details_pub.changedattributetabtype; BEGIN fnd_global.APPS_INITIALIZE (0, 21676, 385); — Provide user_id, resp_id and…

Read More

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_version NUMBER := 1.0; p_init_msg_list VARCHAR2(30); –Parameters for WSH_DELIVERIES_PUB.Delivery_Action. p_action_code VARCHAR2(15); p_delivery_id NUMBER:= p_delivery_id_s; p_delivery_name VARCHAR2(30); p_asg_trip_id NUMBER:=p_trip_id;…

Read More

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 shipped quantity line should…

Read More

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  

Read More

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

Read More

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

Read More

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 custom table. oe_order_pub.Process_Order is the…

Read More

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 – Generic Negotiation Flow: Negotiation Flow – Generic with…

Read More

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 validate the workflow then…

Read More