Monday, 6 January 2020

Upload revision of items in oracle apps r12

Suppose Item Revision did not get updated then we need to push it again on Interface Table and submit "Import Items" request to create Item Revisions :

INSERT INTO mtl_item_revisions_interface 
            (item_number, 
             revision, 
             organization_id, 
             description, 
             effectivity_date, 
             process_flag, 
             set_process_id, 
             transaction_type) 
SELECT A.segment1, 
       '0', 
       organization_id, 
       NULL, 
       CREATION_DATE,--SYSDATE, 
       1, 
       120, 
       'CREATE' 
FROM   mtl_system_items A
WHERE  A.organization_id = <Organization_Id>
       AND NOT EXISTS (SELECT 1 
                       FROM   mtl_item_revisions X 
                       WHERE  X.inventory_item_id = A.inventory_item_id 
                              AND X.organization_id = A.organization_id 
                              AND X.revision IS NOT NULL 
                              AND X.revision_label IS NOT NULL); 
commit;



No comments:

Post a Comment