Simplified Loader’s External Cash Template is a fully integrated Spreadsheet with Oracle Fusion, which allows to create or update Cash transactions in Oracle Fusion.
Simplified Loader External Cash Template adds an extra layer of simplification and robustness to the overall cash management process. External Cash Template enables to create and update cash transactions – individually or in bulk. Excel Template provides a feature-rich interface and allows the user to manage all information required to create or update cash transactions from within the Spreadsheet. Excel Template provides a list of values for fields like bank accounts (concealed), Chart of Accounts, etc.
Oracle provides an FBDI sheet for the Cash transaction. Compared with FBDI, Simplified loader Templates are 95% more convenient to use in terms of organizing data in Excel, steps involved in data upload, and resolving errors. Please review a detailed comparison with FBDI Template here.
Create External Cash Transactions
Create External Cash Transaction functionality enables you to create cash payment transactions.
Update External Cash Transactions
There’s a constant need to review and update existing Cash transactions. Simplified Loader addressed this requirement by providing the functionality to update External Cash transactions. This functionality enables the users to amend cash transactions already created in the system using Excel functionality for both single or bulk transactions.
Get GL Account Details
The General Ledger Chart of Accounts structure is different for each organization. It is the key to performing any transaction in the Oracle Cash Management system. Simplified Loader Cash Management Template supports multi-segment COA values structure. Get GL Account Details operation downloads Account Combination ID for the Offset and Asset account entered in the Spreadsheet.
1) Roles or privileges required for External Cash Template.
The user must have the Manage External Cash Transaction (CE_MANAGE_EXTERNAL_CASH_TRANSACTION_PRIV) role to upload the transaction.