E1: 45: 43: Basket/Order Level Pricing for Procurement (R45750) Correctly Applies Volume Level Adjustments for Procurement But Writes Base Price to Volume History by Procurement Detail (P43500) / Rebate History (F4079) (Doc ID 2886754.1)

Last updated on AUGUST 01, 2022

Applies to:

Symptoms

Customer is using a volume level adjustment in procurement with basis code 5 to adjust the price from zero to 5.00 or 3.00 based on quantity purchases. When creating a purchase order, and then repricing the order using Basket/Order Level Pricing for Procurement (R45750), the order is repriced to reflect the adjustment. R45750 writes records to the Rebate Transaction Detail table (F4079). Volume History by Procurement Detail (P45300) displays the F4079 records, showing Total Purchase Amount and Cumulative Amount of zero. It shows the base price of the order rather than the adjusted price on the order. The purchase order detail(F4311) shows the correct price while the volume history/rebate transaction detail (F4079) does not reflect the adjustment.

The issue can be reproduced at will with the following steps:

1. In P4071, Price Adjustment Definitions, create and adjustment VOL for procurement, volume level adjustment, preference hierarchy and quantity level break.
2. In P4072, Work with Adjustment Detail for VOL, add adjustment for item WIDGET, address(supplier) 12345 from level 1.000, factor numeric 5.000 basis code 5, with valid effective dates.
3. In P4072, add a second adjustment for the same item WIDGET, address(supplier) 12345 from level 10.000, factor numeric 3.000, basis code 5 with valid effective dates.
4. In P4070, Work with Adjustment Schedule, add adjustment schedule VOLUME.
5. Select adjustment schedule, add sequence 10 with adjustment name VOL.
6. In the Supplier Master, P04012, inquire on Supplier 12345. On Purchasing tab 1 add the adjustment schedule VOLUME.
7. In Purchase Order Entry, P4310, with the Processing tab processing options set to 1 for Auto Basket and Order Level re-pricing, create a purchase order for item WIDGET, supplier 12345.
8. Note the unit cost on the purchase order is 0.00 which is the base cost of the item in the item cost (P4105).
9. Save the purchase order. Auto repricing is performed by R45750, Basket/Order Level Pricing for Procurement.
10. In P4310, reinquire on the purchase order. Note the unit cost now reflects the volume level adjusted cost. In this example 3.00 (0.00 + 3.00). Previous orders over quantity 10 were assigned 5.00(0.00 + 5.00)
11. Review Volume Incentive Deal History for Procurement (P45300) for the Supplier and Adjustment. P45300 displays the F4079, rebates, records.
12. The Total Purchase Amount and Cumulative Amount fields reflect the base price (0.00)
13. P45300 shows the base price rather than the volume level adjustment price for each order.
14. P45300 does not match the purchase order detail, F4311.

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.