Object XLA_00140_AAD_S_011117_PKG Is Invalid After Upgrading To 12.1.3

(Doc ID 1608494.1)

Last updated on MARCH 30, 2018

Applies to:

Oracle Assets - Version 12.1.3 and later
Information in this document applies to any platform.

Goal



Object XLA_00140_AAD_S_011117_PKG is invalid after upgrading to 12.1.3

Compiling the package results in errors:

SQL> ALTER PACKAGE XLA_00140_AAD_S_011117_PKG COMPILE BODY;

SQL> show errors;

LINE/COL ERROR
-------- ---------------------------------------------------------------
23/10 PLS-00323: subprogram or cursor 'GETMEANING' is declared in a
  package specification and must be defined in the package body

274/4 PL/SQL: Statement ignored
276/7 PLS-00201: identifier 'CREATEHEADERSANDLINES' must be declared


However, no errors were found in both Import AAD and Validate AAD output files.
 

Solution

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