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

Last updated on MAY 31, 2017

Applies to:

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

Symptoms

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

Error
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  

    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