oracle的汇总模板,Oracle EBS汇总模板建立问题处理

当建立总账汇总模板时，报错：

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

GLSTPM module: 增加/删除汇总账户

+---------------------------------------------------------------------------+

当前的系统时间为 24-08-2020 09:41:45

+---------------------------------------------------------------------------+

>> main() 24-08-2020 09:41:45

>> glsini() 24-08-2020 09:41:45

STPM0021: 默认优化系数为 0。

<< glsini() 24-08-2020 09:41:45

>> glstexs() 24-08-2020 09:41:45

<< glstexs() 24-08-2020 09:41:45

>> glsfst() 24-08-2020 09:41:45

>> open_cursor() 24-08-2020 09:41:45

<< open_cursor() 24-08-2020 09:41:45

>> load_segnum_vsid() 24-08-2020 09:41:45

<< load_segnum_vsid() 24-08-2020 09:41:45

>> do_fetch_templates() 24-08-2020 09:41:45

SHRD0108: 从 GL_SUMMARY_TEMPLATES 中取回 1 记录

<< do_fetch_templates() 24-08-2020 09:41:45

>> close_cursor() 24-08-2020 09:41:45

<< close_cursor() 24-08-2020 09:41:45

<< glsfst() 24-08-2020 09:41:45

>> glsltmp() 24-08-2020 09:41:45

>> gludlk() 24-08-2020 09:41:45

<< gludlk() 24-08-2020 09:41:45

<< glsltmp() 24-08-2020 09:41:45

>> glstexs() 24-08-2020 09:41:45

<< glstexs() 24-08-2020 09:41:45

>> glsuab() 24-08-2020 09:41:45

<< glsuab() 24-08-2020 09:41:45

>> glstadd() 24-08-2020 09:41:45

>> glucmt() 24-08-2020 09:41:45

<< glucmt() 24-08-2020 09:41:45

STPM0003: 已验证模板 "D-D-LEV1-D-D-D-D-D-D-D-D"，并已定义全部累计组。

>> glsdsh() 24-08-2020 09:41:45

SHRD0119: 从 GL_SUMMARY_HIERARCHIES 中删除 0 记录。

SHRD0119: 从 GL_SUMMARY_HIERARCHY_INT 中删除 0 记录。

>> glucmt() 24-08-2020 09:41:45

<< glucmt() 24-08-2020 09:41:45

<< glsdsh() 24-08-2020 09:41:45

>> glsdah() 24-08-2020 09:41:45

SHRD0119: 从 GL_CODE_COMBINATIONS 中删除 0 记录。

>> glucmt() 24-08-2020 09:41:45

<< glucmt() 24-08-2020 09:41:45

<< glsdah() 24-08-2020 09:41:45

>> glsash() 24-08-2020 09:41:45

SHRD0117: 把 761 记录插入 GL_SUMMARY_HIERARCHIES

>> glucmt() 24-08-2020 09:41:45

<< glucmt() 24-08-2020 09:41:45

<< glsash() 24-08-2020 09:41:45

>> glsmah() 24-08-2020 09:41:45

>> gls_fill_seg_info() 24-08-2020 09:41:45

<< gls_fill_seg_info() 24-08-2020 09:41:45

>> gls_get_max_ccid() 24-08-2020 09:41:45

>> glucmt() 24-08-2020 09:41:45

<< glucmt() 24-08-2020 09:41:45

<< gls_get_max_ccid() 24-08-2020 09:41:45

>> glstmt() 24-08-2020 09:41:45

<< glstmt() 24-08-2020 09:41:45

>> gls_csa_rollup() 24-08-2020 09:41:45

>> glsgsmi() 24-08-2020 09:41:45

SHRD0114: 正在执行 Pro*C 语句 Insert into gl_sum_int ...

SHRD0043: ERROR: ORA-00001: 违反唯一约束条件 (GL.GL_SUMMARY_INT_2_U1)

SHRD0075: 在 gls_csa_rollup() 的错误.

SHRD0075: 在 glsmah() 的错误.

SHRD0075: 在 glstadd_addtmp() 的错误.

问题处理：

通过脚本检查总账科目设置问题：

applprod:

@/u01/PROD/app/fs1/EBSapps/appl/gl/12.0.0/sql/glxacovl.sql

处理完直接的子父级后：

重新删除之前错误的模板，运行：

增加/删除汇总账户

运行完成后，重新新增模板即可。

具体sql如下：

SELECT vs.flex_value_set_name value_set_name,

fvh1.parent_flex_value ancestor,

gl_flexfields_pkg.get_parent_from_children(val.flex_value_set_id,

fvh1.parent_flex_value,

fvh1.child_flex_value_low,

fvh1.child_flex_value_high,

1) parent_flex_value,

fvh1.child_flex_value_low child_flex_value_low,

fvh1.child_flex_value_high child_flex_value_high,

gl_flexfields_pkg.get_parent_from_children(val.flex_value_set_id,

fvh1.parent_flex_value,

fvh2.child_flex_value_low,

fvh2.child_flex_value_high,

2) parent_flex_value2,

fvh2.child_flex_value_low child_flex_value_low2,

fvh2.child_flex_value_high child_flex_value_high2

FROM fnd_flex_values val,

fnd_flex_value_sets vs,

fnd_flex_value_hierarchies fvh1,

fnd_flex_value_hierarchies fvh2

WHERE val.structured_hierarchy_level IS NOT NULL

AND vs.flex_value_set_id = val.flex_value_set_id

AND fvh1.flex_value_set_id = val.flex_value_set_id

AND fvh1.parent_flex_value = val.flex_value

AND fvh2.flex_value_set_id = val.flex_value_set_id

AND fvh2.parent_flex_value = val.flex_value

AND fvh2.child_flex_value_low BETWEEN fvh1.child_flex_value_low AND fvh1.child_flex_value_high

AND (fvh2.child_flex_value_low <> fvh1.child_flex_value_low OR

fvh2.rowid < fvh1.rowid)

AND fvh2.rowid <> fvh1.rowid

ORDER BY 1, 2, 3, 4, 5, 6, 7, 8