My Oracle Support Banner

The Combination Of Effective Date And Disable Date You Are Trying To Create Or Update In Operation &OP_SEQ_NUMBER Is Overlapping. (Doc ID 2094331.1)

Last updated on JULY 13, 2020

Applies to:

Oracle Bills of Material - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Bills

When updating BOM routing operations using API, Trying to disable / end-date current operation sequence 10 and adding new operation sequence with the same operation sequence number, The API errors out with overlapping operation sequence number error.

The combination of Effective Date and Disable date you are trying to create or update in Operation 10 is overlapping

The log for the API shows -

The issue can be reproduced at will with the following steps:
1. End date and Create new operation code using the same operation sequence number using API - BOM_Rtg_Pub.Process_Rtg
(For more steps on using this API, Please review <Note 1244314.1> - Oracle Bills of Material and Engineering Application Program Interface (APIs) / <Note 1244125.1> - How to Create a Routing for a Bill using Bom_Rtg_Pub.Process_Rtg API [Video]




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.