My Oracle Support Banner

Notification Preference for PQH_ROLE are all set as QUERY After Running 'Synchronize WF LOCAL tables' (Doc ID 793287.1)

Last updated on NOVEMBER 03, 2023

Applies to:

Oracle Self-Service Human Resources - Version 11.5.10.2 to 12.2.2 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.
pqhwfsy.odf 115.4


Symptoms

-- Problem Statement:
Find that running 'Synchronize WF LOCAL tables' resets the notification preference to QUERY.

EXPECTED BEHAVIOR
Expect the notification preference to remain MAILHTML as set by
update apps.wf_local_roles
set notification_preference = 'MAILHTML'
where name like 'PQH_ROLE%';

commit;

exec FND_PREFERENCE.put('PQH_ROLE', 'WF', 'MAILTYPE', 'MAILHTML');

commit;

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1.update apps.wf_local_roles
set notification_preference = 'MAILHTML'
where name like 'PQH_ROLE%';

commit;

exec FND_PREFERENCE.put('PQH_ROLE', 'WF', 'MAILTYPE', 'MAILHTML');

commit;

2. run concurrent request 'Synchronize WF LOCAL tables '
see that preference is reset to QUERY


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.