E1: 45: Unable To Change Expiration Dates Using Base Price Interoperability (R4106Z1) (Doc ID 2824363.1)

Last updated on FEBRUARY 27, 2024

Applies to:

Symptoms

When attempting to use the Item Price Unedited Transaction (R4106Z1) processor to change the expiration date on existing prices, the expiration dates are not changed.

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

1. Go into the Work With Preference Base Price (P4106) and find a previously created base price.
   1. Notice the expiration date was set to 12/31/2025.
2. Create one record in the Inbound Item Price Revisions (P4106Z1) to change the expiration date on the record you found.
   1. On the line enter “C” for Change in the Transaction Action Column.
   2. Purpose of the Change is to Change the Expiration Date not Change the Price.
   3. Change “Effective Date Through” to Today’s Date (11/22/2021) so the so the system will automatically expire the current record.
   4. Click the green checkmark to save the records.
3. Run Item Price Unedited Transaction (R4106Z1) with data selection on the EDI Batch Number
4. The Report PDF shows the record was not processed.
5. Check the Work Center. No Error Messages appear in the work center.
6. Check the Debug Log. There are no error messages in the Debug Log.
7. The SQL SELECT statement cannot find a record with an Effective Through Date of 11/22/2021 to modify the price.

   SELECT * FROM PDCUR.F4106 WHERE ( BPITM = 0.000000 AND BPMCU = ' ' AND BPLOCN = ' ' AND BPLOTN = ' ' AND BPAN8 = 0.000000 AND BPIGID = 185.000000 AND BPCGID = 10.000000 AND BPLOTG = ' ' AND BPFRMP = 0.000000 AND BPCRCD = 'USD' AND BPUOM = 'EA' AND BPEXDJ = 121326 )

   No More Data found

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.