1401: bis_collection_utilities.log('Starting Resolution Initial Load');
1402: bis_collection_utilities.log('From ' || fnd_date.date_to_displaydt(l_collect_from_date),1);
1403: bis_collection_utilities.log('To ' || fnd_date.date_to_displaydt(l_collect_to_date),1);
1404:
1405: bis_collection_utilities.log('Truncating table '||l_biv_schema||'.'||'BIV_DBI_RESOLUTION_SUM_F');
1406:
1407: if biv_dbi_collection_util.truncate_table
1408: (l_biv_schema, 'BIV_DBI_RESOLUTION_SUM_F', l_error_message) <> 0 then
1409: raise l_exception;
1404:
1405: bis_collection_utilities.log('Truncating table '||l_biv_schema||'.'||'BIV_DBI_RESOLUTION_SUM_F');
1406:
1407: if biv_dbi_collection_util.truncate_table
1408: (l_biv_schema, 'BIV_DBI_RESOLUTION_SUM_F', l_error_message) <> 0 then
1409: raise l_exception;
1410: end if;
1411:
1412: bis_collection_utilities.log('Inserting rows into BIV_DBI_RESOLUTION_SUM_F');
1408: (l_biv_schema, 'BIV_DBI_RESOLUTION_SUM_F', l_error_message) <> 0 then
1409: raise l_exception;
1410: end if;
1411:
1412: bis_collection_utilities.log('Inserting rows into BIV_DBI_RESOLUTION_SUM_F');
1413:
1414: insert /*+ APPEND parallel(rsf)*/
1415: into biv_dbi_resolution_sum_f rsf
1416: (
1411:
1412: bis_collection_utilities.log('Inserting rows into BIV_DBI_RESOLUTION_SUM_F');
1413:
1414: insert /*+ APPEND parallel(rsf)*/
1415: into biv_dbi_resolution_sum_f rsf
1416: (
1417: report_date
1418: , incident_id
1419: , incident_type_id