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 JULY 27, 2017

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms