'ORA-01403: no data found' Error Running Truncate Stage Tables Procedure (fn_truncateStageTable)
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:
- Go to Operations > Batch Maintenance
- Create a new Batch
- Create a new Task with TRANSFORM DATA and Rule Name = fn_truncateStageTable
- Go to Operations > Batch Execution and Execute the batch
- 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