PLS-00306: wrong number or types of arguments in call to APPPROC_BLE_ACTUALS_LY (Doc ID 1214105.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Demand Management - Version 7.2.0.2 and later
Information in this document applies to any platform.
***Checked for relevance on 03-May-2013***

Symptoms


Following error is observed in the Collaborator.log during the EBS Full Download workflow

2010-08-26 13:15:03,739 [WFProcess_134] FATAL workflow.general: appserver.workflow.general
java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'APPPROC_BLE_ACTUALS_LY'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:184)
at oracle.jdbc.driver.T4CCallableStatement.execute_for_rows(T4CCallableStatement.java:873)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1161)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3001)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3093)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4286)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169)
at com.demantra.workflow.step.StoredProcedureStep.runStoredProcedure(StoredProcedureStep.java:167)
at com.demantra.workflow.step.StoredProcedureStep.doExecute(StoredProcedureStep.java:108)
at com.demantra.workflow.step.LinkedStep.execute(LinkedStep.java:464)
at com.demantra.workflow.process.WFProcess.mainLoop(WFProcess.java:458)
at com.demantra.workflow.process.WFProcess.run(WFProcess.java:263)
at java.lang.Thread.run(Thread.java:595)

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