Fusion Shipping – SQL Query to get all the Open Pick Slips
Venkanna Mittakanti's ORACLE ERP Blog
by Venkanna Mittakanti
9M ago
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 ..read more
Visit website
Fusion Pricing – Maintaining Price List data using ADFDI Excel Template
Venkanna Mittakanti's ORACLE ERP Blog
by Venkanna Mittakanti
9M ago
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 ..read more
Visit website
Oracle Fusion Supply Planning – Mass updating Sourcing Rules/Assignments thru ADFDI
Venkanna Mittakanti's ORACLE ERP Blog
by Venkanna Mittakanti
9M ago
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 ..read more
Visit website
Fusion Order Mgmt Cloud – SQL Query to get all the open shipment lines
Venkanna Mittakanti's ORACLE ERP Blog
by Venkanna Mittakanti
9M ago
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 ..read more
Visit website
Fusion Supply Planning – Implementing Safety Stock planning with user defined Quantities
Venkanna Mittakanti's ORACLE ERP Blog
by Venkanna Mittakanti
9M ago
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 ..read more
Visit website
Fusion SCM – Implementing Back to Back Make Flow
Venkanna Mittakanti's ORACLE ERP Blog
by Venkanna Mittakanti
9M ago
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 ..read more
Visit website
Fusion SCM – Implementing Drop Ship Order Process
Venkanna Mittakanti's ORACLE ERP Blog
by Venkanna Mittakanti
9M ago
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 ..read more
Visit website
Fusion Inventory – Receipt Routing for the Transfer Order Receiving
Venkanna Mittakanti's ORACLE ERP Blog
by Venkanna Mittakanti
9M ago
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 ..read more
Visit website
Fusion Inventory – Query to get Inventory On-Hand balances and Available To Reserve quantities
Venkanna Mittakanti's ORACLE ERP Blog
by Venkanna Mittakanti
10M ago
We have a common requirement from most of the businesses to get inventory on-hand balances and available to reserve quantities by item and sub-inventory for their operation(s). This will help them to understand the current inventory to fulfill the sales order(s)/work order(s) demand, commiting the delivery dates with the customers and planning to source the ... Read more ..read more
Visit website
Fusion SCM – SQL Query to get Transfer Orders data
Venkanna Mittakanti's ORACLE ERP Blog
by Venkanna Mittakanti
10M ago
Transfers Orders are used in Oracle Fusion SCM for the intercompany material transfers, similar to the Internal Requisition/Internal Sales Order process in the Oracle EBS. No cost markup for the material transfers within the BU. Across the Business Units/Legal entities, Transfer Pricing policies can be setup based on the Cost Plus markup / List Less ... Read more ..read more
Visit website

Follow Venkanna Mittakanti's ORACLE ERP Blog on FeedSpot

Continue with Google
Continue with Apple
OR