
Venkanna Mittakanti's ORACLE ERP Blog
18 FOLLOWERS
This is Venkanna Venkat Reddy / Venky Mittakanti from Houston,TX. Welcome to my Oracle blog! I am certified as an Oracle ACE by Oracle Corporation. I have over 21 years of experience working with Oracle EBS and Oracle technologies, specifically focusing on implementing, designing, developing and maintaining of Oracle EBS since 2002.
Venkanna Mittakanti's ORACLE ERP Blog
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
Venkanna Mittakanti's ORACLE ERP Blog
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
Venkanna Mittakanti's ORACLE ERP Blog
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
Venkanna Mittakanti's ORACLE ERP Blog
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
Venkanna Mittakanti's ORACLE ERP Blog
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
Venkanna Mittakanti's ORACLE ERP Blog
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
Venkanna Mittakanti's ORACLE ERP Blog
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
Venkanna Mittakanti's ORACLE ERP Blog
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
Venkanna Mittakanti's ORACLE ERP Blog
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
Venkanna Mittakanti's ORACLE ERP Blog
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