you can Import historical revisions for an Item through Import Items concurrent program
Execute following Steps to populate revision Interface :
1). Insert into MTL_ITEM_REVISIONS_INTERFACE table like below:
INSERT INTO MTL_ITEM_REVISIONS_INTERFACE
(ITEM_NUMBER,REVISION,ORGANIZATION_ID,DESCRIPTION,EFFECTIVITY_DATE,
PROCESS_FLAG, SET_PROCESS_ID , TRANSACTION_TYPE)
VALUES -- EXAMPLE DATA BELOW
('12122006-0','B',204,'REV-B',TO_DATE('30-JAN-2012','DD-MON-YYYY'),1,120,'CREATE');
COMMIT;
2). Run the concurrent program 'Import Items' specifying appropriate parameters.
3). Please check if revisions are created.
Execute following Steps to populate revision Interface :
1). Insert into MTL_ITEM_REVISIONS_INTERFACE table like below:
INSERT INTO MTL_ITEM_REVISIONS_INTERFACE
(ITEM_NUMBER,REVISION,ORGANIZATION_ID,DESCRIPTION,EFFECTIVITY_DATE,
PROCESS_FLAG, SET_PROCESS_ID , TRANSACTION_TYPE)
VALUES -- EXAMPLE DATA BELOW
('12122006-0','B',204,'REV-B',TO_DATE('30-JAN-2012','DD-MON-YYYY'),1,120,'CREATE');
COMMIT;
2). Run the concurrent program 'Import Items' specifying appropriate parameters.
3). Please check if revisions are created.
No comments:
Post a Comment