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_DIMENSIONS

Line 2729: ' bis_dimensions pmf_d'||

2725: h_sql := 'SELECT DISTINCT bsc_d.short_name'||
2726: ' FROM bsc_sys_dim_levels_b@'||g_db_link||' bsc_do,'||
2727: ' bsc_sys_dim_groups_vl@'||g_db_link||' bsc_d,'||
2728: ' bsc_sys_dim_levels_by_group@'||g_db_link||' bsc_dlg,'||
2729: ' bis_dimensions pmf_d'||
2730: ' WHERE bsc_do.dim_level_id = bsc_dlg.dim_level_id AND'||
2731: ' bsc_dlg.dim_group_id = bsc_d.dim_group_id AND'||
2732: ' bsc_do.source = :1 AND'||
2733: ' bsc_d.short_name = pmf_d.short_name(+) AND'||

Line 2751: ' bis_dimensions pmf_d'||

2747: ' FROM bsc_kpi_dim_groups@'||g_db_link||' k,'||
2748: ' bsc_sys_dim_levels_b@'||g_db_link||' bsc_do,'||
2749: ' bsc_sys_dim_groups_vl@'||g_db_link||' bsc_d,'||
2750: ' bsc_sys_dim_levels_by_group@'||g_db_link||' bsc_dlg,'||
2751: ' bis_dimensions pmf_d'||
2752: ' WHERE k.dim_group_id = bsc_d.dim_group_id AND'||
2753: ' bsc_do.dim_level_id = bsc_dlg.dim_level_id AND'||
2754: ' bsc_dlg.dim_group_id = bsc_d.dim_group_id AND'||
2755: ' bsc_do.source = :1 AND'||

Line 2873: ' bis_dimensions@'||g_db_link||' d,'||

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'||
2877: ' td.short_name = d.short_name(+) AND '||

Line 2874: ' bis_dimensions td'||

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'||
2877: ' td.short_name = d.short_name(+) AND '||
2878: ' td.short_name IS NULL';

Line 2898: ' bis_dimensions@'||g_db_link||' sd,'||

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'||
2902: ' m.source = :1 AND'||

Line 2899: ' bis_dimensions td'||

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'||
2902: ' m.source = :1 AND'||
2903: ' m.short_name = i.short_name AND'||

Line 5803: -- Description is stored only in BIS_DIMENSIONS

5799: g_syncup_done := TRUE;
5800: -- ---------------------------------------------------------------------
5801:
5802: -- Bug#3138718 Description of the dimensions is not migrated
5803: -- Description is stored only in BIS_DIMENSIONS
5804: -- We need to update the description ONLY FOR BSC DIMENSIONS
5805: -- with the value from the source system
5806: IF NOT Update_BSC_Dimensions_In_PMF THEN
5807: RAISE e_unexpected_error;

Line 5865: -- AW_INTEGRATION: The BIS dimensions used in AW indicators will be loaded to AW

5861: END LOOP;
5862:
5863: -- Refresh BIS Dimension tables. The BIS dimension tables that are materialized in BSC
5864: -- will be refreshed.
5865: -- AW_INTEGRATION: The BIS dimensions used in AW indicators will be loaded to AW
5866: IF NOT BSC_UPDATE_DIM.Create_Dbi_Dim_Temp_Tables THEN
5867: RAISE e_unexpected_error;
5868: END IF;
5869: -- AW_INTEGRATION: Create temporary tables needed for AW dimension processing

Line 6285: bis_dimensions spmf_d

6281: --bug 5099776
6282: CURSOR c_dimensions (p1 NUMBER, p2 NUMBER,p3 NUMBER,p4 NUMBER) IS
6283: SELECT DISTINCT spmf_d.dimension_id
6284: FROM bsc_sys_dim_groups_vl sbsc_d,
6285: bis_dimensions spmf_d
6286: WHERE sbsc_d.short_name = spmf_d.short_name AND
6287: spmf_d.created_by NOT IN (p1, p2,p3,p4);
6288:
6289: h_dimension_id NUMBER;

Line 6328: -- Update DIM_GRP_ID to NULL in BIS_DIMENSIONS so the new dimension group id can be populated

6324: END LOOP;
6325:
6326: COMMIT;
6327:
6328: -- Update DIM_GRP_ID to NULL in BIS_DIMENSIONS so the new dimension group id can be populated
6329: -- during synchronization
6330: UPDATE bis_dimensions
6331: SET dim_grp_id = NULL;
6332:

