Unable To Open Notications From Custom Workflow Administrator Responsibility (Doc ID 1418275.1)

Last updated on FEBRUARY 03, 2014

Applies to:

Oracle Workflow Cartridge - Version 12.1.2 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms


Using the Oracle Applications release 12.1.2, created a Custom Responsibility to access HR records in a limited manner.  This was done to have role that does not have full access to HR records.

This works fine except when the user is trying to Open a Notification, the system hangs (blank screen and status bar does not move).

STEPS
----------
Responsibility: Custom Workflow Administrator
Navigation: Administrator Workflow / Status Monitor
Steps:
1. Enter Item key as ˜OEOL™ and user key as ˜%item_key%
2. Select the search results and Click on ˜Activity History
3. Click the œOpen link in the Status Monitor and system hangs.

During the problem, the following SQL is trying to run, but is high in cost:


RELATED SQL QUERY
-------------------------
SELECT *
FROM (SELECT workflowitemeo.item_type, workflowitemeo.item_key,
workflowitemeo.root_activity,
activityeo.display_name process_name,
workflowitemeo.root_activity_version,
workflowitemeo.owner_role, workflowitemeo.parent_item_type,
workflowitemeo.parent_item_key,
workflowitemeo.parent_context, workflowitemeo.begin_date,
workflowitemeo.end_date, workflowitemeo.user_key,
workflowitemtypeeo.NAME, workflowitemtypeeo.display_name,
wf_directory.getroledisplayname2
(workflowitemeo.owner_role)
AS role_name,
wf_fwkmon.getitemstatus
(workflowitemeo.item_type,
workflowitemeo.item_key,
workflowitemeo.end_date,
workflowitemeo.root_activity,
workflowitemeo.root_activity_version
) AS status_code,
wf_fwkmon.getroleemailaddress
(workflowitemeo.owner_role)
AS role_email,
DECODE
((SELECT COUNT (0)
FROM wf_items wi2
WHERE workflowitemeo.item_type = wi2.parent_item_type
AND workflowitemeo.item_key = wi2.parent_item_key),
0, 'WfMonNoChildren',
'WfMonChildrenExist'
) AS child_switcher
FROM wf_items workflowitemeo,
wf_item_types_vl workflowitemtypeeo,
wf_activities_vl activityeo
WHERE workflowitemeo.item_type = workflowitemtypeeo.NAME
AND activityeo.item_type = workflowitemeo.item_type
AND activityeo.NAME = workflowitemeo.root_activity
AND activityeo.VERSION = workflowitemeo.root_activity_version)
WHERE ((EXISTS (
SELECT NULL
FROM fnd_grants gnt
WHERE gnt.grant_guid IN
(HEXTORAW ('B5B217F7C56A00AAE043AABF0ED500AA'))
AND item_type NOT IN (gnt.parameter1, gnt.parameter2))
)
)
ORDER BY begin_date DESC;

Changes

Created a Read-Only HR Role

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