Auditing

This chapter covers the following topics:

Auditing

Oracle Advanced Pricing supports the auditing of price lists and modifiers. You can:

To perform auditing you must set the profile option QP: Enable Auditing to Yes and set the QP: Audit Pricing Tables process parameters to Yes. To disable auditing, set the value profile option to No and set the values in the QP: Audit Pricing Tables process parameters to No.

When you select the fields to audit on the Audit Setup page, the application saves the information in the following audit tables for each base table: (QP_LIST_HEADERS_HD, QP_LIST_HEADERS_TL_HD , and QP_LIST_LINES_HD).

Run the QP: Audit Trail Report to generate the audit report for the tables that need to be audited.

See QP: Audit Trail Report and QP: Audit Pricing Tables in the Oracle Advanced Pricing User's Guide.

Setting up Auditing

Oracle Advanced Pricing enables you to audit price lists and modifiers. Use the Audit Setup page to select the headers and line fields for which to record the history of changes. You can then generate an audit report for the selected fields.

To set up auditing of price lists and modifiers, perform the following steps:

  1. Use the System Administrator responsibility and navigate to the Profiles window. Query the profile option QP: Enable Auditing. Set the profile option to Yes at the site level.

    For information on profile options, see Profile Options Setup Summary.

  2. Switch to the Oracle Pricing Administrator responsibility and run the QP: Audit Pricing Tables process to enable the triggers on the base tables.

    For information on this process, see QP: Audit Pricing Tables in Oracle Advanced Pricing User's Guide.

  3. Navigate to the Audit Setup page to select the fields for which to audit.

    For information on the fields, see Audit Setup.

  4. Create or update a price list or a modifier list.

    For information on how to create and updating price lists, see Creating a Price List and Updating a Price List in Oracle Advanced Pricing User's Guide.

    Creating a Modifier Lists and Updating a Modifier List Lines in Oracle Advanced Pricing User's Guide.

  5. Switch to the Oracle Pricing Manager responsibility to run the QP: Audit Trail Report to generate the audit report.

    For information on the audit report, see QP: Audit Trail Report in Oracle Advanced Pricing User's Guide.

Audit Setup

Use the Audit Setup page to select the fields to be audited.

Note: You cannot audit qualifiers and pricing attributes in the price lists and the modifiers.

To audit price lists and modifiers

  1. Log in with the Oracle Pricing Administrator responsibility.

  2. Click Audit to access the Audit Setup page.

  3. Click the Price Lists tab to see headers and lines for the price lists.

  4. Add the headers and lines fields that you want to audit.

  5. Click the Modifiers tab to see headers and lines for the modifiers.

  6. Add the headers and lines fields that you want to audit.

    Audit Setup Page

    the picture is described in the document text

To add header or line fields for auditing

When you add the fields to audit on the Audit Setup page, the application saves the information in the following audit tables for each base table: QP_LIST_HEADERS_HD, QP_LIST_HEADERS_TL_HD, and QP_LIST_LINES_HD.

Perform the following steps to add a field for a header or list lines:

  1. Click the Add Another Row icon (+) to add a new row.

  2. Search for the field that you want to audit.

  3. Select the field and click Select. The selected entity is added.

  4. Select the Audit check box.

  5. Click Apply.

    The selected field is saved to the database.

    Adding fields for Auditing

    the picture is described in the document text

To remove header or line fields for auditing

  1. To remove a field from being audited, click the Delete icon.

After you add the fields on the Audit Setup page, you can create a price list or a modifier list. You can then make changes to the fields on the price list or the modifier list that need to be audited.

For information on price lists and modifier lists, see "Price Lists" and "Modifiers" in Oracle Advanced Pricing User's Guide.