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.BSC_MIGRATION dependencies on BIS_INDICATORS

Line 96: h_short_name BIS_INDICATORS.SHORT_NAME%TYPE;

92: h_cursor t_cursor;
93: h_sql VARCHAR2(2000);
94:
95: h_count NUMBER;
96: h_short_name BIS_INDICATORS.SHORT_NAME%TYPE;
97: h_dataset_id BIS_INDICATORS.DATASET_ID%TYPE;
98:
99: BEGIN
100: h_sql := 'SELECT DISTINCT si.short_name,si.dataset_id'||

Line 97: h_dataset_id BIS_INDICATORS.DATASET_ID%TYPE;

93: h_sql VARCHAR2(2000);
94:
95: h_count NUMBER;
96: h_short_name BIS_INDICATORS.SHORT_NAME%TYPE;
97: h_dataset_id BIS_INDICATORS.DATASET_ID%TYPE;
98:
99: BEGIN
100: h_sql := 'SELECT DISTINCT si.short_name,si.dataset_id'||
101: ' FROM bis_indicators@'||g_db_link||' si'||

Line 101: ' FROM bis_indicators@'||g_db_link||' si'||

97: h_dataset_id BIS_INDICATORS.DATASET_ID%TYPE;
98:
99: BEGIN
100: h_sql := 'SELECT DISTINCT si.short_name,si.dataset_id'||
101: ' FROM bis_indicators@'||g_db_link||' si'||
102: ', bsc_sys_datasets_b@'||g_db_link||' sd'||
103: ' WHERE sd.dataset_id = si.dataset_id AND'||
104: ' si.created_by NOT IN (:2, :3, :4, :5)';
105: IF(h_cursor%ISOPEN) THEN

Line 113: UPDATE bis_indicators SET dataset_id = h_dataset_id WHERE short_name = h_short_name;

109: LOOP
110: FETCH h_cursor INTO h_short_name,h_dataset_id;
111: EXIT WHEN h_cursor%NOTFOUND;
112: --EXECUTE IMMEDIATE h_upd_stmt USING h_dataset_id,h_short_name;
113: UPDATE bis_indicators SET dataset_id = h_dataset_id WHERE short_name = h_short_name;
114: END LOOP;
115: CLOSE h_cursor;
116:
117: COMMIT;

Line 2829: ' FROM bsc_sys_measures@'||g_db_link||' bsc_m, bis_indicators pmf_m'||

2825:
2826: -- Get all the invalid measures. PMF measures not existing in the target
2827: g_num_invalid_pmf_measures := 0;
2828: h_sql := 'SELECT DISTINCT bsc_m.short_name'||
2829: ' FROM bsc_sys_measures@'||g_db_link||' bsc_m, bis_indicators pmf_m'||
2830: ' WHERE bsc_m.source = :1 AND'||
2831: ' bsc_m.short_name = pmf_m.short_name(+) AND'||
2832: ' pmf_m.short_name IS NULL';
2833: OPEN h_cursor FOR h_sql USING h_pmf;

Line 2851: ' bis_indicators i'||

2847: h_sql := 'SELECT DISTINCT k.indicator'||
2848: ' FROM bsc_kpi_analysis_measures_b@'||g_db_link||' k,'||
2849: ' bsc_sys_datasets_b@'||g_db_link||' d,'||
2850: ' bsc_sys_measures@'||g_db_link||' m,'||
2851: ' bis_indicators i'||
2852: ' WHERE k.dataset_id = d.dataset_id AND'||
2853: ' d.measure_id1 = m.measure_id AND'||
2854: ' m.source = :1 AND'||
2855: ' m.short_name = i.short_name (+) AND'||

Line 2872: ' bis_indicators@'||g_db_link||' i,'||

2868: -- Fix bug#4226188: This is a new validation. We want to get the dimensions used by the measures
2869: -- that not exists in the target
2870: h_sql := 'SELECT DISTINCT d.short_name'||
2871: ' FROM bis_indicator_dimensions@'||g_db_link||' id,'||
2872: ' bis_indicators@'||g_db_link||' i,'||
2873: ' bis_dimensions@'||g_db_link||' d,'||
2874: ' bis_dimensions td'||
2875: ' WHERE i.indicator_id = id.indicator_id AND'||
2876: ' d.dimension_id = id.dimension_id AND'||

