Report ZXARRECV.rdf Compile Fails In Patch 21226613 Due To Invalid Package Body ZX_ZXARRECV_XMLP_PKG (Doc ID 2187577.1)

Last updated on OCTOBER 21, 2016

Applies to:

Oracle E-Business Tax - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, Patch Application, upgrade from 11i to Rel 12.2.5

Applying the patch 21226613 it fails with the following error:

Generating report "ZXARRECV.rdf" with command:

/app/findev/fs2/EBSapps/10.1.2/bin/rwconverter
source=/app/findev/fs2/EBSapps/appl/zx/12.0.0/reports/US/ZXARRECV.rdf
dest=/app/findev/fs2/EBSapps/appl/admin/ddetfi_patch/out/tmp002.rdf
stype=rdffile dtype=rdffile overwrite=yes batch=yes compile_all=yes
Enter Userid:
Converting '/app/findev/fs2/EBSapps/appl/zx/12.0.0/reports/US/ZXARRECV.rdf'
to '/app/findev/fs2/EBSapps/appl/admin/ddetfi_patch/out/tmp002.rdf'...
REP-0736: There exist uncompiled program unit(s).

Trying to manually compile this package body, it gives the following errors:

SQL> alter package zx_zxarrecv_xmlp_pkg compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors
Errors for PACKAGE BODY ZX_ZXARRECV_XMLP_PKG:

LINE/COL ERROR
________________________________________
-----------------------------------------------------------------
34/23 PL/SQL: Item ignored
34/23 PLS-00201: identifier 'APPS.GL_SETS_OF_BOOKS' must be declared
35/19 PL/SQL: Item ignored
35/19 PLS-00201: identifier 'APPS.GL_PERIOD_STATUSES' must be declared
36/17 PL/SQL: Item ignored
36/17 PLS-00201: identifier 'APPS.GL_PERIOD_STATUSES' must be declared
65/7 PL/SQL: SQL Statement ignored
67/12 PLS-00320: the declaration of the type of this expression is
incomplete or malformed

68/7 PL/SQL: ORA-00904: : invalid identifier

LINE/COL ERROR
________________________________________
-----------------------------------------------------------------
72/7 PL/SQL: SQL Statement ignored
79/34 PL/SQL: ORA-00904: "L_SET_OF_BOOKS_ID": invalid identifier
79/34 PLS-00320: the declaration of the type of this expression is
incomplete or malformed

 

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