VCP 18.104.22.168 - CRP HZ Plan - FRM-40735:POPUP1 Trigger Raised Unhandled Exception ORA-01422
(Doc ID 2119286.1)
Last updated on JUNE 28, 2017
Oracle Advanced Supply Chain Planning - Version 12.2.4 and later Information in this document applies to any platform.
22.214.171.124 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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!