13 Replies Latest reply on Mar 18, 2019 5:03 AM by Beauty_and_dBest

    EBS R12.1.3, Adadmin, Generate forms error

    Beauty_and_dBest

      EBS R12.1.3

      11g

      OL6

       

      Hi ALL,

       

      I am generating forms using ADADMIN, but I got error below:

       

      AD_DEFERRED_JOBS table dropped.

       

      The following Oracle Forms objects did not generate successfully:

       

      au      resource        INVADPTE.pll

      au      resource        INVCORE.pll

      au      resource        INVLTENT.pll

      au      resource        INVOBGEN.pll

      au      resource        INVMTXIT.pll

      au      resource        INVSAFDH.pll

      au      resource        INVRSVFM.pll

      au      resource        INVMTXFH.pll

      au      resource        INVSDOSI.pll

      au      resource        INVSLENT.pll

      au      resource        INVTTELT.pll

      au      resource        INVTOTRL.pll

      au      resource        INVTTMVE.pll

      au      resource        INVTTMTX.pll

      au      resource        RCVCOTRX.pll

      au      resource        RCVRCERL.pll

      au      resource        RCVSHESH.pll

      au      resource        RCVTXECO.pll

      au      resource        RCVTXERE.pll

      au      resource        RCVTXVTX.pll

      inv     forms/US        INVCCEOI.fmx

      inv     forms/US        INVIDSNT.fmx

      inv     forms/US        INVITSNU.fmx

      inv     forms/US        INVKBPSQ.fmx

      inv     forms/US        INVMSDEF.fmx

      inv     forms/US        INVIDITM.fmx

      inv     forms/US        INVPCKLT.fmx

      inv     forms/US        INVMWBIV.fmx

      inv     forms/US        INVSAFDH.fmx

      inv     forms/US        INVRSVF1.fmx

      inv     forms/US        INVSDOIO.fmx

      inv     forms/US        INVSDSUB.fmx

      inv     forms/US        INVTDILT.fmx

      inv     forms/US        INVTTESR.fmx

      inv     forms/US        INVTOTRX.fmx

      inv     forms/US        INVTVPTX.fmx

      inv     forms/US        INVTTMTX.fmx

      inv     forms/US        INVTVTXN.fmx

      po      forms/US        RCVRCERC.fmx

      po      forms/US        RCVSHESH.fmx

      po      forms/US        RCVTXECO.fmx

      po      forms/US        RCVTXERE.fmx

      po      forms/US        RCVTXVTX.fmx

      po      forms/US        RCVTXERT.fmx

      wip     forms/US        WIPTXCFM.fmx

       

      An error occurred while generating Oracle Forms objects.

      Continue as if it were successful [No] :

       

      [appmoli@tstsvr log]$ grep -i 'ERROR generating' adwork*

      adwork001.log:ERROR generating library "resource/INVOBGEN.plx" from input file

      adwork001.log:ERROR generating library "resource/INVTTMTX.plx" from input file

      adwork001.log:ERROR generating library "resource/RCVTXVTX.plx" from input file

      adwork001.log:ERROR generating form "forms/US/INVCCEOI.fmx" from input file

      adwork001.log:ERROR generating form "forms/US/INVKBPSQ.fmx" from input file

      adwork001.log:ERROR generating form "forms/US/INVMSDEF.fmx" from input file

      adwork001.log:ERROR generating form "forms/US/INVPCKLT.fmx" from input file

      adwork001.log:ERROR generating form "forms/US/INVRSVF1.fmx" from input file

      adwork001.log:ERROR generating form "forms/US/INVSDOIO.fmx" from input file

      adwork001.log:ERROR generating form "forms/US/INVTVPTX.fmx" from input file

      adwork001.log:ERROR generating form "forms/US/RCVRCERC.fmx" from input file

      adwork002.log:ERROR generating library "resource/INVLTENT.plx" from input file

      adwork002.log:ERROR generating library "resource/INVRSVFM.plx" from input file

      adwork002.log:ERROR generating library "resource/INVTTELT.plx" from input file

      adwork002.log:ERROR generating library "resource/INVTTMVE.plx" from input file

      adwork002.log:ERROR generating library "resource/RCVTXERE.plx" from input file

      adwork002.log:ERROR generating form "forms/US/INVIDSNT.fmx" from input file

      adwork002.log:ERROR generating form "forms/US/INVMWBIV.fmx" from input file

      adwork002.log:ERROR generating form "forms/US/RCVSHESH.fmx" from input file

      adwork002.log:ERROR generating form "forms/US/RCVTXECO.fmx" from input file

      adwork002.log:ERROR generating form "forms/US/RCVTXERT.fmx" from input file

      adwork002.log:ERROR generating form "forms/US/WIPTXCFM.fmx" from input file

      adwork003.log:ERROR generating library "resource/INVADPTE.plx" from input file

      adwork003.log:ERROR generating library "resource/INVCORE.plx" from input file

      adwork003.log:ERROR generating library "resource/INVMTXFH.plx" from input file

      adwork003.log:ERROR generating library "resource/INVSLENT.plx" from input file

      adwork003.log:ERROR generating library "resource/RCVCOTRX.plx" from input file

      adwork003.log:ERROR generating library "resource/RCVRCERL.plx" from input file

      adwork003.log:ERROR generating library "resource/RCVSHESH.plx" from input file

      adwork003.log:ERROR generating form "forms/US/INVITSNU.fmx" from input file

      adwork003.log:ERROR generating form "forms/US/INVSAFDH.fmx" from input file

      adwork003.log:ERROR generating form "forms/US/INVTDILT.fmx" from input file

      adwork003.log:ERROR generating form "forms/US/INVTTESR.fmx" from input file

      adwork003.log:ERROR generating form "forms/US/INVTTMTX.fmx" from input file

      adwork003.log:ERROR generating form "forms/US/INVTVTXN.fmx" from input file

      adwork003.log:ERROR generating form "forms/US/RCVTXERE.fmx" from input file

      adwork003.log:ERROR generating form "forms/US/RCVTXVTX.fmx" from input file

      adwork004.log:ERROR generating library "resource/INVMTXIT.plx" from input file

      adwork004.log:ERROR generating library "resource/INVSAFDH.plx" from input file

      adwork004.log:ERROR generating library "resource/INVSDOSI.plx" from input file

      adwork004.log:ERROR generating library "resource/INVTOTRL.plx" from input file

      adwork004.log:ERROR generating library "resource/RCVTXECO.plx" from input file

      adwork004.log:ERROR generating form "forms/US/INVIDITM.fmx" from input file

      adwork004.log:ERROR generating form "forms/US/INVSDSUB.fmx" from input file

      adwork004.log:ERROR generating form "forms/US/INVTOTRX.fmx" from input file

      [appmoli@tstsvr log]$

       

       

      One of the forms library errors is shown in ADWORKER log below.

       

        Temporarily resetting FORMS_PATH to:

        "/u02/appmoli/PROD/apps/apps_st/appl/au/12.0.0/resource:/u02/appmoli/PROD/apps/apps_st/appl/au/12.0.0/forms/US:/u02/appmoli/PROD/apps/apps_st/appl/au/12.0.0/resource/US"

       

      Generating library "resource/INVOBGEN.plx" with command:

       

      /u02/appmoli/PROD/apps/tech_st/10.1.2/bin/frmcmp_batch module=/u02/appmoli/PROD/apps/apps_st/appl/au/12.0.0/resource/INVOBGEN.pll userid=APPS/***** output_file=/u02/appmoli/PROD/apps/apps_st/appl/au/12.0.0/resource/INVOBGEN.plx module_type=library batch=yes compile_all=special

       

       

      ERROR generating library "resource/INVOBGEN.plx" from input file

      /u02/appmoli/PROD/apps/apps_st/appl/au/12.0.0/resource/INVOBGEN.pll

       

      Results of library generation:

      (from file /u02/appmoli/PROD/apps/apps_st/appl/au/12.0.0/resource/INVOBGEN.err

      AD Worker has deleted the original .err file)

      -------------------------------------------------------------------------

      Compilation errors on CHILD_TREE:

      PL/SQL ERROR 302 at line 170, column 51

      component 'GETGENEALOGYLEVEL' must be declared

      PL/SQL ERROR 0 at line 170, column 19

      Statement ignored

      PL/SQL ERROR 306 at line 319, column 25

      wrong number or types of arguments in call to 'INV_POPULATE_CHILD_TREE'

      PL/SQL ERROR 0 at line 319, column 25

      Statement ignored

      PL/SQL ERROR 306 at line 413, column 8

      wrong number or types of arguments in call to 'INV_POPULATE_CHILD_TREE'

      PL/SQL ERROR 0 at line 413, column 8

      Statement ignored

       

      Failed to generate library.

       

      FRM-30312: Failed to compile the library.

       

      -------------------------------------------------------------------------

       

       

       

      Please help how to resolve above issue.... 

       

       

       

      Kind regards,

      jc

        • 1. Re: EBS R12.1.3, Adadmin, Generate forms error
          Kanda-Oracle

          Hi JC

           

          • Can you check out any recent changes (patching/upgrade/nls) ?
          • Please ensure there is no invalid objects at DB level.
          • Also check out the version of INVOBGEN.pll

           

          Thanks


          N Kandasamy

          • 2. Re: EBS R12.1.3, Adadmin, Generate forms error
            Beauty_and_dBest

            Hi Kanda,

             

            I already run compile invalid objects using adadmin schema, and utlrp on the database.

            This is a  clone in PROD and the PROD has no issue

             

             

            Kind regards,

            • 3. Re: EBS R12.1.3, Adadmin, Generate forms error
              VishnuVinnakota

              Hi,

               

                 Please provide the output of below:

               

              • select owner,count(*) from dba_objects where status='INVALID' group by owner order by 2 desc;
              • Post error messages from all worker logs. No need of full logs. Just the error part like above
              • Once try running "Recreate grants and sysnonyms for apps" in ADADMIN. Then compile only AU first followed by others.

               

              Thanks,

              Vishnu

              • 4. Re: EBS R12.1.3, Adadmin, Generate forms error
                Beauty_and_dBest

                Thanks Vishnu and Kanda,

                 

                I will try that.....brb 

                • 5. Re: EBS R12.1.3, Adadmin, Generate forms error
                  Beauty_and_dBest

                  Hi Vishnu,

                   

                  SQL> select owner,count(*) from dba_objects where status='INVALID' group by owner order by 2 desc;

                   

                  OWNER                            COUNT(*)

                  ------------------------------ ----------

                  APPS                                   18

                   

                  SQL>

                   

                   

                  The above INVALID is the same as the source which has no issue.

                   

                   

                  I have run :

                   

                  There are now 9 jobs remaining (current phase=admin):

                      4 running, 5 ready to run and 0 waiting.

                   

                  Completed: file adappsgs.pls on worker  4 for product ad  username APPLSYS.

                  Assigned: file adappsgs.pls on worker  4 for product ad  username APPLSYS.

                  Completed: file adappsgs.pls on worker  3 for product ad  username APPLSYS.

                  Assigned: file adappsgs.pls on worker  3 for product ad  username APPLSYS.

                  Completed: file adappsgs.pls on worker  3 for product ad  username APPLSYS.

                  Assigned: file adappsgs.pls on worker  3 for product ad  username APPLSYS.

                  Completed: file adappsgs.pls on worker  4 for product ad  username APPLSYS.

                  Assigned: file adappsgs.pls on worker  4 for product ad  username APPLSYS.

                  Completed: file adappsgs.pls on worker  3 for product ad  username APPLSYS.

                  Assigned: file adappsgs.pls on worker  3 for product ad  username APPLSYS.

                  Completed: file adappsgs.pls on worker  3 for product ad  username APPLSYS.

                  Completed: file adappsgs.pls on worker  4 for product ad  username APPLSYS.

                  Completed: file adappsgs.pls on worker  1 for product ad  username APPLSYS.

                  Completed: file adappsgs.pls on worker  2 for product ad  username APPLSYS.

                   

                  Done maintaining grants and synonyms in APPS schema(s).

                   

                  Telling workers to quit...

                   

                  All workers have quit.

                   

                  Dropping FND_INSTALL_PROCESSES table...

                   

                  FND_INSTALL_PROCESSES table dropped.

                   

                  Dropping AD_DEFERRED_JOBS table...

                   

                  AD_DEFERRED_JOBS table dropped.

                   

                  Review the messages above, then press [Return] to continue.

                  • 6. Re: EBS R12.1.3, Adadmin, Generate forms error
                    Beauty_and_dBest

                    But  the error for compiling forms still persist.

                     

                    The following Oracle Forms objects did not generate successfully:

                     

                    au      resource        INVADPTE.pll

                    au      resource        INVCORE.pll

                    au      resource        INVMTXIT.pll

                    au      resource        INVOBGEN.pll

                    au      resource        INVLTENT.pll

                    au      resource        INVSAFDH.pll

                    au      resource        INVRSVFM.pll

                    au      resource        INVMTXFH.pll

                    au      resource        INVSDOSI.pll

                    au      resource        INVSLENT.pll

                    au      resource        INVTTELT.pll

                    au      resource        INVTOTRL.pll

                    au      resource        INVTTMVE.pll

                    au      resource        INVTTMTX.pll

                    au      resource        RCVCOTRX.pll

                    au      resource        RCVRCERL.pll

                    au      resource        RCVSHESH.pll

                    au      resource        RCVTXECO.pll

                    au      resource        RCVTXVTX.pll

                    au      resource        RCVTXERE.pll

                    au      resource        OEXOELIB.pll

                    au      resource        WMSTXECO.pll

                    au      resource        WMSTXERE.pll

                    inv     forms/US        INVCCEOI.fmx

                    inv     forms/US        INVIDSNT.fmx

                    inv     forms/US        INVITSNU.fmx

                    inv     forms/US        INVKBPSQ.fmx

                    inv     forms/US        INVIDITM.fmx

                    inv     forms/US        INVMSDEF.fmx

                    inv     forms/US        INVMWBIV.fmx

                    inv     forms/US        INVPCKLT.fmx

                    inv     forms/US        INVRSVF1.fmx

                    inv     forms/US        INVSAFDH.fmx

                    inv     forms/US        INVSDOIO.fmx

                    inv     forms/US        INVSDSUB.fmx

                    inv     forms/US        INVTDILT.fmx

                    inv     forms/US        INVTTESR.fmx

                    inv     forms/US        INVTOTRX.fmx

                    inv     forms/US        INVTVPTX.fmx

                    inv     forms/US        INVTTMTX.fmx

                    inv     forms/US        INVTVTXN.fmx

                    po      forms/US        POXRQTMP.fmx

                    po      forms/US        RCVRCERC.fmx

                    po      forms/US        RCVSHESH.fmx

                    po      forms/US        RCVTXECO.fmx

                    po      forms/US        RCVTXERE.fmx

                    po      forms/US        RCVTXVTX.fmx

                    po      forms/US        RCVTXERT.fmx

                    wip     forms/US        WIPTXMAT.fmx

                    pjm     forms/US        PJMFDOGP.fmx

                    wip     forms/US        WIPTXCFM.fmx

                    wip     forms/US        WIPTXCMP.fmx

                    wip     forms/US        WIPTXSFM.fmx

                    ja      forms/US        JAINVMTX.fmx

                    wsh     forms/US        WSHFURSS.fmx

                    wsh     forms/US        WSHFUTRK.fmx

                    wsh     forms/US        WSHSTREF.fmx

                    wsh     forms/US        WSHQSSUI.fmx

                    wsh     forms/US        WSHFSTRX.fmx

                     

                     

                    An error occurred while generating Oracle Forms objects.

                    Continue as if it were successful [No]

                    • 7. Re: EBS R12.1.3, Adadmin, Generate forms error
                      Kanda-Oracle

                      Please compile few of them (.pll & fmb ).. Just check out whether any common errors that it fails with.

                       

                      Thanks!

                      • 8. Re: EBS R12.1.3, Adadmin, Generate forms error
                        Beauty_and_dBest

                        Thanks ...I will try that....brb

                        • 9. Re: EBS R12.1.3, Adadmin, Generate forms error
                          Mr. C

                          You should compare the name of the invalid objects between 2 databases, not the total amounts of invalids.

                           

                          What I would try is to run the Recreate Grants and Synonyms function from adadmin

                          • 10. Re: EBS R12.1.3, Adadmin, Generate forms error
                            Mr. C

                            Or ... all FMB's

                             

                            But, if PLL's are failing, and the database content is OK, there's an issue on file level ?

                             

                            Missing files, corrupted files, on the target ?

                             

                             

                            Was an additional patch applied on the target, or any specific function that is not included in the normal cloning action ?

                            • 11. Re: EBS R12.1.3, Adadmin, Generate forms error
                              Beauty_and_dBest

                              Hi ALL,

                               

                              I already run:

                               

                              compile forms, recreate grants, recomile invalid objects.

                               

                              PROD and TEST have the same invalid objects.

                               

                              I suspec the developer have altered some packages in TEST? But how can I prove it?

                               

                               

                              Kind regards,

                              • 12. Re: EBS R12.1.3, Adadmin, Generate forms error
                                Kanda-Oracle

                                Can you check  LAST_DDL_TIME in dba_objects table.

                                 

                                Thanks

                                 

                                N Kandasamy

                                • 13. Re: EBS R12.1.3, Adadmin, Generate forms error
                                  Beauty_and_dBest

                                  Thanks ALL,

                                   

                                  Maybe at OS level error, and files are corrupted?

                                  But  I do not know how did it happened

                                   

                                  Workaround is to restore the instance from backup.

                                   

                                   

                                  Kind regards,