9 Replies Latest reply: Jul 8, 2013 9:17 PM by user13656868 RSS

    APXINWKB Form compile Error

    979900
      Hi All,

      When we compile the APXINWKB form we got the following error.

      Check the forms source file. It is not compiling.

      ps/apps_st/appl/ap/12.0.0/forms/US/APXINWKB.fmx module_type=form batch=no compile_all=yes
      Forms 10.1 (Form Compiler) Version 10.1.2.3.0 (Production)

      Forms 10.1 (Form Compiler): Release - Production

      Copyright (c) 1982, 2005, Oracle. All rights reserved.

      Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
      With the Partitioning, OLAP, Data Mining and Real Application Testing options
      PL/SQL Version 10.1.0.5.0 (Production)
      Oracle Procedure Builder V10.1.2.3.0 - Production
      Oracle Virtual Graphics System Version 10.1.2.0.0 (Production)
      Oracle Multimedia Version 10.1.2.0.2 (Production)
      Oracle Tools Integration Version 10.1.2.0.2 (Production)
      Oracle Tools Common Area Version 10.1.2.0.2
      Oracle CORE 10.1.0.5.0 Production
      FRM-18108: Failed to load the following objects.

      Source Module:APPAYSHD.fmb
      Source Object: IBY_PAYEE_BANKACCT_2
      Source Module:IBYFDOBJ.fmb
      Source Object: PAYEE_BANKACCOUNT_2_LOV
      Source Module:APXHOLDS.fmb
      Source Object: APXHOLDS
      Source Module:IBYFDOBJ.fmb
      Source Object: IBY_FD_OBJECTS
      Source Module:APPAYSHD.fmb
      Source Object: APPAYSHD
      Source Module:ZXTRLLINEDISTUI.fmb
      Source Object: ZX_TRX_LINE_STAT_OG
      Source Module:ZXTRLLINEDISTUI.fmb
      Source Object: ZX_LINES_OBJECT_GROUP
      Source Module:ZXTRLLINEDISTUI.fmb
      Source Object: ZX_DISTRIBUTION_OG
      Source Module:ZXTRLLINEDISTUI.fmb
      Source Object: ZX_TRX_DIST_STAT_OBJECT_GROUP
      Source Module:APPREPAY.fmb
      Source Object: APPREPAY
      Source Module:APVIWPAY.fmb
      Source Object: APVIWPAY
      Source Module:APPSTAND
      Source Object: STANDARD_PC_AND_VA
      Source Module:APPSTAND
      Source Object: STANDARD_TOOLBAR
      Source Module:APPSTAND
      Source Object: STANDARD_FOLDER
      Source Module:APSTAND
      Source Object: AP_STANDARD_PC
      Source Module:APPSTAND
      Source Object: STANDARD_CALENDAR

      Compiling package body INV_SUM_FOLDER_ITEM_MAIN4...
      Compilation error on package body INV_SUM_FOLDER_ITEM_MAIN4:
      PL/SQL ERROR 49 at line 364, column 3
      bad bind variable 'PARAMETER.P_PBA_PMT_CURRENCY'
      PL/SQL ERROR 49 at line 364, column 3
      bad bind variable 'PARAMETER.P_PBA_PMT_CURRENCY'
      PL/SQL ERROR 49 at line 365, column 3
      bad bind variable 'PARAMETER.P_PBA_PAYEE_PARTY_ID'
      PL/SQL ERROR 49 at line 365, column 3
      bad bind variable 'PARAMETER.P_PBA_PAYEE_PARTY_ID'
      PL/SQL ERROR 49 at line 366, column 3
      bad bind variable 'PARAMETER.P_PBA_PAYEE_PARTY_SITE_ID'
      PL/SQL ERROR 49 at line 366, column 3
      bad bind variable 'PARAMETER.P_PBA_PAYEE_PARTY_SITE_ID'
      PL/SQL ERROR 49 at line 367, column 3
      bad bind variable 'PARAMETER.P_PBA_SUPPLIER_SITE_ID'
      PL/SQL ERROR 49 at line 367, column 3
      bad bind variable 'PARAMETER.P_PBA_SUPPLIER_SITE_ID'
      PL/SQL ERROR 49 at line 368, column 3
      bad bind variable 'PARAMETER.P_PBA_ORG_ID'
      PL/SQL ERROR 49 at line 368, column 3
      bad bind variable 'PARAMETER.P_PBA_ORG_ID'
      PL/SQL ERROR 49 at line 369, column 3
      bad bind variable 'PARAMETER.P_PBA_ORG_TYPE'
      PL/SQL ERROR 49 at line 369, column 3
      bad bind variable 'PARAMETER.P_PBA_ORG_TYPE'
      PL/SQL ERROR 49 at line 373, column 5
      bad bind variable 'PARAMETER.P_PBA_PMT_FUNCTION'
      PL/SQL ERROR 49 at line 373, column 5
      bad bind variable 'PARAMETER.P_PBA_PMT_FUNCTION'
      PL/SQL ERROR 49 at line 375, column 5
      bad bind variable 'PARAMETER.P_PBA_PMT_FUNCTION'
      PL/SQL ERROR 49 at line 414, column 6
      bad bind variable 'parameter.p_pba_org_id'
      PL/SQL ERROR 49 at line 414, column 6
      bad bind variable 'parameter.p_pba_org_id'
      PL/SQL ERROR 49 at line 415, column 11
      bad bind variable 'parameter.p_pba_org_type'
      PL/SQL ERROR 49 at line 415, column 11
      bad bind variable 'parameter.p_pba_org_type'
      PL/SQL ERROR 49 at line 416, column 11
      bad bind variable 'parameter.p_pba_payee_party_id'
      PL/SQL ERROR 49 at line 416, column 11
      bad bind variable 'parameter.p_pba_payee_party_id'
      PL/SQL ERROR 49 at line 417, column 13
      bad bind variable 'parameter.p_pba_payee_party_site_id'
      PL/SQL ERROR 49 at line 417, column 13
      bad bind variable 'parameter.p_pba_payee_party_site_id'
      PL/SQL ERROR 49 at line 418, column 13
      bad bind variable 'parameter.p_pba_supplier_site_id'
      PL/SQL ERROR 49 at line 418, column 13
      bad bind variable 'parameter.p_pba_supplier_site_id'
      PL/SQL ERROR 49 at line 419, column 13
      bad bind variable 'parameter.p_pba_pmt_currency'
      PL/SQL ERROR 49 at line 419, column 13
      bad bind variable 'parameter.p_pba_pmt_currency'
      PL/SQL ERROR 49 at line 422, column 3
      bad bind variable 'parameter.p_pba_pmt_function'
      PL/SQL ERROR 49 at line 422, column 3
      bad bind variable 'parameter.p_pba_pmt_function'
      PL/SQL ERROR 49 at line 424, column 3
      bad bind variable 'parameter.p_pba_pmt_function'
      PL/SQL ERROR 49 at line 464, column 3
      bad bind variable 'PARAMETER.P_PBA_PMT_CURRENCY'
      PL/SQL ERROR 49 at line 465, column 3
      bad bind variable 'PARAMETER.P_PBA_PAYEE_PARTY_ID'
      PL/SQL ERROR 49 at line 466, column 3
      bad bind variable 'PARAMETER.P_PBA_PAYEE_PARTY_SITE_ID'
      PL/SQL ERROR 49 at line 467, column 3
      bad bind variable 'PARAMETER.P_PBA_SUPPLIER_SITE_ID'
      PL/SQL ERROR 49 at line 468, column 3
      bad bind variable 'PARAMETER.P_PBA_ORG_ID'
      PL/SQL ERROR 49 at line 469, column 3
      bad bind variable 'PARAMETER.P_PBA_ORG_TYPE'
      PL/SQL ERROR 49 at line 472, column 5
      bad bind variable 'PARAMETER.P_PBA_PMT_FUNCTION'
      PL/SQL ERROR 49 at line 474, column 5
      bad bind variable 'PARAMETER.P_PBA_PMT_FUNCTION'
      PL/SQL ERROR 49 at line 512, column 6
      bad bind variable 'parameter.p_pba_org_id'
      PL/SQL ERROR 49 at line 513, column 11
      bad bind variable 'parameter.p_pba_org_type'
      PL/SQL ERROR 49 at line 514, column 11
      bad bind variable 'parameter.p_pba_payee_party_id'
      PL/SQL ERROR 49 at line 515, column 13
      bad bind variable 'parameter.p_pba_payee_party_site_id'
      PL/SQL ERROR 49 at line 516, column 13
      bad bind variable 'parameter.p_pba_supplier_site_id'
      PL/SQL ERROR 49 at line 517, column 13
      bad bind variable 'parameter.p_pba_pmt_currency'
      PL/SQL ERROR 49 at line 520, column 3
      bad bind variable 'parameter.p_pba_pmt_function'
      PL/SQL ERROR 49 at line 522, column 3
      bad bind variable 'parameter.p_pba_pmt_function'


      Compilation errors have occurred.


      Form not created

      Regards,
      Raju.
        • 1. Re: APXINWKB Form compile Error
          Hussein Sawwan-Oracle
          Compilation error on package body INV_SUM_FOLDER_ITEM_MAIN4
          Please compile this package first and make sure it's valid before compiling the form.

          Thanks,
          Hussein
          • 2. Re: APXINWKB Form compile Error
            979900
            Hi Hussein,

            we are not able to find out the following package.

            INV_SUM_FOLDER_ITEM_MAIN4

            Please let me know which package we have to compile first.

            Regards,
            Raju.
            • 3. Re: APXINWKB Form compile Error
              Hussein Sawwan-Oracle
              Hi Raju,

              Please check all invalid objects in the database that could be related to this form and make sure you have it all compiled.

              Thanks,
              Hussein
              • 4. Re: APXINWKB Form compile Error
                979900
                Hi Hussein,

                We have compile the all invalid objects related to this form, but still we are unable to compile the form.


                While compile the form we got the following error.

                Compiling WHEN-BUTTON-PRESSED trigger in FOLDER_OPEN property class...
                No compilation errors.

                FRM-30457: Warning: Maximum Length ignored for character-datatype subordinate mirror item INV_SUM_FOLDER.PAYMENT_CURRENCY_CODE_DSP.
                FRM-30457: Warning: Maximum Length ignored for character-datatype subordinate mirror item INV_SUM_FOLDER.INVOICE_CURRENCY_CODE_DSP.
                FRM-30441: Warning: Initial Value ignored for subordinate mirror item LINE_SUM_FOLDER.D_SUM_DESCRIPTION.
                FRM-30457: Warning: Maximum Length ignored for character-datatype subordinate mirror item D_SUM_FOLDER.LINE_TYPE_DSP.
                FRM-30457: Warning: Maximum Length ignored for character-datatype subordinate mirror item D_SUM_FOLDER.POSTED_OVERFLOW.

                Created form file /iflora/iffdev/app/apps/apps_st/appl/ap/12.0.0/forms/US/APXINWKB.fmx

                Generated 0 files successfully.
                Generated 1 files with non-fatal warnings.
                Generated 0 files with fatal errors.

                adfrmgen is exiting with status 0

                Regards,
                Raju.
                • 5. Re: APXINWKB Form compile Error
                  Hussein Sawwan-Oracle
                  Created form file /iflora/iffdev/app/apps/apps_st/appl/ap/12.0.0/forms/US/APXINWKB.fmx
                  This indicates that the form was generated successfully.

                  Have you tried to access the form and see if there are any issues?

                  Thanks,
                  Hussein
                  • 6. Re: APXINWKB Form compile Error
                    979900
                    Hi Hussein,

                    I tried, but the result is same.

                    Regards,
                    Raju.
                    • 7. Re: APXINWKB Form compile Error
                      yoonas
                      Hi,

                      Did you try to generate using adadmin?

                      Regards
                      Yoonas
                      • 8. Re: APXINWKB Form compile Error
                        Hussein Sawwan-Oracle
                        976897 wrote:
                        Hi Hussein,

                        I tried, but the result is same.

                        Regards,
                        Raju.
                        What is the result?

                        Please see (RM-30457 Maximum length ignored for character-datatype suborindate mirror item "ITEM -NAME" [ID 222546.1]).

                        Thanks,
                        Hussein
                        • 9. Re: APXINWKB Form compile Error
                          user13656868

                          Hi Hussein,

                           

                          Even we have same issue while compiling the form while applying patch 11930938

                           

                          FRM-30457: Warning: Maximum Length ignored for character-datatype subordinate mirror item INV_SUM_FOLDER.PAYMENT_CURRENCY_CODE_DSP.

                          FRM-30457: Warning: Maximum Length ignored for character-datatype subordinate mirror item INV_SUM_FOLDER.INVOICE_CURRENCY_CODE_DSP.

                          FRM-30441: Warning: Initial Value ignored for subordinate mirror item LINE_SUM_FOLDER.D_SUM_DESCRIPTION.

                          FRM-30457: Warning: Maximum Length ignored for character-datatype subordinate mirror item D_SUM_FOLDER.LINE_TYPE_DSP.

                          FRM-30457: Warning: Maximum Length ignored for character-datatype subordinate mirror item D_SUM_FOLDER.POSTED_OVERFLOW.

                           

                          Created form file /u002/shared/ARCMRG/apps/apps_st/appl/ap/12.0.0/forms/US/APXINWKB.fmx

                           

                          Thanks

                          Sobu