In 12.2 - Pegging Expands With FRM-40735: MSCTREE_EVENT Trigger Raised Unhandled Exception ORA-04063 (Doc ID 1917753.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

12.2.3

PROBLEM
-------------
1. The planner workbench pegging is not working and we got this error when expanding the pegging
-- FRM-40735: MSCTREE_EVENT trigger raised un-handled exception ORA-4063 While Expanding The Pegging Tree
-- Seem to happen only for planned orders.

2. Applied 18561375:R12.MSC.C - this patch is for ORA-4062 (not 4063)
and confirm that we now see MSCFTPEG.pld 120.55.12020000.4
Also manually rebuilt all forms and PLL again and still not resolved.

STEPS
--------
query supply/demand and try to expand for planned orders.


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms