6.3 The Detail Cash Flow Process
After processing Cash Flows from either Oracle ALM or Oracle FTP, do the following to view the audit results:
- Determine the value of Result Sys ID
- View data by: Navigating to Oracle ALM Business Intelligence and viewing results in the Detail Cash Flow Audit Report.
Or you can use SQL Developer or a similar SQL query tool. For example, you can write the following SQL Statement to view Cash Flow results:
SELECT * FROM FSI_O_PROCESS_CASH_FLOWS WHERE RESULT_SYS_ID = <your SysID
number> ORDER BY SCENARIO_NUM, RECORD_SEQUENCE, CASH_FLOW_DATE,
FINANCIAL_ELEM_ID;