'fn_deleteFusionTables' Batch Fails with 'Empty/Illegal Rule : No Jobs Found' in Log

(Doc ID 2316093.1)

Last updated on OCTOBER 16, 2017

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 8.0.0 and later
Oracle Financial Services Asset Liability Management - Version 8.0.0 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 and later
Oracle Financial Services Profitability Management - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA) 8.0, when you runs the seeded program fn_deleteFusionTables in a batch, the process fails and no records are deleted from FSI_D_<table>.  The following messages exist in the 'DT_' log in $FIC_DB_HOME/log/date:

Log Message here 1: Fri 25 Aug 2017 11:35:46 AM EDT||INFO||After reading parameters
Log Message here 1: Fri 25 Aug 2017 11:35:46 AM EDT||INFO||Before logging in
Log Message here 1: Fri 25 Aug 2017 11:35:46 AM EDT||INFO||Connecting to database
Log Message here 1: Fri 25 Aug 2017 11:35:46 AM EDT||INFO||Connect successful
Log Message here 1: Fri 25 Aug 2017 11:35:46 AM EDT||INFO||Login Status : 0
Log Message here 1: Fri 25 Aug 2017 11:35:46 AM EDT||INFO||Select Stmt : select distinct replace(rtrim(b.v_step_type),'',' ')
Log Message here 1: Fri 25 Aug 2017 11:35:46 AM EDT||INFO||Before returning from readJobs.
Log Message here 1: Fri 25 Aug 2017 11:35:46 AM EDT||SEVERE||Empty/Illegal Rule : No Jobs Found
Log Message here 1: Fri 25 Aug 2017 11:35:46 AM EDT||INFO||Task status -> 1


You populated FSI_DELETE_TABLES_SETUP with a row for table being deleted.  You do not understand what causes the program to fail.

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