1 2 Previous Next 15 Replies Latest reply: Sep 10, 2011 6:55 AM by EBSDBA RSS

    ORA-01403: no data found

    877315
      HI All,

      After applying the patch we got the following issue.

      ORA-01403: no data found

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

      when we are trying to open the forms.

      We applied the Patch 8731994R12.INV.B for 12.1.1 to change the version of the below

      The patch will change the following file version
      INVRCVVB.pls 120.92.12010000.5(present version) to INVRCVVB.pls 120.92.12010000.19


      All the requests are running fine

      Edited by: sairanga on Sep 10, 2011 11:46 AM
        • 1. Re: ORA-01403: no data found
          Hussein Sawwan-Oracle
          After applying the patch we got the following issue.
          Did you apply the patch successfully with no errors?
          ORA-01403: no data found

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

          when we are trying to open the forms.
          Please generate the form via adadmin or manually and check then.

          Also, please confirm that you have no invalid objects in the database after applying the patch.

          Thanks,
          Hussein
          • 2. Re: ORA-01403: no data found
            877315
            Yes the patch completed without Errors.

            When running the adadmin and trying to compile invalid objects we are getting errors

            Trying to compile the Apps schema adadmin stopped with errors

            ORA-03114 oracle not connected.

            Hi All,

            From Adamin I'm getting the following error.

            Running UTL_RECOMP.RECOMP_PARALLEL...

            declare
            *


            ERROR:
            ORA-03114: not connected to ORACLE

            ERROR:
            ORA-03114: not connected to ORACLE


            SP2-0359: memory exhausted


            Edited by: sairanga on Sep 10, 2011 9:51 AM

            Edited by: sairanga on Sep 10, 2011 9:58 AM
            • 3. Re: ORA-01403: no data found
              EBSDBA
              Hi,
              Do you the following object invalid.

              Object_name
              FUN_VENDOR_PVT_PKG

              If yes please see, R12: Invalid Object FUN_VENDOR_PVT_PKG Package Body [ID 1295382.1]

              Also please see if you see any errors in alert log file

              Thanks
              • 4. Re: ORA-01403: no data found
                Hussein Sawwan-Oracle
                Please bounce the database and relink adadmin manually and check if you get the same error or not.

                In addition to the doc referenced above by Taher "user11970143", please see these docs.

                Autoconfig Error On Dbtier After Upgrade - afdbprf.sh and adcrobj.sh fail with ORA-27101: shared memory realm does not exist [ID 422709.1]
                R12 Merged Upgrade Patch 7303029 Fails On Worker For File fpamain.sql [ID 1292479.1]

                Thanks,
                Hussein
                • 5. Re: ORA-01403: no data found
                  877315
                  Hi,

                  We have applied the database patch p7707103_111070_Linux-x86-64 and the Apps compile schema has completed successfully.

                  But the same issue is coming like

                  ORA-01403: no data found

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

                  For Inventry INV  8731994R12.INV.B for 12.1.1_

                  when we logged in to the Oracle Applications R12 and when we click on any forms.

                  This Error message is coming after applying the patch.This patch changes the version of the files as i post before.

                  It is complusory to apply the PSU - July2100 patch. Is this will solve the issue are any other solution......Please suggest us.......

                  Thank you

                  Edited by: sairanga on Sep 10, 2011 2:54 PM

                  Edited by: sairanga on Sep 10, 2011 3:00 PM
                  • 6. Re: ORA-01403: no data found
                    EBSDBA
                    Hi,
                    Did you try to generate all the INV forms and packages.

                    Thanks
                    • 7. Re: ORA-01403: no data found
                      877315
                      Hi,

                      Yes we have generate all the forms and packages in INV. It completed successfully.

                      Thanks
                      • 8. Re: ORA-01403: no data found
                        EBSDBA
                        Hi,
                        As per note
                        adadmin - compile invalid objects against a 11i Database hangs or fails with ORA-07445 [ID 1277719.1]
                        Either you need to apply (CPU or PSU) patch or Patch 7707103.

                        Do you see any errors in alert logfile and also did you bouce the database.

                        Thanks
                        • 9. Re: ORA-01403: no data found
                          Hussein Sawwan-Oracle
                          What is the status of UTL_RECOMP package?

                          Have you relinked adadmin as suggested before?

                          This INV patch should not impact the functionality of the main application, so please confirm that you had no issues before applying the patch (I assume the patch was applied successfully).

                          If you have invalid objects please compile it manually and check then.

                          Thanks,
                          Hussein
                          • 10. Re: ORA-01403: no data found
                            877315
                            Hi,

                            Yes we have applied the pathch and adadmin successfully completed but when we logged to the R12 applications and clicking on forms we are getting

                            ORA-01403: no data found

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

                            But all the requests are running normally all working fine but everytime when we click on form we are getting the popup issue.
                            • 11. Re: ORA-01403: no data found
                              877315
                              Hi,

                              UTL_RECOMP package completed successfully and no issues patch applied successfully. Yes we have relinked the adadmin but no change.

                              Thanks
                              • 12. Re: ORA-01403: no data found
                                EBSDBA
                                Hi,
                                Do you see any errors in alert log file and did you bounce the database??

                                Please see
                                Troubleshooting ORA-01403, ORA-06508 and FRM-40735 in Forms [ID 459005.1]

                                thanks
                                • 13. Re: ORA-01403: no data found
                                  877315
                                  No Errors is alert log and we bounce the database but the same status no luck...

                                  Thanks
                                  • 14. Re: ORA-01403: no data found
                                    877315
                                    No Errors is alert log and we bounced the database too but no luck ....

                                    Thanks
                                    1 2 Previous Next