The below script can be used to add Older revision numbers to an item.<\/p>\n
Why we need to use this script: In Oracle standard functionality revisions need to be added in sequence like A, B, C\u2026.. It doesn\u2019t 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.<\/p>\n
DECLARE BEGIN item_revision_rec.REVISION_ID := l_revision_id; MTL_ITEM_REVISIONS_UTIL.INSERT_ROW(P_Item_Revision_Rec=>item_revision_rec, x_rowid => l_row_id);<\/p>\n END;<\/code><\/p>\n","protected":false},"excerpt":{"rendered":" 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\u2026.. It doesn\u2019t allow us to add B after adding A and C. In that case this script can be […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[],"class_list":["post-1846","post","type-post","status-publish","format-standard","hentry","category-scripts"],"yoast_head":"\n<\/p>\n
\nitem_revision_rec MTL_ITEM_REVISIONS_B%ROWTYPE;
\nl_revision_id mtl_item_revisions_b.revision_id%TYPE;
\nl_row_id VARCHAR2(100);<\/p>\n
\nselect mtl_item_revisions_b_s.nextval
\ninto l_revision_id
\nfrom dual;<\/p>\n
\nitem_revision_rec.INVENTORY_ITEM_ID := &itemid ;
\nitem_revision_rec.ORGANIZATION_ID := &organization_id;
\nitem_revision_rec.REVISION := &revision;
\nitem_revision_rec.LAST_UPDATE_DATE := SYSDATE;
\nitem_revision_rec.LAST_UPDATED_BY := 1;
\nitem_revision_rec.CREATION_DATE := SYSDATE;
\nitem_revision_rec.CREATED_BY := 1;
\nitem_revision_rec.EFFECTIVITY_DATE := to_date('&effectivity_date','DD-MON-YYYY HH24:MI:SS') ;
\nitem_revision_rec.IMPLEMENTATION_DATE:= to_date('&effectivity_date','DD-MON-YYYY HH24:MI:SS') ;
\nitem_revision_rec.revision_label := &revision;<\/p>\n