R12: PAXPREPR Personalization Not Working on Projects Form Block KEY_MEMBERS with RAISE FORM_TRIGGER_FAILURE
Last updated on MARCH 08, 2017
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.
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