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;