FRM-30312: Failed to compile the library

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:
When applying this patch 5739724, following error is encountered: -
The following Oracle Forms objects did not generate successfully:
au resource ARXPLCOM.pll
au resource ARXTXSTD.pll
ar forms/US RAXSTDTE.fmx
ar forms/US RAXSUDTE.fmx
FRM-30312: Failed to compile the library

Symptoms:
On : 11.5.10.2 version, Installation Issues

When attempting to compile, the following error occurs.

Errors:
-----
Compiling library ARXTXSTD...
Invalidating Package Spec TAX_STANDARD......
Invalidating Package Body TAX_STANDARD......
Invalidating Function Body ARXTXSTD_REVISION......
Compiling Package Spec TAX_STANDARD......
Compiling Package Body TAX_STANDARD......
ERROR 302 at line 14, column 22
component 'GET' must be declared
ERROR 0 at line 14, column 11
Statement ignored
Compiling Function Body ARXTXSTD_REVISION......
Closing library ARXTXSTD...
Compilation errors on TAX_STANDARD:
PL/SQL ERROR 302 at line 14, column 22
component 'GET' must be declared
PL/SQL ERROR 0 at line 14, column 11
Statement ignored

Failed to generate library.

FRM-30312: Failed to compile the library.
-----
Compiling library ARXPLCOM...
Compilation errors on AR_COMMON_INIT_PROFILES:
PL/SQL ERROR 302 at line 117, column 25
component 'VALUE' must be declared
PL/SQL ERROR 0 at line 117, column 8
Statement ignored
PL/SQL ERROR 302 at line 120, column 25
component 'VALUE' must be declared
PL/SQL ERROR 0 at line 120, column 8
Statement ignored
PL/SQL ERROR 302 at line 123, column 25
component 'VALUE' must be declared
PL/SQL ERROR 0 at line 123, column 8
Statement ignored

Failed to generate library.

FRM-30312: Failed to compile the library

Log files:
11i.AR.O

Errors:
-----
Compiling library ARXTXSTD...
Invalidating Package Spec TAX_STANDARD......
Invalidating Package Body TAX_STANDARD......
Invalidating Function Body ARXTXSTD_REVISION......
Compiling Package Spec TAX_STANDARD......
Compiling Package Body TAX_STANDARD......
ERROR 302 at line 14, column 22
component 'GET' must be declared
ERROR 0 at line 14, column 11
Statement ignored
Compiling Function Body ARXTXSTD_REVISION......
Closing library ARXTXSTD...
Compilation errors on TAX_STANDARD:
PL/SQL ERROR 302 at line 14, column 22
component 'GET' must be declared
PL/SQL ERROR 0 at line 14, column 11
Statement ignored

Failed to generate library.

FRM-30312: Failed to compile the library.
-----
Compiling library ARXPLCOM...
Compilation errors on AR_COMMON_INIT_PROFILES:
PL/SQL ERROR 302 at line 117, column 25
component 'VALUE' must be declared
PL/SQL ERROR 0 at line 117, column 8
Statement ignored
PL/SQL ERROR 302 at line 120, column 25
component 'VALUE' must be declared
PL/SQL ERROR 0 at line 120, column 8
Statement ignored
PL/SQL ERROR 302 at line 123, column 25
component 'VALUE' must be declared
PL/SQL ERROR 0 at line 123, column 8
Statement ignored

Failed to generate library.

