Venkanna Mittakanti's ORACLE ERP Blog

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

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

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

Most of the businesses have requirement to get Indented BOM (Bill of Material) export of the assembly into the excel to validate the bill of material/item structure for the Engineering Change Request/Change Order changes, impacted Work orders/Sales orders etc., This is much needed for ETO (Engineer to Order) and CTO (Configure to Order) model items. … Read more

Here is the Item extract SQL which i used for the item data analysis and item updates thru FBDI. SELECT ESI.INVENTORY_ITEM_ID,ESI.ORGANIZATION_ID,ESI.ITEM_NUMBER,IOP.ORGANIZATION_CODE INV_ORG,— EIC.ITEM_CLASS_ID,EIC.ITEM_CLASS_NAME ITEM_CLASS,ESI.ITEM_TYPE ITEM_TYPE,(SELECT MEANINGFROM FND_LOOKUP_VALUES_VLWHERE LOOKUP_TYPE = ‘EGP_ITEM_TYPE’AND lookup_code = ESI.ITEM_TYPE) User_Item_type,ESI.PRIMARY_UOM_CODE PRIMARY_UNIT_OF_MEASURE,— ESI.WIP_SUPPLY_TYPE BUILD_IN_WIP,ESI.BUILD_IN_WIP_FLAG BUILD_IN_WIP,ESI.COSTING_ENABLED_FLAG COSTING_ENABLED,ESI.INVENTORY_ASSET_FLAG INVENTORY_ASSET_VALUE,DECODE (ESI.WIP_SUPPLY_TYPE,1, ‘Push’,2, ‘Assembly Pull’,3, ‘Operation Pull’,4, ‘Bulk’,5, ‘Vendor’,6, ‘Phantom’) PIM_SUPPLY_TYPE,(SELECT MEANINGFROM FND_LOOKUP_VALUES_VLWHERE LOOKUP_TYPE = ‘EGP_SERIAL_NUMBER_CONTROL_TYPE’AND … Read more

Problem: For the Global Order Promising Assignment Set, We have Item and Organization, Category and Organization, Category & Global level sourcing assignments. The global level sourcing rule was setup to source from multiple suppliers based on the priority. Some reason sales orders were processed as drop ship orders when the warehouse wasn’t entered at the … Read more

Here are the some commonly used SQLs/Tables in the Fusion SCM Cloud applications for implementation and support resources. This will help to understand the enterprise structure, setting up custom lookup and base tables in the SCM modules etc., 1. Business Units: Business Unit is nothing but operating unit in Fusion applications — Business UnitsSELECT * … Read more

Here is another SQL Which I extensively used to validate the price list conversions in the OM Cloud implementations and getting the price list(s) export from the Fusion SCM Applications. SELECT qplt.name “Price List”,qplt.price_list_type_code,qplt.currency_code Currency,qplt.start_date,qplt.end_date,qplt.description,qplt.org_id Business_Unit_ID,qplt.status_code Status,— qpli.price_list_item_id, qpli.price_list_id,qpli.item_level_code,(SELECT item_number FROM fusion.egp_system_items esi WHERE esi.inventory_item_id = qpli.item_id AND esi.organization_id=300000007099064) “Item”, — Master Org Id(SELECT unit_of_measure … Read more