My Oracle Support Banner

Item Description Function Failed When "Enable Key Attributes" Is Selected (Doc ID 2271976.1)

Last updated on MAY 12, 2020

Applies to:

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


Problem Statement
Item Description Function failed with error:ORA-06550/PLS-00306 when "Enable Key Attributes" is selected.

The Function "XXXX_XXPE_DESC" threw the following exception: java.sql.SQLException: ORA-06550: line 1, column 15: PLS-00306: wrong number or types of arguments in call to 'XXXX_XXPE_GET_DESC' ORA-06550: line 1, column 8: PL/SQL: Statement ignored . Please check the error logs for more complete error information.

Steps To Reproduce

  1. Create the Function in database  
  2. Create a new Item with ICC:XXXX_ICC_002 (Enable Key Attributes : No)
    (N)Item Catalog > Create Production Items
    ==>Works fine
  3. Create a new Item with ICC:XXXX_ICC_003 (Enable Key Attributes : Yes)
    (N)Item Catalog > Create Production Items




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.