PLS-00306: Wrong Number Or Types Of Arguments In Call To 'CREATE_ITEM_INSTANCE' (Doc ID 2219227.1)

Last updated on JUNE 15, 2017

Applies to:

Oracle Installed Base - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version,

When attempting to manually create an IB instance in IB UI, the following error occurs

ERROR:      PLS-00306: wrong number or types of arguments in call to 'CREATE_ITEM_INSTANCE'

Oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'CREATE_ITEM_INSTANCE' ORA-06550: line 1, column 7:


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility> Oracle Installed Base Agent User > Item Instance > Item Instances
2. In Item Instance Search Page, click CREATE button
3. Enter all data needed to create a new Installed Base instance > Click Apply

4. Error above is shown at the top of the page.

Changes

 

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