Security

Worksheet and the Transition Grid are two different components and you can assign different access security to each component.

Business unit row level security is enforced by using a security view for the business unit prompt table for both the Worksheet Process Options page and on the Search Record for the Transition Grid component, when creating the cash flow statement you are not able to access data for business units for which you do not have access.

Note:

From the outset, you must have security to all business units that are to be included in the creation of your cash flow statement. However, if your access to certain business units is restricted after the cash flow worksheet has been created, you will still be able to use that existing worksheet, created prior to the restriction of original access to any of the business units, to produce and see results from the restricted business units on the worksheet and transition grid.

The Cash Flow Process (FR_CALCULATE) validates security based on the business unit security setup, so if a business unit tree is used in the process, an error message is issued and the data for the business units that the user does not have access to is not processed.

Process options for the Cash Flow Worksheet are stored by user ID and another user ID cannot see or use the setup. Also a user ID cannot see the cash flow worksheet results generated by another user ID. However, a user can use the cash flow worksheet created by another user to generate cash flow worksheet results.

User ID and date-time stamp are stored on the FR_WORKSHT_GRID table when any override or manual entries are made. The system calculated original amounts are maintained and are not modified by override or manual entries.