Troubleshooting: Dropping and Recreating Database Objects

In the event of invalid database objects, you can drop and recreate the database objects. You drop database objects by either:

• Copying the OEBS_DROP.sql file from the RA Oracle E-Business Suite Agent .zip file from the Automic Download Center and running it from SQL*Plus.
• Logging into Client 0 and updating your OEBS Agent(s). You update RA Oracle E-Business Suite Agent solution Agents by checking the Update Database, after Agent Restart box on the General Parameters section on the Oracle E-Business Suite page for the OEBS Agent and saving the Agent. You then need to stop and restart the service(s) for your Oracle E-Business Suite Agent(s) from the Service-Manager window or command line.
• Updating the trigger when the OEBS Agent is stopped. You do this by copying the upgrade.sql file from the RA Oracle E-Business Suite Agent Agent .zip file from the Automic Download Center and running it from SQL*Plus.

You may get invalid objects for various reasons and the Agent may fail to start. However, when Jobs run, there will be errors like the following in the reports:

+++++++++++++++++++++++++++ Start of Runtime Exception +++++++++++++++++++++++++++++++++

java.sql.SQLException: ORA-04063: package body "APPS.UC4_OAE_PK" has errors

ORA-06508: PL/SQL: could not find program unit being called: "APPS.UC4_OAE_PK"

ORA-06512: at line 1