eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POA_DBI_REQ_F_C dependencies on BIS_COLLECTION_UTILITIES

Line 127: l_go_ahead := bis_collection_utilities.setup('POAREQLN');

123:
124: dbms_application_info.set_module(module_name => 'DBI REQ COLLECT', action_name => 'start');
125: l_dop := bis_common_parameters.get_degree_of_parallelism;
126: -- default DOP to profile in EDW_PARALLEL_SRC if 2nd param is not passed
127: l_go_ahead := bis_collection_utilities.setup('POAREQLN');
128:
129: IF (g_init)
130: then
131: execute immediate 'alter session set hash_area_size=104857600';

Line 139: bis_collection_utilities.g_debug := false;

135: IF (NOT l_go_ahead) THEN
136: errbuf := fnd_message.get;
137: raise_application_error (-20000, 'Error in SETUP: ' || errbuf);
138: END IF;
139: bis_collection_utilities.g_debug := false;
140:
141: -- --------------------------------------------
142: -- Taking care of cases where the input from/to
143: -- date is NULL.

Line 150: l_start_date := '''' || to_char(fnd_date.displaydt_to_date(bis_collection_utilities.get_last_refresh_period('POAREQLN'))-0.004,'YYYY/MM/DD HH24:MI:SS') || '''';

146: IF (g_init) THEN
147: l_start_date := To_char(bis_common_parameters.get_global_start_date,'YYYY/MM/DD HH24:MI:SS');
148: d_start_date := bis_common_parameters.get_global_start_date;
149: ELSE
150: l_start_date := '''' || to_char(fnd_date.displaydt_to_date(bis_collection_utilities.get_last_refresh_period('POAREQLN'))-0.004,'YYYY/MM/DD HH24:MI:SS') || '''';
151: /* if there is not a success record in the bis refresh log, then we have to get the global start date as l_start_date*/
152: d_start_date := fnd_date.displaydt_to_date(bis_collection_utilities.get_last_refresh_period('POAREQLN'))-0.004;
153: END IF;
154:

Line 152: d_start_date := fnd_date.displaydt_to_date(bis_collection_utilities.get_last_refresh_period('POAREQLN'))-0.004;

148: d_start_date := bis_common_parameters.get_global_start_date;
149: ELSE
150: l_start_date := '''' || to_char(fnd_date.displaydt_to_date(bis_collection_utilities.get_last_refresh_period('POAREQLN'))-0.004,'YYYY/MM/DD HH24:MI:SS') || '''';
151: /* if there is not a success record in the bis refresh log, then we have to get the global start date as l_start_date*/
152: d_start_date := fnd_date.displaydt_to_date(bis_collection_utilities.get_last_refresh_period('POAREQLN'))-0.004;
153: END IF;
154:
155:
156: l_end_date := '''' || To_char(SYSDATE, 'YYYY/MM/DD HH24:MI:SS') || '''';

