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.OPI_DBI_PTP_BASELINE_PKG dependencies on OPI_DBI_RUN_LOG_CURR

Line 1141: select stop_reason_code into l_refresh from opi_dbi_run_log_curr where etl_id = 7 and source = 1;

1137: END;
1138:
1139: --if fail to refresh OPI_PTP_SUM_STG_MV last time, try to refresh it again
1140: BEGIN
1141: select stop_reason_code into l_refresh from opi_dbi_run_log_curr where etl_id = 7 and source = 1;
1142: IF l_refresh = 1 THEN
1143: BIS_COLLECTION_UTILITIES.put_line('re-synchronize OPI_PTP_SUM_STG_MV with OPI_DBI_PTP_PLAN_STG.');
1144: EXECUTE IMMEDIATE 'ALTER SESSION FORCE PARALLEL QUERY';
1145: DBMS_MVIEW.REFRESH('OPI_PTP_SUM_STG_MV','?',parallelism => g_degree);

Line 1150: insert into opi_dbi_run_log_curr

1146: EXECUTE IMMEDIATE 'ALTER SESSION DISABLE PARALLEL QUERY';
1147: END IF;
1148: EXCEPTION
1149: WHEN NO_DATA_FOUND THEN
1150: insert into opi_dbi_run_log_curr
1151: (organization_id,
1152: source,
1153: last_collection_date,
1154: start_txn_id,

Line 1847: update opi_dbi_run_log_curr

1843: BEGIN
1844: EXECUTE IMMEDIATE 'ALTER SESSION FORCE PARALLEL QUERY';
1845: DBMS_MVIEW.REFRESH('OPI_PTP_SUM_STG_MV','?',parallelism => g_degree);
1846: EXECUTE IMMEDIATE 'ALTER SESSION DISABLE PARALLEL QUERY';
1847: update opi_dbi_run_log_curr
1848: set stop_reason_code = 2
1849: where etl_id = 7 and source = 1;
1850: commit;
1851: EXCEPTION

Line 1853: update opi_dbi_run_log_curr

1849: where etl_id = 7 and source = 1;
1850: commit;
1851: EXCEPTION
1852: WHEN OTHERS THEN
1853: update opi_dbi_run_log_curr
1854: set stop_reason_code = 1
1855: where etl_id = 7 and source = 1;
1856: commit;
1857: BIS_COLLECTION_UTILITIES.put_line('Fail to refresh materialized view OPI_PTP_SUM_STG_MV. Please fix the problem and re-run the concurrent request set.');