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 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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!