Re: upgrade R12.1.3 to R12.2

Posted by ErmanArslansOracleBlog on Apr 18, 2023; 10:02am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/upgrade-R12-1-3-to-R12-2-tp11806p11811.html

you can compile FND_WEB_SEC.
Your problem is in FND_USER_PKG and especially the following ones are the causes;

PLS-00323: subprogram or cursor 'LOAD_ROW' is declared in a
         package specification and must be defined in the package body

PLS-00323: subprogram or cursor 'VALIDATESSOLOGIN' is declared in
         a package specification and must be defined in the package body

PLS-00323: subprogram or cursor 'REMOVESECURITYATTRS' is declared
         in a package specification and must be defined in the package
         body

PLS-00323: subprogram or cursor 'REMOVE_PII_USER' is declared in
 subprogram or cursor 'GETEFPASSWORD' is declared in a
         package specification and must be defined in the package body

*There is mismatch there. So you need to correct your packages, recreate them with the correct versions.. In this case, your spec and body are not aligned.

See the following oracle community thread for this -->

https://community.oracle.com/mosc/discussion/3035316/5903765-11i-applications-technology-linux-x86-failed-on-failed-file-afgstusr-sql-on-worker-1

This will help you.