Line 6330: UPDATE bis_dimensions

6326: COMMIT;
6327:
6328: -- Update DIM_GRP_ID to NULL in BIS_DIMENSIONS so the new dimension group id can be populated
6329: -- during synchronization
6330: UPDATE bis_dimensions
6331: SET dim_grp_id = NULL;
6332:
6333: COMMIT;
6334:

Line 6444: -- Update description of the BSC dimensions in BIS_DIMENSIONS_TL with the value

6440: h_i NUMBER;
6441:
6442: BEGIN
6443:
6444: -- Update description of the BSC dimensions in BIS_DIMENSIONS_TL with the value
6445: -- from the source system
6446: h_sql := 'UPDATE bis_dimensions_tl tdtl'||
6447: ' SET description = ('||
6448: ' SELECT sdtl.description'||

Line 6446: h_sql := 'UPDATE bis_dimensions_tl tdtl'||

6442: BEGIN
6443:
6444: -- Update description of the BSC dimensions in BIS_DIMENSIONS_TL with the value
6445: -- from the source system
6446: h_sql := 'UPDATE bis_dimensions_tl tdtl'||
6447: ' SET description = ('||
6448: ' SELECT sdtl.description'||
6449: ' FROM bis_dimensions@'||g_db_link||' sd,'||
6450: ' bis_dimensions_tl@'||g_db_link||' sdtl,'||

Line 6449: ' FROM bis_dimensions@'||g_db_link||' sd,'||

6445: -- from the source system
6446: h_sql := 'UPDATE bis_dimensions_tl tdtl'||
6447: ' SET description = ('||
6448: ' SELECT sdtl.description'||
6449: ' FROM bis_dimensions@'||g_db_link||' sd,'||
6450: ' bis_dimensions_tl@'||g_db_link||' sdtl,'||
6451: ' bis_dimensions td'||
6452: ' WHERE tdtl.dimension_id = td.dimension_id AND'||
6453: ' td.short_name = sd.short_name AND'||

Line 6450: ' bis_dimensions_tl@'||g_db_link||' sdtl,'||

6446: h_sql := 'UPDATE bis_dimensions_tl tdtl'||
6447: ' SET description = ('||
6448: ' SELECT sdtl.description'||
6449: ' FROM bis_dimensions@'||g_db_link||' sd,'||
6450: ' bis_dimensions_tl@'||g_db_link||' sdtl,'||
6451: ' bis_dimensions td'||
6452: ' WHERE tdtl.dimension_id = td.dimension_id AND'||
6453: ' td.short_name = sd.short_name AND'||
6454: ' sd.dimension_id = sdtl.dimension_id AND'||

Line 6451: ' bis_dimensions td'||

6447: ' SET description = ('||
6448: ' SELECT sdtl.description'||
6449: ' FROM bis_dimensions@'||g_db_link||' sd,'||
6450: ' bis_dimensions_tl@'||g_db_link||' sdtl,'||
6451: ' bis_dimensions td'||
6452: ' WHERE tdtl.dimension_id = td.dimension_id AND'||
6453: ' td.short_name = sd.short_name AND'||
6454: ' sd.dimension_id = sdtl.dimension_id AND'||
6455: ' tdtl.language = sdtl.language'||

Line 6460: ' bis_dimensions pmf_d, bsc_sys_dim_groups_tl bsc_d,'||

6456: ' )'||
6457: ' WHERE tdtl.dimension_id IN ('||
6458: ' SELECT DISTINCT pmf_d.dimension_id'||
6459: ' FROM bis_levels pmf_do, bsc_sys_dim_levels_vl bsc_do,'||
6460: ' bis_dimensions pmf_d, bsc_sys_dim_groups_tl bsc_d,'||
6461: ' bsc_sys_dim_levels_by_group bsc_dlg'||
6462: ' WHERE pmf_do.short_name = bsc_do.short_name AND'||
6463: ' bsc_do.source = :1 AND bsc_do.dim_level_id = bsc_dlg.dim_level_id AND'||
6464: ' bsc_dlg.dim_group_id = bsc_d.dim_group_id AND'||

Line 6493: h_sql := 'UPDATE bis_dimensions_tl d1'||

6489: FETCH h_cursor INTO h_lang_code;
6490: EXIT WHEN h_cursor%NOTFOUND;
6491:
6492: IF h_lang_code <> h_base_language THEN
6493: h_sql := 'UPDATE bis_dimensions_tl d1'||
6494: ' SET description = ('||
6495: ' SELECT description'||
6496: ' FROM bis_dimensions_tl d2'||
6497: ' WHERE d2.dimension_id = d1.dimension_id AND'||

