Upgrade Error: PLS-00306 Wrong Number Or Types Of Arguments In Call To DO_DYNAMIC_INSERT_FOR_JAVA

(Doc ID 2084748.1)

Last updated on DECEMBER 08, 2015

Applies to:

Oracle Applications DBA - Version 12.2 to 12.2 [Release 12.2]
Information in this document applies to any platform.


During an upgrade from 12.1.3 to 12.2.0, there are 3 failed workers with a root cause of the APPS.FND_FLEX_SERVER package body being invalid.

The current versions of the FND_FLEX SERVER spec and body are:
Spec =
$Header: AFFFSSVS.pls 120.3.12010000.3 2015/04/02 19:37:00 hgeorgi ship

Body =
Header: AFFFSSVB.pls 120.28 2011/11/18 20:33:03 hgeorgi ship

The following error is produced:

On line: 4131
PLS-00306: wrong number or types of arguments in call to 'DO_DYNAMIC_INSERT_FOR_JAVA'

The issue can be reproduced at will with the following steps:
1. Applying 12.2 driver and associated patches during an upgrade from 12.1.3 to 12.2.0.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms