My Oracle Support Banner

MRPFUSSM - Planning Manager form Errors when opening ORA-01403 FRM-40735 ORA-06502 - Also Starting Planning Manager Errors ORA-03123, FRM-40735 (Doc ID 1332045.1)

Last updated on OCTOBER 06, 2022

Applies to:

Oracle Materials Requirement Planning - Version 11.5.8 and later
Information in this document applies to any platform.
Form:MRPFUSSM.FMB - Start Planning Manager


Goal

Users are receiving the following error message in production environment when opening the Planning Manager form - MRPFUSSM.fmb.

ORA-01403: no data found

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


Similar error was also encountered in 12.1.3 and 12.2.3 when users tried to start the planning manager. The form showed the following errors

ORA-03123: operation would block

--------------------------------------------------------------
FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-04062


How is this resolved?


Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


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