Item Where Used Form (BOMFQWIN) gives APP-ORA-20870: ORA-08176 errors when Opened First Time
Last updated on AUGUST 03, 2016
Applies to:Oracle Bills of Material - Version 184.108.40.206 to 12.1.1 [Release 11.5 to 12.1]
Oracle Database - Enterprise Edition - Version 220.127.116.11 to 18.104.22.168 [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 ***
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.
APP-BOM-20870: ORA-08176: Consistant read failure: rollback data not available
Here is a screen shot:
See the following SQL in the trace file enabling trace via Help > Diagnostics > Trace > Trace with Binds.
INSERT INTO BOM_SMALL_IMPL_TEMP ...
1. Navigate to: Bills of Material>Bills> Item Where Used Enter item number
2. Press find.
3. Get error.
4. Works after that.
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