MSCFNSCW: ORA-04063 error while accessing ASCP Horizontal Plan.
(Doc ID 1361815.1)
Last updated on SEPTEMBER 09, 2016
Applies to:Oracle Advanced Supply Chain Planning - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
When attempting to open horizontal plan from Supply/Demand window, the following error occurs.
HP QUERY DATA ERROR(SQLERR=ORA-04063: package body "APPS.MSC_HORIZONTAL_PLAN_SC" has errors)
1. Login to Application.
2. Navigate to Planner Workbench and search for any item.
Nav: Advanced Supply Chain Planner Responsibility -> Supply Chain Plan -> Planner Workbench.
3. Right click on any supply/demand record -> Horizontal plan.
Verifying from backend:
Errors for PACKAGE BODY APPS.MSC_HORIZONTAL_PLAN_SC:
32/11 PLS-00323: subprogram or cursor 'GET_DETAIL_RECORDS' is declared in a package specification and must be defined in the package body
Customer has recently upgraded from 12.0.6 to 12.1.3.
Customer is currently at Patch 10389190 - VCP 188.8.131.52
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!