C.1.1 Mapping the Transaction Statuses and Transaction Outcomes

After you provide the new transaction status and outcome in step 4, you need to map the values in the required tables to update the value on the PMF page.

To update the status on the PMF page, populate the following status in the Config schema:

1. Run select * from AAI_WF_STATUS_B t where t.v_app_package_id = 'OFS_SAC' and select * from AAI_WF_STATUS_TL where t.v_app_package_id = 'OFS_SAC' queries.
2. In the AAI_WF_STATUS_B table, populate a unique entry in the v_status_id column for each new status and map the same entry in the AAI_WF_STATUS_TL table for a column. For example, populate the entry OFS_SAC in the v_app_package_id column.
3. When you map the new status, it appears on the PMF page.
   • Ensure that data is provided in all required columns in the AAI_WF_STATUS_TL table.
   • When doing the mapping in any other configuration tables, ensure that you provide the same status that is mentioned in the v_status_name column in the AAI_WF_STATUS_TL table.

To update the outcome on the PMF page, populate the following status in the Config schema:

1. Run the select * from AAI_WF_OUTCOME_B t and where t.v_app_package_id = 'OFS_SAC' queries.
2. In the AAI_WF_OUTCOME_B table, populate a unique outcome ID in the v_outcome_id column for each new status and map the same entry in the AAI_WF_OUTCOME_TL table.
   • Ensure that data is provided in all required columns in the AAI_WF_OUTCOME_TL table.
   • When doing the mapping in any other configuration tables, ensure that you provide the same status that is mentioned in the AAI_WF_OUTCOME_TL table.
   • After you complete the above steps, refresh the application and web servers.