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

Thursday, December 16, 2010

Multiple FFP invalid objects after installing R12.1.3

We got 250+ invalid objects whose name started with FFP:

FFP55375_01011990 FFP50508_01011900 FFP50512_01011900 FFP52744_01071999 FFP50510_01011900 FFP52724_01071999 FFP55355_01011990 FFP55058_01011990 FFP60833_01012000 FFP60793_01012004 FFP60963_01012000 FFP60964_01012000 FFP60606_01011990 FFP60607_01011990

A quick search on My Oracle support revealed some articles with similar errors for 11i:

Applied Patch 9062727 (11i.Hr_pf.K.Delta.5) And Left With FFP<######> Invalid Packages [ID 1096417.1]

The above article pointed to this article:

How to compile fast formula from the server (via FFXBCP) (Doc ID 167689.1) and I executed this command:

$ FFXBCP apps/apps 0 Y %% %%
Log filename : L5826316.log


Report filename : O5826316.out

All the FFP invalids were resolved after executing the above command.

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