R12 : Performance Problem with Receiving Account Distribution Report (XML) (Doc ID 2166633.1)

Last updated on JULY 29, 2016

Applies to:

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

Symptoms

On : 12.1.3 version, Reports - PO and RCV

Receiving Account Distribution Report (XML) - Performance issue

When running Receiving Account Distribution Report (XML) report one inventory organization for just one day 20-Jan-2016. The report is running is not completing.

ERROR
-----------------------
POXRRVDR_XML module: Receiving Account Distribution Report (XML)
+---------------------------------------------------------------------------+

Current system time is 02-JUN-2016 13:13:41

+---------------------------------------------------------------------------+

XDO Data Engine Version No: 5.6.3
Resp: 50967
Org ID : 85
Request ID: 17893483
All Parameters: P_TITLE=:P_SORT_OPTION=ACCOUNT AND ITEM:P_ORG_ID=99:P_DATE_FROM="2016/01/01 00:00:00":P_DATE_TO="2016/05/25 00:00:00":P_ITEM_FROM=:P_ITEM_TO=:P_CATEGORY_SET=1100000041:P_STRUCT_NUM=201:P_CATEGORY_FROM=:P_CATEGORY_TO=:P_VENDOR_FROM=:P_VENDOR_TO=:P_RECEIPT_NUM_FROM=:P_RECEIPT_NUM_TO=:P_CHART_OF_ACCOUNTS_ID=50348:P_ACCOUNT_FROM=:P_ACCOUNT_TO=:P_QTY_PRECISION=2:DebugFlag=N
Data Template Code: POXRRVDR_XML
Data Template Application Short Name: PO
Debug Flag: N
{P_RECEIPT_NUM_FROM=, P_CATEGORY_TO=, P_ITEM_TO=, P_RECEIPT_NUM_TO=, P_TITLE=, P_DATE_FROM=2016/01/01 00:00:00, P_CATEGORY_SET=1100000041, P_ACCOUNT_FROM=, P_CHART_OF_ACCOUNTS_ID=50348, P_SORT_OPTION=ACCOUNT AND ITEM, P_VENDOR_FROM=, P_QTY_PRECISION=2, P_ORG_ID=99, P_VENDOR_TO=, P_STRUCT_NUM=201, P_CATEGORY_FROM=, P_ITEM_FROM=, P_ACCOUNT_TO=, P_DATE_TO=2016/05/25 00:00:00}
Calling XDO Data Engine...
****Warning!!! Due to high volume of data, got out of memory exception...***
****Please retry with scalable option or modify the Data template to run in scalable mode...***


Steps to Reproduce :
-----------------------
1. Navigate to request submission form
2. Submit Receiving Account Distribution Report (XML)

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