11 Replies Latest reply on Jan 29, 2017 4:44 PM by mdtaylor

    Opening Oracle EBS 12.1.3 requests I receive the below error

    Readme

      ora-01403:no data found

      FRM-40735:PRE-FORM trigger raised unhandled exception ora-04063

        • 1. Re: Opening Oracle EBS 12.1.3 requests I receive the below error
          2755920

          Hi,

           

          Thanks for posting your issue.

           

          Could you please let us know is it specific to any particular Concurrent request.

           

          Thanks,

          • 2. Re: Opening Oracle EBS 12.1.3 requests I receive the below error
            Readme

            Sure running the active users report

            • 3. Re: Opening Oracle EBS 12.1.3 requests I receive the below error
              mdtaylor

              Please compile invalid objects with adadmin compile apps schema.  See MOS ID 2163788.1.

               

              Regards,

              Michael

              • 4. Re: Opening Oracle EBS 12.1.3 requests I receive the below error
                Readme

                Thanks for the answer ,but I appleid what you mentioned  it didn't  work ,any other advice?

                • 5. Re: Opening Oracle EBS 12.1.3 requests I receive the below error
                  mdtaylor

                  Please bounce the concurrent manager after recompiling.  Also post any FND related invalid objects.

                   

                  select object_name, object_type from user_objects where object_bane like 'FND%' and status = 'INVALID';

                  1 person found this helpful
                  • 6. Re: Opening Oracle EBS 12.1.3 requests I receive the below error
                    Readme

                    FND_CONC_CLONE                                                                                                                   PACKAGE BODY

                    FND_CONC_MAINTAIN                                                                                                                PACKAGE BODY

                    FND_CONC_PRIVATE_UTILS                                                                                                           PACKAGE BODY

                    FND_CONC_REQUEST_PKG                                                                                                             PACKAGE BODY

                    FND_DELIVERY                                                                                                                     PACKAGE BODY

                    FND_DSQL                                                                                                                         PACKAGE BODY

                    FND_FILE                                                                                                                         PACKAGE BODY

                    FND_FLEX_APIS                                                                                                                    PACKAGE BODY

                    FND_FLEX_DESCVAL                                                                                                                 PACKAGE BODY

                    FND_FLEX_DSC_API                                                                                                                 PACKAGE BODY

                     

                     

                    OBJECT_NAME                                                                                                                      OBJECT_TYPE

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

                    FND_FLEX_EXT                                                                                                                     PACKAGE BODY

                    FND_FLEX_HIERARCHY_COMPILER                                                                                                      PACKAGE BODY

                    FND_FLEX_KEY_API                                                                                                                 PACKAGE BODY

                    FND_FLEX_LOADER_APIS                                                                                                             PACKAGE BODY

                    FND_FLEX_SERVER                                                                                                                  PACKAGE BODY

                    FND_FLEX_SERVER2                                                                                                                 PACKAGE BODY

                    FND_FLEX_XML_PUBLISHER_APIS                                                                                                      PACKAGE BODY

                    FND_PROGRAM                                                                                                                      PACKAGE BODY

                    FND_REQUEST                                                                                                                      PACKAGE BODY

                    FND_REQUEST_SETS_PKG                                                                                                             PACKAGE BODY

                    FND_SET                                                                                                                          PACKAGE BODY

                     

                     

                    OBJECT_NAME                                                                                                                      OBJECT_TYPE

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

                    FND_SUBMIT                                                                                                                       PACKAGE BODY

                    • 7. Re: Opening Oracle EBS 12.1.3 requests I receive the below error
                      mdtaylor

                      How many FND invalid objects remain after the DBA compiled them with adadmin or $ORACLE_HOME/rdbms/admin/utlrp.sql?

                       

                      If any remain, please provide the output of recent patches:  Change the date range until you receive the last 20 or so patches.

                       

                      col patch_name format A12

                      select patch_name, creation_date from ad_applied_patches where creation_date > sysdate - 90;

                       

                      There should be zero FND invalid objects.  The DBA will have to determine if he missed prerequisite patches or did something else to cause these invalids.  He should either open the invalid object in SQL Developer and try to compile and research the error, or compile in sqlplus and execute show errors after.

                      • 8. Re: Opening Oracle EBS 12.1.3 requests I receive the below error
                        Readme

                        I applied utrp.sql

                        and adadmin compile

                        still the same number of of invalid

                        SQL> select patch_name, creation_date from ad_applied_patches where creation_date > sysdate -300;

                         

                         

                        PATCH_NAME                                                                                                               CREATION_DATE

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

                        9980722                                                                                                                  04-JUN-16

                        9980722                                                                                                                  04-JUN-16

                        14196434                                                                                                                 02-AUG-16

                        16015113                                                                                                                 02-AUG-16

                        7651166                                                                                                                  23-NOV-16

                        7651166                                                                                                                  23-NOV-16

                        9239090                                                                                                                  01-JUN-16

                        9239090                                                                                                                  05-JUN-16

                        9817770                                                                                                                  05-JUN-16

                        9980722                                                                                                                  04-JUN-16

                        8919489                                                                                                                  22-JUN-16

                         

                         

                        PATCH_NAME                                                                                                               CREATION_DATE

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

                        8919489                                                                                                                  22-JUN-16

                        8919489                                                                                                                  22-JUN-16

                        9738085                                                                                                                  22-JUN-16

                        9852070                                                                                                                  22-JUN-16

                        12686610                                                                                                                 22-JUN-16

                        12715586                                                                                                                 20-AUG-16

                        21370116                                                                                                                 24-AUG-16

                        21649685                                                                                                                 24-AUG-16

                        9239089                                                                                                                  31-MAY-16

                        9239089                                                                                                                  31-MAY-16

                        12387976                                                                                                                 01-AUG-16

                         

                         

                        PATCH_NAME                                                                                                               CREATION_DATE

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

                        6678700                                                                                                                  30-MAY-16

                        8492461                                                                                                                  05-JUN-16

                        8492461                                                                                                                  05-JUN-16

                        8492461                                                                                                                  05-JUN-16

                        9239095                                                                                                                  05-JUN-16

                        9966055                                                                                                                  05-JUN-16

                        9239095                                                                                                                  05-JUN-16

                        12387976                                                                                                                 01-AUG-16

                        8576725                                                                                                                  29-MAY-16

                        12387976                                                                                                                 31-JUL-16

                        12715586                                                                                                                 20-AUG-16

                         

                         

                        PATCH_NAME                                                                                                               CREATION_DATE

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

                        9239090                                                                                                                  05-JUN-16

                        9171651                                                                                                                  09-JUN-16

                        9171651                                                                                                                  09-JUN-16

                        • 9. Re: Opening Oracle EBS 12.1.3 requests I receive the below error
                          mdtaylor

                          It appears some patch was applied without meeting the mandatory prerequisites.

                           

                          For each patch applied after 12.1.3 (01-JUN-16), open the readme and any notes referenced, and query the database to ensure all prerequisite patches have been applied.

                           

                          https://updates.oracle.com/Orion/PatchDetails/process_form?patch_num=7651166

                           

                          Why was 7651166 applied on 23-Nov-16?

                           

                          From sqlplus as apps:

                           

                          alter package FND_CONC_REQUEST_PKG compile body;

                          show errors;

                           

                          Do the same for some of the other packages.  Search MOS for the errors returned.

                          • 10. Re: Opening Oracle EBS 12.1.3 requests I receive the below error
                            Readme

                            SQL> /

                             

                             

                            Warning: Package Body altered with compilation errors.

                             

                             

                            SQL> sho werror

                            SP2-0158: unknown SHOW option "werror"

                            SQL> sho error

                            Errors for PACKAGE BODY FND_CONC_REQUEST_PKG:

                             

                             

                            LINE/COL ERROR

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

                            35/13    PLS-00323: subprogram or cursor 'GET_PHASE_STATUS' is declared in

                                     a package specification and must be defined in the package body

                             

                             

                            SQL> sho error

                            Errors for PACKAGE BODY FND_CONC_REQUEST_PKG:

                             

                             

                            LINE/COL ERROR

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

                            35/13    PLS-00323: subprogram or cursor 'GET_PHASE_STATUS' is declared in

                                     a package specification and must be defined in the package body

                            • 11. Re: Opening Oracle EBS 12.1.3 requests I receive the below error
                              mdtaylor

                              Your package spec for FND_CONC_REQUEST_PKG is missing GET_PHASE_STATUS.  You need to navigate to $FND_TOP/patch/115/sql and execute

                               

                              sqlplus apps/apps_pw @AFCPFCRS.pls

                               

                              It wouldn't hurt to adident the package to ensure you have 120.2 version.

                               

                              adident Header AFCPFCRS.pls

                              AFCPFCRS.pls:

                              $Header AFCPFCRS.pls 120.2 2005/08/19 21:41:49 rckalyan ship $

                               

                              grep -i get_phase_status AFCPFCRS.pls

                                procedure get_phase_status  (pcode in char,

                                pragma restrict_references    (get_phase_status, WNDS);

                               

                              Once you load that package, run utlrp.sql or adadmin recompile apps schema.  Do the same exercise for other invalid objects.

                               

                              If you are still in $FND_TOP/patch/115/sql, you can execute

                               

                              grep FND_FLEX_SERVER *

                               

                              to find the package spec and body scripts to reload based on the error observed from show errors.