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

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?
    創(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;
                
    
                標(biāo)題名稱：HOWTOIDENTITYMISCLASSIFIEDCCID
                
    
                文章來(lái)源：http://www.chinadenli.net/article20/gshhco.html
            
    
            
    
                成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供網(wǎng)站收錄、全網(wǎng)營(yíng)銷推廣、品牌網(wǎng)站制作、商城網(wǎng)站、云服務(wù)器、服務(wù)器托管            
    
            
    
                廣告
                
            
    
            
    
                聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來(lái)源：
                創(chuàng)新互聯(lián)