Line 2897: ' bis_indicators@'||g_db_link||' i,'||

2893: ' FROM bsc_kpi_analysis_measures_b@'||g_db_link||' k,'||
2894: ' bsc_sys_datasets_b@'||g_db_link||' d,'||
2895: ' bsc_sys_measures@'||g_db_link||' m,'||
2896: ' bis_indicator_dimensions@'||g_db_link||' id,'||
2897: ' bis_indicators@'||g_db_link||' i,'||
2898: ' bis_dimensions@'||g_db_link||' sd,'||
2899: ' bis_dimensions td'||
2900: ' WHERE k.dataset_id = d.dataset_id AND'||
2901: ' d.measure_id1 = m.measure_id AND'||

Line 5684: -- we need to sync up dataset_ids between bis_indicators and bsc_sys_datasets_b

5680: -- g_invalid_dimenisions and g_invalid_dim_levels
5681: Clean_Metadata_Invalid_PMF;
5682:
5683:
5684: -- we need to sync up dataset_ids between bis_indicators and bsc_sys_datasets_b
5685: -- because there can be many datasets pointing to same measure as measure_id1
5686: -- sync up is not able to handle this issue.
5687: -- bug 5990096
5688: syncup_dataset_id_in_target;

Line 6361: FROM bis_indicators si,

6357: FUNCTION Remove_Custom_Measures_In_PMF RETURN BOOLEAN IS
6358: -- bug 5099776 modified cursor correct join is with dataset_ids
6359: CURSOR c_measures (p1 NUMBER, p2 NUMBER, p3 NUMBER, p4 NUMBER) IS
6360: SELECT DISTINCT si.indicator_id
6361: FROM bis_indicators si,
6362: bsc_sys_datasets_b sd
6363: WHERE sd.dataset_id = si.dataset_id AND
6364: si.created_by NOT IN (p1, p2, p3,p4);
6365:

Line 6402: -- Update dataset_id to NULL in BIS_INDICATORS so the new dataset id can be populated

6398: ,x_return_status => h_return_status
6399: ,x_error_Tbl => h_error_tbl);
6400: END LOOP;
6401:
6402: -- Update dataset_id to NULL in BIS_INDICATORS so the new dataset id can be populated
6403: -- during synchronization
6404: UPDATE bis_indicators
6405: SET dataset_id = NULL;
6406:

Line 6404: UPDATE bis_indicators

6400: END LOOP;
6401:
6402: -- Update dataset_id to NULL in BIS_INDICATORS so the new dataset id can be populated
6403: -- during synchronization
6404: UPDATE bis_indicators
6405: SET dataset_id = NULL;
6406:
6407: COMMIT;
6408:

Line 7192: ' FROM bis_indicators@'||g_db_link||' i,'||

7188: END LOOP;
7189:
7190: -- perf bug#4583017: remove distinct
7191: h_sql := 'SELECT itl.name, i.short_name, f.application_name'||
7192: ' FROM bis_indicators@'||g_db_link||' i,'||
7193: ' bis_indicators_tl@'||g_db_link||' itl,'||
7194: ' bis_application_measures@'||g_db_link||' am,'||
7195: ' fnd_application_vl@'||g_db_link||' f'||
7196: ' WHERE i.indicator_id = itl.indicator_id AND'||

Line 7193: ' bis_indicators_tl@'||g_db_link||' itl,'||

7189:
7190: -- perf bug#4583017: remove distinct
7191: h_sql := 'SELECT itl.name, i.short_name, f.application_name'||
7192: ' FROM bis_indicators@'||g_db_link||' i,'||
7193: ' bis_indicators_tl@'||g_db_link||' itl,'||
7194: ' bis_application_measures@'||g_db_link||' am,'||
7195: ' fnd_application_vl@'||g_db_link||' f'||
7196: ' WHERE i.indicator_id = itl.indicator_id AND'||
7197: ' itl.language = USERENV(''LANG'') AND'||

Line 7648: ' FROM bis_indicators@'||g_db_link||' si,'||

