Invalid Objects

[big]

Hi,
On R12.2.9 on AIX, DB 12c we have 44 invalid APPS objects. They should be standard Oracle objects because we did not create any object. They are the followings:

FFP60342_01012008
FFP60342_01012006
FFP60342_01010001
FFP60315_01012010
FFP60315_01010001
FFP60280_01010001
FFP57513_01010001
FFP57512_01010001
FFP57511_01010001
and more.
When we compile they all give the message like:
alter package apps.FFP55409_01012005 compile body;

Warning: Package Body altered with compilation errors.

SQL> show error
Errors for PACKAGE BODY APPS.FFP55409_01012005:

LINE/COL ERROR
-------- -----------------------------------------------------------------
408/1    PL/SQL: Statement ignored
408/6    PLS-00306: wrong number or types of arguments in call to
         'GET_PENSION_DETAILS'
I looked at the code:
Line 408 is : V20:=pay_ie_p35_magtape.get_pension_details(V6,V7,V8,V9,V10,V11,V12,V13,V14,V15,FFFUNC.TN(T5),V16);
We wonder how these standard objects can be invalid. How to correct them? We have already ran:
FNDLOAD apps/*** 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct $AD_TOP/patch/115/import/US/adzdpatch.ldt - CUSTOM_MODE=FORCE
adadmin:
2.  Recompile the APPS schema using adadmin.
a. Open the adadmin application on the applications tier.
b. Provide the "SYSTEM" schema password in the prompt.
c. Provide the "APPS" schema password in the prompt.
d. After login, select option 3 "Compile/Reload Applications Database Entities menu".
e. Select option 1 from the menu that reads "Compile APPS schema".

3. Recreate grants/synonyms using adadmin.
a. Open the Main AD Administration menu.
b. Go to the Maintain Applications Database Entities menu.
c. Select the "Recreate grants and synon
And: SQL> @?/rdbms/admin/utlrp.sql
Thanks for help.

[ErmanArslansOracleBlog]

Those are Fast Formulas objects. We have a dedicated procedure for compiling those types of object, but! in your case, I don't think that it will help. Still sharing it; how To Compile Oracle Fast Formulas? (Doc ID 155737.1)
Your solution is based on FNDLOAD, a correct FNDLOAD from correct ldt.
That PLS error is an evidence to that.. Your codes (related with those FFP* objects) are not compatible with the current state. that error reporting wrong number of arguments in calling GET_PENSION_DETAILS, is a clear evidence to the problem.. One code tries to call another code , but doing it wrongly..

I don't have any clue about the past of your environment, but probably, it is an upgraded one.
You should review your upgrade process.. You can try to find the ldts on your file system (ldts that include the related definitions/those FF object definitions, directly GET_PENSION_DETAILS definition maybe) and consider reuploading them.
hrglobal may also related with it , here is a known issue but it is for 12.1.3! -> Invalid FFP Objects in the Database after Upgrade (Doc ID 1331911.1)

So, review your upgrade/patch process, push your limits to find those ldts that look suspicious, and in parallel -> Please log a new SR and make Oracle Support to reivew this.

[big]

Hi,

Thank you.

A teammate ran again:
SQL> @?/rdbms/admin/utlrp.sql

And no more invalid FFP*

I'm Astonished.

Regards.