My Oracle Support Banner

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

Last updated on MARCH 04, 2019

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 (XML) 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=

...

:DebugFlag=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=,
...}
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  EBSAPP301 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

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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