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.

Symptoms

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:

PACKAGE BODY APPS.FND_FLEX_SERVER
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.

Cause

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