189 8069 5689

HOWTOIDENTITYMISCLASSIFIEDCCID


How to Identify Account Code Combinations That Are Misclassified And Have An Account_type Different From Account (文档 ID 259210.1) HOW TO IDENTITY MISCLASSIFIED CCID

Applies to:

Oracle General Ledger - Version 11.5.10.2 and later
Information in this document applies to any platform.

Goal

How to identify account code combinations which have a different account_type to that defined in the Account Flexfield Segment Value, in order to prevent balance problems related to misclassified accounts in the beginning of a new year?

创新互联建站主营龙游网站建设的网络公司,主营网站建设方案,App定制开发,龙游h5微信平台小程序开发搭建,龙游网站营销推广欢迎龙游等地区企业咨询

Solution

The following script should be able to identify the misclassified code combinations.

You need to enter the set of books short name (sobname) and the segment number representing the position of the account segment (segnum).

Query for R11i:

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_sets_of_books b
where
b.short_name = '&SOBNAME' 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) ;  

 

Query for R12:

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' 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) ;                                                                       


The identified code combinations need to be fixed before the opening of the first period of the new year, otherwise you may need to follow steps from Note:1050920.6

This sql identifies additional sets of books which may also need correcting :

SELECT glsob.name,
glsob.short_name,
glsob.set_of_books_id
FROM gl_sets_of_books glsob
WHERE glsob.chart_of_accounts_id = &ChartOfAccountsId;

当前名称:HOWTOIDENTITYMISCLASSIFIEDCCID
网页路径:http://cdxtjz.cn/article/gshhco.html

联系我们

您好HELLO!
感谢您来到成都网站建设公司,若您有合作意向,请您为我们留言或使用以下方式联系我们, 我们将尽快给你回复,并为您提供真诚的设计服务,谢谢。
  • 电话:028- 86922220 18980695689
  • 商务合作邮箱:631063699@qq.com
  • 合作QQ: 532337155
  • 成都网站设计地址:成都市青羊区锣锅巷31号五金站写字楼6楼

小谭建站工作室

成都小谭网站建设公司拥有多年以上互联网从业经验的团队,始终保持务实的风格,以"帮助客户成功"为已任,专注于提供对客户有价值的服务。 我们已为众企业及上市公司提供专业的网站建设服务。我们不只是一家网站建设的网络公司;我们对营销、技术、管理都有自己独特见解,小谭建站采取“创意+综合+营销”一体化的方式为您提供更专业的服务!

小谭观点

相对传统的成都网站建设公司而言,小谭是互联网中的网站品牌策划,我们精于企业品牌与互联网相结合的整体战略服务。
我们始终认为,网站必须注入企业基因,真正使网站成为企业vi的一部分,让整个网站品牌策划体系变的深入而持久。