Revised Item Components Are Created With The Same Item Number, OpSeqNo And Effectivity (Doc ID 1607565.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Engineering - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, ECO

ACTUAL BEHAVIOR
---------------
PROCESS_ECO: Revised item components are created with the same item number, operation sequence number OpSeqNo and effectivity.

If PROCESS_ECO is used to create an ECO including revised items and revised item components, the following problem can occur:

Normally, it is not possible to add the same revised item with the same operation sequence number and the same effectivity more than once. But under the following conditions it is possible and the ECO is corrupt and cannot be maintained anymore using the Oracle forms UI:

Assumption: No routing exists for the revised item.

Create two revised item components with the same item number and the same effective date, one with op seq no 1 and the other with 10. The PROCESS_ECO logic will find no routing and because of that, it will default all operation sequence numbers to 1. Suddenly, we have the same component twice including OpSeqNo and PROCESS_ECO will create them without any additional checks. The result is a corrupt ECO which cannot be maintained in the Oracle forms UI anymore (except deleting one record).

EXPECTED BEHAVIOR
-----------------------
Process_eco to validate that the operation sequence corresponds to an existing routing

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Create two revised item components with the same item number and the same effective date, one with op seq no 1 and the other with 10. The PROCESS_ECO logic will find no routing and because of that, it will default all operation sequence numbers to 1. Suddenly, we have the same component twice including OpSeqNo and PROCESS_ECO will create them without any additional checks. The result is a corrupt ECO which cannot be maintained in the Oracle forms UI anymore (except deleting one record).

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