1 4 5 6 7 8 Previous Next 173 Replies Latest reply: May 30, 2013 12:07 PM by Hussein Sawwan-Oracle Go to original post Branched to a new discussion. RSS
      • 75. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
        user10994730
        Thanks Hussein.
        as per the adctrl utility we have this.

        Control
        Worker Code Context Filename Status
        ------ -------- ----------------- -------------------------- --------------
        1 Run AutoPatch R120 pl Wait
        2 Run AutoPatch R120 pl Wait
        3 Run AutoPatch R120 pl Wait
        4 Run AutoPatch R120 pl peehrgeo.sql FAILED

        worker 4 log file shows following.( emailed you worker log files.)

        AD Worker error:
        The following ORACLE error:

        ORA-02430: cannot enable constraint (HR_S_US_CITY_GEOCODES_PK) - no such constra
        int

        occurred while executing the SQL statement:

        ALTER TABLE HR_S_US_CITY_GEOCODES ENABLE CONSTRAINT
        HR_S_US_CITY_GEOCODES_PK

        Error occurred in file

        /data/rel12/apps/apps_st/appl/pay/12.0.0/patch/115/sql/peehrgeo.sql

        with arguments '&un_per &pw_per'.

        Time when worker failed: Thu Mar 07 2013 16:08:42
        AdjavaWorker has reached the maximum wait timeout specified( 36000000 ). So Exit
        • 76. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
          Hussein Sawwan-Oracle
          AD Worker error:
          The following ORACLE error:

          ORA-02430: cannot enable constraint (HR_S_US_CITY_GEOCODES_PK) - no such constra
          int
          Please see if (Bug 14753637 : UPGRADE PATCH FAILS WITH PEEHRGEO.SQL, PAYPKPRO.SQL AND PEPKSTU.SQL) helps. Otherwise, please log a SR.

          Thanks,
          Hussein
          • 77. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
            user10994730
            As per following and oracle support https://communities.oracle.com/portal/server.pt/community/view_discussion_topic/216?threadid=480842


            I did the following & restatred the failed worker and Issue still there.

            drop index HR.HR_S_CITY_GEOCODES_PK;

            Index dropped.
            Restarting job that failed and was fixed.

            Time when worker restarted job: Fri Mar 08 2013 13:22:17

            Start time for file is: Fri Mar 08 2013 13:22:17

            sql /data/rel12/apps/apps_st/appl/pay/12.0.0/patch/115/sql/peehrgeo.sql &un_per
            &pw_per

            Start time for statement below is: Fri Mar 08 2013 13:22:17

            CONNECT HR/*****

            Connecting to HR......Connected successfully.

            Start time for statement below is: Fri Mar 08 2013 13:22:17

            ALTER TABLE HR_S_US_CITY_GEOCODES ENABLE CONSTRAINT
            HR_S_US_CITY_GEOCODES_PK

            AD Worker error:
            The following ORACLE error:

            ORA-02430: cannot enable constraint (HR_S_US_CITY_GEOCODES_PK) - no such constra
            int

            occurred while executing the SQL statement:

            ALTER TABLE HR_S_US_CITY_GEOCODES ENABLE CONSTRAINT
            HR_S_US_CITY_GEOCODES_PK

            Error occurred in file

            /data/rel12/apps/apps_st/appl/pay/12.0.0/patch/115/sql/peehrgeo.sql

            with arguments '&un_per &pw_per'.

            Restarting job that failed and was fixed.

            Time when worker restarted job: Fri Mar 08 2013 13:22:17

            Start time for file is: Fri Mar 08 2013 13:22:17

            sql /data/rel12/apps/apps_st/appl/pay/12.0.0/patch/115/sql/peehrgeo.sql &un_per
            &pw_per

            Start time for statement below is: Fri Mar 08 2013 13:22:17

            CONNECT HR/*****

            Connecting to HR......Connected successfully.

            Start time for statement below is: Fri Mar 08 2013 13:22:17

            ALTER TABLE HR_S_US_CITY_GEOCODES ENABLE CONSTRAINT
            HR_S_US_CITY_GEOCODES_PK

            AD Worker error:
            The following ORACLE error:

            ORA-02430: cannot enable constraint (HR_S_US_CITY_GEOCODES_PK) - no such constra
            int

            occurred while executing the SQL statement:

            ALTER TABLE HR_S_US_CITY_GEOCODES ENABLE CONSTRAINT
            HR_S_US_CITY_GEOCODES_PK

            Error occurred in file

            /data/rel12/apps/apps_st/appl/pay/12.0.0/patch/115/sql/peehrgeo.sql

            with arguments '&un_per &pw_per'.

            Worker Code Context Filename Status
            ------ -------- ----------------- -------------------------- --------------
            1 Run AutoPatch R120 pl Wait
            2 Run AutoPatch R120 pl Wait
            3 Run AutoPatch R120 pl Wait
            4 Run AutoPatch R120 pl peehrgeo.sql FAILED



            It is trying to enable constraint whichis not there. I just droped it. Can we skip this worker?

            I am at the end of the applying upgrade driver. There r 1700 process to finsh.

            Thanks.
            • 78. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
              Hussein Sawwan-Oracle
              I would not recommended skipping the worker unless you are instructed to do so by Oracle support.

              If this is only a practice upgrade, then you may skip it and log a SR for a solution (for your next upgrade).

              Thanks,
              Hussein
              • 79. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                user10994730
                Thanks Hussein,

                As per the oracle support I have recreated the Primary key and enabled it.

                SQL> ALTER TABLE HR.HR_S_US_CITY_GEOCODES
                2 ADD (CONSTRAINT HR_S_US_CITY_GEOCODES_PK PRIMARY KEY
                3 (STATE_CODE,COUNTY_CODE,CITY_CODE) using index tablespace HRX);

                Table altered.

                SQL> select owner||'|'||INDEX_NAME||'|'||INDEX_TYPE||'|'||TABLE_OWNER||'|'||TABLE_NAME||'|' from all_indexes
                2 WHERE table_name LIKE '%HR_S_US_CITY_GEOCODES%';

                OWNER||'|'||INDEX_NAME||'|'||INDEX_TYPE||'|'||TABLE_OWNER||'|'||TABLE_NAME||'|'
                --------------------------------------------------------------------------------
                HR|HR_S_US_CITY_GEOCODES_PK|NORMAL|HR|HR_S_US_CITY_GEOCODES|

                SQL> alter table HR.HR_S_US_CITY_GEOCODES enable constraint HR_S_US_CITY_GEOCODES_PK;

                Table altered.

                SQL>


                ATTENTION: Please fix the above failed worker(s) so the manager can continue.

                Completed: file peehrgeo.sql on worker 4 for product pay username HR.

                Starting phase 284 (A284): en+1

                There are now 1339 jobs remaining (current phase=A284):
                0 running, 84 ready to run and 1255 waiting.

                Assigned: file amw_opinion_mv.xdf on worker 1 for product amw username APPS.
                Assigned: file fffkff.sql on worker 2 for product ff username HR.
                Assigned: file GMEMGDRI1.sql on worker 3 for product gme username GME.
                Assigned: file GMFPUEN.sql on worker 4 for product gmf username GMF.
                Completed: file GMFPUEN.sql on worker 4 for product gmf username GMF.
                Assigned: file GMITXADD.sql on worker 4 for product gmi username GMI.
                Completed: file fffkff.sql on worker 2 for product ff username HR.
                Assigned: file isc_dr_curr_01_mv.xdf on worker 2 for product isc username APPS
                .
                Completed: file GMITXADD.sql on worker 4 for product gmi username GMI.
                Assigned: file isc_dr_service_code_mv.xdf on worker 4 for product isc username
                APPS.

                Now the process is moving.
                • 80. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                  user10994730
                  I got the following error.

                  Completed: file poa_pod_bs_mv.xdf on worker 2 for product poa username APPS.

                  ATTENTION: All workers either have failed or are waiting:

                  FAILED: file fem_bal_nacc_hier_l2_mv.xdf on worker 1.

                  ATTENTION: Please fix the above failed worker(s) so the manager can continue.
                  oracle@hmf-hrm-001:~>

                  XDF file application started. Current time is: Mon Mar 11 14:21:41 EDT 2013

                  ================================================================================
                  Applying XDF file : /data/rel12/apps/apps_st/appl/fem/12.0.0/patch/115/xdf/fem_b
                  al_nacc_hier_l2_mv.xdf
                  ================================================================================

                  Materialized View Name is FEM_BAL_NACC_HIER_L2_MV
                  Materialized View does not exist in the target database

                  Executing create Statement
                  Create Statement is

                  CREATE MATERIALIZED VIEW "APPS"."FEM_BAL_NACC_HIER_L2_MV"
                  ORGANIZATION HEAP PCTFREE 10 PCTUSED 40 INITRANS 10 MAXTRANS 255 LOGGING
                  STORAGE(INITIAL 4096 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645
                  PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 4 BUFFER_POOL DEFAULT)
                  TABLESPACE "APPS_TS_SUMMARY"
                  BUILD DEFERRED
                  USING INDEX
                  REFRESH FORCE ON DEMAND
                  WITH ROWID USING DEFAULT LOCAL ROLLBACK SEGMENT
                  ENABLE QUERY REWRITE
                  AS select
                  FEM_BAL_BASE_SUMMARY_MV.LEDGER_ID,
                  FEM_BAL_BASE_SUMMARY_MV.DATASET_CODE,
                  FEM_BAL_BASE_SUMMARY_MV.CAL_PERIOD_ID,
                  FEM_BAL_BASE_SUMMARY_MV.CURRENCY_CODE,
                  FEM_BAL_BASE_SUMMARY_MV.COMPANY_COST_CENTER_ORG_ID,
                  FEM_BAL_BASE_SUMMARY_MV.COMPANY_COST_CENTER_ORG_VS_ID,
                  FEM_DIS_NAT_ACCTS_HIER_B.VALUE_SET_ID,
                  FEM_DIS_NAT_ACCTS_HIER_B.OBJECT_ID,
                  FEM_DIS_NAT_ACCTS_HIER_B.OBJECT_DEFINITION_ID,
                  FEM_DIS_NAT_ACCTS_HIER_B.LEVEL1_ID,
                  FEM_DIS_NAT_ACCTS_HIER_B.LEVEL2_ID ,
                  FEM_DIS_NAT_ACCTS_HIER_B.VALUE_SET_ID NATURAL_ACCOUNT_VS_ID,
                  SUM( FEM_BAL_BASE_SUMMARY_MV.XTD_BALANCE_E) XTD_BALANCE_E,
                  SUM( FEM_BAL_BASE_SUMMARY_MV.XTD_BALANCE_F) XTD_BALANCE_F,
                  SUM( FEM_BAL_BASE_SUMMARY_MV.QTD_BALANCE_E) QTD_BALANCE_E,
                  SUM( FEM_BAL_BASE_SUMMARY_MV.QTD_BALANCE_F) QTD_BALANCE_F,
                  SUM( FEM_BAL_BASE_SUMMARY_MV.YTD_BALANCE_E) YTD_BALANCE_E,
                  SUM( FEM_BAL_BASE_SUMMARY_MV.YTD_BALANCE_F) YTD_BALANCE_F,
                  SUM(PTD_CREDIT_BALANCE_E) PTD_CREDIT_BALANCE_E,
                  SUM(PTD_DEBIT_BALANCE_E) PTD_DEBIT_BALANCE_E,
                  SUM(YTD_CREDIT_BALANCE_E) YTD_CREDIT_BALANCE_E,
                  SUM(YTD_DEBIT_BALANCE_E) YTD_DEBIT_BALANCE_E
                  from FEM_DIS_NAT_ACCTS_HIER_B,
                  FEM_BAL_BASE_SUMMARY_MV
                  where
                  FEM_DIS_NAT_ACCTS_HIER_B.VALUE_SET_ID = FEM_BAL_BASE_SUMMARY_MV.NATURAL_ACCOUNT
                  VSID
                  AND FEM_DIS_NAT_ACCTS_HIER_B.LEVEL20_ID = FEM_BAL_BASE_SUMMARY_MV.NATURAL_ACCOUN
                  T_ID
                  GROUP BY
                  FEM_BAL_BASE_SUMMARY_MV.LEDGER_ID,
                  FEM_BAL_BASE_SUMMARY_MV.DATASET_CODE,
                  FEM_BAL_BASE_SUMMARY_MV.CAL_PERIOD_ID,
                  FEM_BAL_BASE_SUMMARY_MV.CURRENCY_CODE,
                  FEM_BAL_BASE_SUMMARY_MV.COMPANY_COST_CENTER_ORG_ID,
                  FEM_BAL_BASE_SUMMARY_MV.COMPANY_COST_CENTER_ORG_VS_ID,
                  FEM_DIS_NAT_ACCTS_HIER_B.VALUE_SET_ID,
                  FEM_DIS_NAT_ACCTS_HIER_B.OBJECT_ID,
                  FEM_DIS_NAT_ACCTS_HIER_B.OBJECT_DEFINITION_ID,
                  FEM_DIS_NAT_ACCTS_HIER_B.LEVEL1_ID,
                  FEM_DIS_NAT_ACCTS_HIER_B.LEVEL2_ID,
                  FEM_DIS_NAT_ACCTS_HIER_B.VALUE_SET_ID


                  Start time for statement above is Mon Mar 11 14:21:42 EDT 2013
                  Exception occured ORA-54015: Duplicate column expression was specified
                  ORA-06512: at "APPS.AD_MV", line 131
                  ORA-06512: at "APPS.AD_MV", line 289
                  ORA-06512: at line 1

                  java.sql.SQLException: ORA-54015: Duplicate column expression was specified
                  ORA-06512: at "APPS.AD_MV", line 131
                  ORA-06512: at "APPS.AD_MV", line 289
                  ORA-06512: at line 1

                  ==========================================================
                  Done calling the utility function. Return Code = [1] TimeStamp = [Mon Mar 11 14:
                  21:42 EDT 2013]
                  Updating task with status 1
                  AD Worker error:
                  The utility FndXdfCmp returned error for the above task.



                  Can I download 10406817 "ORA-54015 APPLYING FEM_BAL_NACC_HIER_L2_MV.XDF ON ORACLE 11GR2 DATABASE" Patch and move this script "fem_bal_nacc_hier_l2_mv.xdf"
                  from patch directory to /data/rel12/apps/apps_st/appl/fem/12.0.0/patch/115/xdf and restart the failed worker?

                  oracle@hmf-hrm-001:/data/rel12/apps/apps_st/appl/fem/12.0.0/patch/115/xdf> strings -a fem_bal_nacc_hier_l2_mv.xdf |grep '$Header'
                  <!-- $Header: fem_bal_nacc_hier_l2_mv.xdf 120.1 2007/09/05 23:28:17 nmartine ship $ -->


                  Thanks.
                  • 81. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                    user10994730
                    Resolved with following.

                    Download Patch 10406817 and unzip it. Do not apply


                    oracle@hmf-hrm-001:/data/rel12/apps/apps_st/appl/fem/12.0.0/patch/115/xdf> cp -p /data/oracle/r12/10406817/fem/patch/115/xdf/fem_bal_nacc_hier_l2_mv.xdf .
                    oracle@hmf-hrm-001:/data/rel12/apps/apps_st/appl/fem/12.0.0/patch/115/xdf> ls -l fem_bal_nacc_hier_l2_mv.xdf*
                    -rwxr-xr-x 1 oracle puppet 88576 Jan 1 2002 fem_bal_nacc_hier_l2_mv.xdf
                    -rwxr-xr-x 1 oracle dba 39205 Nov 25 2008 fem_bal_nacc_hier_l2_mv.xdf_orig
                    oracle@hmf-hrm-001:/data/rel12/apps/apps_st/appl/fem/12.0.0/patch/115/xdf> strings -a fem_bal_nacc_hier_l2_mv.xdf |grep '$Header' <!-- $Header: fem_bal_nacc_hier_l2_mv.xdf 120.1.12010000.2 2011/01/07 00:00:28 ghall ship $ -->


                    Rstarted the failed worker.



                    ATTENTION: All workers either have failed or are waiting:

                    FAILED: file fem_bal_nacc_hier_l2_mv.xdf on worker 1.

                    ATTENTION: Please fix the above failed worker(s) so the manager can continue.

                    biv_b_age_h_sum_mv.xdf

                    TTENTION: Please fix the above failed worker(s) so the manager can continue.

                    Fixed: file fem_bal_nacc_hier_l2_mv.xdf on worker 1 for product fem usernam
                    e APPS.
                    Restarted: file fem_bal_nacc_hier_l2_mv.xdf on worker 1 for product fem usernam
                    e APPS.
                    Completed: file fem_bal_nacc_hier_l2_mv.xdf on worker 1 for product fem usernam
                    e APPS.

                    Starting phase 294 (A294): en+11

                    There are now 1026 jobs remaining (current phase=A294):
                    0 running, 6 ready to run and 1020 waiting.

                    Assigned: file czintlfx.sql on worker 1 for product cz username CZ.
                    Assigned: file czsvtxt.sql on worker 2 for product cz username CZ.
                    Assigned: file czuct.sql on worker 3 for product cz username CZ.
                    Assigned: file czuif1.sql on worker 4 for product cz username CZ.
                    Completed: file czintlfx.sql on worker 1 for product cz username CZ.
                    Assigned: file czuimgs.sql on worker 1 for product cz username CZ.
                    Completed: file czuimgs.sql on worker 1 for product cz username CZ.


                    Thanks.
                    • 82. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                      user10994730
                      Upgrade driver is done. I do still see some invalids and how do i handle them?
                      Should I be continuing with next step "Apply latest product patches (required)" as per http://docs.oracle.com/cd/B53825_08/current/acrobat/121upgrade.pdf

                      Compiling invalid objects...

                      sqlplus -s APPS/***** @/data/rel12/apps/apps_st/appl/ad/12.0.0/sql/adutlrcmp.sql
                      APPLSYS ***** APPS ***** ***** 4 0 NONE FALSE

                      Copying admin/<sid>/applterr.txt to admin/applterr.txt (if needed)...

                      Did not need to copy admin/LNXRES/applterr.txt to admin/applterr.txt.

                      sqlplus -s APPS/***** @/data/rel12/apps/apps_st/appl/ad/12.0.0/sql/adtimrpt.sql
                      2346 adt02346

                      A job timing report has been generated for the current session.
                      You should check the file
                      /data/rel12/apps/apps_st/appl/admin/LNXRES/out/adt02346.lst

                      for details.

                      Purging timing information for prior sessions.

                      sqlplus -s APPS/***** @/data/rel12/apps/apps_st/appl/ad/12.0.0/sql/adtpurge.sql
                      10 1000

                      Done purging timing information for prior sessions.

                      AutoPatch is complete.

                      AutoPatch may have written informational messages to the file
                      /data/rel12/apps/apps_st/appl/admin/LNXRES/log/adpatch_upgrd_drv_030613.lgi

                      Errors and warnings are listed in the log file
                      /data/rel12/apps/apps_st/appl/admin/LNXRES/log/adpatch_upgrd_drv_030613.log

                      and in other log files in the same directory.

                      oracle@hmf-hrm-001:/data/rel12/apps/apps_st/appl/admin/LNXRES/merged>
                      oracle@hmf-hrm-001:~>

                      OWNER||'|'||OBJECT_TYPE||'|'||OBJECT_NAME||'|'
                      --------------------------------------------------------------------------------
                      APPS|VIEW|CST_LAYER_ACTUAL_COST_DTLS_V|
                      APPS|VIEW|WF_HZ_PARTY_ROLES|
                      APPS|VIEW|WF_HZ_GROUP_UR|
                      APPS|PACKAGE BODY|HR_PERSON_ADDRESS_BK1|
                      APPS|PACKAGE BODY|HR_ASSIGNMENT_BK2|
                      APPS|PACKAGE BODY|PE_AEI_RKD|
                      APPS|PACKAGE BODY|PE_AEI_RKI|
                      APPS|PACKAGE BODY|PE_AEI_RKU|
                      APPS|PACKAGE BODY|HR_ASSIGNMENT_EXTRA_INFO_BK1|
                      APPS|PACKAGE BODY|HR_ASSIGNMENT_EXTRA_INFO_BK2|
                      APPS|PACKAGE BODY|HR_LOCATION_EXTRA_INFO_BK1|

                      OWNER||'|'||OBJECT_TYPE||'|'||OBJECT_NAME||'|'
                      --------------------------------------------------------------------------------
                      APPS|PACKAGE BODY|HR_LOCATION_EXTRA_INFO_BK2|
                      APPS|PACKAGE BODY|HR_PHONE_BK1|
                      APPS|PACKAGE BODY|HR_PHONE_BK2|
                      APPS|PACKAGE BODY|HR_ORGANIZATION_BK1|
                      APPS|PACKAGE BODY|HR_ORGANIZATION_BK2|
                      APPS|PACKAGE BODY|HR_PERSON_ADDRESS_BK3|
                      APPS|PACKAGE BODY|PER_REI_RKI|
                      APPS|PACKAGE BODY|PER_REI_RKU|
                      APPS|PACKAGE BODY|WMS_EPC_PVT|
                      APPS|PACKAGE BODY|PAY_MX_SUBSIDY_EMP_PD_RPT|
                      APPS|PACKAGE BODY|PAY_CA_RL1_AMEND_MAG|

                      OWNER||'|'||OBJECT_TYPE||'|'||OBJECT_NAME||'|'
                      --------------------------------------------------------------------------------
                      APPS|PACKAGE BODY|PAY_GB_PAYE_SYNC|
                      APPS|PACKAGE BODY|PAY_GB_HIST_ARCH_PKG|
                      APPS|PACKAGE BODY|PAY_IE_HIST_ARCH_PKG|
                      APPS|PACKAGE BODY|PAY_KR_YEA20090101_PKG|
                      APPS|PACKAGE BODY|PAY_KR_YEA20100101_PKG|
                      APPS|PACKAGE BODY|PAY_SA_HIST_ARCH_PKG|
                      APPS|PACKAGE BODY|PER_ZA_EE_WORKFORCE_PROFILE|
                      APPS|PACKAGE BODY|PER_ZA_EE_DIFFERENTIAL_PKG|
                      APPS|PACKAGE BODY|PAY_DYT_ASSIGNMENT_ATTRIB_PKG|
                      APPS|TRIGGER|PERCONTACTRELATIONSHI_139U_DYT|
                      APPS|TRIGGER|PERCONTACTRELATIONSHI_138I_DYT|

                      OWNER||'|'||OBJECT_TYPE||'|'||OBJECT_NAME||'|'
                      --------------------------------------------------------------------------------
                      APPS|PACKAGE BODY|FEM_CHECK_BR_DIS_MBRS_PKG|
                      APPS|PACKAGE BODY|ZPB_BUILD_METADATA|
                      NJIT|SYNONYM|CST_LAYER_ACTUAL_COST_DTLS_V|
                      NJIT|SYNONYM|WF_HZ_GROUP_UR|
                      NJIT|SYNONYM|WF_HZ_PARTY_ROLES|
                      ADPCONNECT|VIEW|HR_ADP_ASSIGNMENT_V|
                      ADPCONNECT2|VIEW|HR_ADP_ASSIGNMENT_V|
                      • 83. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                        Hussein Sawwan-Oracle
                        user10994730 wrote:
                        Upgrade driver is done. I do still see some invalids and how do i handle them?
                        Should I be continuing with next step "Apply latest product patches (required)" as per http://docs.oracle.com/cd/B53825_08/current/acrobat/121upgrade.pdf
                        If you are planning to upgrade to 12.1.3 then you can apply the latest patches later.

                        For the invalid objects, compile them via adadmin and check then. If you still have invalid objects, compile them manually and post the error here.

                        Thanks,
                        Hussein
                        • 84. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                          user10994730
                          Thanks Hussein.

                          Should I be running adadmin with new environment or old?
                          I ran with new environment and I do see invalids still.
                          Could you please give me some direction to upgrade to 12.1.3?


                          Thanks.
                          • 85. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                            Hussein Sawwan-Oracle
                            Should I be running adadmin with new environment or old?
                            New.
                            I ran with new environment and I do see invalids still.
                            What if you compile it manually?
                            Could you please give me some direction to upgrade to 12.1.3?
                            https://blogs.oracle.com/stevenChan/entry/ebs_1213_available

                            Thanks,
                            Hussein
                            • 86. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                              user10994730
                              Thanks Hussein.

                              I just compiled manually couple of them.

                              For following invaid see following note.
                              APPS|VIEW|WF_HZ_PARTY_ROLES|
                              APPS|VIEW|WF_HZ_GROUP_UR|

                              After 12.1.2 Upgrade WF_HZ_GROUP_UR And WF_HZ_PARTY_ROLES Views Are Invalid [ID 1236335.1]

                              SQL> alter package apps.HR_PERSON_ADDRESS_BK1 compile body;

                              Warning: Package Body altered with compilation errors.

                              SQL> show error
                              Errors for PACKAGE BODY APPS.HR_PERSON_ADDRESS_BK1:

                              LINE/COL ERROR
                              -------- -----------------------------------------------------------------
                              263/1 PL/SQL: Statement ignored
                              263/1 PLS-00201: identifier 'INVALID_SEE_COMMENT_IN_SOURCE' must be declared


                              SQL> show error
                              Errors for PACKAGE BODY APPS.HR_ASSIGNMENT_BK2:

                              LINE/COL ERROR
                              -------- -----------------------------------------------------------------
                              298/1 PL/SQL: Statement ignored
                              298/1 PLS-00201: identifier 'INVALID_SEE_COMMENT_IN_SOURCE' must be
                              declared
                              • 87. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                                Hussein Sawwan-Oracle
                                Please apply R12 patches in (During 12.1.1 Upgrade From 11.5.10 RUP 4 Peaeirsd.Sql Fails with PLS-00201: identifier 'INVALID_SEE_COMMENT_IN_SOURCE' must be declared [ID 888701.1]).

                                Thanks,
                                Hussein
                                • 88. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                                  user10994730
                                  I am confused about this note Hussein,

                                  It says apply this patch before you upgrade to r12 from 11i Rup 4.
                                  should I be applying this patch since i am already in r12.1.1?
                                  Patch 8865454:R12.PER.B

                                  Edited by: user10994730 on Mar 12, 2013 11:46 AM
                                  • 89. Re: Upgrading  ebs 11i to r12 12.1.1 on Suse
                                    Hussein Sawwan-Oracle
                                    should I be applying this patch since i am already in r12.1.1?
                                    Patch 8865454:R12.PER.B
                                    Yes.

                                    Thanks,
                                    Hussein
                                    1 4 5 6 7 8 Previous Next