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.

Symptoms

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)


STEPS

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:

LINE/COL ERROR

32/11 PLS-00323: subprogram or cursor 'GET_DETAIL_RECORDS' is declared in a package specification and must be defined in the package body

Changes

Customer has recently upgraded from 12.0.6 to 12.1.3.
Customer is currently at Patch 10389190 - VCP 12.1.3.3

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