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:

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

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