My Oracle Support Banner

Item Where Used Form (BOMFQWIN) gives APP-ORA-20870: ORA-08176 errors when Opened First Time (Doc ID 867262.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Bills of Material - Version 11.5.10.0 to 12.1.1 [Release 11.5 to 12.1]
Oracle Database - Enterprise Edition - Version 11.1.0.7 to 11.1.0.7 [Release 11.1]
Information in this document applies to any platform.
FORM:BOMFQWIN.FMB - View Item Usage (Item WhereUsed)
*** Checked for Currency on 2-MAR-2015 ***

Symptoms

The first time the Item Where Used for is used the following error occurs.
The error is almost immediate.
If the user keeps trying, the error eventually goes away.

Important: Users have reported the issue on multiple Database (DB) versions including 11.1.0.7.0 and 11.2.0.1.0. This appeared to be working on earlier versions like 11.1.0.6.0.


Error
APP-BOM-20870: ORA-08176: Consistant read failure: rollback data not available

Screen Shot
Here is a screen shot:


Last SQL
See the following SQL in the trace file enabling trace via Help > Diagnostics > Trace > Trace with Binds.
INSERT INTO BOM_SMALL_IMPL_TEMP ...
EXEC #13:c=52991,e=65993

Steps
1. Navigate to: Bills of Material>Bills> Item Where Used Enter item number
2. Press find.
3. Get error.
4. Works after that.

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!


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