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
Business has a common requirement to generate Shipping Documents (Packing List, Bill of Lading and Commercial Invoice) for the drop ship sales order from Oracle and share with Supplier(s), So supplier can use the selling organization’s shipping documents when shipping the products/items. This wasn’t feasible in the Oracle E-Business Suite world and the documentation was … Read more
Drop Shipment is a process where the Sales Orders are fulfilled using third party suppliers who ship the products/items directly to the customer, without physically receiving the material into the organization warehouse. Order Management sends a purchase request to Oracle Procurement, which places a purchase order with third party supplier, then the supplier ships directly … Read more
Transfer Orders are used for intercompany and intracompany inventory transfers. Internally Receipt Routing is defaulted and stored while shipping the transfer order from the sourcing organization. Here is the Receipt Routing Hierarchy for Transfer Orders receiving. Receipt Routing from the Item at Organization level takes highest precedence. If the receipt routing is blank at the … Read more