真实的国产乱ⅩXXX66竹夫人,五月香六月婷婷激情综合,亚洲日本VA一区二区三区,亚洲精品一区二区三区麻豆

成都創(chuàng)新互聯(lián)網(wǎng)站制作重慶分公司

HOWTOIDENTITYMISCLASSIFIEDCCID

    <del id="waoc4"><sup id="waoc4"></sup></del>
    <abbr id="waoc4"></abbr><ul id="waoc4"><sup id="waoc4"></sup></ul><abbr id="waoc4"></abbr>
    			
    							
    			    							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定制開發(fā),龍游h5微信平臺(tá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            
    
            當(dāng)前網(wǎng)址：http://weahome.cn/article/gshhco.html
        
    





    
    
    
        
    
            
                
                
    在線咨詢
    
                
        
    
    
    
    
    
        
    微信咨詢
    
        
    
    
    
    
    
        
    電話咨詢
    
        
    
            
    028-86922220（工作日）
    
            
    18980820575（7×24）
    
        
    
    
    
    
    
        
    
            
                
    提交需求
    
                
        
    
    
    
    
    
        
    
            
                
    返回頂部
    
                
        
    
    
    

    






      • <strike id="waoc4"><rt id="waoc4"></rt></strike>
      <ul id="waoc4"><sup id="waoc4"></sup></ul>