BOMFDBOM - ORA-1403 and FRM-40735 Errors When Opening the Define Bill of Material Form (Doc ID 359627.1)

Last updated on AUGUST 03, 2015

Applies to:

Oracle Bills of Material - Version 11.5.10.1 to 12.2.4 [Release 11.5 to 12.2]
Information in this document applies to any platform.
FORM:BOMFDBOM.FMB - Define Bill of Material

Symptoms

When attempting to create a new bill in the Define Bill of Material form, one or more of the following errors occur:

ORA-01403: no data found

FRM-40735: WHEN-NEW-FORM-INSTANCE trigger raised unhandled exception ORA-06502

ORA-01001:invalid cursor
ORA-06512: at "APPS.BOM_REVISIONS", line 356
ORA-06512: at "APPS.BOM_REVISIONS", line 702

FRM-40735: WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-01001
Note: is possible for the errors above to appear tht you have to collect an FRD trace, see any of the notes below:

Note 438652.1 - R12: Forms Runtime Diagnostics (FRD), Tracing And Logging For Forms In Oracle Applications
Note 373548.1 - How To Collect And Use Forms Trace (FRD) in Oracle Applications Release 12
Note 445166.1 - How to create a FRD (Forms Runtime Diagnostic) Log in EBusiness Suite R12 using Forms 10g


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