E1: 42: Line Margin Hold Code Not Removed After Item Price Revision on Sales Order When Using Advanced Preference (19) Profit Margin Hold (Doc ID 2796957.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

Line Margin hold code not removed from sales order line when price revision is done on Sales Order and margin is inside the hold limits when using Advanced Preference (19) Gross Profit Margin.

Steps:

1. Setup Gross Profit Margin Advanced Preference (19)
2. Advanced Preference Definition (P4071)
3. Advanced Preference Detail (P4072) - Take the Row Exit to 'Pref Details' to input the preference limits: Lower 2.5% and Upper 80%
4. Advanced Preference Schedule (P4070) - Add the advanced preference to a preference schedule (i.e. PROFIT)
5. P4210 – Processing Options
6. Tab 10 - Preference - set #3 to "PROFIT"
7. Tab 22 - Profit Margin - set #1 to "1", set #2 to "ND" and set #3 to "1"
8. Limit "blank", as the limits will come to play from Adv. Preference
9. P4210 – Enter a sales order and use item location where price will cause
10. Profit be over 80%. See the warning: "Gross Profit Exceeds Not Within Range" and "Line 1.000 will go to the following holds"
11. Click on "Submit and Close" button to save the order. See that the order went to Margin Line Hold (M2)
12. P4210 – Inquire order back and change the location which has lower price and so, will recalculated the profit. See, % of profit margin now is 40% within the range. Click on "Submit and Close" button.
13. No warnings this time, as expected however see that Margin Line Hold code is not cleared from order line.

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.