Tel：028-86922220 我有需求

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://bzwzjz.com/article/gshhco.html

其他资讯

Copyright © 2007-2020 广东宝晨空调科技有限公司 All Rights Reserved 粤ICP备2022107769号
友情链接： 重庆电商网站建设 成都企业网站制作 重庆网站建设 重庆网站制作 重庆企业网站建设 成都网站建设公司 网站制作 定制级高端网站建设 成都网站建设 手机网站制作设计 定制网站设计 成都网站设计公司 营销型网站建设 手机网站制作 成都网站建设 网站建设推广 成都网站设计 成都网站制作 手机网站建设套餐 响应式网站设计 自适应网站建设 H5网站制作 

    • 微信扫一扫在线咨询