My Oracle Support Banner

R12:AP:Will Upgrade Perform Faster by Pre-Allocating Extent To AP_INVOICE_DISTRIBUTIONS_ALL ? (Doc ID 1900725.1)

Last updated on FEBRUARY 25, 2021

Applies to:

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


Looking for out of the box ideas to cut down the timeline for an R12 upgrade.

Currently size is 750 million rows in the AP_INVOICE_DISTRIBUTIONS_ALL table
and another 700 million rows in the AP_CHRG_ALLOCATIONS table.

Would it make a substantial difference in the upgrade time
if space is pre-allocated to AP_INVOICE_DISTRIBUTIONS_ALL ?


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

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