R12: PAXPREPR Personalization Not Working on Projects Form Block KEY_MEMBERS with RAISE FORM_TRIGGER_FAILURE
(Doc ID 1938274.1)
Last updated on JULY 20, 2020
Applies to:Oracle Project Foundation - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
A personalization made on the Projects form to avoid duplicate entries on the key members in 11i, does not work anymore on 12.1.3 with the same setup.
The Personalization is triggered :
Trigger event : WHEN-VALIDATE-RECORD
Trigger Object: KEY_MEMBERS
Condition: <sql code to check duplicate roles> AND :SYSTEM.RECORD_STATUS in ('CHANGED', 'NEW', 'INSERT')
with the Actions:
# Action 1 : A form Message
# Action 2 Type: Built in
with Built in Type: RAISE FORM_TRIGGER_FAILURE
But, it appears that the record is saved as the second action is never raised.
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