MSCFNSCW: ORA-04063 error while accessing ASCP Horizontal Plan.
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 126.96.36.199
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