1 2 Previous Next 17 Replies Latest reply on Mar 7, 2019 2:10 PM by Beauty_and_dBest

    EBS 12.1.3  Create SO error

    Beauty_and_dBest

      EBS R12.1.3

      11g

      OL6

       

      Hi ALL,

       

      We cloned our PROD instance to TEST  by restoring online RMAN backup.

      But when we query data in TEST instance, we encounter error ORA-04062, ORA-01403.

      But it is good in PROD instance.

       

       

      Please help.....

       

       

      Kind regards,

      jc

        • 1. Re: EBS 12.1.3  Create SO error
          mdtaylor

          Hi jc,

           

          Please regenerate all ont forms and forms libraries in adadmin.

           

          Unable To Navigate to Sales Order Line form - ORA-04062: of has been changed (Doc ID 454170.1)

           

          Regards,

          Michael

          • 2. Re: EBS 12.1.3  Create SO error
            Beauty_and_dBest

            Thanks Michael,

             

             

            I can regenerate it even if there are users right, or the apps is running?

             

             

            Kind regards,

            • 3. Re: EBS 12.1.3  Create SO error
              mdtaylor

              Hi jc,

               

              Yes. Users will need to close the the sales order form and reopen to open the just compiled form before testing.

               

              Regands,

              Michael

              • 4. Re: EBS 12.1.3  Create SO error
                VishnuVinnakota

                Hi,

                 

                   Please recompile all the module forms. There is no harm. You can even compile specific form but ensure you select below options as Yes to ensure the related PL/SQL, Menus are compiled as well.

                 

                Do you want to regenerate Oracle Forms PL/SQL library files [Yes] ?

                 

                Do you want to regenerate Oracle Forms menu files [Yes] ?

                 

                Do you want to regenerate Oracle Forms executable files [Yes] ? ( give default values)

                 

                Thanks,

                Vishnu

                • 5. Re: EBS 12.1.3  Create SO error
                  Beauty_and_dBest

                  Thanks Michael, Vishnu and ALL.

                   

                   

                  I will try to recompile it after office so that there will be no users just to be sure.

                   

                   

                  Kind regards,

                  • 6. Re: EBS 12.1.3  Create SO error
                    Beauty_and_dBest

                    Thanks Vishnu & Michael,

                     

                     

                    What should my response to the last option? Is it still default NO?

                     

                    Do you want to regenerate Oracle Forms PL/SQL library files [Yes] ?

                     

                    Do you want to regenerate Oracle Forms menu files [Yes] ?

                     

                    Do you want to regenerate Oracle Forms executable files [Yes] ?

                     

                    Enter list of products ('all' for all products) [all] :

                     

                    Generate specific forms objects for each selected product [No] ?   <<<<

                     

                     

                    Kind regards,

                    • 7. Re: EBS 12.1.3  Create SO error
                      mdtaylor

                      Hi jc,

                       

                      On Enter list of products ('all' for all products) [all] : ont

                       

                      Then still No for Generate Specific forms objects.

                       

                      Regards,

                      Michael

                      • 9. Re: EBS 12.1.3  Create SO error
                        Beauty_and_dBest

                        Hi Micheal, Vishnu, and ALL,

                         

                        I run adadmin compile forms, but I got error below:

                         

                        There are now 7 jobs remaining (current phase=admin+2):

                            2 running, 5 ready to run and 0 waiting.

                         

                        Assigned: file WSHFSTRX.fmx on worker  3 for product wsh username WSH.

                        Assigned: file WSHFURSS.fmx on worker  4 for product wsh username WSH.

                        Completed: file JAINVMTX.fmx on worker  1 for product ja  username JA.

                        Assigned: file WSHFUTRK.fmx on worker  1 for product wsh username WSH.

                        Completed: file WSHFURSS.fmx on worker  4 for product wsh username WSH.

                        Assigned: file WSHQSSUI.fmx on worker  4 for product wsh username WSH.

                        Completed: file WSHFUTRK.fmx on worker  1 for product wsh username WSH.

                        Assigned: file WSHSTREF.fmx on worker  1 for product wsh username WSH.

                        Completed: file WIPTXSFM.fmx on worker  2 for product wip username WIP.

                        Completed: file WSHSTREF.fmx on worker  1 for product wsh username WSH.

                        Completed: file WSHQSSUI.fmx on worker  4 for product wsh username WSH.

                        Completed: file WSHFSTRX.fmx on worker  3 for product wsh username WSH.

                         

                        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.

                         

                         

                        The following Oracle Forms objects did not generate successfully:

                         

                        au      resource        INVCORE.pll

                        au      resource        INVMTXIT.pll

                        au      resource        INVADPTE.pll

                        au      resource        INVOBGEN.pll

                        au      resource        INVSAFDH.pll

                        au      resource        INVLTENT.pll

                        au      resource        INVRSVFM.pll

                        au      resource        INVMTXFH.pll

                        au      resource        INVSDOSI.pll

                        au      resource        INVTTELT.pll

                        au      resource        INVTOTRL.pll

                        au      resource        INVSLENT.pll

                        au      resource        INVTTMVE.pll

                        au      resource        INVTTMTX.pll

                        au      resource        RCVSHESH.pll

                        au      resource        RCVRCERL.pll

                        au      resource        RCVTXECO.pll

                        au      resource        RCVCOTRX.pll

                        au      resource        RCVTXVTX.pll

                        au      resource        RCVTXERE.pll

                        au      resource        WMSTXECO.pll

                        au      resource        WMSTXERE.pll

                        au      resource        OEXOELIB.pll

                        inv     forms/US        INVIDSNT.fmx

                        inv     forms/US        INVCCEOI.fmx

                        inv     forms/US        INVMSDEF.fmx

                        inv     forms/US        INVKBPSQ.fmx

                        inv     forms/US        INVPCKLT.fmx

                        inv     forms/US        INVITSNU.fmx

                        inv     forms/US        INVSAFDH.fmx

                        inv     forms/US        INVMWBIV.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        INVTVPTX.fmx

                        inv     forms/US        INVTOTRX.fmx

                        inv     forms/US        INVTVTXN.fmx

                        po      forms/US        POXRQTMP.fmx

                        inv     forms/US        INVTTMTX.fmx

                        po      forms/US        RCVSHESH.fmx

                        inv     forms/US        INVIDITM.fmx

                        po      forms/US        RCVRCERC.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

                        ja      forms/US        JAINVMTX.fmx

                        wsh     forms/US        WSHFURSS.fmx

                        wsh     forms/US        WSHFUTRK.fmx

                        wip     forms/US        WIPTXSFM.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] :

                         

                         

                        Please help how to resolve.

                         

                         

                        Thanks a lot,

                        • 10. Re: EBS 12.1.3  Create SO error
                          yoonas

                          Hi,

                           

                          Did you check invalid database objects count before and after clone?

                          Please check the adwork0 log to get exact compilation error details.

                          get failed object name and search in the adadmin logfile to see where this was assigned, then you can check adwork log file.

                           

                          Regards,

                          Yoonas

                          • 11. Re: EBS 12.1.3  Create SO error
                            VishnuVinnakota

                            Hi,

                             

                              Thats a lot of forms. Mostly related to same issue then i.e. ideally invalid objects. Action plan:

                             

                            • Firstly check adadmin/worker log files
                            • Compile Apps Schema
                            • Run utlrp if you see still invalids
                            • Re-run Generate Forms

                             

                            Thanks,

                            Vishnu

                            • 12. Re: EBS 12.1.3  Create SO error
                              Beauty_and_dBest

                              Thanks Vishnu and Yoonas,

                               

                              I already check the adworkers log and they are successful,

                               

                                No compilation errors.

                              Compiling WHEN-BUTTON-PRESSED trigger on REFRESH item in PROGRESS_INDICATOR data block...

                                 No compilation errors.

                              Compiling WHEN-BUTTON-PRESSED trigger on CANCEL_PROPERTIES item in PROGRESS_INDICATOR data block...

                                 No compilation errors.

                               

                              Created form file /u02/appmoli/PROD/apps/apps_st/appl/wsh/12.0.0/forms/US/WSHFPGRP.fmx

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

                               

                              Generated    1 files successfully.

                              Generated    0 files with non-fatal warnings.

                              Generated    0 files with fatal errors.

                               

                              adfrmgen is exiting with status 0

                               

                              End of adfrmgen session

                              Date/time is Thu Mar 07 2019 14:58:58

                              **********************************************************

                              Time when worker completed job: Thu Mar 07 2019 14:58:58

                              Manager says to quit.

                              Time when worker quit: Thu Mar 07 2019 14:59:12

                              Connecting to APPS......Connected successfully.

                              AD Worker is complete.

                              Errors and warnings are listed in the log file

                              /u02/appmoli/PROD/apps/apps_st/appl/admin/PROD/log/adwork003.log

                               

                              and in other log files in the same directory.

                               

                              I also run compile apps schema objects and utlrp , but still the issue persist

                              There are invalid objects but they are not related to inv errors.

                               

                              Please help who to resolve  >  An error occurred while generating Oracle Forms objects.

                               

                               

                               

                              Kind regards,

                              • 13. Re: EBS 12.1.3  Create SO error
                                Beauty_and_dBest

                                Hi ALL,

                                 

                                Is it possible to copy below programs from other source instance like UAT, or PROD  instance?

                                 

                                 

                                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] :

                                 

                                 

                                 

                                Kind regards,

                                • 14. Re: EBS 12.1.3  Create SO error
                                  yoonas

                                  I already check the adworkers log and they are successful,    

                                  I think you did not do a thorough check

                                   

                                  in the log file location can you just run

                                   

                                  grep -i 'ERROR generating form "forms/US/INVIDSNT.fmx"' adwork*

                                   

                                  If you don't mind share adadmin log file

                                  1 2 Previous Next