Indented Bills form gives Errors like FRM-40734, FRM-40735, FRM-41076, FRM-92100, ORA-06508 for Huge Models OR Bills (Doc ID 1570136.1)

Last updated on NOVEMBER 02, 2015

Applies to:

Oracle Bills of Material - Version 12.1.3 and later
Information in this document applies to any platform.
BOMFQBIN

Symptoms

On : 12.1.3 version, Bills

Issue
---------------
When Searching Indented BOM with large number of levels and components , the output comes very different when search by changing levels.

Also getting  different errors like FRM-40734,  FRM-41076, FRM-92100 for some levels

FRM-40735:ON-ERROR trigger raised unhandled exception ORA-06508 error

FRM-92100 : Your connection to the Server was interrupted

STEPS
-----------------------
The issue can be reproduced at will with the following steps:


1. Bills of Materials > Bills > Indented Bills
2. Enter the model Item with large levels and click the Find button
3. Indented bill form eventually results in the errors

Cause

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