Excel Price List Update EOEPPriceList.XLS Removes Future Date Effective Pricing (Doc ID 2876672.1)

Last updated on JUNE 19, 2022

Applies to:

Symptoms

When uploading pricing from Excel Price List Update Excel Price List Update (EOEPPriceList.XLS), pricing entries that are in effect in the future are removed.

Steps to Reproduce Issue:

1.  Identify a price list that has future effective pricing entries.

Pricing Configuration, Create Pricing Information, Price List Maintenance

2.  On the Price List Extract page, create a request for data, specifying the exact search criteria, and submit the job for processing.
The application extracts the selected data and stores it in a EOEP_LIST_COST record.

Pricing Configuration, Mass Updates, Price List to MS Excel

3.  Launch Excel Price List Update (EOEPPriceList.XLS).

Click the Download Prices button and supply logon data.

Microsoft Excel loads and formats the received data.

4.  Add or Update Pricing in Excel.

5.  Click the Upload Prices button and provide logon data to upload the changes made to the price lists to PeopleSoft Enterprise Pricer.  Confirmation of the update is sent back to Microsoft Excel. For each row that successfully applies, the status column turns green and reads Uploaded. If the a row in the price list does not post properly, the column turns red and reads Failed.  Correct as needed and click Upload Prices button again.

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.