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

Last updated on MAY 05, 2023

Applies to:

Symptoms

On 7.3, 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 : <CHILD_PID>
Log Message here 1: Thu May  2 04:42:36 2013||INFO||Exited pid : <PID>, 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 successfully.
2. Populate FSI_DELETE_TABLES_SETUP.

3. Run Batch Execution for fn_deleteFusionTables.
4. Populate Parameter List with: FSI_D_BORROWING
5. Check Batch Monitor and see Failed error and Package not Loaded error.
6. Check $FIC_DB_HOME/ficdb/log/date/ and found two logs for the process with the above error.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.