In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-04-02 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Internet Technology >
Share
Shulou(Shulou.com)06/02 Report--
How to Identify Account Code Combinations That Are Misclassified And Have An Account_type Different From Account (document 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?
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.valued attributes attributes5 and 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.exact valueattributes5); 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.valued attributes attributes5 and 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.published valuewriting attributes5Phone1)
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
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.