My Oracle Support Banner

Summary Account Balances Not Updated With Balances of New Detail Account Combination (Doc ID 1552114.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle General Ledger - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

Creating a new detail account and posting to this combination, does not update the balances of summary account.

The issue persists even after running the concurrent requests below:

Program - Incremental Add/Delete Summary Templates
Program - Maintain Summary Templates

Also, for the new detail code combinations created, the gl_account_hierarchies table is updated having the new records inserted with :
- negative template_id for the summary accounts that should be updated
- negative set_of_books_ID corresponding to the same records created

This can be determined by the query below:

select *
from gl_account_hierarchies
where detail_code_combination_id=&new_detail_CCID;

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.