7644: --Query to get non-pre-seeded BSC/PMF measures from the source
7645: --We will need to create/update those measures in the target
7646: -- bug 5099776
7647: h_sql := 'SELECT DISTINCT si.short_name'||
7648: ' FROM bis_indicators@'||g_db_link||' si,'||
7649: ' bsc_sys_datasets_b@'||g_db_link||' sd'||
7650: ' WHERE sd.dataset_id= si.dataset_id AND'||
7651: ' si.created_by NOT IN (:2, :3, :4, :5)';
7652: OPEN h_cursor FOR h_sql USING 1, 2,120,121;

Line 7777: from bis_indicators

7773: --check if the dimension level exists in the target
7774: h_count := 0;
7775: select count(short_name)
7776: into h_count
7777: from bis_indicators
7778: where short_name = h_measure_short_name;
7779:
7780: IF h_count = 0 THEN
7781: -- Measure does not exists, create it

Line 8966: l_Actual_Data_Source bis_indicators.actual_data_source%TYPE;

8962: l_Attribute_Code_Tbl BISVIEWER.t_char ;
8963: l_Attribute_App_Id_Tbl BISVIEWER.t_num ;
8964: l_Region_Code ak_region_items.region_code%TYPE;
8965: l_Retain_Dim_Att2 BIS_STRING_ARRAY;
8966: l_Actual_Data_Source bis_indicators.actual_data_source%TYPE;
8967: l_sql VARCHAR2(32000);
8968: l_Periodicity_Sht_Name bsc_sys_periodicities.short_name%TYPE;
8969: l_Comparison_Source bis_indicators.comparison_source%TYPE;
8970: l_Enable_Link bis_indicators.enable_link%TYPE;

Line 8969: l_Comparison_Source bis_indicators.comparison_source%TYPE;

8965: l_Retain_Dim_Att2 BIS_STRING_ARRAY;
8966: l_Actual_Data_Source bis_indicators.actual_data_source%TYPE;
8967: l_sql VARCHAR2(32000);
8968: l_Periodicity_Sht_Name bsc_sys_periodicities.short_name%TYPE;
8969: l_Comparison_Source bis_indicators.comparison_source%TYPE;
8970: l_Enable_Link bis_indicators.enable_link%TYPE;
8971: TYPE c_cur_type IS REF CURSOR;
8972: c_cursor c_cur_type;
8973:

Line 8970: l_Enable_Link bis_indicators.enable_link%TYPE;

8966: l_Actual_Data_Source bis_indicators.actual_data_source%TYPE;
8967: l_sql VARCHAR2(32000);
8968: l_Periodicity_Sht_Name bsc_sys_periodicities.short_name%TYPE;
8969: l_Comparison_Source bis_indicators.comparison_source%TYPE;
8970: l_Enable_Link bis_indicators.enable_link%TYPE;
8971: TYPE c_cur_type IS REF CURSOR;
8972: c_cursor c_cur_type;
8973:
8974: CURSOR c_Default_Node IS

Line 8991: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String('ak_item, bis_indicators');

8987: SAVEPOINT BscSyncAKBscMetadata;
8988: -- DataSet Sync Up
8989: l_sql := 'SELECT ak_item.region_code,ak_item.region_application_id,ak_item.attribute_code,ak_item.attribute_application_id, i.comparison_source,i.enable_link, ';
8990: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String('ak_item.attribute2,i.dataset_id from ak_region_items');
8991: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String('ak_item, bis_indicators');
8992: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String('i,bsc_kpis_b');
8993: l_sql := l_sql || ' k WHERE ak_item.region_code = k.short_name and ak_item.attribute1 = :1 and i.short_name = ak_item.attribute2';
8994: l_sql := l_sql || ' AND k.indicator = :2';
8995:

Line 9012: bis_indicators

9008: short_name,actual_data_source
9009: INTO
9010: l_New_Attribute2,l_Actual_Data_Source
9011: FROM
9012: bis_indicators
9013: WHERE
9014: dataset_id = p_New_DataSet_Map(i);
9015:
9016: IF l_Actual_Data_Source IS NULL THEN

Line 9018: bis_indicators

9014: dataset_id = p_New_DataSet_Map(i);
9015:
9016: IF l_Actual_Data_Source IS NULL THEN
9017: UPDATE
9018: bis_indicators
9019: SET
9020: actual_data_source = p_short_name || '.' || l_Item_Att_Code,
9021: function_name = p_short_name,
9022: actual_data_source_type = 'AK',