Pricing Administration Guide > Testing and Validating Pricing Models > The Process of Testing Pricing Models >

Examining the Pricing Engine Log File


If you want more details about how the pricing adjustments were applied in this test, check the Pricing Engine Log file.

When you run tests using the Quote Pricing Model Validation or Order Pricing Model Validation, Siebel ePricer will create a log file whenever you process new products or click the Reprice or Reprice All button.

This file is located in the Siebel server installation directory in a TEMP file titled Pricing_Engine_Log_<username>.txt, where the username is your login name.

This log file is a simple text file to which records are appended each time the Siebel ePricer engine attempts to execute a pricing adjustment. It provides information about how ePricer executed or attempted to execute pricing adjustments.

Make arrangements with your Siebel Systems Administrator so that you have immediate read and write access to this file, which is crucial for testing and validation purposes.

Save a copy of the log file under another name to preserve the information in it. Give the copy a name that identifies the session, and add text to the beginning of the copied file to define the testing parameters, if appropriate.

After you have saved a copy of it, delete the original log file.

If you continue the testing session without renaming the log file and deleting the original log file, Siebel ePricer will continue to append data to the original log file, which can make it too large to be useful for troubleshooting. If you rename it, Siebel ePricer will create a new Pricing Engine Log file the next time you attempt to execute a pricing factor. By renaming the log file, you can create a separate log file for each test.

If you exit the testing session, and then begin testing again, the log file for the new test data will overwrite the existing log file. You can preserve the log file by renaming it as soon as each defined test is completed.

Example: Sample Results in the Pricing Engine Log File

You can see an example of a Pricing Engine Log File in Figure 12. The current price at the beginning of each entry shows the result of a price adjustment, and the details below it describe that price adjustment.

Figure 12.  Using the Log File to Detect a Pricing Factor Error
Click for full size image

In the first entry in this sample, there was an error. The name of a product, Game Pod, was incorrectly entered as Game Pad, so a match did not occur and the pricing adjustment was not applied. Notice that Game Pod appears in the Left Side Value field and Game Pad appears in the Right Side Value field. The row that says Rule Applied? = N indicates that the pricing adjustment was not applied.

In the second entry in this sample, there was not an error. The Left Side Value and the Right Side Value are the same: both are Computers R Us. The row that says Rule Applied? = Y tells us that the pricing adjustment was applied, and the pricing factor executes. The Action Type is Discount Amount, and the Action Value is 3.500000, so we know that a $3.50 discount was applied. The Reason field says CP.Name, which means that a customizable product name field was used to set up the condition for firing this factor.

All the fields in the Pricing Engine Log file are explained in Fields in the Pricing Engine Log File.

Typical Problems in the Pricing Engine Log File

Using the Pricing Engine Log file, you may be able to identify the typical problems described in Table 43.

Table 43.  Identifying Problems Using the Pricing Engine Log
If you see this...
Check this

Only the Product ID lines are displayed for a log entry.

n Verify that the date of the test is within the range specified in the pricing factor.
n Verify that the pricing factor is active.
n Verify that the pricing model has been associated with a price list.
n Exit and reenter the application to verify that the price list has been refreshed.

Left Side Value is blank.

Verify that the specified business component field is active.

Rule Applied equals N and Right Side Value is blank.

It is probable that fields with unlike data types are being compared. Check the data types of both business components fields in Siebel Tools. If the data types are different, change the pricing factor business component fields.

Numbers after the Factor ID are the same.

Check Rule Applied:

n If it equals N, the pricing factor did not execute.
n If it equals Y, the pricing factor is setting the selling price to the target price.

Fields in the Pricing Engine Log File

Table 44 describes the fields in the Pricing Engine Log.

Table 44.  Fields in the Pricing Engine Log
Field
Description

Product ID

Displays the database ID of the product in the quote or order.

Price List ID

Displays the price list used by the pricing model.

List Price

Displays the list price of the product from the Price List Line Items view.

Promotional Price

Displays the promotional price of the item from the Price List Line Items view. If the product has a Promotional Price, it is the basis for pricing calculations, not List Price.

Current Price

Displays the current price of the item, which reflects all pricing adjustments that have been applied before to this point.

Quote ID and Quote Item ID (or Order ID and Order Item ID)

Identifies the quote or order that is being reported.

Volume Discount fields

Show if a volume discount was applied to the product.

Factor ID

Identifies the pricing factor that was executed.

The number following this ID is the current price after this pricing adjustment was executed.

Type

Identifies the type of pricing factor - single, matrix-based, script-based, bundling, or aggregate.

Use this field to verify that the pricing factor is being applied as intended.

Left Side Value

Identifies the value that comes from the Quote or Order.

If this field is blank, it typically means that the business component field is inactive.

Operator

Identifies the comparison operator in the pricing factor.

Right Side Value

Identifies the value that comes from the field value or mapping.

For some types of adjustments, individual values are not listed:

n If this field contains [..], it means that the search specification in a mapping returned values.
n If the pricing factor is script-based, the pricing factor name appears here.
n If the pricing factor is bundling type, the Buy product requirements are referenced here.

Use this value to spot character string errors in a field value or mapping, such as the one in Figure 12.

Rule Applied?

Indicates whether the price was adjusted. If the value in this field is N, the pricing factor was not applied. If it is Y, then the factor was applied.

Action Type

Displays the type of calculation in the pricing factor.

Target Price

Identifies the price-basis in the pricing factor as one of the following: List price, Current price, MSRP, Purchase Price or Cost.

Action Value

Displays the value of the Adjustment Amount field in the pricing factor.

Reason

Displays the text of the Comments field in the pricing factor.

Start Time

Displays the date and time at which the factor will be activated.

End Time

Displays the date and time at which the factor will be deactivated.

Pricing Administration Guide