Create Accounting for Process Category = Receipts Performs Poorly When Distribution Volumes are High (Doc ID 1677098.1)

Last updated on JUNE 08, 2016

Applies to:

Oracle Receivables - Version 12.1.2 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Subledger Accounting Uptake for Receivables

Create accounting performs poorly and does not complete for Process Category = Receipts when there are 1.2 million distribution lines for a receipt.

Steps to Reproduce:
1. Create a Transaction with thousands of lines and post to GL.
2. Create Adjustments for each transaction line and post to GL.
3. Apply a Receipt (one application) to this transaction.
This results in three (3) rows in the Applications table, and 1.2 million rows in the Distributions table.

MFAR (Multi Fund Accounts Receivable) is being utilized in this situation.

Cause

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