R12 Performance issue when clicking 'Monitor Request' after Submitting Concurrent Requests

In R12, when clicking on the 'Monitor requests' button after submitting a request, It is taking longer time for this screen to open. This performance issue can be reproduced when invoking the standard concurrent request submission (or) View request page  from Oracle Application Framework (OAF) from various modules like Quoting, Report Manager, etc.

Solution

To implement the solution, please execute the following steps:

1. Download and review the readme and pre-requisites for Patch 9747291
2. Ensure that you have taken a backup and Apply the patch in a test environment. .
3. Confirm the following file versions

RequestSummarySearchVO.xml  120.14.12010000.3

You can use the commands like the following:

strings -a $JAVA_TOP/oracle/apps/fnd/cp/viewreq/server/RequestSummarySearchVO.xml | grep Header

4. Retest the issue.
5. Migrate the solution as appropriate to other environments.