Understanding the Statement Validation Report

If you make changes to row, column, or statement definitions, your changes might cause the statement definitions in your system to become invalid. For example, if the OVFS constant for row definitions is set to enable changes and you change a row definition that is used in a statement definition, you might make a change that makes the row definition ineligible to be included in the section in which it is used in the report definition. Likewise, if you export OVFS components from an environment, such as your test environment, and then import it into another environment, such as your production environment, you might import OVFS components that will cause errors when you attempt to generate a statement in the new environment. Oracle recommends that you generate the Statement Validation report if you import OVFS components into an environment.

You can run the Statement Validation program to validate one or more statement definitions. You specify which statement definitions to validate by using data selection in the batch program.

The report reads the records in the OVFS Statement Definition Setup table (F09330) and generates a PDF file with the validation results. The PDF file contains the following columns and values:

• Statement Definition Name

  Error messages appear in this column.

• Statement Definition Description

• Created By

  The user ID of the person who created the statement definition.

• Validation

  If the statement definition passed the validations, then this column contains the term Passed in this column. If the statement definition failed, then this column contains the text Failed - View Work Center for more detailed information.

The validations that the Statement Validation report performs are similar to the validations that the system performs when you create statement definitions. The following list describes the validations performed in the Statement Validation program:

• Each section description must be unique.

• Each row definition can be used once only in a section.

• Each column definition can be used once only in a section.

• The text value, numeric value, and subtotal row definitions cannot have associated columns in the section.

• Types of row definitions in a section:

  • If a section includes a data with grouping elements row definition, then the following validations are performed:

    • All row definitions in the section must be data with grouping elements.

    • All row definitions must use the same grouping elements and have same settings for the Enable Level of Detail Rollup and Include GLG AAI Item Number check boxes.

      The values for the Enable Level of Detail Rollup and Include GLG AAI Item Number check boxes must be the same in the F09310 and F09330 tables. If the values are not the same, then the system changes the value in the F09330 table to match the F09310 table, and then continues with the validation process.

    • All row definitions must have at least one column definition and must use the same column definitions for all row definitions in the section.

  • If a section includes a data without grouping elements row definition, then the following validations are performed:

    • All row definitions in the section must be data without grouping elements.

    • All row definitions must have at least one column definition and must use the same column definitions for all row definitions in the section.

  • If a section includes a subtotal row definition, then the following validations are performed:

    • No other row definitions are included in the section.

      A section with a subtotal row definition can include only one row definition.

    • The Section From and Section Thru fields must be populated, and the value in the Section Thru field must be greater than the value in the Section From field.

    • At least one data or subtotal row definition must be included in the range of values in the Section From and Section Thru fields.

  • If the section includes a text or numeric row definition, no data or subtotal row definitions can be included in the section.