Translate

Wednesday, July 16, 2014

Retrieving Previously Saved Production Batch Error FRM-40735: POST-QUERY trigger raised unhandled exception

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

An attempt to execute a stored procedure to serve an RPC stub was made, which specifies a timestamp/signature that is different from the current timestamp/signature of the procedure.

SOLUTION

Recompile forms, PLLs and objects in APPS schema using adadmin utility to pick up the new timestamp/signature.

No comments:

Post a Comment