E1: 44H: Deselecting Options via P44H500 Sales Workbench Select Options Row Exit Updates F44H501 - Sales Master Option Field Data but the Audit Fields are Not Updated (Doc ID 2958599.1)

Last updated on JUNE 30, 2023

Applies to:

Symptoms

P44H500 - Sales Workbench Select Options Row Exit  / N44H0013 – F44H501 Clear Option Revenue does not update F44H501 audit fields.  After deselecting options in Sales workbench (P44H500), the F44H501 Option Revenue (OPRV1- OPRV9), Net Option Price (NETOPT) & Total Sales Price (TOTSAL) data fields are updated, but the audit fields remain unchanged.

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

1.  Find an existing Lot in P44H500 - Sales Workbench for which Options have been selected.
2.  Use Databrowser to capture the "Before" data for this Lot in the F44H201 Lot Master Table & F44H501 Sales Master Table.  Note the current value in the Option related fields: (OPRV1- OPRV9, NETOPT & TOTSAL).
3.  Row Exit to ‘View Options’ to see which Options have been selected.  Exit back to Sales Workbench.
4.  In P44H500 - Sales Workbench, select the Lot and Row Exit to Select Options.  For one or more of the Options that were selected (have a quantity next to the Option), clear the quantity from the field and then save the change.  Exit back to Sales Workbench and then Row Exit to 'View Options' to verify the Options that you 'deselected' are no longer showing as selected in the View Options form.
5.  Return to Databrowser and do a new Find on this Lot in both the F44H201 & F44H501.
6.  Capture the F44H201 & F44H501 table data (Export to Excel) to create the "After" data for this Lot and compare to the "Before" data.
7.  In the F44H201 no data was changed by this process, so there are no updates to any field in the table.  This is correct.
8.  In the F44H501 the Option Revenue (OPRV1- OPRV9), Net Option Price (NETOPT) & Total Sales Price (TOTSAL) data fields are updated, but the audit fields remain unchanged.  This is not correct.

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.