ORA-00904: "AD_PA_MISC"."GET_TOTAL_TIME": invalid identifier

I upgraded a freshly installed R12.1.1 Vision instance to 12.1.3 by applying patch 9239090. Howerver I got errors wherever adtimrpt.sql was executed after a patch similar to this:

sqlplus -s APPS/APPS @/jaer12/appl/ad/12.0.0/sql/adtimrpt.sql 550206 adt550206

The spooled file would give this error:

Product Information page

1

rpad(ad_pa_misc.get_total_time(inner.session_id,

*

ERROR at line 5:

ORA-00904: "AD_PA_MISC"."GET_TOTAL_TIME": invalid identifier

I checked the instance for availability of package AD_PA_MISC, and found that it was non existant.

So I checked what files created this package by

cd $AD_TOP/patch/115/sql

grep ad_pa_misc *

adpamisb.pls:REM | Body for ad_pa_misc package

adpamisb.pls:CREATE or REPLACE package body ad_pa_misc as

adpamisb.pls:END ad_pa_misc;

adpamiss.pls:REM | Specification for ad_pa_misc package

adpamiss.pls:CREATE OR REPLACE package ad_pa_misc as

adpamiss.pls:end ad_pa_misc;

So adpamiss.pls is the package specification and adpamisb.pls is the package body.

I connected as apps and executed adpamisb.pls and adpamiss.pls

This has created the missing ad_pa_misc package. I re-executed the failing sql again and it succeded this time:

sqlplus -s APPS/APPS @/jaer12/appl/ad/12.0.0/sql/adtimrpt.sql 550206 adt550206

Spooling to adt550206.lst

Spooling to adt550206.csv