R12.1.3 Trade Management Update Error: "java.sql.SQLException: ORA-06550: PLS-00306: wrong number or types of arguments in call to UPDATE_SYS_PARAMETERS" (Doc ID 1519580.1)

Last updated on AUGUST 03, 2015

Applies to:

Oracle Trade Management - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Cannot update Trade Management system parameters, receiving ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'UPDATE_SYS_PARAMETERS' error.

 

Steps to Reproduce

  1. Responsibility: Oracle Trade Management
  2. Navigation: Administration > System Parameters
  3. Make change and click update button
  4. Recieve Error

 

Error

java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'UPDATE_SYS_PARAMETERS'
ORA-06550: line 1, column 7: PL/SQL: Statement ignored java.sql.SQLException:
ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'UPDATE_SYS_PARAMETERS'
ORA-06550: line 1, column 7: PL/SQL: Statement ignored at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)


Also, similar error with Claim lines,

java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'UPDATE_CLAIM_LINE_TBL'
ORA-06550: line 1, column 7: PL/SQL: Statement ignored java.sql.SQLException:
ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'UPDATE_CLAIM_LINE_TBL'
ORA-06550: line 1, column 7: PL/SQL: Statement ignored at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521) at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:202)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows


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