PLS-00306: wrong number or types of arguments in call to 'FSI_PFT_TBL_ID_STG_LOAD' while Saving Static Table Driver (Doc ID 1951241.1)

Last updated on APRIL 29, 2016

Applies to:

Oracle Financial Services Profitability Management - Version 6.1.0.3 to 6.1.0.3 [Release 6]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Service Profitability Management (PFT) 6.1.0.3 version, in Allocation Entries:

Unable to edit previously saved Static Table driver.

Error:

pftapp.log shows the following:

~ INFO ~ PFT ~ *[Error when Running Procedure]*
java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'FSI_PFT_TBL_ID_STG_LOAD'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Steps:
1. Created a new Static Table Driver by selecting Key field and a Target fields complete with coefficients.
2. Saved it.
3. Edit the Static Table Driver,
4. Previously selected and saved coefficients are no longer visible on the tabs of the key and target fields.
5. pftapp.log shows the above error.

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