Find Items Form Raises Unhandled Exception Error FRM-40735 When Using 'Show Quantity' Option

(Doc ID 2362000.1)

Last updated on MARCH 05, 2018

Applies to:

Oracle Item Master - Version 12.2.5 and later
Information in this document applies to any platform.
INVIVCSU

Goal

When attempting to use the Find Items form INVIVCSU.fmb, if the 'Show Quantity' checkbox is selected, then a 'No Data Found' message is thrown. Details of the error are: FRM-40735: POST-QUERY trigger raised unhandled exception ORA-04062.

The FRD trace file get error message:

Error Message: FRM-40105: Unable to resolve reference to item MATCHING_ITEMS.SEGMENT1.
INVIVCSU, 14, Built-In, Exit, 1648571152, USER_EXIT

Executing NAME_IN Built-in:
In Argument 0 - Type: String Value: matching_items.organization_id
Out Argument 0 - Type: String Value: 2429

Executing NAME_IN Built-in:
In Argument 0 - Type: String Value: matching_items.inventory_item_id
Out Argument 0 - Type: String Value: 16007

Unhandled Exception ORA-04062
State Delta:

Error Message: FRM-40735: POST-QUERY trigger raised unhandled exception ORA-04062.

ON-ERROR Trigger Fired:
Form: INVIVCSU

Solution

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