Post Load Transformations Do Not Work After Updating Attached Stored Procedures in OFSAAI 7.2
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
Checked for relevance on 13-Mar-2013.
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.
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.
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
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