Package OKL_AM_INVOICES_PVT is Invalid After Upgrading to 12.2.5 (Doc ID 2131639.1)

Last updated on APRIL 27, 2016

Applies to:

Oracle Lease and Finance Management - Version 12.2.5 and later
Information in this document applies to any platform.

Goal

Upgraded from 12.1.3 to 12.2.5 and PACKAGE OKL_AM_INVOICES_PVT is invalid.

alter package APPS.OKL_AM_INVOICES_PVT compile body;


LINE/COL ERROR
-------- -----------------------------------------------------------------
613/1 PL/SQL: Item ignored
619/31 PLS-00371: at most one declaration for 'TILV_TBL_TYPE' is
  permitted

1608/1 PL/SQL: Item ignored
1613/25 PLS-00371: at most one declaration for 'TILV_REC_TYPE' is
  permitted

2055/14 PL/SQL: Item ignored
2055/14 PLS-00371: at most one declaration for 'TILV_REC_TYPE' is
  permitted

2056/15 PL/SQL: Item ignored
2056/15 PLS-00371: at most one declaration for 'TILV_REC_TYPE' is
  permitted

2059/15 PL/SQL: Item ignored
2059/15 PLS-00371: at most one declaration for 'TILV_TBL_TYPE' is
  permitted

2060/15 PL/SQL: Item ignored
2060/15 PLS-00371: at most one declaration for 'TILV_TBL_TYPE' is
  permitted

2124/2 PL/SQL: Statement ignored
2129/46 PLS-00320: the declaration of the type of this expression is
  incomplete or malformed

2150/6 PL/SQL: Statement ignored
2150/6 PLS-00320: the declaration of the type of this expression is
  incomplete or malformed

2151/6 PL/SQL: Statement ignored
2151/6 PLS-00320: the declaration of the type of this expression is
  incomplete or malformed

2152/6 PL/SQL: Statement ignored
2152/6 PLS-00320: the declaration of the type of this expression is
  incomplete or malformed

How to resolve this?
 

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