Hi,

We are using PARALLEL hint very regularly. But, for some reason, it is not using PARALLEL hint only for the following query.

SELECT /*+ PARALLEL(glcc,6) */
glcc.segment3 A_ARC,
glcc.segment1 Fund,
tl.hierarchy_name Begin_Line,
SUBSTR(l.attribute9,1,4),
glcc.segment2 ,
0 Budget,
0,
0,
0,
(DECODE(NVL(SUBSTR(l.attribute9,5,1),glp.quarter_num),'1',NVL(l.accounted_dr,0) - NVL(l.accounted_cr,0))) Exp_Quarter1,
(DECODE(NVL(SUBSTR(l.attribute9,5,1),glp.quarter_num),'2',NVL(l.accounted_dr,0) - NVL(l.accounted_cr,0))) Exp_Quarter2,
(DECODE(NVL(SUBSTR(l.attribute9,5,1),glp.quarter_num),'3',NVL(l.accounted_dr,0) - NVL(l.accounted_cr,0))) Exp_Quarter3,
(DECODE(NVL(SUBSTR(l.attribute9,5,1),glp.quarter_num),'4',NVL(l.accounted_dr,0) - NVL(l.accounted_cr,0))) Exp_Quarter4,
0,0,0,0
FROM gl_je_lines l,
gl_je_headers h,
gl_code_combinations glcc,
gl_periods glp
,fnd_flex_value_hierarchies f
,fnd_flex_values v
,fnd_flex_hierarchies_tl tl
WHERE
glcc.code_combination_id = l.code_combination_id
and glcc.chart_of_accounts_id = :chart_of_Accounts_id
and glcc.segment10 NOT LIKE 'ZZ%'
AND glcc.segment2 BETWEEN f.child_flex_value_low AND f.child_flex_value_high
AND glcc.summary_flag = 'N'
AND f.flex_value_set_id = :sac_value_Set_id
AND f.parent_flex_value = v.flex_value
AND v.flex_value_set_id = :sac_value_set_id
AND v.summary_flag = 'Y'
AND v.structured_hierarchy_level = tl.hierarchy_id
AND tl.hierarchy_name LIKE '%-%'
AND l.period_name = glp.period_name
AND (
(glp.period_year = :fiscal_year AND :fiscal_year = eriod_year AND glp.period_num <= :begin_num)
OR
-- newly added for different year logic
(TRUNC(l.effective_date) BETWEEN '01-JUL-'||TO_CHAR(TO_DATE(:P_EXPENDITURE_DATE),'YY') AND '01-'||TO_CHAR(TO_DATE(:P_EXPENDITURE_DATE),'MON-YY'))
)
AND SUBSTR(l.attribute9,1,4) = :fiscal_year -- BUDGET YEAR
AND l.je_header_id = h.je_header_id
AND h.actual_Flag IN ('A')
AND h.je_source IN ('1','Manual','Spreadsheet')

If I simply use PARALLEL hint in say

select /*+ PARALLEL(glcc,6) */ segment2 from gl_code_combinations glcc

then, it shows PARALLEL operation in its Explain Plan.

Pl. advise.

Thanks,