My Oracle Support Banner

R12 : How to Rebuild Trial Balance Table XLA_TRIAL_BALANCES for Specific Events Instead of Rebuilding the Entire Definition (Doc ID 1947736.1)

Last updated on JUNE 11, 2024

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

Overview: AP Trial Balance Net Change Effect
When we have some changes due to a datafix for a limited number of transactions, it is painful to go through the entire run of a typical rebuild.  It takes time to rebuild the entire Trial Balance -- depending on your volume, it can take hours.  This is time-consuming activity during the Period Close -- any time saved during the Period Close is always welcomed.

Advantage: With this Patch we can complete the New AP Trial Balance Rebuild in a much shorter time, because it rebuilds only the transactions that were affected by the datafix.

Solution

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
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.