EBS Packages Than 128K Are Invalid Due to Truncation While Importing (Doc ID 1355920.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.
***Checked for relevance on 14-Mar-2013***

Symptoms

A full import of a E-Business Suite database using DataPump reports the warnings:

ORA-39082: Object type PACKAGE_BODY:"APPS"."XLA_00200_AAD_S_000010_PKG"
created with compilation warnings


Several package bodies of E-Business Suite with a size bigger than 128K (about 131000 lines) are invalid, like:

     XLA_00140_AAD_S_000002_PKG
     XLA_00140_AAD_S_000018_PKG
     XLA_00140_AAD_S_000021_PKG
     XLA_00200_AAD_S_000002_PKG
     XLA_00200_AAD_S_000006_PKG
     XLA_00200_AAD_S_000010_PKG
     XLA_00200_AAD_S_000012_PKG
     XLA_00200_AAD_S_000020_PKG
     XLA_00555_AAD_S_000001_PKG
     XLA_00707_AAD_S_000002_PKG
     XLA_00707_AAD_S_000005_PKG
     XLA_00707_AAD_S_000007_PKG
     XLA_00707_AAD_S_000011_PKG
     XLA_00707_AAD_S_000018_PKG
     XLA_00707_AAD_S_000019_PKG


The error PLS-103 is reported when the packages are manually compiled.

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