Posted by
ErmanArslansOracleBlog on
Jan 26, 2017; 7:17am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/R12-Upgrade-from-12-1-3-to-12-2-0-on-Solaris-10-Sun-Sparc-machine-tp1980p2016.html
In Lct file, you have LOAD_ROW in two places.
fnd_executables_pkg.LOAD_ROW;
fnd_concurrent_programs_pkg.LOAD_ROW
Gathered version info:
AFCPMCPS.pls 120.2.12010000.2 2014/01/17 21:41:21 ckclark ship
AFCPMCPB.pls 120.4 2009/07/22 15:24:29 tkamiya ship
afcpprog.lct 120.7 2012/01/13 20:54:45 tkamiya ship
There is a mismatch between your lct version and FND_CONCURRENT_PROGRAMS_PKG version , which lead us to the note: REL 12.2 - Patch fails with PLS-00306: wrong number or types of arguments in call to 'LOAD_ROW' (Doc ID 1933052.1)
However, this note is for EBS 12.2 and it modified lots of PLS versions. That's why I can't recommend it for now.
Do the following -->
1)
cd $FND_TOP/patch/115/sql
sqlplus <as apps>
@AFCPMCPS.pls
sqlplus <as apps>
@AFCPMCPB.pls
select status , object_name from dba_objects where object_name = 'FND_CONCURRENT_PROGRAMS_PKG';
--update me with the output
SQL> alter package FND_CONCURRENT_PROGRAMS_PKG compile body;
SQL> show err
--update me with the output
2)
select status , object_name from dba_objects where object_name = 'FND_EXECUTABLES_PKG';
SQL> alter package FND_EXECUTABLES_PKG compile body;
SQL> show err
--update me with the output
3)
SQL>alter system set events '6550 trace name errorstack level 3';
Then, recreate the error (retry the failed worker)
Check user_dump_dest for the new trace files
Upload the trace file
...disable the trace SQL>alter system set events '6550 trace name context off'