Post Load Transformations Do Not Work After Updating Attached Stored Procedures in OFSAAI 7.2 (Doc ID 1305081.1)

Last updated on MARCH 13, 2013

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.2.7 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA) - Version 5.2
Data Integrator

Checked for relevance on 13-Mar-2013.

Symptoms

In Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) 7.2.6, after editing a Post Load Transformation to delete a parameter which was removed from the SQL procedure in the database, the following error occurs.

ERROR
PLS-00306: wrong number of types of arguments in call to 'AGGREGATEFEESCOMMISSIONS'PL/SQL: Statement ignored

Creation of a new Post Load Transformation with the same procedure completes successfully.

STEPS
The issue can be reproduced at will with the following steps:
1. Deleted one parameter from the sql-procedures in the database and compiled the package without any errors.
2. Edit the Post Load Transformations which contained the sql-procedures
3. Attempt to save the Post Load Transformation after deleting this parameter

==> error message occurs

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