Create Accounting for Process Category = Receipts Performs Poorly When Distribution Volumes are High
Last updated on FEBRUARY 13, 2018
Applies to:Oracle Receivables - Version 12.1.2 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
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.
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