ORACLE ERP & APPS TECH

Process steps to Disable ATO items (uncheck ATO flag) Pre-Requisites : 1-> Cancel Schedule program -  AutoCreate Final Assembly Orders 2-> Close or Cancel Internal Orders 3-> Ship & complete Order to close for Awaiting Shipping & Awaiting Returns status order lines. 4-> Accept and close Pre_Billing Acceptance order lines. Action Steps : 1 a-> Cancel all Reservations against the item to un-check ATO flag. 1 b-> May require cancellation of WO (re-check with your functional folks) 2-> Cancel all Sales Order lines against the Items. 3-> Un-Check ATO Flag (REPLENISH_TO_ORDER_FLAG = 'N') 4-> Re-create cancelled Order lines if required.

Script to upload items for a given quote and vendor: --SET SERVEROUTPUT ON; DECLARE V_ITEM_ID           mtl_system_items_b.inventory_item_id%TYPE; V_PRICE             PO_LINES_ALL.UNIT_PRICE%TYPE; V_ITEM_DESC         mtl_system_items_b.DESCRIPTION%TYPE; V_line_num          PO_LINES_ALL.LINE_NUM%TYPE := 0; V_organization_id   mtl_system_items_b.organization_id%TYPE; CURSOR C1 IS select msib.inventory_item_id,msib.segment1 ITEM_NUM,        msib.DESCRIPTION,        msib.PRIMARY_UNIT_OF_MEASURE UOM       ,msib.organization_id,mic.category_id,        (select ITEM_COST    from cst_item_costs   where INVENTORY_ITEM_ID = msib.INVENTORY_ITEM_ID     and ORGANIZATION_ID = msib.ORGANIZATION_ID     and COST_TYPE_ID =1) price  from mtl_system_items_b msib,       mtl_item_categories mic where msib.INVENTORY_ITEM_ID = mic.INVENTORY_ITEM_ID and msib.ORGANIZATION_ID = mic.ORGANIZATION_ID and msib.organization_id = 12 and mic .CATEGORY_SET_ID = 1001 AND msib.segment1 in ('2

Query to Assign Items to Sourcing rule: --SET SERVEROUTPUT ON; DECLARE V_ASSIGNMENT_ID             MRP_SR_ASSIGNMENTS.ASSIGNMENT_ID%TYPE;  V_ASSIGNMENT_SET_ID    MRP_SR_ASSIGNMENTS.ASSIGNMENT_SET_ID%TYPE := 1; V_ASSIGNMENT_TYPE       MRP_SR_ASSIGNMENTS.ASSIGNMENT_TYPE%TYPE := 1; V_SOURCING_RULE_ID      MRP_SR_ASSIGNMENTS.SOURCING_RULE_ID%TYPE := 1001; V_SOURCING_RULE_TYPE   MRP_SR_ASSIGNMENTS.SOURCING_RULE_TYPE%TYPE :=1; V_organization_id                    MRP_SR_ASSIGNMENTS.organization_id%TYPE; CURSOR C1 IS select msib.inventory_item_id,msib.segment1 ITEM_NUM,msib.organization_id    from mtl_system_items_b msib where msib.organization_id = 12   AND msib.segment1 in ('2017');  BEGIN   FOR SR IN C1 LOOP     V_organization_id := SR.organization_id ;      IF V_organization_id = 12 THEN             BEGIN                           V_ASSIGNMENT_ID := MRP_SR_ASSIGNMENTS_S.NEXTVAL ;                                    INSERT INTO MRP_SR_ASSIGNMENTS MSRA