| 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 laterInformation in this document applies to any platform. GoalHow 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微信平台小程序开发搭建,龙游网站营销推广欢迎龙游等地区企业咨询 SolutionThe following script should be able to identify the misclassified code combinations. 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) ;
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
成都网站建设公司_创新互联,为您提供网站收录、全网营销推广、品牌网站制作、商城网站、云服务器、服务器托管 声明:本网站发布的内容(图片、视频和文字)以用户投稿、用户转载内容为主,如果涉及侵权请尽快告知,我们将会在第一时间删除。文章观点不代表本网站立场,如需处理请联系客服。电话:028-86922220;邮箱:631063699@qq.com。内容未经允许不得转载,或转载时需注明来源: 创新互联 猜你还喜欢下面的内容 ![]()
|