oracle ebs r12设置科目组合交叉验证,Oracle ebs 交叉验证规则导出

–已测试(两段均可)，请变更账套名

select x.flex_validation_rule_name,

x.description,

h.include_exclude_indicator,

h.concatenated_segments_low,

h.concatenated_segments_high

from apps.fnd_flex_vdation_rules_vl      x,

apps.fnd_flex_validation_rule_lines h,

gl_ledgers                          g

where 1 = 1

and x.id_flex_num = g.chart_of_accounts_id

and x.flex_validation_rule_name = h.flex_validation_rule_name

and (h.id_flex_code = 'GL#')

and (h.application_id = 101)

and g.name = 'FIN_Ledger'

order by x.flex_validation_rule_name;

SELECT FFCV.APPLICATION_NAME,

FFCV.FLEX_STRUCTURE_NAME,

FFVV.FLEX_VALIDATION_RULE_NAME,

FFVV.DESCRIPTION,

FFVV.ERROR_MESSAGE_TEXT 错误信息,

DECODE(FFVL.INCLUDE_EXCLUDE_INDICATOR, 'I', '包括', '排除'