'[4493] Error While Saving Transformation' in Stored Procedure Editor & ORA-12899 When Creating a Post Load Transformation (Doc ID 1641182.1)

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)

Symptoms

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:

[4493] 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][4493] Error while saving Transformation:Reason is Unknown

You do not know why the Post Load Transformation fails to save.

Steps to Reproduce:

  1. Go to Unified Metadata Manager
  2. Go to Data Integrator Framework > Post Load Transformation
  3. Create a new Post Load Transformation for a Stored Procedure
  4. Click Finish

The error appears.

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