8 Replies Latest reply on Oct 14, 2015 6:19 AM by Beauty_and_dBest

    How to compile single form?

    Beauty_and_dBest

      Hi ALL,

       

      EBS R12.2.4

      RHEL6.5

       

      How do you  compile a single form? or  all forms in a single module like AR?

       

      Actually, I have compiled all forms for all modules in our EBS instance, and it took very long time. After that the issue of one functional user was resolved.

       

      Now, I can not understand why another functional encountering similar error again:


      While she is opening  a form, the error message displayed FRM-40735: WHEN-NEW-FORM-INSTANCE trigger raised unhandled exeption ORA-20002

      Capture1.PNG

      Capture2.PNG

      Capture3.PNG

      Capture4.PNG

      ---------------------------------------
      Current Form
      ----------------------------------------
      Form Application : Receivables
      Form Name : ARXRAATR
      Form Path : /u01/appuat/UAT/fs2/EBSapps/appl/ar/12.0.0/forms/US/ARXRAATR.fmx
      Form Version : 12.0.30.12020000.2
      Form Last Modified : $Date: 2013/03/10 06:49  $

       

      How do I compile this form ARXRAATR.fmx?

      Please help...
      Thanks a lot,
      jc

       

        • 1. Re: How to compile single form?
          Bashar.

          Hi,

           

          I am not sure that this will fix your problem but anyway here is a list of screenshots of how to compile the form through adadmin:

           

          adadmin 1.png

           

          adadmin 2.png

           

          adadmin 3.png

           

          adadmin 4.png

           

          adadmin 5.png

           

          Regards,

          Bashar

          1 person found this helpful
          • 2. Re: How to compile single form?
            Beauty_and_dBest

            Thanks Bashar and ALL,

             

            I will try the option again. But actually I did compile choosing options ALL modules. I did run fol a long time compiling like 5000+ forms.

            So I believe AR has been included right?

             

            How about the invalid objects in the database? Can they be cause the issue? I have the following invalid objects which when compiled still gets error.

            APPS,XLA_00140_AAD_S_000001_PKG,PACKAGE BODY

            APPS,XLA_00707_AAD_C_000044_PKG,PACKAGE BODY

            APPS,MRP_COMPANY_USERS_SN,MATERIALIZED VIEW

            APPS,OZF_EARNING_SUMMARY_MV,MATERIALIZED VIEW

            APPS,OE_ITEMS_MV,MATERIALIZED VIEW

            APPS,HRI_TIME_CAL_DAY_MV,MATERIALIZED VIEW

            APPS,OZF_CUST_FUND_SUMMARY_MV,MATERIALIZED VIEW

            APPS,GL_ACCESS_SET_LEDGERS,MATERIALIZED VIEW

             

            Do the above relate to AR forms error?

             

            Thanks.

            • 3. Re: How to compile single form?
              Bashar.

              In adadmin, you should choose the application to limit the compilation scope and decrease the time required to finish.

               

              The invalid objects can be an issue but based on the object names I do not think that they are the cause.

               

              Regards,

              Bashar

              1 person found this helpful
              • 4. Re: How to compile single form?
                Pravin Takpire

                you can use FRMCMP_BATCH to compile one form

                you can check syntax in metalinl

                regards

                Pravin

                1 person found this helpful
                • 5. Re: How to compile single form?
                  Beauty_and_dBest

                  Hi ALL,

                   

                  I the error still persist even if the form is compiled

                  FRM-40735: WHEN-NEW-FORM-INSTANCE trigger raised unhandled exception ORA-20002

                   

                  Maybe this is a setup error or the setup is not complete?

                  How do you trace the form and  the error to display why the trigger fails?

                   

                  This is a new created responsibility for   Receivables, Titanic Corp.

                  How can I test other existing VISION companies if this is good in others.

                  Can you help where can I run navigation Control> Accounting > Revenue Accounting  from other existing co.?

                  So I can tell the functional user it is a setup error.

                   

                  Thanks a lot.

                  jc

                  • 6. Re: How to compile single form?
                    Bashar.

                    Check this document:

                     

                    Revenue Accounting And Sales Credits: Unexpected Error While Initializing FRM-40735: When-New-Form-Instance trigger (Doc ID 1386372.1)

                     

                    Regards,

                    Bashar

                    1 person found this helpful
                    • 7. Re: How to compile single form?
                      Beauty_and_dBest

                      Thanks

                       

                      I can not know if there someone answering my post because INBOX(0)  does not update now

                      Before it works fine.