Introduction:
Encountering an issue where the Concurrent Request Report Output from the Oracle Report Manager Homepage dashboard redirects to the DMZ node instead of the primary node can be frustrating. This blog post provides two solutions, a permanent fix requiring downtime and a temporary fix with no downtime.

Navigation:
ORACLE*Report Manager Home Page –> Dashboard –> Output –> View Report Now

Cause:
The values for the profile’s are updated from DMZ node instead of PRIMARY node.

Permanent Fix (Solution 1):
========================

Step 1 :Run the following SQL query to identify the profile values
——————————————————————————-
SELECT
fpot.user_profile_option_name NAME,
DECODE (fpov.level_id,
10001, ‘Site’,
10002, ‘Application’,
10003, ‘Responsibility’,
10004, ‘User’,
10005, ‘Server’,
‘UnDef’)
LEVEL_SET,
fpov.profile_option_value VALUE
FROM fnd_profile_options fpo,
fnd_profile_option_values fpov,
fnd_profile_options_tl fpot,
fnd_user fu,
fnd_application fap,
fnd_responsibility frsp,
fnd_nodes fnod,
hr_operating_units hou
WHERE fpo.profile_option_id = fpov.profile_option_id(+)
AND fpo.profile_option_name = fpot.profile_option_name
AND fu.user_id(+) = fpov.level_value
AND frsp.application_id(+) = fpov.level_value_application_id
AND frsp.responsibility_id(+) = fpov.level_value
AND fap.application_id(+) = fpov.level_value
AND fnod.node_id(+) = fpov.level_value
AND hou.organization_id(+) = fpov.level_value
AND fpot.user_profile_option_name like ‘%Agent’
and fpov.level_id = 10001
ORDER BY 1,2;

 

The query will returns profile values related to DMZ node as given below
—————————————————————————————

Profile Option Name                             Site                              Profile Options Value
======================   ======    =======================================
Application Framework Agent       Site             https://DMZhostname.domainname:port
Applications JSP Agent                   Site             https://DMZhostname.domainname:port
Applications Web Agent                  Site             https://DMZhostname.domainname:port/pls/SID
Apps Servlet Agent                           Site             https://DMZhostname.domainname:port:/OA_HTML

Step 2: Update Profile Values
Update the profile values related to the DMZ node with those of the primary node by running autoconfig in primary node only as shown below.

(i) Shutdown DMZ node application services
(ii) Shutdown PRIMARY node application services
(iii) Run “AUTOCONFIG” only in EBS primary node.
(iv) Start PRIMARY node application services.
(v) Start DMZ node application services.

Step 3: Verify Profile Values
Rerun the query to ensure the profile values now point to the primary node.

Profile Option Name                     Site                              Profile Options Value
===================    =======      ======================================
Application Framework Agent       Site         https://PRIMARYhostname.domainname:port
Applications JSP Agent                   Site          https://PRIMARYhostname.domainname:port
Applications Web Agent                  Site          https://PRIMARYhostname.domainname:port/pls/SID
Apps Servlet Agent                           Site          https://PRIMARYhostname.domainname:port:/OA_HTML

Step 4: Confirm Resolution
Clicking on “View Report Now” from the Report Manager Homepage dashboard should now display the correct concurrent request output.

[OR]

Temporary Fix (Solution 2):
====================
Step 1:

Update the profile values related to the primary node through the EBS front-end application at the SITE level as shown below

Profile Option Name                     Site                              Profile Options Value
===================    =======      ======================================
Application Framework Agent       Site         https://PRIMARYhostname.domainname:port
Applications JSP Agent                   Site          https://PRIMARYhostname.domainname:port
Applications Web Agent                  Site         https://PRIMARYhostname.domainname:port/pls/SID
Apps Servlet Agent                           Site          https://PRIMARYhostname.domainname:port:/OA_HTML

Step 2: Bounce Workflow Directory Services
Bounce workflow directory services .

Conclusion:
Choose the appropriate solution based on your operational requirements. The permanent fix ensures a long-term resolution but requires downtime, while the temporary fix provides a quick solution without service disruption. Always perform these actions in a controlled environment and back up critical data before making changes.

 

Recent Posts

Start typing and press Enter to search