DEFAULT_WHERE Does Not Work On the Price List Setup Form (Doc ID 1635940.1)

Last updated on MARCH 21, 2014

Applies to:

Oracle Advanced Pricing - Version 12.1.3 and later
Information in this document applies to any platform.
price list setup form - QPXPRLST.fmb

Symptoms

On : 12.1.3 version, Price List

ACTUAL BEHAVIOR
---------------
The Default_where in the forms personalization for the price list setup form (QPXPRLST.fmb) on the List_Lines block does not work.

EXPECTED BEHAVIOR
-----------------------
The default_where works for all other blocks but this one.
Hence expect that is should be consistent in the application and also work for this form.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
The form personalization is as follows:



BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, they cannot control what is shown for users.

Changes

<Bug 18111125> : FORM PERSONALIZATION DEFAULT_WHERE DOESN'T WORK ON PRICE LISTS(QPXPRLST) FORM IN
Applied <Patch 14686371> with Fixed file: QPXPRLST.fmb 120.42.12010000.13
To addesses a condition where the PRE-QUERY in the LIST LINES block changed the
DEFAULT_WHERE clause of the block to see if this fix would address this issue.  Same issue is present.

Cause

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