Database Views as Sources in Cash Flow Processes

Select a supported database view based on an instrument table as the input source for a Cash Flow Process. Use the view to classify, filter, or enrich instrument data before cash flow calculations. Include every instrument-table column, including placeholder columns registered through Data Model Extension.

Prepare data without duplicating instrument datasets or adding customer-specific enrichment logic to the cash flow engine.

Steps to enable and configure

1.    Create and register a supported view in Database Views under the appropriate classification. Include all columns from the instrument table and every placeholder column registered through Data Model Extension. Follow Database Views and Table UDP Mapping for View Classification in the User Guide.
2.    In Create Cash Flow Process, select the registered view in Source Data. Configure the remaining process settings and execute the process.

Tips and considerations

Check that the view includes every required instrument-table column and each registered placeholder column. Verify the classification and the records returned before processing.

Key resources

https://docs.oracle.com/en/industries/financial-services/ofs-analytical-applications/profitability-balance-sheet-base/index.html