HOWTOIDENTITYMISCLASSIFIEDCCID

How to Identify Account Code Combinations That Are Misclassified And Have An Account_type Different From Account (文檔 ID 259210.1)

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?

創(chuàng)新互聯(lián)建站主營(yíng)龍游網(wǎng)站建設(shè)的網(wǎng)絡(luò)公司,主營(yíng)網(wǎng)站建設(shè)方案,App定制開(kāi)發(fā),龍游h5微信平臺(tái)小程序開(kāi)發(fā)搭建,龍游網(wǎng)站營(yíng)銷推廣歡迎龍游等地區(qū)企業(yè)咨詢

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

其他資訊

日韩精品无码一区二区三区不卡,精品无码三级在线观看视频,国产精品民宅偷窥盗摄,国产成人精品亚洲日本在线,久久人人爽人人爽人人爽,粉嫩人国产呦系列(634),精品少妇人妻AV一区二区三区,无码专区—VA亚洲V天堂麻豆,亚洲1卡2卡三卡4卡网站老狼,无码八A片人妻少妇久久,国产在线拍揄自揄拍无码,久久久久亚洲国产AV麻豆,一区二区三区精品视频免费播放,大杳焦伊人久久综合福利,无码免费人妻A片AAA毛片,精人妻无码一区二区三区,精品欧美一区二区在线观看

網(wǎng)站建設(shè)知識(shí)

HOWTOIDENTITYMISCLASSIFIEDCCID

Applies to:

Goal

Solution

其他資訊