Post date: Mar 15, 2019 8:5:51 AM
Check using this script:
SELECT c.chart_of_accounts_id coa,
c.concatenated_segments code_combination,
c.code_combination_id ccid,
c.gl_account_type type_is,
SUBSTR (v.compiled_value_attributes, 5, 1) should_be
FROM gl_code_combinations_kfv c,
fnd_flex_values v,
fnd_id_flex_segments s,
gl_ledgers b
WHERE b.short_name = '&LEDGERNAME' --NFI_LEDGER(IDR)
AND c.chart_of_accounts_id = s.id_flex_num
AND c.template_id IS NULL
AND c.chart_of_accounts_id = b.chart_of_accounts_id
AND s.application_id = 101
AND s.id_flex_code = 'GL#'
AND s.segment_num = &segnum
AND s.flex_value_set_id = v.flex_value_set_id
AND v.flex_value = c.segment&segnum
AND c.gl_account_type != SUBSTR (v.compiled_value_attributes, 5, 1);
Then run the script in attachment
Regards,
Iwan