Re: Invalid Objects

Posted by ErmanArslansOracleBlog on Nov 16, 2022; 10:41am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Invalid-Objects-tp11230p11236.html

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.