' Error While Saving Transformation' in Stored Procedure Editor & ORA-12899 When Creating a Post Load Transformation
Last updated on APRIL 02, 2014
Applies to:Oracle Financial Services Analytical Applications Infrastructure - Version 7.3 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
In Oracle Financial Services Analytical Applications (OFSAA) Infrastructure 7.3, in the Post Load Transformation screen, when you try to save a function in the Stored Procedure Editor, the following error occurs when you click Finish:
 Error while saving Transformation
When you check the ETLService.log in the Tomcat/Weblogic/Websphere OFSAA log directory, you find the following error:
[ETLLOG] Mar 27,14 11:09:58 : [CLSUETLENTITYTRANFORMATION] Failed Saving
[ETLLOG] Mar 27,14 11:09:58 : [CLSUETLENTITYTRANFORMATION] Error while saving Transformation:Reason is Unknown
You do not know why the Post Load Transformation fails to save.
Steps to Reproduce:
- Go to Unified Metadata Manager
- Go to Data Integrator Framework > Post Load Transformation
- Create a new Post Load Transformation for a Stored Procedure
- Click Finish
The error appears.
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