Cloud ERP
Overview: Allows a fulfillment process to be “paused” until a specific condition is met. A pause task temporarily stops an orchestration process from running so that it can wait for a condition to be met. When the condition is met, the orchestration process releases this pause task, then proceeds to the next orchestration process step. … Read more
Replacing an item with some other item to fulfill the sales order when the item is out of stock or partially available. Item Substitution will work only when the base item is not available in Inventory. If the ordered item is partially available, then the line get split into ordered item and the substitute item … Read more
Business(es) has a requirement to use the customer’s part number instead of our internal number when creating sales order. This will allow us to directly align our sales order process how customers identify products on their Purchase Orders, facilitation smoother order processing, including B2B sales order creation. Here are the detailed steps to implement the … Read more
A freight carrier is a commercial company that transports shipment/deliveries to and from customers, suppliers and internal organizations. Freight Carriers are setup commonly for the Order Management, Inventory and Procurement. The freight carriers are setup with their model of transport like Air, Ground, Ocean, Service levels like 1 Day, 2 day and Overnight etc., and … Read more
Overview: Sales Order demand triggers supply creation, and a link is established between the sales order and the supply Requisition / Purchase Order. Back-Back fulfillment is used when we prefer not to keep stock on-hand. Secondly, It provides 360 degree visibility of the supply creation and fulfillment process Back to Back fulfillment is a 3 … Read more
A set of order lines that Order Management ships together as one group. All of these order lines ship and arrive on the same date, although they might be spread across more than one package, depending on packing requirements. Shipment sets can be assigned on an individual order line or Group of lines in an … Read more
Here is the SQL Query to get Back2Back Sales Orders and their corresponding Supply Order details. SELECT sh.SUPPLY_ORDER_REFERENCE_NUMBER “Sales Order”,sl.SUPPLY_ORDER_REF_LINE_NUMBER “SOLine_Num”,sh.SUPPLY_ORDER_NUMBER,sh.status_code hdr_status,sh.SUPPLY_ORDER_SOURCE,sl.LINE_NUMBER “Supply_Lines”,sl.EXEC_SYSTEM_ITEM_NUMBER “Item”,sl.quantity Requested_Qty,stl.status_code status,–stl.quantity tl_qty , stl.available_quantity avail_qty ,sl.need_by_date Requested_Delivery_Date,sl.supply_type supply_type,sl.DESTINATION_ORGANIZATION_CODE Supply_Destination, –sl.DESTINATION_BU_ID , sl.DESTINATION_ORGANIZATION_ID ,sl.MOVEMENT_REQUEST_FLAG,sl.contract_manufacturing_flag CM_FLAG,sl.back_to_back_flag B2B_FLAG,sl.CONFIG_ITEM_FLAG,sl.OUTSIDE_PROCESSING_FLAG OSP_FLAG,DECODE (stld.document_type,‘ORA_PR’, ‘Purchase Requisition’,‘ORA_PO’, ‘Purchase Order’,‘ORA_RSV’, ‘Reservation’,‘ORA_RCPT’, ‘Receipt’,‘ORA_TO’, ‘Transfer Order’,‘ORA_WO’, ‘Work Order’,‘ORA_SH’, ‘Shipment’) “Document Type”,stld.document_number … Read more
Business has a common requirement to find out all the open Sales Order Pick Slips (Released to the warehouse, but not yet pick confirmed) in their operation, including sourcing sub-inventory and locator info. We should able to find out all the open pick slips using Manage Shipment Lines or Confirm Pick Slips UI screens in … Read more
Price List Administrator(s)/Pricing Manager(s) have a requirement to review the price list(s) on regular intervals and update the price lists. There are two options to update price for the item(s) on the price list. First option is to update the price thru Manage Price Lists UI Screens, but it has to be done item by … Read more
Business has a common requirement to mass update sourcing rules/sourcing assignments frequently for the Supply Planning/GOP Assignment Set. Sourcing assignments can be updated thru standard user interface screen (Manage Assignment Sets, but it has to updated one by one and takes a lot of time. Oracle provided an additional feature in Oracle Fusion to mass … Read more