Cloud ERP
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
Here is the SQL Query to get all the open shipment lines and their statuses. This will help shipping manager/shipping user to find out all the open shipment lines, including awaiting to be released, Released to Warehouse, but not yet picked, Staged and Shipped etc., We can get the same info from Manage Shipment lines … Read more
Safety stock quantity ae maintained in inventory to cover any fluctuations in demand. Maintaining a sufficient level of safety stock allows businesses to continue supplying goods to their customers even if they encounter supply disruptions. Here are the detailed steps to implement safety stock planning method with user defined quantities Navigation: PIM > Manage Items … Read more
Overview: Sales Order demand triggers supply creation, and a hard link is established between the Sales Order and Supply Work Order. Back-Back fulfillment is used when we prefer not to keep stock on-hand and it is supported for Discrete Manufacturing only. Back to Back fulfillment is a 3 step process. Implementation Steps: Below are the … Read more