E1: 45: Re-Apply Volume Level Pricing (R45900) Creates Sales Order Detail Ledger File (F42199) with Date Updated Audit Field (UPMJ) Blank (Doc ID 3081126.1)

Last updated on APRIL 10, 2025

Applies to:

Symptoms

When using volume level adjustments in Advanced Pricing and when running the Re-Apply Volume Level Pricing (R45900), the system will update the Sales Order Ledger (F42199), but the Date Updated (UPMJ) field will be blank.

Steps:
1. Create a volume level adjustment (P4071, P4072) with different From Levels.
2. Create an Advanced Pricing Schedule (P4070) that uses the adjustment.
3. Create a Sales Order (P4210) using the Schedule so that the first level is applied and save.
4. Re-inquire on the order and increase the order quantity.
5. In databrowser, note that the VIDCHG flag in the F4079 table is updated to 1.
6. Run the R45900.
7. Review the Sales Order in S.O. Detail Ledger File (F42199). Notice there is a record linked to the R42900, but the UPMJ field is blank.

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.