My Oracle Support Banner

Why is a R12 Pricing Formula() Behaviour Different Than Same Formula From R11? (Doc ID 2662356.1)

Last updated on APRIL 23, 2020

Applies to:

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


When attempting to query within a factor list,
cannot enter desired value  for "Pricing Attribute Value From Low".


The issue can be reproduced at will with the following steps:
1. responsibility Order Pricing Manager
2. Navigate to: Pricing Formula > Formula Setup
3. Query for formula
4. Do a find for
  base pricing attribute = <select value from LOV>
  base pricing attribute context: <select value from LOV>
  base pricing attribute: <select value from LOV>
  operator: Between
   value from: 1234
   value to: 1234
  adjustment: <enter value here>
  click on Find (b)
5. Open factor list :
6. Now try to do a FIND as follows:
  factor pricing attribute context:<select value from LOV>
  factor pricing attribute:<select value from LOV>
  query operator: Between
  enter 1234 for Pricing Attribute Value From Low"
  which opens the LOV for "Pricing Attribute Value From Low"
  -- All it shows is XXXX

Screenshot from 11i where one can query for 1234 as the pricing attribute value from low
and as the pricing attribute value from high.




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

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