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_PTP_SUM_STG_MV

Line 1139: --if fail to refresh OPI_PTP_SUM_STG_MV last time, try to refresh it again

1135: errbuf := SQLERRM;
1136: RAISE intialization_exception;
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.');

Line 1143: BIS_COLLECTION_UTILITIES.put_line('re-synchronize OPI_PTP_SUM_STG_MV with OPI_DBI_PTP_PLAN_STG.');

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);
1146: EXECUTE IMMEDIATE 'ALTER SESSION DISABLE PARALLEL QUERY';
1147: END IF;

Line 1145: DBMS_MVIEW.REFRESH('OPI_PTP_SUM_STG_MV','?',parallelism => g_degree);

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);
1146: EXECUTE IMMEDIATE 'ALTER SESSION DISABLE PARALLEL QUERY';
1147: END IF;
1148: EXCEPTION
1149: WHEN NO_DATA_FOUND THEN

Line 1168: 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.');

1164: values
1165: (null, 1, null, null, null, 7, 2, null, g_sysdate, g_last_updated_by, g_sysdate, g_last_updated_by, g_last_update_login);
1166: commit;
1167: WHEN OTHERS THEN
1168: 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.');
1169: retcode := g_error;
1170: errbuf := SQLERRM;
1171: RAISE intialization_exception;
1172: END;

Line 1645: from OPI_PTP_SUM_STG_MV stg,

1641: g_last_updated_by,
1642: g_sysdate,
1643: g_last_updated_by,
1644: g_last_update_login
1645: from OPI_PTP_SUM_STG_MV stg,
1646: OPI_DBI_BASELINE_SCHEDULES sched,
1647: fii_time_day day
1648: where sched.next_collection_date <= g_sysdate
1649: and sched.schedule_type = 1

Line 1838: --synchronize OPI_PTP_SUM_STG_MV with OPI_DBI_PTP_PLAN_STG

1834:
1835: --explict commit
1836: COMMIT;
1837:
1838: --synchronize OPI_PTP_SUM_STG_MV with OPI_DBI_PTP_PLAN_STG
1839: BIS_COLLECTION_UTILITIES.put_line('synchronize OPI_PTP_SUM_STG_MV with OPI_DBI_PTP_PLAN_STG.');
1840: l_segment_num := 180;
1841: --analyze table first per performance team's advice
1842: FND_STATS.GATHER_TABLE_STATS(errbuf,retcode,'OPI','OPI_DBI_PTP_PLAN_STG');

Line 1839: BIS_COLLECTION_UTILITIES.put_line('synchronize OPI_PTP_SUM_STG_MV with OPI_DBI_PTP_PLAN_STG.');

1835: --explict commit
1836: COMMIT;
1837:
1838: --synchronize OPI_PTP_SUM_STG_MV with OPI_DBI_PTP_PLAN_STG
1839: BIS_COLLECTION_UTILITIES.put_line('synchronize OPI_PTP_SUM_STG_MV with OPI_DBI_PTP_PLAN_STG.');
1840: l_segment_num := 180;
1841: --analyze table first per performance team's advice
1842: FND_STATS.GATHER_TABLE_STATS(errbuf,retcode,'OPI','OPI_DBI_PTP_PLAN_STG');
1843: BEGIN

Line 1845: DBMS_MVIEW.REFRESH('OPI_PTP_SUM_STG_MV','?',parallelism => g_degree);

1841: --analyze table first per performance team's advice
1842: FND_STATS.GATHER_TABLE_STATS(errbuf,retcode,'OPI','OPI_DBI_PTP_PLAN_STG');
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;

Line 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.');

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.');
1858: RAISE mv_refresh_exception;
1859: END;
1860:
1861: BIS_COLLECTION_UTILITIES.put_line('Successfully collect baseline data on ' || TO_CHAR(g_sysdate, 'DD-MON-YYYY') || '.');

Line 1961: dbms_mview.refresh('OPI_PTP_SUM_STG_MV',

1957: PROCEDURE REFRESH_SUM_STG_MV(errbuf in out NOCOPY varchar2, retcode in out NOCOPY varchar2)
1958: IS
1959: BEGIN
1960:
1961: dbms_mview.refresh('OPI_PTP_SUM_STG_MV',
1962: '?',
1963: parallelism => g_degree -- PARALLELISM
1964: );
1965: END REFRESH_SUM_STG_MV;

Line 1992: BIS_COLLECTION_UTILITIES.PUT_LINE('Refresh OPI_PTP_SUM_STG_MV finished ...');

1988: BIS_COLLECTION_UTILITIES.PUT_LINE('Refresh OPI_PTP_SUM_F_MV finished ...');
1989:
1990: l_stmt_num := 50;
1991: REFRESH_SUM_STG_MV(errbuf, retcode);
1992: BIS_COLLECTION_UTILITIES.PUT_LINE('Refresh OPI_PTP_SUM_STG_MV finished ...');
1993:
1994: l_stmt_num := 60;
1995: REFRESH_RPT_BND_MV(errbuf, retcode);
1996: BIS_COLLECTION_UTILITIES.PUT_LINE('Refresh OPI_PTP_RPT_BND_MV finished ...');