12 Replies Latest reply: Feb 20, 2013 9:59 PM by WF001 RSS

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

    WF001
      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-Oracle
          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
            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
              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
                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
                  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
                    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
                      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
                        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
                          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
                            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
                              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