This discussion is archived
12 Replies Latest reply: Feb 20, 2013 7:59 PM by WF001 RSS

many invalid objects found after new install the R12 vision demo (12.1.1)

WF001 Newbie
Currently Being Moderated
In AIX Server,
I found many invalid objects after new install the R12 vision demo (12.1.1) with DB v11.1.0.7, can I drop the following invalid objects then upgrade to R12.1.3 ?

OWNER OBJECT_NAME OBJECT_TYPE STATUS
---------- ----------------------------------- ------------------- -------
APPS XLA_00707_AAD_C_000026_PKG PACKAGE BODY INVALID
APPS XLA_00200_AAD_C_000017_PKG PACKAGE BODY INVALID
APPS XLA_00200_AAD_C_000016_PKG PACKAGE BODY INVALID
APPS XLA_00200_AAD_S_000032_PKG PACKAGE BODY INVALID
APPS XLA_00200_AAD_S_000034_PKG PACKAGE BODY INVALID
APPS XLA_00200_AAD_S_000039_PKG PACKAGE BODY INVALID
APPS XLA_00200_AAD_S_000041_PKG PACKAGE BODY INVALID
APPS XLA_00200_AAD_C_000020_PKG PACKAGE BODY INVALID
RE RE_PROFILER PACKAGE BODY INVALID
APPS XLA_00200_AAD_C_000018_PKG PACKAGE BODY INVALID
APPS XLA_00200_AAD_C_000021_PKG PACKAGE BODY INVALID
APPS XLA_00555_AAD_S_000014_PKG PACKAGE BODY INVALID
APPS XLA_00555_AAD_C_000015_PKG PACKAGE BODY INVALID
APPS XLA_00200_AAD_C_000022_PKG PACKAGE BODY INVALID
APPS XLA_00140_AAD_S_000036_PKG PACKAGE BODY INVALID
APPS FSAH_DUPLICATE_PKG PACKAGE BODY INVALID
APPS XLA_00707_AAD_C_000044_PKG PACKAGE BODY INVALID
APPS MSD_DEM_OBI_DEMANTRA_MV MATERIALIZED VIEW INVALID

18 rows selected.

SQL> alter package XLA_00707_AAD_C_000026_PKG compile body;

Warning: Package Body altered with compilation errors.

SQL> show error
Errors for PACKAGE BODY XLA_00707_AAD_C_000026_PKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
1/49 PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
is as compress compiled wrapped
The symbol "compress" was substituted for "end-of-file" to continue.

SQL> alter package RE.RE_PROFILER compile body;

Warning: Package Body altered with compilation errors.

SQL> show error
Errors for PACKAGE BODY RE.RE_PROFILER:

LINE/COL ERROR
-------- -----------------------------------------------------------------
1180/13 PL/SQL: SQL Statement ignored
1180/13 PLS-00435: DML statement without BULK In-BIND cannot be used inside FORALL

1181/32 PLS-00440: FORALL bulk IN-bind variables cannot be used here
1926/9 PL/SQL: SQL Statement ignored
1926/9 PLS-00435: DML statement without BULK In-BIND cannot be used inside FORALL

SQL> alter package FSAH_DUPLICATE_PKG compile body;

Warning: Package Body altered with compilation errors.

SQL> show error
Errors for PACKAGE BODY FSAH_DUPLICATE_PKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
7/12 PLS-00341: declaration of cursor 'C1' is incomplete or malformed
8/7 PL/SQL: SQL Statement ignored
9/14 PL/SQL: ORA-00942: table or view does not exist
12/17 PL/SQL: Item ignored
16/7 PL/SQL: SQL Statement ignored
16/71 PL/SQL: ORA-00942: table or view does not exist
22/13 PL/SQL: SQL Statement ignored
22/27 PLS-00320: the declaration of the type of this expression is incomplete or malformed

