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