After Running GAP Collector, Creating a New Redline BOM Shows Unexpected Value In the Ref Des Field (Doc ID 2963488.1)

Last updated on AUGUST 10, 2023

Applies to:

Symptoms

Ref Des (reference designators) which was not added by the user shows in Redline BOM tab after new Redline BOM is added.


The issue can be reproduced with the following steps:

1. Log into Web Client, and create Engineering Change Order (ECO) against the item.
2. Go to Affected Items tab, and redline BOM and add a new BOM item.
3. See the value shows up in Ref Des field even though the user did not enter Ref Des information.
   
   

Can see many row count returns when logging into sqlplus as agile database user and running below sql to check for REFDESIG table rows containing invalid BOM.ID in the BOM field:

Changes

Gap Collector was run to avoid the Averify error: AGIL-00025153 : E : table has bad data (SEVERE PROBLEM - AGILE OBJECT SEQUENCE ID IS REACHING)

Cause

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