Edited by: SamCH on 2013年2月4日 下午11:19
  • 1. Re: many invalid objects found after new install the R12 vision demo (12.1.1)
    Carlo den Otter Explorer
    Currently Being Moderated
    Hello Sam,

    Note 967352.1 : "XLA Invalid Body Packages after Patching" explains about 4 invalid XLA packages.
    You might raise an SR for this, or backup and upgrade to 12.1.3 and check the status again.

    Regards, Carlo.
  • 2. Re: many invalid objects found after new install the R12 vision demo (12.1.1)
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    There is no need to drop these objects - you can upgrade to 12.1.3 without issues

    HTH
    Srini
  • 3. Re: many invalid objects found after new install the R12 vision demo (12.1.1)
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    I found many invalid objects after new install the R12 vision demo (12.1.1) with DB v11.1.0.7, can I drop the following invalid objects then upgrade to R12.1.3 ?
    I would not drop those objects before the upgrade since they are seeded ones.

    Please see these docs to compile those objects before you upgrade to 12.1.3 since you might encounter issues during 12.1.3 upgrade if those objects are invalid.

    Invalid XLA Packages In Release 12.1.3 [ID 1496529.1]
    Xla Invalids After Upgrade From 11i To Release 12 [ID 1302349.1]
    XLA Package Invalid in 12.1.1 [ID 1093888.1]
    R12: Invalid Xla Objects After Upgrade from 11i To R12 - Unable To Compile [ID 1238973.1]
    Unable To Compile Invalid XLA Objects [ID 1468836.1]

    Thanks,
    Hussein
  • 4. Re: many invalid objects found after new install the R12 vision demo (12.1.1)
    WF001 Newbie
    Currently Being Moderated
    Found invalid objects after upgrade from 12.1.1 to 12.1.3 in vision demo, Can I safely ignore these? Thanks

    OWNER OBJECT_NAME OBJECT_TYPE STATUS
    -------- ------------------------------ ------------------- -------
    CA F TABLE INVALID
    APPS FSAH_DUPLICATE_PKG PACKAGE BODY INVALID
    CA G TABLE INVALID
    APPS MSD_DEM_OBI_DEMANTRA_MV MATERIALIZED VIEW INVALID
    APPS POS_AP_SUPPLIER_BO_PKG PACKAGE INVALID
    APPS POS_AP_SUPPLIER_BO_PKG PACKAGE BODY INVALID
    APPS POS_AP_SUPPLIER_SITE_BO_PKG PACKAGE INVALID
    APPS POS_AP_SUPPLIER_SITE_BO_PKG PACKAGE BODY INVALID
    APPS POS_BANK_ACCOUNT_BO_PKG PACKAGE INVALID
    APPS POS_BANK_ACCOUNT_BO_PKG PACKAGE BODY INVALID
    APPS POS_BANK_PAYEE_BO_PKG PACKAGE BODY INVALID
    APPS POS_BANK_PAYEE_BO_PKG PACKAGE INVALID
    APPS POS_BUSINESS_CLASS_BO_PKG PACKAGE BODY INVALID
    APPS POS_BUSINESS_CLASS_BO_PKG PACKAGE INVALID
    APPS POS_HZ_LOCATION_BO_PKG PACKAGE BODY INVALID
    APPS POS_HZ_LOCATION_BO_PKG PACKAGE INVALID
    APPS POS_HZ_PARTY_BO_PKG PACKAGE BODY INVALID
    APPS POS_HZ_PARTY_BO_PKG PACKAGE INVALID
    APPS POS_HZ_PARTY_SITE_BO_TBL_PKG PACKAGE BODY INVALID
    APPS POS_HZ_PARTY_SITE_BO_TBL_PKG PACKAGE INVALID
    APPS POS_PRODUCT_SERVICE_BO_PKG PACKAGE INVALID
    APPS POS_PRODUCT_SERVICE_BO_PKG PACKAGE BODY INVALID
    APPS POS_SUPPLIER_BO_PKG PACKAGE BODY INVALID
    APPS POS_SUPPLIER_BO_PKG PACKAGE INVALID
    APPS POS_SUPPLIER_CONTACT_BO_PKG PACKAGE INVALID
    APPS POS_SUPPLIER_CONTACT_BO_PKG PACKAGE BODY INVALID
    APPS POS_SUPPLIER_TAX_PROF_BO_PKG PACKAGE INVALID
    APPS POS_SUPPLIER_TAX_PROF_BO_PKG PACKAGE BODY INVALID
    APPS POS_SUPPLIER_UDA_BO_PKG PACKAGE BODY INVALID
    APPS POS_SUPPLIER_UDA_BO_PKG PACKAGE INVALID
    APPS POS_SUPP_GENERATE_RPT_PKG PACKAGE BODY INVALID
    APPS POS_SUPP_PUB_RAISE_EVENT_PKG PACKAGE BODY INVALID
    APPS POS_TAX_REPORT_BO_PKG PACKAGE BODY INVALID
    APPS POS_TAX_REPORT_BO_PKG PACKAGE INVALID
    RE RE_PROFILER PACKAGE BODY INVALID
    APPS XLA_00140_AAD_S_000036_PKG PACKAGE BODY INVALID
    APPS XLA_00200_AAD_C_000016_PKG PACKAGE BODY INVALID
    APPS XLA_00200_AAD_C_000017_PKG PACKAGE BODY INVALID
    APPS XLA_00200_AAD_C_000018_PKG PACKAGE BODY INVALID
    APPS XLA_00200_AAD_C_000020_PKG PACKAGE BODY INVALID
    APPS XLA_00200_AAD_C_000021_PKG PACKAGE BODY INVALID
    APPS XLA_00200_AAD_C_000022_PKG PACKAGE BODY INVALID
    APPS XLA_00200_AAD_S_000032_PKG PACKAGE BODY INVALID
    APPS XLA_00200_AAD_S_000034_PKG PACKAGE BODY INVALID
    APPS XLA_00200_AAD_S_000039_PKG PACKAGE BODY INVALID
    APPS XLA_00200_AAD_S_000041_PKG PACKAGE BODY INVALID
    APPS XLA_00555_AAD_C_000015_PKG PACKAGE BODY INVALID
    APPS XLA_00555_AAD_S_000014_PKG PACKAGE BODY INVALID
    APPS XLA_00707_AAD_C_000026_PKG PACKAGE BODY INVALID
    APPS XLA_00707_AAD_C_000044_PKG PACKAGE BODY INVALID

    50 rows selected.
  • 5. Re: many invalid objects found after new install the R12 vision demo (12.1.1)
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    Found invalid objects after upgrade from 12.1.1 to 12.1.3 in vision demo, Can I safely ignore these? Thanks
    Not if you are using those modules.

    Have you reviewed the docs referenced above?

    What is the error you get when you compile those objects manually?

    Thanks,
    Hussein
  • 6. Re: many invalid objects found after new install the R12 vision demo (12.1.1)
    WF001 Newbie
    Currently Being Moderated
    Hi Hussein,

    Thanks for your reply again, the compile error as below

    e.g.
    show error
    SQL> ALTER PACKAGE APPS.XLA_00707_AAD_C_000026_PKG COMPILE BODY;
    Warning: Package Body altered with compilation errors.
    SQL> show error
    Errors for PACKAGE BODY APPS.XLA_00707_AAD_C_000026_PKG:
    LINE/COL ERROR
    -------- -----------------------------------------------------------------
    1/49 PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
    is as compress compiled wrapped
    The symbol "compress" was substituted for "end-of-file" to continue.

    SQL> ALTER PACKAGE APPS.XLA_00200_AAD_C_000017_PKG COMPILE BODY;
    Warning: Package Body altered with compilation errors.
    SQL> show error
    Errors for PACKAGE BODY APPS.XLA_00200_AAD_C_000017_PKG:
    LINE/COL ERROR
    -------- -----------------------------------------------------------------
    131072/2 PLS-00103: Encountered the symbol "end-of-file" when expecting
    one of the following:
    ( begin case declare end exit for goto if loop mod null
    pragma raise return select update while with <an identifier>
    <a double-quoted delimited-identifier> <a bind variable> <<
    continue close current delete fetch lock insert open rollback
    savepoint set sql execute commit forall merge pipe purge

    SQL> ALTER PACKAGE APPS.XLA_00200_AAD_S_000032_PKG COMPILE BODY;
    Warning: Package Body altered with compilation errors.
    SQL> show error
    Errors for PACKAGE BODY APPS.XLA_00200_AAD_S_000032_PKG:
    LINE/COL ERROR
    -------- -----------------------------------------------------------------
    131072/7 PLS-00103: Encountered the symbol "end-of-file" when expecting
    2 one of the following:
    . ( ) , * % & = - + < / > at in is mod remainder not rem
    <an exponent (**)> <> or != or ~= >= <= <> and or like like2
    like4 likec between || multiset member submultiset

    SQL> ALTER PACKAGE RE.RE_PROFILER COMPILE BODY;
    Warning: Package Body altered with compilation errors.
    SQL> show error
    Errors for PACKAGE BODY RE.RE_PROFILER:
    LINE/COL ERROR
    -------- -----------------------------------------------------------------
    1180/13 PL/SQL: SQL Statement ignored
    1180/13 PLS-00435: DML statement without BULK In-BIND cannot be used inside FORALL
    1181/32 PLS-00440: FORALL bulk IN-bind variables cannot be used here
    1926/9 PL/SQL: SQL Statement ignored
    1926/9 PLS-00435: DML statement without BULK In-BIND cannot be used inside FORALL
    ....

    SQL> ALTER PACKAGE APPS.XLA_00555_AAD_S_000014_PKG COMPILE BODY;
    Warning: Package Body altered with compilation errors.
    SQL> show error
    Errors for PACKAGE BODY APPS.XLA_00555_AAD_S_000014_PKG:
    LINE/COL ERROR
    -------- -----------------------------------------------------------------
    131072/5 PLS-00103: Encountered the symbol "end-of-file" when expecting
    7 one of the following:
    begin function pragma procedure subtype type <an identifier>
    <a double-quoted delimited-identifier> current cursor delete exists prior

    SQL> ALTER PACKAGE APPS.FSAH_DUPLICATE_PKG COMPILE BODY;
    Warning: Package Body altered with compilation errors.
    SQL> show error
    Errors for PACKAGE BODY APPS.FSAH_DUPLICATE_PKG:
    LINE/COL ERROR
    -------- -----------------------------------------------------------------
    7/12 PLS-00341: declaration of cursor 'C1' is incomplete or malformed
    8/7 PL/SQL: SQL Statement ignored
    9/14 PL/SQL: ORA-00942: table or view does not exist
    12/17 PL/SQL: Item ignored
    16/7 PL/SQL: SQL Statement ignored
    16/71 PL/SQL: ORA-00942: table or view does not exist
    22/13 PL/SQL: SQL Statement ignored
    22/27 PLS-00320: the declaration of the type of this expression is incomplete or malformed
    ......

    SQL> ALTER PACKAGE APPS.XLA_00707_AAD_C_000044_PKG COMPILE BODY;
    Warning: Package Body altered with compilation errors.
    SQL> show error
    Errors for PACKAGE BODY APPS.XLA_00707_AAD_C_000044_PKG:
    LINE/COL ERROR
    -------- -----------------------------------------------------------------
    201713/1 PL/SQL: SQL Statement ignored
    201826/1 PL/SQL: ORA-00904: "CST_XLA_INV_REF_V"."TRANSACTION_SOURCE_ID":
    30 invalid identifier
    202147/1 PL/SQL: SQL Statement ignored
    202191/1 PL/SQL: ORA-00904: "CST_XLA_INV_REF_V"."TRANSACTION_SOURCE_ID":
    30 invalid identifier
    202973/5 PL/SQL: Statement ignored
    202973/2 PLS-00364: loop index variable 'HEADER_RECORD' use is invalid
    7

    SQL> ALTER PACKAGE APPS.POS_AP_SUPPLIER_BO_PKG COMPILE BODY;
    Warning: Package Body altered with compilation errors.
    SQL> show error
    Errors for PACKAGE BODY APPS.POS_AP_SUPPLIER_BO_PKG:
    LINE/COL ERROR
    -------- -----------------------------------------------------------------
    0/0 PL/SQL: Compilation unit analysis terminated
    1/14 PLS-00304: cannot compile body of 'POS_AP_SUPPLIER_BO_PKG' without its specification
    1/14 PLS-00905: object APPS.POS_AP_SUPPLIER_BO_PKG is invalid

    SQL> ALTER PACKAGE APPS.POS_AP_SUPPLIER_BO_PKG COMPILE ;
    Warning: Package altered with compilation errors.
    SQL> show error
    Errors for PACKAGE APPS.POS_AP_SUPPLIER_BO_PKG:
    LINE/COL ERROR
    -------- -----------------------------------------------------------------
    3/3 PL/SQL: Declaration ignored
    7/32 PLS-00201: identifier 'POS_AP_SUPPLIER_BO' must be declared
    28/3 PL/SQL: Declaration ignored
    35/40 PLS-00201: identifier 'POS_AP_SUPPLIER_BO' must be declared

    SQL> ALTER PACKAGE APPS.POS_BANK_ACCOUNT_BO_PKG COMPILE BODY;
    Warning: Package Body altered with compilation errors.
    SQL> show error
    Errors for PACKAGE BODY APPS.POS_BANK_ACCOUNT_BO_PKG:
    LINE/COL ERROR
    -------- -----------------------------------------------------------------
    0/0 PL/SQL: Compilation unit analysis terminated
    1/14 PLS-00304: cannot compile body of 'POS_BANK_ACCOUNT_BO_PKG' without its specification
    1/14 PLS-00905: object APPS.POS_BANK_ACCOUNT_BO_PKG is invalid

    SQL> ALTER PACKAGE APPS.POS_BANK_ACCOUNT_BO_PKG COMPILE ;
    Warning: Package altered with compilation errors.
    SQL> show error
    Errors for PACKAGE APPS.POS_BANK_ACCOUNT_BO_PKG:
    LINE/COL ERROR
    -------- -----------------------------------------------------------------
    4/6 PL/SQL: Declaration ignored
    9/80 PLS-00201: identifier 'POS_BANK_ACCOUNT_BO_TBL' must be declared
    13/5 PL/SQL: Declaration ignored
    19/69 PLS-00201: identifier 'POS_BANK_ACCOUNT_BO_TBL' must be declared
  • 7. Re: many invalid objects found after new install the R12 vision demo (12.1.1)
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    SQL> show error
    Errors for PACKAGE BODY APPS.XLA_00707_AAD_C_000026_PKG:
    LINE/COL ERROR
    -------- -----------------------------------------------------------------
    1/49 PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
    is as compress compiled wrapped
    The symbol "compress" was substituted for "end-of-file" to continue.

    SQL> ALTER PACKAGE APPS.XLA_00200_AAD_S_000032_PKG COMPILE BODY;
    Warning: Package Body altered with compilation errors.
    SQL> show error
    Errors for PACKAGE BODY APPS.XLA_00200_AAD_S_000032_PKG:
    LINE/COL ERROR
    -------- -----------------------------------------------------------------
    131072/7 PLS-00103: Encountered the symbol "end-of-file" when expecting
    2 one of the following:
    . ( ) , * % & = - + < / > at in is mod remainder not rem
    <an exponent (**)> <> or != or ~= >= <= <> and or like like2
    like4 likec between || multiset member submultiset
    No similar errors are reported on MOS, so I would suggest you log a SR for those objects (and similar ones).
    SQL> ALTER PACKAGE RE.RE_PROFILER COMPILE BODY;
    Warning: Package Body altered with compilation errors.
    SQL> show error
    Errors for PACKAGE BODY RE.RE_PROFILER:
    LINE/COL ERROR
    -------- -----------------------------------------------------------------
    1180/13 PL/SQL: SQL Statement ignored
    1180/13 PLS-00435: DML statement without BULK In-BIND cannot be used inside FORALL
    1181/32 PLS-00440: FORALL bulk IN-bind variables cannot be used here
    1926/9 PL/SQL: SQL Statement ignored
    1926/9 PLS-00435: DML statement without BULK In-BIND cannot be used inside FORALL
    When Upgrading 11g, the Wrapped Package Body with FORALL Raises PLS-435, PLS-440 on Compilation [ID 949343.1]
    SQL> ALTER PACKAGE APPS.XLA_00555_AAD_S_000014_PKG COMPILE BODY;
    Warning: Package Body altered with compilation errors.
    SQL> show error
    Errors for PACKAGE BODY APPS.XLA_00555_AAD_S_000014_PKG:
    LINE/COL ERROR
    -------- -----------------------------------------------------------------
    131072/5 PLS-00103: Encountered the symbol "end-of-file" when expecting
    7 one of the following:
    begin function pragma procedure subtype type <an identifier>
    <a double-quoted delimited-identifier> current cursor delete exists prior

    SQL> ALTER PACKAGE APPS.FSAH_DUPLICATE_PKG COMPILE BODY;
    Warning: Package Body altered with compilation errors.
    SQL> show error
    Errors for PACKAGE BODY APPS.FSAH_DUPLICATE_PKG:
    LINE/COL ERROR
    -------- -----------------------------------------------------------------
    7/12 PLS-00341: declaration of cursor 'C1' is incomplete or malformed
    8/7 PL/SQL: SQL Statement ignored
    9/14 PL/SQL: ORA-00942: table or view does not exist
    12/17 PL/SQL: Item ignored
    16/7 PL/SQL: SQL Statement ignored
    16/71 PL/SQL: ORA-00942: table or view does not exist
    22/13 PL/SQL: SQL Statement ignored
    22/27 PLS-00320: the declaration of the type of this expression is incomplete or malformed
    ......

    SQL> ALTER PACKAGE APPS.XLA_00707_AAD_C_000044_PKG COMPILE BODY;
    Warning: Package Body altered with compilation errors.
    SQL> show error
    Errors for PACKAGE BODY APPS.XLA_00707_AAD_C_000044_PKG:
    LINE/COL ERROR
    -------- -----------------------------------------------------------------
    201713/1 PL/SQL: SQL Statement ignored
    201826/1 PL/SQL: ORA-00904: "CST_XLA_INV_REF_V"."TRANSACTION_SOURCE_ID":
    30 invalid identifier
    202147/1 PL/SQL: SQL Statement ignored
    202191/1 PL/SQL: ORA-00904: "CST_XLA_INV_REF_V"."TRANSACTION_SOURCE_ID":
    30 invalid identifier
    202973/5 PL/SQL: Statement ignored
    202973/2 PLS-00364: loop index variable 'HEADER_RECORD' use is invalid
    7

    SQL> ALTER PACKAGE APPS.POS_AP_SUPPLIER_BO_PKG COMPILE BODY;
    Warning: Package Body altered with compilation errors.
    SQL> show error
    Errors for PACKAGE BODY APPS.POS_AP_SUPPLIER_BO_PKG:
    LINE/COL ERROR
    -------- -----------------------------------------------------------------
    0/0 PL/SQL: Compilation unit analysis terminated
    1/14 PLS-00304: cannot compile body of 'POS_AP_SUPPLIER_BO_PKG' without its specification
    1/14 PLS-00905: object APPS.POS_AP_SUPPLIER_BO_PKG is invalid

    SQL> ALTER PACKAGE APPS.POS_AP_SUPPLIER_BO_PKG COMPILE ;
    Warning: Package altered with compilation errors.
    SQL> show error
    Errors for PACKAGE APPS.POS_AP_SUPPLIER_BO_PKG:
    LINE/COL ERROR
    -------- -----------------------------------------------------------------
    3/3 PL/SQL: Declaration ignored
    7/32 PLS-00201: identifier 'POS_AP_SUPPLIER_BO' must be declared
    28/3 PL/SQL: Declaration ignored
    35/40 PLS-00201: identifier 'POS_AP_SUPPLIER_BO' must be declared

    SQL> ALTER PACKAGE APPS.POS_BANK_ACCOUNT_BO_PKG COMPILE BODY;
    Warning: Package Body altered with compilation errors.
    SQL> show error
    Errors for PACKAGE BODY APPS.POS_BANK_ACCOUNT_BO_PKG:
    LINE/COL ERROR
    -------- -----------------------------------------------------------------
    0/0 PL/SQL: Compilation unit analysis terminated
    1/14 PLS-00304: cannot compile body of 'POS_BANK_ACCOUNT_BO_PKG' without its specification
    1/14 PLS-00905: object APPS.POS_BANK_ACCOUNT_BO_PKG is invalid

    SQL> ALTER PACKAGE APPS.POS_BANK_ACCOUNT_BO_PKG COMPILE ;
    Warning: Package altered with compilation errors.
    SQL> show error
    Errors for PACKAGE APPS.POS_BANK_ACCOUNT_BO_PKG:
    LINE/COL ERROR
    -------- -----------------------------------------------------------------
    4/6 PL/SQL: Declaration ignored
    9/80 PLS-00201: identifier 'POS_BANK_ACCOUNT_BO_TBL' must be declared
    13/5 PL/SQL: Declaration ignored
    19/69 PLS-00201: identifier 'POS_BANK_ACCOUNT_BO_TBL' must be declared
    Once POS_BANK_ACCOUNT_BO_PKG is compiled successfully you should be able to compile all packages/objects that depend on this package.

    I would suggest you log a SR if you want to validate these objects since they are seeded ones.

    Thanks,
    Hussein
  • 8. Re: many invalid objects found after new install the R12 vision demo (12.1.1)
    WF001 Newbie
    Currently Being Moderated
    Hi Hussein,

    Thanks for your quick reply, I already have opened a SR with Oracle support and waiting for reply.

    One more question, do I need refer "MOS ID#954704.1 - EBS:R12.1 Oracle Financials Recommended Patch Collection(RPC)" to apply the recommended patches (exclude R12.1 Pre-Upgrade Patches) in my R12 (12.1.3) vision demo env before to use CE,GL,AR,AP,FA?

    Thanks :)
    Sam
  • 9. Re: many invalid objects found after new install the R12 vision demo (12.1.1)
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    Hi Sam,
    One more question, do I need refer "MOS ID#954704.1 - EBS:R12.1 Oracle Financials Recommended Patch Collection(RPC)" to apply the recommended patches (exclude R12.1 Pre-Upgrade Patches) in my R12 (12.1.3) vision demo env before to use CE,GL,AR,AP,FA?
    It is recommended you apply those patches. I do include this list of patches in my 12.1.3 upgrade docs.

    Thanks,
    Hussein
  • 10. Re: many invalid objects found after new install the R12 vision demo (12.1.1)
    WF001 Newbie
    Currently Being Moderated
    Hi Hussein,

    Refer "MOS ID#954704.1 - EBS:R12.1 Oracle Financials Recommended Patch Collection(RPC)"
    and "R12.1: Payables Recommended Patch Collection (AP RPC), August 2012 [ID 1397581.1]"

    I want to apply the patch#14273383:R12.AP.B in my "vision demo" R12.1.3 env., but refer the readme, do I need to choose the Federal customers's Pre-requisite patch #14491652:R12.FV.B if I'm non Federals customers ?

    Thanks again.
    Sam
  • 11. Re: many invalid objects found after new install the R12 vision demo (12.1.1)
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    I want to apply the patch#14273383:R12.AP.B in my "vision demo" R12.1.3 env., but refer the readme, do I need to choose the Federal customers's Pre-requisite patch #14491652:R12.FV.B if I'm non Federals customers ?
    No -- You can skip this patch.

    Thanks,
    Hussein

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points