My Oracle Support Banner

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

To view full details, 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 a vibrant support community of peers and Oracle experts.