Setup of Cash Management in Oracle EBS R12

Setting up Cash Management in Oracle E-Business Suite (EBS) R12.3 involves several configuration and master data setup steps. Here's a step-by-step guide to set up Cash Management:

Step 1: Define Bank Branches

Navigation: Cash Management > Banks > Bank Branches

Define the bank branches where your organization has accounts.

Step 2: Define Bank Accounts

Navigation: Cash Management > Banks > Bank Accounts

Create bank accounts for each bank branch where your organization holds accounts.

Step 3: Define Bank Account Access

Navigation: Cash Management > Setup > Bank Account Access

Define the access type for each user who needs access to specific bank accounts.

Step 4: Define Bank Statement Transaction Codes

Navigation: Cash Management > Setup > Bank Statement > Transaction Codes

Define transaction codes for different types of bank statement transactions (e.g., deposits, withdrawals).

Step 5: Define Bank Statement Sources

Navigation: Cash Management > Setup > Bank Statement > Sources

Define bank statement sources to specify the source of bank statement information (e.g., manual entry, file import).

Step 6: Define Bank Statement Cashflow Categories

Navigation: Cash Management > Setup > Bank Statement > Cashflow Categories

Define cash flow categories to categorize bank statement transactions for cash flow forecasting.

Step 7: Define Bank Statement Cashflow Rules

Navigation: Cash Management > Setup > Bank Statement > Cashflow Rules

Create cash flow rules to automatically assign cash flow categories to bank statement transactions.

Step 8: Set Up Reconciliation Accounts

Navigation: Cash Management > Setup > Bank Statement > Reconciliation Accounts

Define reconciliation accounts to manage the clearing of bank statement transactions.

Step 9: Define Bank Statement Controls

Navigation: Cash Management > Setup > Bank Statement > Controls

Define bank statement controls to specify the parameters for importing bank statements.

Step 10: Import Bank Statements

Navigation: Cash Management > Bank Statements > Import and Reconciliation > Bank Statements

Import bank statements from external sources using the defined bank statement controls.

Step 11: Reconcile Bank Statements

Navigation: Cash Management > Bank Statements > Import and Reconciliation > Bank Statements

Reconcile bank statement transactions with accounting entries and resolve any discrepancies.

Step 12: Set Up Cash Pools (if applicable)

Navigation: Cash Management > Bank Statements > Cash Pools

If your organization uses cash pooling, set up cash pool structures and rules.

Step 13: Perform Cash Forecasting (if applicable)

Navigation: Cash Management > Forecasting

Set up cash forecasting parameters and perform cash forecasting based on bank statement data.

Step 14: Review Cash Management Reports

Navigation: Cash Management > Reports

Use various Cash Management reports to review bank statement details, cash positions, and cash forecasts