11 Replies Latest reply: Aug 28, 2013 12:05 AM by pritesh ranjan RSS

    Hi expert,

    pritesh ranjan

      plz help me i apply the patch 5739724, patch 10111967 for our product inventory. i applied all the patch successfully but after applying the patch 10111967  it gives the following error regarding an inventory form.


      The following oracle forms objects did not generate successfully:

      Inv  forms/US INVIDICG.fmx


      currently my application is running well and no issue occured. but i want to know is there is any issue occured in future. due to this form  INVIDICG.fmx. and plz suggest me how can i resolve this issue.



        • 1. Re: Hi expert,
          Asif Muhammad

          Hi,

           

          Please compile only form INVIDICG.fmx using adadmin, and provide a unique name while running it and see whether you can capture any information to troubleshoot it. Or otherwise upload the logfile and provide the link here so that we may assist you.

           

          Please provide the count of INVALID OBJECTS.

           

          Please also see the Forum Search:

          https://forums.oracle.com/message/search.jspa?peopleEnabled=true&userID=&containerType=&container=&q=objects+did+not+generate+successfully

           

          Thanks &

          Best Regards,

          • 2. Re: Hi expert,
            pritesh ranjan

            to resolve this issue i chek the metalink doc id 1444322.1. in which provide the solution.


             

            Verify the version of form. Focus on US forms failures first!

            adident Header $AU_TOP/forms/US/<form_name>.fmb
            adident Header $PROD_TOP/forms/US/<form_name>.fmx


            Note! You will find all the .fmb files in your $AU_TOP
            You will find .fmx files in your product top, for example $CSC_TOP or $AP_TOP or $AR_TOP

             

            Depending on the results, there are different investigation paths:

             

            A. Same version for .fmb and .fmx, then it was compiled successfully
            Issue is solved, so there is no need for other investigation steps.

             

            B. Different version for US fmx and US fmb
            We need to start the investigation in next steps.

             

            below i define the version:

            version of  INVIDICG.fmb

             

            [appdemo@demo US]$ pwd

            /u03/ORIDEMO/LIVE_APPL/liveappl/au/11.5.0/forms/US

            [appdemo@demo US]$ adident Header INVIDICG.fmb

            INVIDICG.fmb:

            $Header APPSTAND.fmb 115.33 2002/04/04 11:01  psloan ship                                                                                                                                                                                                                                                                                 $

            $Header APPSTAND.fmb 115.33 2002/04/04 11:01  psloan ship                                                                                                                                                                                                                                                                                 $

            $Header INVIDICG.fmb 115.22 2004/06/02 03:29  skadamal ship               $

            $Header INVIDICG.fmb 115.22 2004/06/02 03:29  skadamal ship               $

            $Header INVIDICG.fmb 115.22 2004/06/02 03:29  skadamal ship               $

            $Header APPSTAND.fmb 115.33 2002/04/04 11:01  psloan ship                                                                                                                                                                                                                                                                                 $

            $Header APPSTAND.fmb 115.33 2002/04/04 11:01  psloan ship                                                                                                                                                                                                                                                                                 $

            $Header APPSTAND.fmb 115.33 2002/04/04 11:01  psloan ship                                                                                                                                                                                                                                                                                 $

            [appdemo@demo US]$

             

             

            version of  INVIDICG.fmx


             

            [appdemo@demo US]$ adident Header INVIDICG.fmx

            INVIDICG.fmx:

            $Header APPSTAND.fmb 115.33 2002/04/04 11:01  psloan ship                                                                                                                                                                                                                                                                                 $

            $Header INVIDICG.fmb 115.22 2004/06/02 03:29  skadamal ship               $

            [appdemo@demo US]$ pwd

            /u03/ORIDEMO/LIVE_APPL/liveappl/inv/11.5.0/forms/US

            [appdemo@demo US]$

             

             

            according to the above details my .fmb and .fmx file version is same.

             

            plz help me how can i resolve this issue.

             

            thanks & regards

            pritesh ranjan

            • 3. Re: Hi expert,
              Asif Muhammad

              Hi Rajan,

               

               

              Did you refer my previous post, please generate/compile the respective form only and this will state why the form generation is failing. From there onwards we can troubleshoot your issue.

               

              Please compile the respective form only and find the cause for it, please upload and provide the link here so that we may have a review.

               

               

              If you need any assistance, let us know.

               

               

              Thanks &

              Best Regards

              • 4. Re: Hi expert,
                pritesh ranjan

                i apply this patch on my test instance.

                after apply the patch i have total count of invalid object 42  and before apply the patch i have total invalid object is 40. there are two object related to inventory that are invalid

                1. INV_UI_ITEM_SUB_LOC_LOVS  2. INVICGDS

                in which  INVICGDS is already invalid before applying the patch.

                 

                between all invalid object i chek only two object that is invalid after applying the patch

                 

                INV_UI_ITEM_SUB_LOC_LOVS and TDS_SECTION1 .


                to resolve the invalid object INV_UI_ITEM_SUB_LOC_LOVS according to metalink i apply the patch 4345239. in this patch there is a post step to run the concurrent request that is for wharehouse management. i have not use the warehouse management. so i unable to run the concurrent request.

                 

                the same issue with me that is define in the below link but i have not use the warehouse management nad quality product.

                 

                Bhaskara Naik Apps DBA: Package body INV_UI_ITEM_SUB_LOC_LOVS altered with compilation errors

                 

                list of invalid object

                 

                OBJECT_NAMEOBJECT_TYPEOWNER
                F_OPENINGFUNCTIONAPPS
                DEBUG_CARTXSYNONYMPUBLIC
                CZ_EXV_ITEM_TYPESVIEWAPPS
                BOM_IMPL_INQUIRY_VVIEWAPPS
                MTL_ITEM_CATALOG_GROUPS_VVIEWAPPS
                BOMPLDCBPACKAGE BODYAPPS
                CTO_CONFIG_BOM_PKPACKAGE BODYAPPS
                INVICGDSPACKAGE BODYAPPS
                CZ_IMP_SINGLEPACKAGE BODYAPPS
                INV_UI_ITEM_SUB_LOC_LOVSPACKAGE BODYAPPS
                PY_ZA_USERMESG_PKGPACKAGE BODYAPPS
                PY_ZA_PRORATE_PKGPACKAGE BODYAPPS
                WWSSO_PSTORE_EXSYNONYMJUNK_PS
                WWCTX_API_VPDSYNONYMJUNK_PS
                WWSSO_APISYNONYMJUNK_PS
                WWSSO_API_PRIVATESYNONYMJUNK_PS
                OKL_AM_ITEM_CATEGORIES_UVVIEWAPPS
                OKL_AM_RMK_ASSGN_UVVIEWAPPS
                OKL_AM_RESIDUAL_VALUE_WD_UVVIEWAPPS
                ASG_DOWNLOADPACKAGE BODYAPPS
                BOM_EXPLOSIONS_VVIEWAPPS
                EGO_CATALOG_GROUPS_VVIEWAPPS
                EGO_ITEM_OCVVIEWAPPS
                BOM_UTILPACKAGE BODYAPPS
                EGO_ITEM_USER_ATTRS_CP_PUBPACKAGE BODYAPPS
                EGO_VALIDATE_CATALOG_GROUPPACKAGE BODYAPPS
                EGO_ITEM_COMPARE_PKGPACKAGE BODYAPPS
                EGO_ITEM_PVTPACKAGE BODYAPPS
                BOM_IMPLOSIONS_VVIEWAPPS
                BOM_BILL_OF_MATERIALS_ERVVIEWAPPS
                CLN_ITEMMST_CTLG_CATS_VVIEWAPPS
                ENI_ITEM_ITM_CAT_VVIEWAPPS
                MTL_SYSTEM_ITEMS_ER1_VVIEWAPPS
                MTL_SYSTEM_ITEMS_ER2_VVIEWAPPS
                MTL_SYSTEM_ITEMS_ER3_VVIEWAPPS
                CTO_UPDATE_BOM_RTG_PKPACKAGE BODYAPPS
                TDS_SECTION_FUFUNCTIONAPPS
                OE_CREDIT_CARD_MIGRATE_UTILPACKAGE BODYAPPS
                MMPPROCEDUREAPPS
                MMP1PROCEDUREAPPS
                XX_CASH_BOOK_OP_BALFUNCTIONAPPS
                TDS_SECTION1PROCEDUREAPPS

                 

                thanks & regards

                pritesh ranjan

                • 5. Re: Hi expert,
                  pritesh ranjan

                  many many thanks

                  • 6. Re: Hi expert,
                    Helios-GunesEROL

                    Hi;

                     

                    1. What is your EBS version and OS

                    2. Did you try to compile this form manualy? What is error message?


                    Regard

                    Helios

                    • 7. Re: Hi expert,
                      AK_AppsDBA

                      ebs 12.1.1

                      os RHEL 5.2

                      • 8. Re: Hi expert,
                        Asif Muhammad

                        Hi,

                         

                        Please manually compile and provide the requested log file so that we may better assist you.

                         

                        You have only provided us with a generic error.

                         

                        Thanks &

                        Best Regards

                        • 9. Re: Hi expert,
                          pritesh ranjan

                          hi sorry for late replay,

                          my ebs is 11i (11.5.10.2) and os rhel-4

                           

                          i regenerate the the application form  INVIDICG.fmx  using the adadmin. the issue is remain same.

                           

                          i found the error in adworker001.log file.

                           

                          FRM-30064: Unable to parse statement select catalog_concat_segs concatenated_segments,

                          description, item_catalog_group_id

                          from mtl_item_catalog_groups_v

                          order by 1.

                          ORA-04063: view "APPS.MTL_ITEM_CATALOG_GROUPS_V" has errors

                          Record Group ITEM_CATALOG_GROUP_RG

                          Form: INVIDICG

                          FRM-30085: Unable to adjust form for output.

                           

                          except these error all things is right in adworker001.log file.

                           

                          now plz help me to resolve these error.

                           

                          one thing more i m new in this form. can i not attach the file in this form if yes then how i not found the link to attach file.

                           

                          thanks and regards

                          pritesh ranjan

                          • 10. Re: Hi expert,
                            Hussein Sawwan-Oracle
                            ORA-04063: view "APPS.MTL_ITEM_CATALOG_GROUPS_V" has errors

                             


                            Invalid Database Objects in APPS Schema With Error ORA-00904 ITEM_CATALOG_GROUP_ID invalid identifier (Doc ID 445025.1)


                            Thanks,

                            Hussein

                            • 11. Re: Hi expert,
                              pritesh ranjan

                              many many thanks Hussein for ur replay,

                              i already chk the document Doc ID 445025.1 on metalink. this said about the setup issue of the inventory.

                              i check this document again. and replay u as soon as possible.


                              thanks

                              pritesh ranjan