6.3.9.3.10 Audit Option

Figure 6-137 Audit Option

Within the Audit Options screen, you can choose to log the detailed Cash Flows. Later you can retrieve Cash Flows from the FTP_O_CASH_FLOW_OUTPUT_HIST table.

In addition, the Enable FTP Audit Trail Output option allows you to capture the audit details in FTP_O_ENGINE_AUDIT_TRAIL_AGGR table.

Note:

In the Audit table, for ‘Use TP add-On rate’ method underlying transfer pricing method codes are logged along with respective Interest rate curves. It will help user to capture more detailed information. Users need to refer following tables to get this audit information:

• FSI_FTP_TP_ADDON_METHOD_MLS table → Transfer Pricing Method (TP_METHD_CD), Add-On Rate Method (LIQ_ADD_ON_METHOD_CD,BASIS_ADD_ON_METHOD_CD,OTHER_ADD_ON_METHOD_CD,PRICING_ADD_ON_METHOD_CD)

FTPCS supports downloading the Engine Audit Data using the Data Management Interface (DMI) module for the following tables:

• FTP_O_ENGINE_AUDIT_TRAIL_AGGR
• FTP_O_CASH_FLOW_OUTPUT_HIST
• FTP_PROCESS_ERRORS
• FTP_O_CASH_FLOW_MESSAGES_HIST (this is not enabled for DMI download.)

For more information on cleaning up the data in the above tables, refer to Data Housekeeping documentation.