When-Validate-Record Personalization Runs Multiple Times on a Price List Using Forms Personalization (Doc ID 2521940.1)

Last updated on FEBRUARY 05, 2024

Applies to:

Symptoms

On : 12.1.3 version, Pricing, Discounting & Charges

ACTUAL BEHAVIOR
We have an requirement, in price list enter or update price form we set personalization.
The personlization is to verify the data, then popup the message based on the result.
We use WHEN-VALIDATE-RECORD trigger, but it's popup message 4 times and above .
Please tell me how to control it to once. Or how to meet this requirement via personalization.
That is, enter or update the data for each row, it takes verify, then popup message.

EXPECTED BEHAVIOR
The validation error from personalization display only once.

STEPS
The issue can be reproduced at will with the following steps:

1. (N)OM > Pricing > Price Lists > Price List Setup
   Go to Help -> Diagnostics -> Custom Code -> Personalize
   
   
2. Function Name:QP_QPXPRLST
   Form Name:QPXPRLST
   
   
3. Condition
   Trigger Event:WHEN-VALIDATE-RECORD
   Trigger Object:LIST_LINES
   Condition:
   :LIST_LINES.OPERAND > 100
   Processing Mode:Not in Enter-Query Mode
   
   
4. Actions
   Seq:10
   Type:Message
   MessageType:Show
   Message Text:Price was updated.
   
   
5. At Price List Setup screen,update the 'Value' field to 101.
6. The Error message 'The Price was updated' poped up and press OK button.
7. The message still in the screen before I click the button 4 times.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.