To create a price list:Price lists are essential to ordering products because each item on an order must have a price. Each price list contains basic price list information and price list lines that define the items and their list prices. Creating a price list in the HTML user interface is a flow-based process that consists of the following guided steps:
Enter general price list information to define general information about the price list such as the price list name, effective dates, currency, pricing controls, rounding factor, and shipping defaults.
Create qualifiers that define eligibility rules for the price list. You can use qualifiers to restrict the price list to certain customers by qualifying customers for a particular price list. For example, the customer must be a Gold class customer to receive the price list.
Review and then save the price list.
Add price list lines that define the items on your price list and their list prices.
Note: Pricing security can affect the View and Maintain features associated with the Update and Details icons in the HTML user interface. See Oracle Advanced Pricing Implementation Guide, Pricing Security for more information.
To create a price list:Navigate to the Create Price List: General Information page.
Complete your entries in the General Information region (selected fields are described below):
Name and Description: Enter the Name and Description for this price list. The price list Name should be unique across Pricing Transaction Entities (PTEs), otherwise an error occurs. For example, if a price list named Corporate is created in the Order Management PTE, an error message appears if you create a Corporate price list in the Purchasing PTE.
Pricing Transaction Entity/Source System: The Source System and Pricing Transaction Entity values are provided by default from the profiles QP: Pricing Transaction Entity and QP: Source System Code. For example, the Source System default is Oracle Pricing.
Currency: Select a base Currency for the price list, such as US dollars (USD). For more information, see Currency.
Multi-Currency Conversion: Select a Multi-currency Conversion Criteria list. This field appears only if the profile QP: Multicurrency Enabled is set to Yes.
Round To: Enter a Round To value for the price list. For more information, see Round To.
Freight Carrier: Select the default Freight Carrier.
Freight Terms: Select the default Freight Terms.
Payment Terms: Select the default Payment Terms, such as Cash On Delivery (COD).
Enter the effective Start Date and End Date.
You cannot create a future-dated price list that has the same name as an existing price list. For example, suppose you have a price list named Price List A, with effective dates 01-Jan-2006 to 31-Dec-2006, and you want to create a second price list named Price List A, effective 01-Jan-2007 to 31-Dec-2007. The system will not allow you to create the second price list because a price list with the same name already exists.
The effective dates of the qualifier (when attached at the header-level of a modifier or price list) determine the effective dates for the associated price list or modifier list. For example, suppose you create a price list with an effective start date of 23-NOV-2005 and no end date. Then you create a qualifier at the header level with effective dates of 10-NOV-2005 and 12-NOV-2005 for customer Computer Service and Rentals. However, after 12-NOV-2005, the price list will not be valid for Computer Service and Rentals or any other customer because the price list has expired.
Pricing for Global Use: If the Pricing for Global Use check box is selected, then the price list can be used by all operating units for pricing transactions. If cleared, then the Operating Unit field appears for the price list:
Note: The Pricing for Global Use check box appears only if pricing security is activated.
If multi-org access is not enabled, the profile MO: Operating Unit provides the operating unit default. This Operating Unit field cannot be updated by users.
If multi-org access is enabled, the profile MO: Default Operating Unit provides the operating unit default. You can over-ride this default and select an operating unit that you can access, as defined by MO: Security Profile.
Mobile Download: Select the Mobile Download check box if you are using an Oracle Mobile application and want to download specific price lists onto a mobile device such as a laptop computer. The default value is No.
Secondary Price Lists Region
Click Add Another Row to add a blank row where you can select a secondary price list.
Click the Search icon and select the price list to be attached as a secondary price list. The Description appears by default based on the price list selected. It is view-only.
The Precedence number is provided by default and can be updated.
Note: If the item is listed on multiple secondary price lists, the precedence value is used to determine which secondary price list the item is selected from.
The lower the precedence number, the higher its precedence ranking. Therefore, a secondary price list with a Precedence value of 100 is selected before a precedence of 200, and a value of 200 is selected before 300, and so on.
Optionally, to delete this price list as a secondary price list, click Delete, and then click Apply to save your changes.
Click Next to display the Create Price List: Qualifiers page. Qualifiers define the eligibility rules that define who qualifies for the modifier. Define any qualifiers for the price list.
When you have completed your entries, click Finish to skip the review page, or click Next to display the Price List Review page.
In the Price List Review page, you can review the price list information before applying the final changes. If changes are required, click the Back button to return to the page and make your changes. If no changes are required, click Finish to save the price list.
A Confirmation message confirms that the price list has been created and asks if you want to add price list lines. Price list lines define the items and prices for the price list.
Note: Once created, the price list remains in Inactive status. You must update the price list and select the Active box to activate the price list.
To add price list lines, click Yes. Click No, if you do not want to add price list lines now. You can add price list lines in the future.
Pricing Service Items in Oracle Order Management:The pricing engine prices service items in the same way that it prices inventory items. Oracle Order Management passes both the serviceable item (which is the parent item in Order Management) and the service item to the pricing engine; the pricing engine first prices the serviceable item and then prices the service item.
You can price service items by:
Unit price: Set a list price for the service item.
Percent price: Set the price of the service item as a percentage of the serviceable item list price. To use this method, select the Service Item check box in the Service tab when you define the item.
This example compares how pricing calculates service pricing using unit price and percent price methods. The following setups are used in the calculations:
Price list setup for laptop computer:
Product: Laptop Computer
Application Method: Unit Price
UOM Code: EA
List Price: $1,000
Price list setup for computer service: unit price and percent price setups:
| -- | Pricing Method: Unit price | Pricing method: Percent price |
|---|---|---|
| Product | Computer Service | Computer Service |
| Application Method | Unit Price | Percent Price |
| UOM Code | Month | Month |
| Price | List Price: $10 | Percent Price: 2 |
Order line
Product: Computer Service
Ordered Quantity: 1
Ordered UOM: Month
Service Period: Year
Service Duration: 1
Serviceable Item: Laptop Computer
List price calculation for computer service
Unit price method: $10 per month * 12 months service period/duration = $120
Percent price method: ($1,000 laptop computer * 2 percent computer service percent price) * 12 months service period/duration = $240
