欧美一区二区三区老妇人-欧美做爰猛烈大尺度电-99久久夜色精品国产亚洲a-亚洲福利视频一区二区

HOWTOIDENTITYMISCLASSIFIEDCCID

<table id="qemwa"></table>
			
							
										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?
創(chuàng)新互聯(lián)建站主營龍游網(wǎng)站建設(shè)的網(wǎng)絡(luò)公司,主營網(wǎng)站建設(shè)方案,App定制開發(fā),龍游h5微信平臺小程序開發(fā)搭建,龍游網(wǎ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://chinadenli.net/article20/gshhco.html
            

            

                成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供網(wǎng)站收錄、全網(wǎng)營銷推廣、品牌網(wǎng)站制作、商城網(wǎng)站、云服務(wù)器、服務(wù)器托管            

            

                廣告
                
            

            

                聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時需注明來源：
                創(chuàng)新互聯(lián)