Duplicate Summary Accounts even after Dropping and Recreating the Summary Templates
(Doc ID 422735.1)
Last updated on FEBRUARY 05, 2024
Applies to:
Oracle General Ledger - Version 11.5.10.2 and laterInformation in this document applies to any platform.
Symptoms
There are duplicate Summary Accounts on the instance. The corresponding Summary Templates have been dropped and recreated, but the duplicates still exist.
The list of duplicates can be obtained from the following query (Query is restricted to Summary Accounts, will not show the duplicate Detail Accounts if any):
SELECT *
FROM gl_code_combinations_kfv
WHERE (chart_of_accounts_id, concatenated_segments ) IN
( SELECT chart_of_accounts_id, concatenated_segments
FROM gl_code_combinations_kfv
WHERE template_id IS NOT NULL
GROUP BY chart_of_accounts_id, concatenated_segments
HAVING count(1) > 1)
ORDER BY chart_of_accounts_id, concatenated_segments;
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |