VCP 12.2.4.1 - CRP HZ Plan - FRM-40735:POPUP1 Trigger Raised Unhandled Exception ORA-01422
(Doc ID 2119286.1)
Last updated on FEBRUARY 26, 2019
Applies to:
Oracle Advanced Supply Chain Planning - Version 12.2.4 and laterInformation in this document applies to any platform.
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
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |