My Oracle Support Banner

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

Last updated on JULY 14, 2020

Applies to:

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


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:

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.




To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.