My Oracle Support Banner

How To Create Route Revision When More Than One Route Revisions Records Are Processed: Error: Routing Revision Already Exists (Doc ID 1591995.1)

Last updated on OCTOBER 23, 2018

Applies to:

Oracle Bills of Material - Version and later
Information in this document applies to any platform.
BOM_RTG_REV_ALREADY_EXISTS: Routing Revision &REVISION already exists for the assembly item &ASSEMBLY_ITEM_NAME.
BOM_RTG_REV_START_DATE_INVALID: The start effective date &START_EFFECTIVE_DATE of revision &REVISION for an assembly item &ASSEMBLY_ITEM_NAME overlaps the start and disable dates of an existing revision.


While create route revision from standard interface by passing more than one route records with different revisions for one assembly, the time stamp is not considered even if we pass the correct value for effectivity date.

Routing Revision 0 already exists for the assembly item ABC123.
The start effective date 01-AUG-13 of revision 1 for an assembly item XXX  overlaps the start and disable dates of an existing revision.

1)Trying to create route revision using standard interface by passing two revisions say rev 0 and rev 1 at a time for one assembly.
2) inserted the data into bom_op_routings_interface,MTL_RTG_ITEM_REVS_INTERFACE for both revision 0 and revision 1.
4)running the standard route import.
5)New routing revision o is created but revision 1 is not getting imported and give the error message.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.