Item Description Function Using EGO_COL_NAME_VALUE_PAIR_ARRAY Errors On Update: ORA-06550: PLS-00306: Wrong Number Or Types Of Arguments [Video] (Doc ID 1199333.1)

Last updated on MAY 08, 2017

Applies to:

Oracle Product Hub - Version 12.1.2 and later
Information in this document applies to any platform.

Symptoms

Receive the following error attempting to create an item with a function generated description.

What is working
Works fine until the user marks the item catalog generation function as "Enable Key Attributes".
After this, receive the error.
Also works fine on creating the item, just not editing the attributes.

Error

The Function "JBP_Function1" threw the following exception: java.sql.SQLException:
ORA-06550: line 1, column 14: PLS-00306: wrong number or types of arguments in call to 'GENERATE_DESCRIPTION1'
ORA-06550: line 1, column 8: PL/SQL: Statement ignored


Movie
The following video / movie steps thru the issue.

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