2 Replies Latest reply: Jan 11, 2013 10:14 AM by 984370 RSS

    P-Track  pacakaged application is missing tables

    userKaren
      We installed the packaged application P-Track in a schema called cpd in Apex version 4.2.0.00.27. When running it, the error below occurs. Essentially it appears that some of the tables are missing as the package does not compile due to tables not being found. We had no trouble running other sample packaged apps. I would really like to look at P-Track. Has anyone else had a problem with installing P-Track? Thanks for any help.


      The following error has occurred while executing the error handling callback: ORA-04063: package body "CPD.EBA_PROJ_FW" has errors ORA-06508: PL/SQL: could not find program unit being called: "CPD.EBA_PROJ_FW" ORA-04063: package body "CPD.EBA_PROJ_STAT_UI" has errors ORA-06508: PL/SQL: could not find program unit being called: "CPD.EBA_PROJ_STAT_UI"

      Technical Info (only visible for developers)

      is_internal_error: true
      apex_error_code: APEX.AUTHORIZATION.UNHANDLED_ERROR
      ora_sqlcode: -4063
      ora_sqlerrm: ORA-04063: package body "CPD.EBA_PROJ_STAT_UI" has errors ORA-06508: PL/SQL: could not find program unit being called: "CPD.EBA_PROJ_STAT_UI"
      component.type: APEX_APPLICATION_AUTHORIZATION
      component.id: 2006685917777498106
      component.name: ADMINISTRATION RIGHTS
      error_backtrace:

      ORA-06512: at line 1
      ORA-06512: at line 2
      ORA-06512: at "SYS.DBMS_SYS_SQL", line 1204
      ORA-06512: at "SYS.WWV_DBMS_SQL", line 973
      ORA-06512: at "SYS.WWV_DBMS_SQL", line 999
      ORA-06512: at "APEX_040200.WWV_FLOW_DYNAMIC_EXEC", line 773
      ORA-06512: at "APEX_040200.WWV_FLOW_AUTHORIZATION", line 80
      ORA-06512: at "APEX_040200.WWV_FLOW_AUTHORIZATION", line 160
      ORA-06512: at "APEX_040200.WWV_FLOW_PLUGIN", line 1922
      ORA-06512: at "APEX_040200.WWV_FLOW_AUTHORIZATION", line 411
        • 1. Re: P-Track  pacakaged application is missing tables
          714270
          Hi,

          I have installed the P-Track*** application in my apex.oracle.com workspace and it works fine. The names in your error messages are referring to packages (EBA_PROJ_FW, EBA_PROJ_STAT_UI).
          Not sure why you are getting these errors; may be, you can try installing this app in a different workspace and see if it works.



          Thanks,
          Rohit
          • 2. Re: P-Track  pacakaged application is missing tables
            984370
            We tried the same install today on our Apex 4.2 instance and received the same error:

            The following error has occurred while executing the error handling callback: ORA-04063: package body "MC.EBA_PROJ_FW" has errors ORA-06508: PL/SQL: could not find program unit being called: "MC.EBA_PROJ_FW" ORA-04063: package body "MC.EBA_PROJ_FW" has errors ORA-06508: PL/SQL: could not find program unit being called: "MC.EBA_PROJ_FW"