A.4 Create the Template

Once combinations and groups are configured, the template must be created by inserting its metadata into the AF_TB_TEMPLATE_MASTER table.

The template details are as follows:

• Template Name: Scenario Weightage
• Template Code: TEMP_SCEN

The template is created as follows:

INSERT INTO AF_TB_TEMPLATE_MASTER
(F_WORKFLOW, V_TEMPLATE_CODE, V_TEMPLATE_NAME, V_TEMPLATE_DESCRIPTION,
 D_CREATED_DATE, D_MODIFIED_DATE,
 V_WORKSPACE_ID, V_TENANT_ID, V_SERVICE_ID, V_CUSTOM_OBJ_CODE)
VALUES (
  'N',
  'TEMP_SCEN',
  'Scenario Weightage',
  'Scenario Weightage',
  NULL, NULL,
  '##workspaceId','##tenantId','##serviceId',NULL
);

Note:

• This step establishes the template definition and associates it with the required workspace, tenant, and service context.
• If an ID column is present in the scripts and requires manual numeric input, provide a sufficiently large and unique value to avoid conflicts with existing records.