SQL Rule Does Not Save Inserted Data to Table (Doc ID 1490721.1)

Last updated on JANUARY 27, 2015

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)
SQL Rule

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA) infrastructure, when you run a basic SQL Rule the inserts data into a table, it fails to insert any data into the table.  The SQL Rule contains the following SQL:

insert into test (ID) values (1)

After you run the SQL rule, it completes successfully but there is no data inserted into the target table.

Steps to Reproduce:

  1. Go to Unified Metadata Manager > Data Integrator Framework > SQL Rules
  2. Create a new SQL Rule
  3. Put an insert statement into the SQL Rule definition
  4. Run the SQL rule

The data is not inserted into the target table.

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