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 JUNE 05, 2017

Applies to:

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

Symptoms

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.

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 -

STEPS
-----------------------
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]

Changes

 <None>

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms