Retrieving Previously Saved Production Batch Displays Error "FRM-40735: POST-QUERY trigger raised unhandled exception ORA-04062" (Doc ID 238358.1)

Last updated on JULY 28, 2017

Applies to:

Oracle Process Manufacturing Process Execution - Version 11.5 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
GMECBTCH - Create Batch/Firm Planned Order
GMEBCHED - Batches
GMEMATED - Batch: Material Details


Symptoms

Cannot retrieve a previously saved batch.  Entering Material Details or Line Allocations on the batch errors:

FRM-40735: POST-QUERY trigger raised unhandled exception ORA-04062
ORA-04062: signature of package 'APPS.GMIVDBL' has been changed
ORA-01403: no data found


The Navigation Path is:
Production Supervisor>Create Document
Production Supervisor>Batches
(B)Material Details>(B)Line Allocations

Changes

Applied OPM 11i Family Pack I (2216258)

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