Defining a Template

Procedure

To define a template:

  1. Click the Admin link in the Application toolbar.
    A list appears.
  2. From the Admin menu, select T and then click Template.
    A sub-menu appears.
  3. Click the Add option from the Template sub-menu.

    The Template screen appears. It consists of the following tabs:

    • Main - Used to specify the basic details for the template.

    • Characteristics - Used to define the characteristics for the template.

    The Main tab contains the following fields:

    Field Name Field Description Mandatory (Yes or No)
    Template Used to specify the template name. Yes
    Description Used to specify the description for the template. Yes
    Detailed Description Used to specify additional information about the template.
    Note: You can resize the text box depending on your requirement by clicking the Resize Handle (The Resize Handle Icon) icon at the bottom right corner of the text box.
    		 No
    Purpose Used to indicate the objective why the template is created. The valid values are:

    • Adjustment Selection - Used when you want to create a template for selecting a set of adjustments based on the given criteria.

    • Bill Segment Selection - Used when you want to create a template for selecting a set of bill segments based on the given criteria.

    • Billable Charge Selection - Used when you want to create a template for selecting a set of billable charges based on the given criteria.

    • Usage Account Selection - Used when you want to create a template for selecting a set of usage accounts based on the given criteria.

    • Usage and Invoice Accounts Selection - Used when you want to create a template for selecting a set of usage and invoice accounts based on the given criteria.

    		 Yes
    Status Used to indicate the status of the template. The valid values are:

    • Active

    • Inactive

    		 Yes
    Select Used to specify the column name (of the below mentioned table) from where you want to retrieve the data using the SELECT statement.
    Note:

    The default value appears in this field when you select the purpose of the template. The default value automatically changes depending on the purpose of template.

    The following table lists the default value when the respective purpose is selected:

    Purpose Default Value
    Adjustment Selection ADJ_​ID
    Bill Segment Selection BSEG_​ID
    Billable Charge Selection BILLABLE_​CHG_​ID
    Usage Account Selection ACCT_​ID
    Usage and Invoice Accounts Selection ACCT_​ID
    		Yes
    From Used to specify name of the table or view from which you want to retrieve the data. Yes
    Where Used to specify the condition based on which you want to retrieve the data from the table or view. You can use the bind variables in the Where clause using the following syntax:

    {column_​name}{operator}:{bind_​variable}

    The bind variables must be alphanumeric and prefixed with the Colon (:) symbol. There should not be any space between the column name, operator, and the bind variable. For example, CURRENCY_​CD=:CURRENCY. All bind variables used in the Where clause must be defined in the Bind Variables section.

    		 No

    In addition, this tab contains the Bind Variables section where you can define the bind variables which are used in the Where clause. The Bind Variables section contains the following fields:

    Field Name Field Description Mandatory (Yes or No)
    Bind Variable Used to specify the bind variable (that is used in the Where clause). For example, CURRENCY. Yes (Conditional)
    Note: This field is required when you are defining a bind variable.
    Data Type Used to indicate the type of data you want to store in the bind variable. The valid values are:

    • Date

    • Numeric

    • String

    		 Yes (Conditional)
    Note: This field is required when you are defining a bind variable.
    Label Used to specify the business label for the bind variable. The business label appears when you define and edit the criteria for selecting a set of adjustments, bill segments, billable charges, usage accounts, or usage and invoice accounts. Yes (Conditional)
    Note: This field is required when you are defining a bind variable.
    Zone Used to specify the zone using which you want to fetch the value for the bind variable. The system then displays the OraSearch The Search Icon icon corresponding to the Value field in the Bind Variable grid while defining selection criteria for the construct.
    Note: The Search (The Search Icon) icon appears corresponding to this field. On clicking the Search icon, the Zone Information window appears.
    		 No
    Tip: Alternatively, you can access the Template screen by clicking the Add button in the Page Title area of the Template screen.
  4. Enter the required details in the Main tab.
  5. If you want to define more than one bind variable, click the Add (The Add Icon) icon in the Bind Variables section and then enter the required details.
    Note: However, if you want to remove a bind variable from the Bind Variables section, click the Delete (The Delete Icon) icon corresponding to the bind variable.
  6. If required, click Validate to validate the syntax of the SELECT statement.
    Note: If the syntax of the SELECT statement is correct, a message appears indicating that the SQL statement was validated successfully. However, if the syntax of the SELECT statement is incorrect, an error message occurs. You need to then correct the SELECT statement accordingly. Otherwise, the system will not allow you to save the template.
  7. Define characteristics for the template, if required.
  8. Click Validate and Save.
    The system validates the syntax of the SELECT statement and then accordingly saves the template.

Related Topics

For more information on... See...
Template screen Template
Search Template zone Search Template
How to define a characteristic for a template Defining a Characteristic for a Template