The below script can be used to add Older revision numbers to an item.
Why we need to use this script: In Oracle standard functionality revisions need to be added in sequence like A, B, C….. It doesn’t allow us to add B after adding A and C. In that case this script can be used to add the missing revision from the backend.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 |
DECLARE item_revision_rec MTL_ITEM_REVISIONS_B%ROWTYPE; l_revision_id mtl_item_revisions_b.revision_id%TYPE; l_row_id VARCHAR2(100); BEGIN select mtl_item_revisions_b_s.nextval into l_revision_id from dual; item_revision_rec.REVISION_ID := l_revision_id; item_revision_rec.INVENTORY_ITEM_ID := &itemid ; item_revision_rec.ORGANIZATION_ID := &organization_id; item_revision_rec.REVISION := &revision; item_revision_rec.LAST_UPDATE_DATE := SYSDATE; item_revision_rec.LAST_UPDATED_BY := 1; item_revision_rec.CREATION_DATE := SYSDATE; item_revision_rec.CREATED_BY := 1; item_revision_rec.EFFECTIVITY_DATE := to_date(‘&effectivity_date’,’DD-MON-YYYY HH24:MI:SS’) ; item_revision_rec.IMPLEMENTATION_DATE:= to_date(‘&effectivity_date’,’DD-MON-YYYY HH24:MI:SS’) ; item_revision_rec.revision_label := &revision; MTL_ITEM_REVISIONS_UTIL.INSERT_ROW(P_Item_Revision_Rec=>item_revision_rec, x_rowid => l_row_id); END; |