This discussion is archived
2 Replies Latest reply: Jan 11, 2013 8:14 AM by 984370 RSS

P-Track  pacakaged application is missing tables

userKaren Newbie
Currently Being Moderated
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 Pro
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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"

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points