Search 800 + Posts

Oct 5, 2017

How to Import historical revisions in Oracle EBS

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. 

No comments:

Post a Comment