'ORA-01403: no data found' Error Running Truncate Stage Tables Procedure (fn_truncateStageTable)

(Doc ID 1573487.1)

Last updated on AUGUST 07, 2013

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) 6.x


In Oracle Financial Services Analytical Applications (OFSAA) 6.x, when you run the Truncate Stage Tables Procedure, fn_truncateStageTable, for a user defined dimension, the batch fails and the following error message is output to FSI_MESSAGE_LOG:

Starting truncate tables
Oracle Error.ORA-01403: no data found

Below is an example of parameters used in the Task for the procedure:


As a result of the error, rows are not deleted from the dimension staging tables.

Steps to Reproduce:

  1. Go to Operations > Batch Maintenance
  2. Create a new Batch
  3. Create a new Task with TRANSFORM DATA and Rule Name = fn_truncateStageTable
  4. Go to Operations > Batch Execution and Execute the batch
  5. Review the messages in FSI_MESSAGE_LOG

The error is listed in FSI_MESSAGE_LOG.


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