fn_deleteFusionTables Function to Unload Data from Instrument Table Failed (Doc ID 1550574.1)

Last updated on MAY 16, 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)

Symptoms

On : 7.3 version, Install and Upgrade Issues

When attempting to run a batch to remove records from the Instrument Table present in the Staging Table using fn_deleteFusionTables function, the batch failed with the following error.

ERROR
$FIC_DB_HOME/ficdb/log/date/Run Procedure log shows:

Log Message here 1: Thu May  2 04:42:36 2013||INFO||Parameters : fn_deleteFusionTables,'OFSAAINFOD_RH_FNDELETEFUSIONTABLE_20130430_2','20130430',FSI_D_BORROWINGS
Log Message here 1: Thu May  2 04:42:36 2013||INFO||Statement to execute : BEGIN :D := fn_deleteFusionTables('OFSAAINFOD_RH_FNDELETEFUSIONTABLE_20130430_2','20130430',FSI_D_BORROWINGS); END;
Error Msg :-> ORA-06550: line 1, column 93:
PLS-00357: Table,View Or Sequence reference 'FSI_D_BORROWINGS' not allowed in this context
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

 

$FIC_DB_HOME/ficdb/log/date/Data Server log shows:

Log Message here 1: Thu May  2 04:42:36 2013||INFO||Started executing for the Step : fn_deleteFusionTables_1
Log Message here 1: Thu May  2 04:42:36 2013||INFO||Parameter : FSI_D_BORROWINGS
Log Message here 1: Thu May  2 04:42:36 2013||INFO||varDim :
Log Message here 1: Thu May  2 04:42:36 2013||INFO||Enterred the while loop
Log Message here 1: Thu May  2 04:42:36 2013||INFO||Finding the presence of "V_TASK_ID"
Log Message here 1: Thu May  2 04:42:36 2013||INFO||Parameters : fn_deleteFusionTables,'OFSAAINFOD_RH_FNDELETEFUSIONTABLE_20130430_2','20130430',FSI_D_BORROWINGS
Log Message here 1: Thu May  2 04:42:36 2013||INFO||child pid : 10816
Log Message here 1: Thu May  2 04:42:36 2013||INFO||Exited pid : 10816, status : 256
Log Message here 1: Thu May  2 04:42:36 2013||INFO||exit status : 1
Log Message here 1: Thu May  2 04:42:36 2013||INFO||Step Failure -- fn_deleteFusionTables_1
Log Message here 1: Thu May  2 04:42:36 2013||INFO||taskStatus - in isRunnableChildPresent : 1
Log Message here 1: Thu May  2 04:42:36 2013||INFO||All the steps/jobs have been executed
Log Message here 1: Thu May  2 04:42:36 2013||INFO||Jobs over.
Log Message here 1: Thu May  2 04:42:36 2013||INFO||tasksatus inside executesteps - 1
Log Message here 1: Thu May  2 04:42:36 2013||INFO||Returned from executeSteps() -> 1
Log Message here 1: Thu May  2 04:42:36 2013||INFO||Stmt : update date_task_master set v_step_status='F' where v_Info_Domain='OFSAAINFOD'  and v_task_id='fn_deleteFusionTables'  and v_step_id='fn_deleteFusionTables_1'
Log Message here 1: Thu May  2 04:42:36 2013||INFO||Task status -> 1

STEPS
1. Run T2T to load data from Instrument Staging table to Instrument Table succesfully.
2. Populate FSI_DELETE_TABLES_SETUP.

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