Receiving Transactions Register (XML) is Running for Very Long Duration (Doc ID 2228608.1)

Last updated on JANUARY 31, 2017

Applies to:

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

Symptoms

On : 12.2.4 version, Reports - PO and RCV

Receiving Transactions Register (XLM) is running for very long duration.
Sometimes it is taking more than a day.

Note:
1. It takes long time to complete but there is no error in the log.
2. The report output is created without error.
3. 'Receiving Transaction Register' report is completing within 1 min with same parameters.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Purchasing User responsibility: Reports> Run
2. Run 'Receiving Transactions Register (XML)'
3. It is running for very long duration. Sometimes it is taking more than a day.

REPORT LOG
-------------------

Current system time is 19-SEP-2016 04:55:25

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

XDO Data Engine Version No: 10.1.3.4.2
Resp: 51009
Org ID : 101
Request ID: 4940301
All Parameters: P_TITLE=:P_ORG_ID=121:P_TRX_TYPE=:P_TRX_DATE_FROM="2016/07/31
00:00:00":P_TRX_DATE_TO="2016/08/27
23:59:59":P_RECEIPT_NUM_FROM=:P_RECEIPT_NUM_TO=:P_RECEIVER=:P_ITEM_FROM=:P_ITE
M_TO=:P_STRUCT_NUM=201:P_CATEGORY_FROM=I...:P_CATEGORY_TO=I...:P_VENDOR_FROM=W
HITE DISTRIBUTION SUPPLY:P_VENDOR_TO=WHITE DISTRIBUTION
SUPPLY:P_PO_NUM_FROM=:P_PO_NUM_TO=:P_BUYER_NAME=:P_REQ_NUM_FROM=:P_REQ_NUM_TO=
:P_SHIP_NUM_FROM=:P_SHIP_NUM_TO=:P_EXCEPTION=:P_DETAIL_SUMMARY=Y:P_INC_LOT_AND
_SERIAL=N:P_CUSTOMER_FROM=:P_CUSTOMER_TO=:P_RMA_NUM_FROM=:P_RMA_NUM_TO=:DebugF
lag=N
Data Template Code: RCVTXRTR_XML
Data Template Application Short Name: PO
Debug Flag: N
{P_EXCEPTION=, P_SHIP_NUM_FROM=, P_TRX_DATE_TO=2016/08/27 23:59:59,
P_RECEIPT_NUM_FROM=, P_INC_LOT_AND_SERIAL=N, P_SHIP_NUM_TO=,
P_CATEGORY_TO=I..., P_ITEM_TO=, P_RECEIPT_NUM_TO=, P_TITLE=,
P_DETAIL_SUMMARY=Y, P_RMA_NUM_TO=, P_BUYER_NAME=, P_PO_NUM_TO=, P_RECEIVER=,
P_PO_NUM_FROM=, P_RMA_NUM_FROM=, P_VENDOR_FROM=WHITE DISTRIBUTION SUPPLY,
P_REQ_NUM_FROM=, P_CUSTOMER_FROM=, P_CUSTOMER_TO=, P_ORG_ID=121,
P_REQ_NUM_TO=, P_VENDOR_TO=WHITE DISTRIBUTION SUPPLY, P_STRUCT_NUM=201,
P_CATEGORY_FROM=I..., P_ITEM_FROM=, P_TRX_TYPE=, P_TRX_DATE_FROM=2016/07/31
00:00:00}
Calling XDO Data Engine...
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+

+---------------------------------------------------------------------------+
Executing request completion options...

Output file size:
3504659

+--------- 1) POST-PROCESSING ---------+
Beginning post-processing of request 4940301 on node HNIEBSAPP301 at
19-SEP-2016 04:56:10.
-- Publishing output

Post-processing of request 4940301 completed at 19-SEP-2016 11:18:00.

CONC-POST-PROCESSING RESULTS

-- PUBLISH:
CONC-OPP-XMLPUB SUCCESS
+---------------------------------------+

Finished executing request completion options.

+---------------------------------------------------------------------------+
Concurrent request completed successfully
Current system time is 19-SEP-2016 11:18:00

 

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