Price Adjustments Issues and "Compile error in modCommon" when Using the 'OMProductPrice.xls' File and the ExcelToCI Utility (Doc ID 1497735.1)

Last updated on AUGUST 04, 2016

Applies to:

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

Symptoms

Price Adjustments issues when using the 'OMProductPrice.xls' file and the ExcelToCI utility:

  1. A Price adjustment which should apply to 'Visible' lines  is applied to all lines.
  2. A Price adjustment which should apply to all' lines is doubled (so 60% becomes 120%).
  3. The decimal separator, comma, in the Excel spreadsheet it not translated into the decimal separator, dot, in PeopleSoft so 25,99 becomes a Price of 2599.00
  4. Compile error in modCommon (reference dll MSXML.DLL that is no longer supported by Microsoft)

'OMProductPrice.xls' is generated by the 'Extract Prod Price with Cost' process (OM_PROD_COST) (navigation: Products, Request Processes, Product Price Extract)


Steps to reproduce the first 3 issues:

  1. Downloade Prices into Excel using the 'Download Prices' button.
  2. Use the column filters to select one line.
  3. Click on the 'Price Maintenance' button.
  4. Enter a percentage in order to adjust the Prices and select Apply to 'Visible'.
  5. Issue # 1: the Price is adjusted on all lines instead of the filtered one(s) only.
  6. Click on the 'Reset Data' button.
  7. Click on the 'Price Maintenance' button.
  8. Enter a percentage in order to adjust the Prices and select Apply to 'All'.
  9. Issue # 2: the adjustment is doubled (so 60% becomes 120%).
  10. Click on the 'Reset Data' button.
  11. Change the Price for an Item from say 25,00 to 25,99 (with a comma) and add an Effective Date day + 1 day.
  12. Upload prices into PeopleSoft using the 'Upload Prices' button.
  13. Issue # 3: the decimal separator, comma, in the Excel spreadsheet it not translated into the decimal separator, dot, in PeopleSoft so 25,99 becomes a Price of 2599.00

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms