My Oracle Support Banner

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

Last updated on MARCH 04, 2019

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).

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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