2.1 List of Parameters

The following is the list of Cash Flow Parameters:

Table 2-1 List of Cash Flow Parameters and Descriptions

Component Code Component Description Component Value
CFE_EDITS_TABLE

Logical Name of tables on which Cash Flow Edits Process can run are displayed here. Following values are seeded by the service and cannot be modified:

Asset~Derivative~Ledger Instrument~Liability~Loan Commitments~Off Balance Sheet

Each table name is separated by ~ character

Physical Name of tables on which Cash Flow Edits Process can run are displayed here. Following values are seeded by the service and cannot be modified:

FSI_D_ASSET~FSI_D_DERIVATIVE~FSI_D_LEDGER_INSTRUMENT~FSI_D_LIABILITY~FSI_D_LOAN_COMMITMENTS~FSI_D_OFF_BALANCE_SHEET

Each table name is separated by ~ character

CFE_PROCESS_TABLE

Logical Name of tables that can be used as source to provide account data to Cash Flow Process are displayed here. Following values are seeded by the service and cannot be modified by user:

Asset~Derivative~Ledger Instrument~Liability~Loan Commitments~Off Balance Sheet

Each table name is separated by ~ character

Physical Name of tables that can be used as source to provide account data to Cash Flow Process are displayed here. Following values are seeded by the service and cannot be modified by user:

FSI_D_ASSET~FSI_D_DERIVATIVE~FSI_D_LEDGER_INSTRUMENT~FSI_D_LIABILITY~FSI_D_LOAN_COMMITMENTS~FSI_D_OFF_BALANCE_SHEET

Each table name is separated by ~ character

CASH_FLOW_PROCESS_BATCH_SIZE Number of Account or Instruments that must be processed in a single batch. This is used by Cash Flow Engine for performance tuning. Default Value of 1000 is seeded by the service, and you can modify it as needed
CASH_FLOW _EDITS_BATCH_SIZE Number of Account or Instruments that must be processed in a single batch. This is used by Cash Flow Edits Engine for performance tuning. Default Value of 1000 is seeded by the service, and you can modify it as needed
CASH_FLOW_PROCESS_PARALLEL_REQUESTS Number of Parallel batches executed by each executor. This is a performance tunning parameter for Cash Flow Engine Cloud Service. Default Value of 2 is seeded by the service, and you can modify it as needed
EXPORT_FILE_ROW_COUNT Number of records to be included in one file when cash flow output is exported from database to Object Storage. You must enter value greater than zero. Default Value of 1000 is seeded by the service, and you can modify it as needed
CASH_FLOW_PROCESS_PARALLEL_THREADS Number of threads created by the executor for each batch. This is a performance tunning parameter for Cash Flow Engine Cloud Service. This defines how much memory can be used by the different components of the process such as the stack, data and text segments. Default Value of 5 is seeded by the service, and you can modify it as needed
CASH_FLOW_PROCESS _FLUSH_BATCH_SIZE Number of records that gets saved or updated in a batch during Cash Flow Process execution. This is used by Cash Flow Engine for performance tuning. Default Value of 500 is seeded by the service, and you can modify it as needed
CASH_FLOW_EDITS_FLUSH_BATCH_SIZE Number of records that gets saved or updated in a batch during Cash Flow Edits Process execution. This is used by Cash Flow Edits Engine for performance tuning. Default Value of 500 is seeded by the service, and you can modify it as needed