FRM-30312: Failed to compile the library.
-----
-----
Invalids:
OWNER OBJECT_NAME OBJECT_TYPE
------------------------------ ------------------------------ -------------------
CTXSYS OKC_REP_CONTRACT_TEXT_IDX_CTX PACKAGE BODY
APPS OKS_CCENCRYPTION_PKG PACKAGE BODY
APPS CS_PARTYMERGE_PKG PACKAGE BODY
APPS CZ_IMP_SINGLE_DEBUG PACKAGE BODY
APPS XXFZDOCUPD PACKAGE BODY
APPS XXHR_EZW_HP_INTERFACE PACKAGE BODY
APPS XXFZ_LIC_PRC_PKG PACKAGE BODY
APPS XXIMS_HP_PN_LIVELEASE_INT_PKG PACKAGE BODY
APPS XXIMS_HP_CRM_PRICE_EXT_PKG PACKAGE BODY
APPS XXIMS_HP_CRM_REV_EXT_PKG PACKAGE BODY
APPS XXIMS_HP_GL_BAL_EXT_PKG PACKAGE BODY
APPS EUL5_B090428091814Q1V1 VIEW
APPS EUL5_B090428090613Q1V1 VIEW
APPS EUL5_B090428090152Q1V1 VIEW
APPS EUL5_B090428090315Q1V1 VIEW
APPS XXFIN_MASTER_PERIOD_DETAIL_V VIEW
APPS XXFIN_FA_PERIOD_DETAILS_V VIEW
APPS XXFIN_INV_PERIOD_DETAILS_V VIEW
APPS XXFIN_ACCT_PREIOD_STS_DTLS VIEW
APPS XXFIN_ACCT_PERIOD_STS_V VIEW
APPS XXFZ_WEB_CONSULTANT_UPLOAD_PKG PACKAGE BODY
APPS XXCONV_PN_LEASE_CONV_PKG PACKAGE BODY
APPS XXESRV_CLIENT_DIRECTORY_PKG PACKAGE BODY
APPS XXCED_GIS_PKG PACKAGE BODY
APPS XXFIN_COA_VALUE_DTLS_MASTER_V VIEW
APPS XXFIN_SEGMENT_VALUES_MASTER_V VIEW
APPS XXFZ_EHS_CLIENT_EXP PACKAGE BODY
APPS XXFZ_WEB_LOOKUP_VALUES PACKAGE BODY
APPS XXFZ_WEB_ENQUIRY_UPLOAD_PKG PACKAGE BODY
APPS XXCONV_DW_AR_RECEIPTS_PKG PACKAGE BODY
APPS XXIMS_GL_EXTRACT_HYP_INTER_PKG PACKAGE BODY
APPS XXCONV_DW_AR_TRX_PKG PACKAGE BODY
APPS XXFZ_OTC_TO_AR_IFACE_PATCH PACKAGE BODY
APPS XXCONV_GENERIC PACKAGE BODY
APPS DBMS_AW_BUILD PACKAGE BODY
APPS BIM_I_LEAD_MGMT_PVT PACKAGE BODY
APPS PN_CC_SYNC_PKG PACKAGE BODY
APPS HZ_IMP_LOAD_WRAPPER PACKAGE BODY
APPS WF_JAVA_DEFERRED SYNONYM
APPS PN_EXP_TO_EAM_PVT PACKAGE BODY
APPS PA_PROJ_TRANSFERS_VIEW VIEW
APPS APS_VALIDATE PROCEDURE
JUNK_PS WWSSO_PSTORE_EX SYNONYM
JUNK_PS WWSSO_API_PRIVATE SYNONYM
JUNK_PS WWSSO_API SYNONYM
JUNK_PS WWCTX_API_VPD SYNONYM
XXFIN XXFIN_FA_DEPRN_PERIODS VIEW
XXFIN XXFIN_ORGANIZATION_DEFINITIONS VIEW
XXFIN XXFIN_ORG_ACCT_PERIODS_V VIEW
XXFIN XXFIN_FA_BOOK_CONTROLS VIEW
XXIMS XXIMS_HR_EMP_INTERFACE PACKAGE BODY
XXCONV XXUPDDB_PROC PROCEDURE
XXHR_R XXHR_UDFS_PKG PACKAGE BODY
XXIDCAUSER T_CARD_FLOW TRIGGER

54 rows selected.
-----
-----
VERT.pld 115.3.1150.2 2000/01/17
ARXPLCOM.pld 115.68.15104.6 2008/01/17
-----
ARXTXSTD.pld 115.4 2003/05/27
-----
RAXSTDTE.fmx RAXSTDTE.fmb: 115.10 11-Oct-2006
-----
RAXSUDTE.fmx RAXSUDTE.fmb: 115.30 11-Oct-2006
-----
-----
RDA:
HZ_IMP_LOAD_WRAPPER ARHLWRPB.pls 115.52 BODY INVALID 25-Nov-2010

Invalid Referenced Objects:
XXFIN_ACCT_PERIOD_STS_V ORA-02019: connection description for remote database not found
XXFIN_ACCT_PERIOD_STS_V ORA-12541: TNS:no listener
XXFIN_MASTER_PERIOD_DETAIL_VORA-04063: view "APPS.XXFIN_ACCT_PERIOD_STS_V" has errors


Solution:



When you have custom code, don't attach any product libraries to CUSTOM.pll.

Please follow the solution from this Note 468860.1 - Error Generating Library "Resource/Arxplcom.Plx" From Input File.

1. Remove customization from CUSTOM.pll. (If you don't have the standard custom.pll I can send it to you, just let me know)
2. Use adadmin to generate custom.pll
if it compiled successfully, please use adadmin to generate other.

References:


Note 468860.1 - Error Generating Library "Resource/Arxplcom.Plx" From Input File.

Get Oracle Certifications for all Exams
Free Online Exams.com