You are browsing the archive for Business Processes.

Oracle Apps Advanced Pricing Interview Questions

  1. At what level you can control security access for pricing entities ?
  2. What is the difference between price list, price agreement and price books ?
  3. what is price list ?
  4. Can we have multi-current price lists ?
  5. Can we have price breaks in a price list ?
  6. What is GSA price list ?
  7. Does oracle supports copying price lists ?
  8. Can we do mass update of price lists ?
  9. Does oracle supports archiving price lists ?
  10. Does oracle supports purging price lists ?
  11. Does oracle supports deleting price lists ?
  12. What are advantage of using pricing attributes to define list price ?
  13. What is modifier ?
  14. How price lists and modifiers are related ?
  15. How do you redeem accruals in advanced pricing ?
  16. Is purging supported for modifiers ?
  17. Is archiving supported for modifiers ?
  18. What are the different types of modifiers ?
  19. How do you setup formula based pricing ?
  20. What is Qualifier ?
  21. What is Qualifier group ?
  22. What is pricing agreement ?
  23. Can we revise price agreements ?
  24. What is price book ?
  25. Can we use modifiers to setup surcharge ?
  26. Can we use modifiers to setup buy one item and get discount on different item ?
  27. Can we use modifiers to issue a coupon for later redemption ?
  28. Can we use modifiers to override terms ?
  29. Can we use modifiers for freight and special charges ?
  30. Does oracle supports overriding selling price ?
  31. What is difference between discount and surcharge ?
  32. Can we use modifiers for item upgrades ?

Create Price Books

Price Books feature is relatively new feature in R12. This functionality let you generate and publish price books to customers from multiple price lists and formulas.

Navigate to Oracle Pricing Manager responsibility -> Price Books

Price Bok create

Price Bok create

1 ) Enter the price book name for each customer.
2 ) Select the operating unit to which price book is attached to.
3 ) Pricing perspective: Here you select the core application in which pricing engine is executed i.e. order management for sales order price execution. When price book generation program runs it simulates the pricing engine to derive the prices for a customer to arrive at list price.
4 ) Product Criteria: You can choose All items, specific item, item category or price list.

Price calculation criteria:
5 ) Select currency
6 ) Select customer
7 ) Select pricing effective date
8 ) Select price basis: Choose price list or agreement

Addition attribute criteria: You can choose additional attributes to determine the price.

Communication method: You can select any of the options

  • Send E-mail
  • Send to Printer
  • Send XML message

Template: You can choose the template format for publishing the price list.
Document Type: Select the document type for publishing: Options available are EXCEL, PDF and RTF.
Publish: You can publish immediately or on a scheduled date.

Once you are ready click on ‘APPLY’ to generate and publish the price book.

Price Books Overview

Price Books feature is relatively new feature in R12. This functionality let you generate and publish price books to customers.

Price Books are of two types:

  • Full Price Books: This price book contains the prices for all items
  • Delta Price Books: This price book contains the additions & changes to prices since last full price book published.

Price Books can be published immediately or scheduled for publishing on a future date.
Price books can be published to EXCEL, RTF, PDF and XML formats. Published price books can be e-mailed, printed on a printer or XML message sent to a directory.

The important feature of price books is it can be based on one or more price lists, modifiers, pricing formulas, including multi currency price lists.

Important Price Book profile options are:

  • QP: E-mail From Address: This profile option defines the from e-mail address for any e-mails that are sent from the price book feature.
  • QP: External Default Pricing Perspective: This profile option sets the default pricing perspective for all external users.
  • QP: Inbound XML Messaging Responsibility: This profile option defines the responsibility to be used for inbound XML messages.
  • QP: Internal Default Pricing Perspective: This profile option sets the default pricing perspective for all internal users.
  • QP: Pricing Perspective Request Type: This profile option defines the mapping between a Pricing Perspective (calling application) and the Request Type that it uses.