About Price List Wizard
Welcome to Price List Wizard.
We developed this tool in response to demand from Oracle Pricing users for a user friendly and robust spreadsheet tool to load price lists into the Oracle E-Business Suite module.
Price List Wizard is a VBA program embedded in a Microsoft Excel workbook. It is a close cousin to our other ‘Wizard’ products and shares the same look and feel.
The software interfaces with the standard Oracle Advanced Pricing List API for Standard and Advanced Price Lists in Order Management and Purchasing. It does NOT modify any other Oracle objects except during the installation, where it adds the More4apps packages and profile options.
There are four modes available in the Price List Wizard Product:
Two modes relate to the Price List namely ‘Price List Wizard’ and ‘Bulk Import of Price List’. ‘Bulk Import of Price List’ uses an interface program to upload price lists and is very useful if you are uploading very large volumes of data.
The other two modes relate to Pricing Agreements module in Oracle EBS. The modes are ‘Standard Pricing Agreements’ and ‘Agreement Price List’.
Features
All options are available on a ribbon. Double-clicking in the spreadsheet also loads the forms. The forms are optional and you can simply type, import, or paste the values into the spreadsheet.
You can upload Price Lists/Agreements one at a time, or your entire worksheet.
The program is flexible about the spreadsheet layout. You can move, delete, or hide (not recommended) unwanted columns. You can also have multiple sheets or even sheets in other workbooks.
Current features include:
• Create Header with associated Qualifiers and Secondary Price Lists
• Create Lines with associated Attributes and Price Breaks
• Descriptive Flexfields (DFF’s)
• Upload using the API or Concurrent Request
• Create Agreement Headers with associated Price List Lines, Pricing Attributes and Price Breaks
Features not currently available:
• Attachments
This product is supported on most versions of the E-Business suite from 11.5.10.2 onwards. Refer to our compatibility section for further details: https://community.more4apps.com/s/article/ebs-toolbox-installation-guide
If you encounter any problems or have any suggestions, do not hesitate to contact us at https://community.more4apps.com/s/ebs-contact-support/