E1: 45: Purchasing Price Adjustment Using Item Cost Instead Of Supplier Catalog Price (Doc ID 2514554.1)

Last updated on DECEMBER 06, 2022

Applies to:

Symptoms

A procurement price adjustment is not calculated using the Supplier Catalog (P41061) price. The Item Cost Ledger (P4105) cost is used instead to calculate the price.

Steps

1. Preference Hierarchy (P40073) N5 is set for All Customers/All Items.
2. An item is setup with Purchase Price Level 1 (Use the supplier/item price from the Purchase Price table (F41061)).
3. An Item Branch Record (P41026) exists with a specific supplier populated.
4. In the Item Cost Ledger (P4105) a cost is populated.
5. In the Supplier Catalog (P41061), a price for the Item and Supplier combination is different than the Item Cost.
6. Setup a Price Adjustment Definition (P4071) for Target Application 1 (Procurement) as a Line Level Adjustment, Adjustment Control Code 2 (Print on Document), Preference Hierarchy is N5, Override Price checkbox is checked, and Quantity Level Break is selected.
7. Price Adjustment Schedule (P4070) has only the one adjustment populated.
8. Price Adjustment Detail (P4072) has factor value numeric 100 and basis code 2. This is for all customers and all items.
9. Populate the Price Adjustment Schedule on the purchasing instructions (P04012).
10. Create a Purchase Order for the Item, Branch and Supplier Combination. The Item Cost is used to calculate the price adjustment.
11. Check Price History (P4074). The Price Adjustment (COEFN5) is applied but the price adjustment is calculated based on the Item Cost (P4105) not the Supplier Catalog (P41061)

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.