My Oracle Support Banner

E1: 42: P4106 Item Preference Base Price and P4072 Price Adjustment Detail Displays Incorrect Query Results When Require Price Approval Functionality Is Enabled in P41001 Pricing Constants (Doc ID 3030039.1)

Last updated on JUNE 20, 2024

Applies to:

JD Edwards EnterpriseOne Advanced Pricing - Sales - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

P4106 - Item base price and P4072 - Adjustment detail forms displays incorrect query results when "Require price approval" functionality is enabled in P41001 Manufacturing pricing constants.

Steps:

36237592  1. P41001 - Inquire on pricing constants and observe "Require price approval" field is not checked.
2. P4106 - In work with preference base price, inquire on QBE field Eff From Date (EFTJ) using the following condition >2/8/23 returns 13 records.
3. P4106 - Observe 13 records meeting the greater than 2/8/23 were displayed.
4. P4072 – In work with adjustment detail, inquire on QBE field Adj name using condition !=A2.
5. Observe multiple records with value not equal to A2 are returned.
6. P41001 - Inquire on pricing constants and set "Require price approval" field to “Y”
7. Log out and log back in.
8. P4106 - In work with preference base price, inquire on QBE field Eff From Date (EFTJ) using the following condition >2/8/23.
9. P4106 - Observe only 2 records which has effective from date = 2/8/23 is displayed.
10. P4072 – In work with adjustment detail, inquire on QBE field Adj name using condition !=A2.
11. Observe multiple records with value not equal to A2 are returned.

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.