My Oracle Support Banner

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

Last updated on JANUARY 24, 2024

Applies to:

Oracle Agile Product Collaboration - Version and later
Information in this document applies to any platform.


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:


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


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.