My Oracle Support Banner

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

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Advanced Pricing - Version 12.1.3 and later
Information in this document applies to any platform.

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.

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.