Line 6496: ' FROM bis_dimensions_tl d2'||

6492: IF h_lang_code <> h_base_language THEN
6493: h_sql := 'UPDATE bis_dimensions_tl d1'||
6494: ' SET description = ('||
6495: ' SELECT description'||
6496: ' FROM bis_dimensions_tl d2'||
6497: ' WHERE d2.dimension_id = d1.dimension_id AND'||
6498: ' d2.language = :1'||
6499: ' ),'||
6500: ' source_lang = :2'||

Line 6505: ' bis_dimensions pmf_d, bsc_sys_dim_groups_tl bsc_d,'||

6501: ' WHERE d1.language = :3 AND'||
6502: ' d1.dimension_id IN ('||
6503: ' SELECT DISTINCT pmf_d.dimension_id'||
6504: ' FROM bis_levels pmf_do, bsc_sys_dim_levels_vl bsc_do,'||
6505: ' bis_dimensions pmf_d, bsc_sys_dim_groups_tl bsc_d,'||
6506: ' bsc_sys_dim_levels_by_group bsc_dlg'||
6507: ' WHERE pmf_do.short_name = bsc_do.short_name AND'||
6508: ' bsc_do.source = :4 AND bsc_do.dim_level_id = bsc_dlg.dim_level_id AND'||
6509: ' bsc_dlg.dim_group_id = bsc_d.dim_group_id AND'||

Line 7226: ' FROM bis_dimensions@'||g_db_link||' d,'||

7222: BSC_APPS.Add_Value_Big_In_Cond(1, g_invalid_pmf_dimensions(h_i));
7223: END LOOP;
7224:
7225: h_sql := 'SELECT DISTINCT dtl.name, d.short_name, f.application_name'||
7226: ' FROM bis_dimensions@'||g_db_link||' d,'||
7227: ' bis_dimensions_tl@'||g_db_link||' dtl,'||
7228: ' fnd_application_vl@'||g_db_link||' f'||
7229: ' WHERE d.dimension_id = dtl.dimension_id AND'||
7230: ' dtl.language = USERENV(''LANG'') AND'||

Line 7227: ' bis_dimensions_tl@'||g_db_link||' dtl,'||

7223: END LOOP;
7224:
7225: h_sql := 'SELECT DISTINCT dtl.name, d.short_name, f.application_name'||
7226: ' FROM bis_dimensions@'||g_db_link||' d,'||
7227: ' bis_dimensions_tl@'||g_db_link||' dtl,'||
7228: ' fnd_application_vl@'||g_db_link||' f'||
7229: ' WHERE d.dimension_id = dtl.dimension_id AND'||
7230: ' dtl.language = USERENV(''LANG'') AND'||
7231: ' d.application_id = f.application_id (+) AND '||h_condition;

Line 7310: ' bis_dimensions@'||g_db_link||' spmf_d'||

7306: --We will need to create/update those dimensions in the target
7307: -- seed data owner r12 bug 5099776
7308: h_sql := 'SELECT DISTINCT sbsc_d.short_name'||
7309: ' FROM bsc_sys_dim_groups_vl@'||g_db_link||' sbsc_d,'||
7310: ' bis_dimensions@'||g_db_link||' spmf_d'||
7311: ' WHERE sbsc_d.short_name = spmf_d.short_name AND'||
7312: ' spmf_d.created_by NOT IN (:1, :2, :3, :4)';
7313: OPEN h_cursor FOR h_sql USING 1, 2,120,121;
7314: LOOP

Line 7348: from bis_dimensions

7344: --check if the dimension exists in the target
7345: h_count := 0;
7346: select count(short_name)
7347: into h_count
7348: from bis_dimensions
7349: where short_name = h_dimension_short_name;
7350:
7351: IF h_count = 0 THEN
7352: -- Dimension does not exists, create it

Line 8169: -- BSC-BIS-DIMENSIONS: If the dimension is a BIS dimension we do not need to join

8165: END IF;
8166:
8167: FOR h_i IN 1..h_num_key_columns LOOP
8168: -- Bug4769877
8169: -- BSC-BIS-DIMENSIONS: If the dimension is a BIS dimension we do not need to join
8170: -- to the dimension table because the code and user_code is the same. We
8171: -- do not need to translate code into user_code
8172: SELECT source
8173: INTO h_level_source