PIPER-Rx - PAM V4 Bug Fixes

PIPER-Rx
Oracle E-Business Suite Resource Centre

PAM Version 4 Bugs and Fixes

Report a Bug

PAM Bugs

This page lists all PAM Version 4 bugs as they are found and actioned.

Note: All Fixes relate to PAM version 4 only. You must have installed PAM version 4 before applying any of the fixes.

Note: As the fixes are accumulative within a version, you can re-apply a stored procedure and or report to fix any additional issues that have been fixed since the last time you updated a procedure or report.

All fixes can be applied independently unless otherwise stated.

Bug Description Fix Date Details ( Severity ) Status
PAMappview - Running requests drill down and PAMreports PAMADCR001 Running Requests are not
displaying running requests where the requests manager process no longer exists
Jan-14 40001 (4) Download

BUG DETAILS

BUG - 40001

PAMappview - Running requests drill down and PAMreports PAMADCR001 Running Requests are not
displaying running requests where the requests manager process no longer exists.

Source Date Severity Bug Type
PIPER_RX_PAM_WEB_PAGES.pkb
PIPER_RX_PAM_REPORTS_ADMIN.pkb
Jan-14
4
PAMAppview
PAMreports

Bug Description:
It was reported that PAMappview main page showed five (5) running requests whereas the running requests drilldown showed only one (1) running request, The PAMreports report PAMADCR001 Running Requests also showed only 1 running request.

Cause:
An instance arose where a request set was terminated abnormally leaving the multiple request set stages in a status of Running Paused. As the concurrent managers had been restarted, the manager processes that were assigned to run the request set stages no longer exists. The fnd_concurrent_requests.controlling_manager attribute did not have a corresponding value in the fnd_concurrent_processes table as the manager process no longer exists.

Solution:
Whilst this is an abnormal occurrence both PIPER_RX_PAM_WEB_PAGES and PIPER_RX_PAM_REPORTS_ADMIN packages have been modified to reflect this abnormal running state and display the requests running manager as * UNKNOWN *.