Line 160: bis_collection_utilities.log( 'The collection range is from '||

156: l_end_date := '''' || To_char(SYSDATE, 'YYYY/MM/DD HH24:MI:SS') || '''';
157: d_end_date := SYSDATE;
158:
159:
160: bis_collection_utilities.log( 'The collection range is from '||
161: l_start_date ||' to '|| l_end_date, 0);
162:
163:
164: IF (l_batch_size is null) THEN

Line 168: bis_collection_utilities.log('Truncate Currency Conversion table: '|| 'Sysdate=' ||to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);

164: IF (l_batch_size is null) THEN
165: l_batch_size := 10000;
166: END IF;
167:
168: bis_collection_utilities.log('Truncate Currency Conversion table: '|| 'Sysdate=' ||to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
169: IF (fnd_installation.GET_APP_INFO('POA', l_status, l_industry, l_poa_schema)) THEN
170: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_REQ_INC';
171: EXECUTE IMMEDIATE l_stmt;
172:

Line 178: bis_collection_utilities.log('Populate Currency Conversion table '|| 'Sysdate=' ||to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);

174: EXECUTE IMMEDIATE l_stmt;
175: END IF;
176:
177: dbms_application_info.set_action('inc');
178: bis_collection_utilities.log('Populate Currency Conversion table '|| 'Sysdate=' ||to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
179: l_glob_date := '''' || To_char(bis_common_parameters.get_global_start_date, 'YYYY/MM/DD HH24:MI:SS') || '''';
180: d_glob_date := bis_common_parameters.get_global_start_date;
181:
182:

Line 281: bis_collection_utilities.log('-------------------------------------------------------------------------------------', 0);

277: end if;
278: fnd_file.put_line(fnd_file.output,corrupt_rec_table(i).name||' '||corrupt_rec_table(i).segment1||' '||corrupt_rec_table(i).line_num);
279: end loop;
280: if (l_num_corrupt_rows > 0) then
281: bis_collection_utilities.log('-------------------------------------------------------------------------------------', 0);
282: bis_collection_utilities.log('This request has encountered corrupt data in PO tables.', 0);
283: bis_collection_utilities.log('There are one or more requisition distributions which are referred to by', 0);
284: bis_collection_utilities.log('multiple non-complex-work purchase order distributions. Please see the output of', 0);
285: bis_collection_utilities.log('this request for the list of such requisition lines.', 0);

Line 282: bis_collection_utilities.log('This request has encountered corrupt data in PO tables.', 0);

278: fnd_file.put_line(fnd_file.output,corrupt_rec_table(i).name||' '||corrupt_rec_table(i).segment1||' '||corrupt_rec_table(i).line_num);
279: end loop;
280: if (l_num_corrupt_rows > 0) then
281: bis_collection_utilities.log('-------------------------------------------------------------------------------------', 0);
282: bis_collection_utilities.log('This request has encountered corrupt data in PO tables.', 0);
283: bis_collection_utilities.log('There are one or more requisition distributions which are referred to by', 0);
284: bis_collection_utilities.log('multiple non-complex-work purchase order distributions. Please see the output of', 0);
285: bis_collection_utilities.log('this request for the list of such requisition lines.', 0);
286: bis_collection_utilities.log(' ', 0);

Line 283: bis_collection_utilities.log('There are one or more requisition distributions which are referred to by', 0);

279: end loop;
280: if (l_num_corrupt_rows > 0) then
281: bis_collection_utilities.log('-------------------------------------------------------------------------------------', 0);
282: bis_collection_utilities.log('This request has encountered corrupt data in PO tables.', 0);
283: bis_collection_utilities.log('There are one or more requisition distributions which are referred to by', 0);
284: bis_collection_utilities.log('multiple non-complex-work purchase order distributions. Please see the output of', 0);
285: bis_collection_utilities.log('this request for the list of such requisition lines.', 0);
286: bis_collection_utilities.log(' ', 0);
287: bis_collection_utilities.log('These requisition lines have not been collected into the fact and consequently', 0);

Line 284: bis_collection_utilities.log('multiple non-complex-work purchase order distributions. Please see the output of', 0);

280: if (l_num_corrupt_rows > 0) then
281: bis_collection_utilities.log('-------------------------------------------------------------------------------------', 0);
282: bis_collection_utilities.log('This request has encountered corrupt data in PO tables.', 0);
283: bis_collection_utilities.log('There are one or more requisition distributions which are referred to by', 0);
284: bis_collection_utilities.log('multiple non-complex-work purchase order distributions. Please see the output of', 0);
285: bis_collection_utilities.log('this request for the list of such requisition lines.', 0);
286: bis_collection_utilities.log(' ', 0);
287: bis_collection_utilities.log('These requisition lines have not been collected into the fact and consequently', 0);
288: bis_collection_utilities.log('are not displayed in DBI reports', 0);

Line 285: bis_collection_utilities.log('this request for the list of such requisition lines.', 0);

281: bis_collection_utilities.log('-------------------------------------------------------------------------------------', 0);
282: bis_collection_utilities.log('This request has encountered corrupt data in PO tables.', 0);
283: bis_collection_utilities.log('There are one or more requisition distributions which are referred to by', 0);
284: bis_collection_utilities.log('multiple non-complex-work purchase order distributions. Please see the output of', 0);
285: bis_collection_utilities.log('this request for the list of such requisition lines.', 0);
286: bis_collection_utilities.log(' ', 0);
287: bis_collection_utilities.log('These requisition lines have not been collected into the fact and consequently', 0);
288: bis_collection_utilities.log('are not displayed in DBI reports', 0);
289: bis_collection_utilities.log(' ', 0);

Line 286: bis_collection_utilities.log(' ', 0);

282: bis_collection_utilities.log('This request has encountered corrupt data in PO tables.', 0);
283: bis_collection_utilities.log('There are one or more requisition distributions which are referred to by', 0);
284: bis_collection_utilities.log('multiple non-complex-work purchase order distributions. Please see the output of', 0);
285: bis_collection_utilities.log('this request for the list of such requisition lines.', 0);
286: bis_collection_utilities.log(' ', 0);
287: bis_collection_utilities.log('These requisition lines have not been collected into the fact and consequently', 0);
288: bis_collection_utilities.log('are not displayed in DBI reports', 0);
289: bis_collection_utilities.log(' ', 0);
290: bis_collection_utilities.log('If you need to collect and report on these records in DBI please fix this bad data',0);

Line 287: bis_collection_utilities.log('These requisition lines have not been collected into the fact and consequently', 0);

283: bis_collection_utilities.log('There are one or more requisition distributions which are referred to by', 0);
284: bis_collection_utilities.log('multiple non-complex-work purchase order distributions. Please see the output of', 0);
285: bis_collection_utilities.log('this request for the list of such requisition lines.', 0);
286: bis_collection_utilities.log(' ', 0);
287: bis_collection_utilities.log('These requisition lines have not been collected into the fact and consequently', 0);
288: bis_collection_utilities.log('are not displayed in DBI reports', 0);
289: bis_collection_utilities.log(' ', 0);
290: bis_collection_utilities.log('If you need to collect and report on these records in DBI please fix this bad data',0);
291: bis_collection_utilities.log('and re-run the DBI initial load request set. If you do not need this data collected',0);

Line 288: bis_collection_utilities.log('are not displayed in DBI reports', 0);

284: bis_collection_utilities.log('multiple non-complex-work purchase order distributions. Please see the output of', 0);
285: bis_collection_utilities.log('this request for the list of such requisition lines.', 0);
286: bis_collection_utilities.log(' ', 0);
287: bis_collection_utilities.log('These requisition lines have not been collected into the fact and consequently', 0);
288: bis_collection_utilities.log('are not displayed in DBI reports', 0);
289: bis_collection_utilities.log(' ', 0);
290: bis_collection_utilities.log('If you need to collect and report on these records in DBI please fix this bad data',0);
291: bis_collection_utilities.log('and re-run the DBI initial load request set. If you do not need this data collected',0);
292: bis_collection_utilities.log('and reported in DBI you can ignore this warning. If you need help fixing this data',0);

Line 289: bis_collection_utilities.log(' ', 0);

285: bis_collection_utilities.log('this request for the list of such requisition lines.', 0);
286: bis_collection_utilities.log(' ', 0);
287: bis_collection_utilities.log('These requisition lines have not been collected into the fact and consequently', 0);
288: bis_collection_utilities.log('are not displayed in DBI reports', 0);
289: bis_collection_utilities.log(' ', 0);
290: bis_collection_utilities.log('If you need to collect and report on these records in DBI please fix this bad data',0);
291: bis_collection_utilities.log('and re-run the DBI initial load request set. If you do not need this data collected',0);
292: bis_collection_utilities.log('and reported in DBI you can ignore this warning. If you need help fixing this data',0);
293: bis_collection_utilities.log('please contact Oracle Support.',0);

Line 290: bis_collection_utilities.log('If you need to collect and report on these records in DBI please fix this bad data',0);

286: bis_collection_utilities.log(' ', 0);
287: bis_collection_utilities.log('These requisition lines have not been collected into the fact and consequently', 0);
288: bis_collection_utilities.log('are not displayed in DBI reports', 0);
289: bis_collection_utilities.log(' ', 0);
290: bis_collection_utilities.log('If you need to collect and report on these records in DBI please fix this bad data',0);
291: bis_collection_utilities.log('and re-run the DBI initial load request set. If you do not need this data collected',0);
292: bis_collection_utilities.log('and reported in DBI you can ignore this warning. If you need help fixing this data',0);
293: bis_collection_utilities.log('please contact Oracle Support.',0);
294: bis_collection_utilities.log('-------------------------------------------------------------------------------------', 0);

Line 291: bis_collection_utilities.log('and re-run the DBI initial load request set. If you do not need this data collected',0);

287: bis_collection_utilities.log('These requisition lines have not been collected into the fact and consequently', 0);
288: bis_collection_utilities.log('are not displayed in DBI reports', 0);
289: bis_collection_utilities.log(' ', 0);
290: bis_collection_utilities.log('If you need to collect and report on these records in DBI please fix this bad data',0);
291: bis_collection_utilities.log('and re-run the DBI initial load request set. If you do not need this data collected',0);
292: bis_collection_utilities.log('and reported in DBI you can ignore this warning. If you need help fixing this data',0);
293: bis_collection_utilities.log('please contact Oracle Support.',0);
294: bis_collection_utilities.log('-------------------------------------------------------------------------------------', 0);
295:

Line 292: bis_collection_utilities.log('and reported in DBI you can ignore this warning. If you need help fixing this data',0);

288: bis_collection_utilities.log('are not displayed in DBI reports', 0);
289: bis_collection_utilities.log(' ', 0);
290: bis_collection_utilities.log('If you need to collect and report on these records in DBI please fix this bad data',0);
291: bis_collection_utilities.log('and re-run the DBI initial load request set. If you do not need this data collected',0);
292: bis_collection_utilities.log('and reported in DBI you can ignore this warning. If you need help fixing this data',0);
293: bis_collection_utilities.log('please contact Oracle Support.',0);
294: bis_collection_utilities.log('-------------------------------------------------------------------------------------', 0);
295:
296: for i in 1..corrupt_rec_table.count loop

Line 293: bis_collection_utilities.log('please contact Oracle Support.',0);

289: bis_collection_utilities.log(' ', 0);
290: bis_collection_utilities.log('If you need to collect and report on these records in DBI please fix this bad data',0);
291: bis_collection_utilities.log('and re-run the DBI initial load request set. If you do not need this data collected',0);
292: bis_collection_utilities.log('and reported in DBI you can ignore this warning. If you need help fixing this data',0);
293: bis_collection_utilities.log('please contact Oracle Support.',0);
294: bis_collection_utilities.log('-------------------------------------------------------------------------------------', 0);
295:
296: for i in 1..corrupt_rec_table.count loop
297: delete from poa_dbi_req_inc where primary_key = corrupt_rec_table(i).requisition_line_id;

Line 294: bis_collection_utilities.log('-------------------------------------------------------------------------------------', 0);

290: bis_collection_utilities.log('If you need to collect and report on these records in DBI please fix this bad data',0);
291: bis_collection_utilities.log('and re-run the DBI initial load request set. If you do not need this data collected',0);
292: bis_collection_utilities.log('and reported in DBI you can ignore this warning. If you need help fixing this data',0);
293: bis_collection_utilities.log('please contact Oracle Support.',0);
294: bis_collection_utilities.log('-------------------------------------------------------------------------------------', 0);
295:
296: for i in 1..corrupt_rec_table.count loop
297: delete from poa_dbi_req_inc where primary_key = corrupt_rec_table(i).requisition_line_id;
298: end loop;

Line 657: bis_collection_utilities.log('Populate base table: '|| 'Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);

653: fnd_stats.gather_table_stats(ownname => l_poa_schema,
654: tabname => 'POA_DBI_REQ_RATES') ;
655: END IF;
656:
657: bis_collection_utilities.log('Populate base table: '|| 'Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
658: select max(batch_id), COUNT(1) into l_no_batch, l_count from poa_dbi_req_inc;
659: bis_collection_utilities.log('Identified '|| l_count ||' changed records. Batch size='|| l_batch_size || '. # of Batches=' || l_no_batch
660: || '. Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
661:

Line 659: bis_collection_utilities.log('Identified '|| l_count ||' changed records. Batch size='|| l_batch_size || '. # of Batches=' || l_no_batch

655: END IF;
656:
657: bis_collection_utilities.log('Populate base table: '|| 'Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
658: select max(batch_id), COUNT(1) into l_no_batch, l_count from poa_dbi_req_inc;
659: bis_collection_utilities.log('Identified '|| l_count ||' changed records. Batch size='|| l_batch_size || '. # of Batches=' || l_no_batch
660: || '. Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
661:
662:
663: /* missing currency handling */

Line 677: bis_collection_utilities.log('Initial Load - using one batch approach, populate base fact. '|| 'Sysdate=' ||to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);

673: l_user := fnd_global.user_id;
674: dbms_application_info.set_action('collect');
675: if (l_no_batch is NOT NULL) then
676: IF (g_init) THEN
677: bis_collection_utilities.log('Initial Load - using one batch approach, populate base fact. '|| 'Sysdate=' ||to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
678: INSERT /*+ append parallel(t) */ INTO poa_dbi_req_f t (
679: t.req_line_id ,
680: t.req_header_id ,
681: t.po_line_location_id ,

Line 1139: bis_collection_utilities.log('incremental collection');

1135: COMMIT;
1136:
1137: ELSE
1138: -- Incremental load (process in batches)
1139: bis_collection_utilities.log('incremental collection');
1140: FOR v_batch_no IN 1..l_no_batch LOOP
1141: bis_collection_utilities.log('batch no='||v_batch_no || ' Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 1);
1142: MERGE INTO poa_dbi_req_f t using
1143: (

Line 1141: bis_collection_utilities.log('batch no='||v_batch_no || ' Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 1);

1137: ELSE
1138: -- Incremental load (process in batches)
1139: bis_collection_utilities.log('incremental collection');
1140: FOR v_batch_no IN 1..l_no_batch LOOP
1141: bis_collection_utilities.log('batch no='||v_batch_no || ' Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 1);
1142: MERGE INTO poa_dbi_req_f t using
1143: (
1144: SELECT
1145: req_line_id,

Line 1739: bis_collection_utilities.log('Collection complete '|| 'Sysdate=' ||to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);

1735: DBMS_APPLICATION_INFO.SET_ACTION('batch ' || v_batch_no || ' done');
1736: END LOOP;
1737: END IF;
1738: END IF;
1739: bis_collection_utilities.log('Collection complete '|| 'Sysdate=' ||to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
1740: bis_collection_utilities.wrapup(TRUE, l_count, 'POA DBI REQ COLLECTION SUCEEDED', to_date(l_start_date, '''YYYY/MM/DD HH24:MI:SS'''), To_date(l_end_date, '''YYYY/MM/DD HH24:MI:SS'''));
1741: g_init := false;
1742: dbms_application_info.set_module(null, null);
1743: if ( l_num_corrupt_rows > 0 ) then

Line 1740: bis_collection_utilities.wrapup(TRUE, l_count, 'POA DBI REQ COLLECTION SUCEEDED', to_date(l_start_date, '''YYYY/MM/DD HH24:MI:SS'''), To_date(l_end_date, '''YYYY/MM/DD HH24:MI:SS'''));

1736: END LOOP;
1737: END IF;
1738: END IF;
1739: bis_collection_utilities.log('Collection complete '|| 'Sysdate=' ||to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
1740: bis_collection_utilities.wrapup(TRUE, l_count, 'POA DBI REQ COLLECTION SUCEEDED', to_date(l_start_date, '''YYYY/MM/DD HH24:MI:SS'''), To_date(l_end_date, '''YYYY/MM/DD HH24:MI:SS'''));
1741: g_init := false;
1742: dbms_application_info.set_module(null, null);
1743: if ( l_num_corrupt_rows > 0 ) then
1744: fnd_concurrent.af_commit;

Line 1755: bis_collection_utilities.log('Collection failed with '||errbuf||':'||retcode||' Sysdate=' ||to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);

1751: WHEN others THEN
1752: dbms_application_info.set_action('error');
1753: errbuf:=sqlerrm;
1754: retcode:=sqlcode;
1755: bis_collection_utilities.log('Collection failed with '||errbuf||':'||retcode||' Sysdate=' ||to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
1756: bis_collection_utilities.wrapup(FALSE, l_count, errbuf||':'||retcode, to_date(l_start_date, '''YYYY/MM/DD HH24:MI:SS'''), to_date(l_end_date, '''YYYY/MM/DD HH24:MI:SS'''));
1757: RAISE;
1758: END populate_req_facts;
1759:

Line 1756: bis_collection_utilities.wrapup(FALSE, l_count, errbuf||':'||retcode, to_date(l_start_date, '''YYYY/MM/DD HH24:MI:SS'''), to_date(l_end_date, '''YYYY/MM/DD HH24:MI:SS'''));

1752: dbms_application_info.set_action('error');
1753: errbuf:=sqlerrm;
1754: retcode:=sqlcode;
1755: bis_collection_utilities.log('Collection failed with '||errbuf||':'||retcode||' Sysdate=' ||to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
1756: bis_collection_utilities.wrapup(FALSE, l_count, errbuf||':'||retcode, to_date(l_start_date, '''YYYY/MM/DD HH24:MI:SS'''), to_date(l_end_date, '''YYYY/MM/DD HH24:MI:SS'''));
1757: RAISE;
1758: END populate_req_facts;
1759:
1760: END POA_DBI_REQ_F_C;