Invalid Objects

Posted by big on Nov 15, 2022; 5:44pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Invalid-Objects-tp11230.html

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.