My Oracle Support Banner

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

Last updated on JUNE 19, 2022

Applies to:

PeopleSoft Enterprise SCM Order Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


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.

Note:  If you are working with the EOEPPriceList.XLS file for the first time, click the Connection Properties button to set connection properties. Typically, the system administrator should have performed this step already.

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.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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