Find Items Form Raises Unhandled Exception Error FRM-40735 When Using 'Show Quantity' Option (Doc ID 2362000.1)

Last updated on SEPTEMBER 14, 2023

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.