1 2 Previous Next 21 Replies Latest reply: May 8, 2012 9:44 AM by pmkr RSS

    Error while applying patch to 12.1.3 from 12.1.1

    Severity
      Hi,

      while I'm applying patch 9239090, I'm getting the following error:
      The following Oracle Forms objects did not generate successfully:
      
      au      resource        IEXFBALI.pll
      au      resource        OKSACTEV.pll
      au      resource        OKSAUDET.pll
      au      resource        CSCUTILS.pll
      au      resource        OKCEXEVT.pll
      au      resource        OKCEXPOR.pll
      au      resource        OKCKSRCH.pll
      
      The following Oracle Forms objects did not generate successfuly:
      
      iex     forms/US     IEXCUOVW.fmx
      iex     forms/US     IEXRCALL.fmx
      wms     forms/US     WMSLABEL.fmx
      wsh     forms/US     WSHQSSUI.fmx
      wsh     forms/US     WSHSTREF.fmx
      wsh     forms/US     WSHFSTRX.fmx
      /
      and i have allready applied patch 9239089 before 9239090
        • 1. Re: Error while applying patch to 12.1.3 from 12.1.1
          Hussein Sawwan-Oracle
          The following Oracle Forms objects did not generate successfully:

          au resource IEXFBALI.pll
          au resource OKSACTEV.pll
          au resource OKSAUDET.pll
          au resource CSCUTILS.pll
          au resource OKCEXEVT.pll
          au resource OKCEXPOR.pll
          au resource OKCKSRCH.pll

          The following Oracle Forms objects did not generate successfuly:

          iex     forms/US     IEXCUOVW.fmx
          iex     forms/US     IEXRCALL.fmx
          wms     forms/US     WMSLABEL.fmx
          wsh     forms/US     WSHQSSUI.fmx
          wsh     forms/US     WSHSTREF.fmx
          wsh     forms/US     WSHFSTRX.fmx
          Please check the worker log files for details about the error.

          You could also skip those jobs for now and regenerate them via adadmin then.

          Thanks,
          Hussein
          • 2. Re: Error while applying patch to 12.1.3 from 12.1.1
            Severity
            Hi,

            i've checked the log and the problem occured because some package body and object are invalid

            and we're going to recompile it after backup

            thx
            • 3. Re: Error while applying patch to 12.1.3 from 12.1.1
              Hussein Sawwan-Oracle
              i've checked the log and the problem occured because some package body and object are invalid

              and we're going to recompile it after backup
              Compiling the invalid objects may resolve the issue, so please do and try to generate those objects then.

              Thanks,
              Hussein
              • 4. Re: Error while applying patch to 12.1.3 from 12.1.1
                Severity
                Hi,

                I've tried to regenerate forms using adadmin but the problem still persist with the same error
                does anyone know how to solve the problem ??

                thx
                • 5. Re: Error while applying patch to 12.1.3 from 12.1.1
                  Hussein Sawwan-Oracle
                  I've tried to regenerate forms using adadmin but the problem still persist with the same error
                  does anyone know how to solve the problem ??
                  Please compile it manually and check the log file for details about the error.

                  How to Generate Form, Library and Menu for Oracle Applications [ID 130686.1]
                  How do I Generate Forms in R11i or R12? [ID 742617.1]

                  Thanks,
                  Hussein
                  • 6. Re: Error while applying patch to 12.1.3 from 12.1.1
                    Severity
                    I've tried to regenerate manually using :
                    frmcmp userid=apps/apps module=IEXCUOVW.fmb output_file=/app/apps/apps_st/appl/iex/12.0.0/forms/US/IEXRCALL.fmx
                    module_type=form batch=no compile_all=special
                    and the feedback is

                    FRM-91500: Unable to start/complete the build

                    am I doing wrong ??

                    thx

                    Edited by: Hendra.K on Feb 21, 2012 5:51 PM
                    • 7. Re: Error while applying patch to 12.1.3 from 12.1.1
                      azodpe
                      have you tried generating invalid packages first and then recompile the forms?

                      As Hussein suggested, you can complete the patch and then comiple the forms.
                      • 8. Re: Error while applying patch to 12.1.3 from 12.1.1
                        azodpe
                        one more thing, have you tried compiling .plls manually?
                        what error you are getting?
                        From your pll names, it looks to me that some of the objects under CTXSYS (oracle text) are invalid.
                        HAve you checked invalid objects under this schema?
                        • 9. Re: Error while applying patch to 12.1.3 from 12.1.1
                          Severity
                          no, i haven't try to compile the library manually because after i recompile using adadmin there are no pll errors anymore


                          thx

                          Edited by: Hendra.K on Feb 21, 2012 6:01 PM
                          • 10. Re: Error while applying patch to 12.1.3 from 12.1.1
                            Severity
                            i'm using the adadmin to recompiled the objects and forms before trying to compile it manually

                            and in the end of the compilation it gives the below erors statement:

                            The following Oracle Forms objects did not generate successfuly:

                            iex     forms/US     IEXCUOVW.fmx
                            iex     forms/US     IEXRCALL.fmx
                            wms     forms/US     WMSLABEL.fmx
                            wsh     forms/US     WSHQSSUI.fmx
                            wsh     forms/US     WSHSTREF.fmx
                            wsh     forms/US     WSHFSTRX.fmx
                            • 11. Re: Error while applying patch to 12.1.3 from 12.1.1
                              azodpe
                              I would say, try to compile plls manually and see what error your are getting.
                              Have you looked at CTXSYS schema?
                              try to compile APPS.IEX_WRITEOFFOBJ_PUB in TOAD or sql developer.
                              it should tell you exactly what the problem is.
                              • 12. Re: Error while applying patch to 12.1.3 from 12.1.1
                                Hussein Sawwan-Oracle
                                FRM-91500: Unable to start/complete the build

                                am I doing wrong ??
                                Please see these docs.

                                R12: Manual Forms compilation In R12 fails With: FRM-91500: Unable to start/complete the build [ID 431324.1]
                                FRM-91500: UNABLE TO START/COMPLETE THE BUILD Encountered When Compiling Forms via FRMCMP [ID 753135.1]
                                Unable To Compile Custom Form Using Frmcmp Utility Receive FRM-91500 [ID 563655.1]

                                Thanks,
                                Hussein
                                • 13. Re: Error while applying patch to 12.1.3 from 12.1.1
                                  Severity
                                  IEXCUOVW.fmx
                                  Error Statement:
                                  
                                  FRM-30064: Unable to parse statement select site_uses.location location, 
                                         party_site.party_site_number,
                                         substr(loc.address1,1,25) ||' '
                                              || substr(loc.address2,1,25) ||' '
                                              || substr(loc.address3,1,25) ||' '
                                              || substr(loc.address4,1,25) ||' '
                                              || loc.city|| ',' || ' ' 
                                              || nvl(loc.state, loc.province) ||' '
                                              || t.territory_short_name address,
                                         site_uses.primary_flag, 
                                         loc.address1 address1, 
                                         loc.address2, 
                                         loc.city ||','|| ' '|| nvl(loc.state, loc.province) 
                                             ||' '||loc.postal_code|| ' ' 
                                             || t.territory_short_name address3, 
                                         site_uses.site_use_id customer_site_use_id, 
                                         site_uses.cust_acct_site_id address_id, 
                                         site_uses.bill_to_site_use_id bill_to_site_use_id,
                                         site_uses.primary_salesrep_id primary_salesrep_id,
                                         loc_assign.loc_id location_id, 
                                         loc.state state, 
                                         loc.country country, 
                                         loc.postal_code postal_code, 
                                         site_uses.territory_id territory_id,
                                         lp.meaning business_purpose,
                                         lp2.meaning primary_flag_meaning,
                                         ca.cust_account_id cust_account_id,
                                         ca.account_number account_number,
                                          decode(substrb(person.person_last_name,1,50), null,
                                                      substrb(person.person_first_name,1,40),
                                                      substrb(person.person_last_name,1,50) ||', ' ||
                                                      substrb(person.person_first_name,1,40))
                                                      contact_name,
                                         owner_party.party_name owner_party
                                  from hz_cust_acct_sites acct_site,
                                       hz_party_sites party_site, 
                                       hz_cust_accounts ca,
                                       hz_loc_assignments loc_assign,
                                       hz_locations loc, 
                                       hz_cust_site_uses site_uses, 
                                       fnd_territories_vl t,
                                       ar_lookups lp ,
                                       ar_lookups lp2,
                                       hz_cust_account_roles  role,
                                       hz_parties person,
                                       hz_relationships  rel,
                                       hz_parties owner_party
                                  where ca.party_id IN
                                       (SELECT CAST(:IEXCUOVW_HEADER.ORG_PARTY_ID AS NUMBER) FROM dual
                                         UNION
                                        SELECT ar.related_party_id
                                          FROM ar_paying_relationships_v ar
                                         WHERE ar.party_id = :IEXCUOVW_HEADER.PARTY_ID
                                           AND TRUNC(sysdate) BETWEEN
                                               TRUNC(NVL(ar.effective_start_date,sysdate)) AND
                                               TRUNC(NVL(ar.effective_end_date,sysdate))  )
                                    and acct_site.cust_account_id = ca.cust_account_id
                                    and acct_site.party_site_id = party_site.party_site_id
                                    and loc.location_id = party_site.location_id
                                    and loc.location_id = loc_assign.location_id
                                    and nvl(acct_site.org_id, -99) = nvl(loc_assign.org_id, -99)
                                    and acct_site.cust_acct_site_id = site_uses.cust_acct_site_id 
                                    and loc.country = t.territory_code
                                    and site_uses.site_use_code = lp.lookup_code
                                    and lp.lookup_type = 'SITE_USE_CODE' 
                                    and site_uses.site_use_code = 'BILL_TO'
                                  --  and site_uses.status = 'A' 
                                  --  and acct_site.status = 'A' 
                                    and site_uses.primary_flag = lp2.lookup_code
                                    and lp2.lookup_type = 'YES/NO'
                                    and   site_uses.contact_id = role.cust_account_role_id(+)
                                    and   role.party_id = rel.party_id(+)
                                    and   rel.subject_table_name(+) = 'HZ_PARTIES'
                                    and   rel.object_table_name(+) = 'HZ_PARTIES'
                                    and   rel.directional_flag(+)  = 'F'
                                    and   role.role_type(+)          = 'CONTACT'
                                    and   rel.subject_id        = person.party_id(+)
                                    and owner_party.party_id = ca.party_id
                                  order by location, 
                                           address1
                                  .
                                  ORA-25137: Data value out of range
                                  Record Group IEXCUOVW_LOC_ORG_PAYING_RG
                                  Form: IEXCUOVW
                                  FRM-30085: Unable to adjust form for output.
                                  **************************************************************************************************************************************************************
                                  
                                  WMSLABEL.fmx
                                  Error Statements:
                                  
                                  FRM-30064: Unable to parse statement select upet.type_name EPC_type_name, upec.name category_name, upet.type_id, upec.category_id               
                                  from mgd_idencoding_category upec,
                                       mgd_idencoding_type upet
                                  where upec.category_id = upet.category_id 
                                  and ((NVl(upet.partition_value,0)= 0 and upet.category_id = 1 ) or upet.category_id <> 1)
                                  order by upec.category_id,type_name.
                                  ORA-00942: table or view does not exist
                                  Record Group EPC_RULE_RG
                                  Form: WMSLABEL
                                  FRM-30085: Unable to adjust form for output.
                                  -------------------------------------------------------------------------
                                  
                                  
                                  Generated    0 files successfully.
                                  Generated    0 files with non-fatal warnings.
                                  Generated    1 files with fatal errors.
                                  
                                  adfrmgen is exiting with status 1
                                  
                                  End of adfrmgen session
                                  Date/time is Mon Feb 20 2012 04:44:01
                                  
                                  
                                  *********************************************************************************************************************************************************************
                                  WSHFSTRX.fmx
                                  Error Statements :
                                  
                                  Compiling package body TRIP...
                                  Compilation error on package body TRIP:
                                  PL/SQL ERROR 905 at line 1703, column 18
                                  object APPS.WSH_FTE_TP_INTEGRATION is invalid
                                  PL/SQL ERROR 0 at line 1703, column 18
                                  Item ignored
                                  PL/SQL ERROR 320 at line 1714, column 35
                                  the declaration of the type of this expression is incomplete or malformed
                                  PL/SQL ERROR 0 at line 1712, column 5
                                  Statement ignored
                                  PL/SQL ERROR 320 at line 1720, column 16
                                  the declaration of the type of this expression is incomplete or malformed
                                  PL/SQL ERROR 0 at line 1720, column 6
                                  Statement ignored
                                  PL/SQL ERROR 320 at line 1721, column 16
                                  the declaration of the type of this expression is incomplete or malformed
                                  PL/SQL ERROR 0 at line 1721, column 6
                                  Statement ignored
                                  PL/SQL ERROR 320 at line 1722, column 17
                                  the declaration of the type of this expression is incomplete or malformed
                                  PL/SQL ERROR 0 at line 1722, column 6
                                  Statement ignored
                                  ***************************************************************************************************************************************************************************
                                  IEXRCALL.fmx
                                  
                                  Error Statements:
                                  
                                  FRM-30064: Unable to parse statement select site_uses.location location, 
                                         party_site.party_site_number,
                                         substr(loc.address1,1,25) ||' '
                                              || substr(loc.address2,1,25) ||' '
                                              || substr(loc.address3,1,25) ||' '
                                              || substr(loc.address4,1,25) ||' '
                                              || loc.city|| ',' || ' ' 
                                              || nvl(loc.state, loc.province) ||' '
                                              || t.territory_short_name address,
                                         site_uses.primary_flag, 
                                         loc.address1 address1, 
                                         loc.address2, 
                                         loc.city ||','|| ' '|| nvl(loc.state, loc.province) 
                                             ||' '||loc.postal_code|| ' ' 
                                             || t.territory_short_name address3, 
                                         site_uses.site_use_id customer_site_use_id, 
                                         site_uses.cust_acct_site_id address_id, 
                                         site_uses.bill_to_site_use_id bill_to_site_use_id,
                                         site_uses.primary_salesrep_id primary_salesrep_id,
                                         loc_assign.loc_id location_id, 
                                         loc.state state, 
                                         loc.country country, 
                                         loc.postal_code postal_code, 
                                         site_uses.territory_id territory_id,
                                         lp.meaning business_purpose,
                                         lp2.meaning primary_flag_meaning,
                                         ca.cust_account_id cust_account_id,
                                         ca.account_number account_number,
                                          decode(substrb(person.person_last_name,1,50), null,
                                                      substrb(person.person_first_name,1,40),
                                                      substrb(person.person_last_name,1,50) ||', ' ||
                                                      substrb(person.person_first_name,1,40))
                                                      contact_name,
                                         owner_party.party_name owner_party
                                  from hz_cust_acct_sites acct_site,
                                       hz_party_sites party_site, 
                                       hz_cust_accounts ca,
                                       hz_loc_assignments loc_assign,
                                       hz_locations loc, 
                                       hz_cust_site_uses site_uses, 
                                       fnd_territories_vl t,
                                       ar_lookups lp ,
                                       ar_lookups lp2,
                                       hz_cust_account_roles  role,
                                       hz_parties person,
                                       hz_relationships  rel,
                                       hz_parties owner_party
                                  where ca.party_id IN
                                       (SELECT CAST(:IEXCUOVW_HEADER.ORG_PARTY_ID AS NUMBER) FROM dual
                                         UNION
                                        SELECT ar.related_party_id
                                          FROM ar_paying_relationships_v ar
                                         WHERE ar.party_id = :IEXCUOVW_HEADER.PARTY_ID
                                           AND TRUNC(sysdate) BETWEEN
                                               TRUNC(NVL(ar.effective_start_date,sysdate)) AND
                                               TRUNC(NVL(ar.effective_end_date,sysdate))  )
                                    and acct_site.cust_account_id = ca.cust_account_id
                                    and acct_site.party_site_id = party_site.party_site_id
                                    and loc.location_id = party_site.location_id
                                    and loc.location_id = loc_assign.location_id
                                    and nvl(acct_site.org_id, -99) = nvl(loc_assign.org_id, -99)
                                    and acct_site.cust_acct_site_id = site_uses.cust_acct_site_id 
                                    and loc.country = t.territory_code
                                    and site_uses.site_use_code = lp.lookup_code
                                    and lp.lookup_type = 'SITE_USE_CODE' 
                                    and site_uses.site_use_code = 'BILL_TO'
                                  --  and site_uses.status = 'A' 
                                  --  and acct_site.status = 'A' 
                                    and site_uses.primary_flag = lp2.lookup_code
                                    and lp2.lookup_type = 'YES/NO'
                                    and   site_uses.contact_id = role.cust_account_role_id(+)
                                    and   role.party_id = rel.party_id(+)
                                    and   rel.subject_table_name(+) = 'HZ_PARTIES'
                                    and   rel.object_table_name(+) = 'HZ_PARTIES'
                                    and   rel.directional_flag(+)  = 'F'
                                    and   role.role_type(+)          = 'CONTACT'
                                    and   rel.subject_id        = person.party_id(+)
                                    and owner_party.party_id = ca.party_id
                                  order by location, 
                                           address1
                                  .
                                  ORA-25137: Data value out of range
                                  Record Group IEXCUOVW_LOC_ORG_PAYING_RG
                                  Form: IEXRCALL
                                  FRM-30085: Unable to adjust form for output.
                                  
                                  ***************************************************************************************************************************************
                                  WSHSTREF.fmx
                                  Error statements:
                                  
                                  Compiling package body TRIP...
                                  Compilation error on package body TRIP:
                                  PL/SQL ERROR 905 at line 1703, column 18
                                  object APPS.WSH_FTE_TP_INTEGRATION is invalid
                                  PL/SQL ERROR 0 at line 1703, column 18
                                  Item ignored
                                  PL/SQL ERROR 320 at line 1714, column 35
                                  the declaration of the type of this expression is incomplete or malformed
                                  PL/SQL ERROR 0 at line 1712, column 5
                                  Statement ignored
                                  PL/SQL ERROR 320 at line 1720, column 16
                                  the declaration of the type of this expression is incomplete or malformed
                                  PL/SQL ERROR 0 at line 1720, column 6
                                  Statement ignored
                                  PL/SQL ERROR 320 at line 1721, column 16
                                  the declaration of the type of this expression is incomplete or malformed
                                  PL/SQL ERROR 0 at line 1721, column 6
                                  Statement ignored
                                  PL/SQL ERROR 320 at line 1722, column 17
                                  the declaration of the type of this expression is incomplete or malformed
                                  PL/SQL ERROR 0 at line 1722, column 6
                                  Statement ignored
                                  
                                  ***************************************************************************************************************************************************
                                  
                                  WSHQSSUI.fmx
                                  
                                  Error statements:
                                  
                                  Compiling package body TRIP...
                                  Compilation error on package body TRIP:
                                  PL/SQL ERROR 905 at line 1703, column 18
                                  object APPS.WSH_FTE_TP_INTEGRATION is invalid
                                  PL/SQL ERROR 0 at line 1703, column 18
                                  Item ignored
                                  PL/SQL ERROR 320 at line 1714, column 35
                                  the declaration of the type of this expression is incomplete or malformed
                                  PL/SQL ERROR 0 at line 1712, column 5
                                  Statement ignored
                                  PL/SQL ERROR 320 at line 1720, column 16
                                  the declaration of the type of this expression is incomplete or malformed
                                  PL/SQL ERROR 0 at line 1720, column 6
                                  Statement ignored
                                  PL/SQL ERROR 320 at line 1721, column 16
                                  the declaration of the type of this expression is incomplete or malformed
                                  PL/SQL ERROR 0 at line 1721, column 6
                                  Statement ignored
                                  PL/SQL ERROR 320 at line 1722, column 17
                                  the declaration of the type of this expression is incomplete or malformed
                                  PL/SQL ERROR 0 at line 1722, column 6
                                  Statement ignored
                                  these are the error statements
                                  • 14. Re: Error while applying patch to 12.1.3 from 12.1.1
                                    Hussein Sawwan-Oracle
                                    Compilation error on package body TRIP:

                                    object APPS.WSH_FTE_TP_INTEGRATION is invalid
                                    object APPS.WSH_FTE_TP_INTEGRATION is invalid
                                    object APPS.WSH_FTE_TP_INTEGRATION is invalid
                                    You need to validate this package in order to compile the forms successfully -- See the commands in (Form Compilation Problem for WSHSTREF.fmx,WSHQSSUI.fmx and WSHFSTRX.fmx [ID 1297848.1]) for details.

                                    Please also see if (Shipping Transaction and Quick Ship Forms will not Compile After New Installation of Release 12.1.2 [ID 1103188.1]) is applicable.

                                    Thanks,
                                    Hussein
                                    1 2 Previous Next