Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps

Monday, December 6, 2010

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

No comments: