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 any Order Type assigned…
Read MoreQuery 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 MoreShipment 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 MoreShip 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 MoreSplit 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 MoreBack 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 MoreUpdating 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 MoreBlanket 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 MoreSales 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 MoreBlanket 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