VCP 12.2.4.1 - CRP HZ Plan - FRM-40735:POPUP1 Trigger Raised Unhandled Exception ORA-01422

Last updated on JUNE 28, 2017

Applies to:

Symptoms

12.2.4.1 in Production and Test


PROBLEM
-------------
An Unhandled Exception error message is encountered - no list of information - a default graph only
When accessed through a Resources List, the pop-up and error message is displayed and the form may be closed without terminating the session abnormally
When accessed from the Gantt Chart, the pop-up window and error displays but the session cannot be ended. The device needs to be rebooted in order to proceed into other Oracle applications
FRM-40735:POPUP1 trigger raised unhandled exception ORA-01422

After we recompiled all the forms and PLL's per note 245974.1 #16 - and confirmed they were properly compiled, the issue still existed

FRD Log - see file FRD.log shows
LINE 579839
Error Message: FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-01422.

ON-ERROR Trigger Fired:
Form: MSCFNSCW

LINE 580039
Executing MESSAGE Built-in:
In Argument 0 - Type: String Value: FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-01422.
In Argument 1 - Type: Number Value: 121

Unhandled Exception ORA-100501
State Delta:
FORM MSCFNSCW

-- SAME SET OF MESSAGES REPEATED TWO MORE TIMES IN FRD.log

Similar to Resource Horizontal Plan Throws FRM-40735:POPUP1 trigger raised unhandled exception ORA-01422 (Doc ID 1321385.1)
- this is for 12.1
customer has MSC_CRP_HORIZONTAL_PLAN MSCHCPLB.pls 120.22

STEPS
--------
ASCP Supply Chain Workbench - navigate to a Resource - select Horizontal Plan - error message appears in Po-up

BUSINESS IMPACT
----------------------
Cannot use resource horizontal plan and graph

Cause