Skip to main content

Posts

Showing posts with the label Cash Management

Cash Management (CE)

Cash Management (CE) New Tables Table Name Feature Area CE_BANK_ACCOUNTS Bank Account Model CE_BANK_ACCT_USES_ALL Bank Account Model CE_GL_ACCOUNTS_CCID Bank Account Model CE_INTEREST_BALANCE_RANGES Balances and Interest Calculation CE_INTEREST_RATES Balances and Interest Calculation CE_INTEREST_SCHEDULES Balances and Interest Calculation CE_BANK_ACCT_BALANCES Balances and Interest Calculation CE_PROJECTED_BALANCES Balances and Interest Calculation CE_INT_CALC_DETAILS_TMP Balances and Interest Calculation CE_CASHFLOWS Bank Account Transfers CE_CASHFLOW_ACCT_H Bank Account Transfers CE_PAYMENT_TRANSACTIONS Bank Account Transfers CE_PAYMENT_TEMPLATES Bank Account Transfers CE_TRXNS_SUBTYPE_CODES Bank Account Transfers CE_XLA_EXT_HEADERS Subledger Accounting CE_CONTACT_ASSIGNMENTS Bank Account Model CE_AP_PM_DOC_CATEGORIES Bank Account Model CE_PAYMENT_DOCUMENTS Bank Account Model CE_SECURITY_PROFILES_GT Bank Account Model CE_CHECKBOOKS Bank Account Model Changed Tables Table Name Feature...

Cash Management Reconciliation

1) Run the program- Bank Statement Loader to load data in following Open Interface tables CE_STATEMENT_HEADERS_INT_ALL (Stores Information about bank statement Header details) CE_STATEMENT_LINES_INTERFACE (Stores Information about bank statement Line details) 2) Run the program- Bank Statement Import to load data in following Base tables from Interface tables. CE_STATEMENT_HEADERS CE_STATEMENT_LINES 3) Error information is stored in following tables while running Bank Statement Import CE_HEADER_INTERFACE_ERRORS CE_LINE_INTERFACE_ERRORS 4) Run the program- AutoReconciliation which in turn calls AutoReconciliation Execution Report (CEXINERR) (AutoReconciliation --> CE_AUTO_BANK_REC.statement --> CE_AUTO_BANK_MATCH.match_process) 5) Error information is stored in following table while running AutoReconciliation Program CE_RECONCILIATION_ERRORS 6) Reconciliation history or audit trail is stored in table- CE_STATEMENT_RECONCILS_ALL. Each row represents an action performed against a st...

Oracle R12 – Some good Question on Supplier – Bank Setups

Where is Supplier Bank Information Stored in Release 12? The supplier bank account information is in the table: IBY_EXT_BANK_ACCOUNTS, the bank and bank branches information is in the table: HZ_PARTIES. The bank branch number can be found in the table: HZ_ORGANIZATION_PROFILES The HZ_ORGANIZATION_PROFILES table stores a variety of information about a party. This table gets populated when a party of the Organization type is created. This table also contains data retrieved from Dun & Bradstreet using either the Dun & Bradstreet online or batch download methods. Historical data for the organization can also be stored in this table. Each time organization information is changed, the effective end date column for the original record is updated and a new record that contains the updated information is created. The column name is BANK_OR_BRANCH_NUMBER VARCHAR2 (30) Stores bank number for banks and branch number for bank branches, primarily ABA number for US bank branches. Where are Su...

Oracle EBS: Banks

The concept of Banks in Oracle Apps is same as Customer or Suppliers i.e. Banks are treated as Party or a Shared Entity. Banks are shared among following modules: Payables Receivables Treasury Payroll Cash Management Technically Banks are owned by Cash Management. The hierarchy of banks is as follows: Bank Bank Branch Bank Account Payment Document or Check Book Banks are used in Payables for Payments and in Receivables they are used for Receipts . Then these payments and receipts are automatically transferred to Oracle Cash Management for reconciliation depending on the configured options for reconciliation and Receipt Methods. The Bank setups are changed in R12 as compared to R11i. The two major changes in Bank setups are: The concept of Account Owner in Bank Account Setup. And secondly you have to configure Cash Management Responsibility whatsoever to setup a bank. This account owner refers to Legal Entity. You can see the use of this concept where there are more...

R12 - How To Make A Personalized View Such As Bank Balance For All Users?

R12 - How To Make A Personalized View Such As Bank Balance For All Users? Do the following to make views visible for other users:    1. Set the Personalize Self-Service Defn profile option to Yes for the functional sysadmin user.    2. Set the FND: Personalization Region Link Enabled profile option to Minimal or Yes.    3. Ensure the profile option Disable Self-Service Personal is not set to NO.    4. Login as the functional sysadmin user and navigate to Project List    5. Click on the Personalize link at the top of the page    6. Click on the eye glasses icon in the Seeded User Views column (Table: Balances..)    7. Create a new view or duplicate an existing one. Take care to provide values for all the required search criteria otherwise your query will fail. Optionally specify a securing function to indicate a subset of users who can access the newly seeded view. You can also mark a...

Cash Management :General Ledger Reconciliation Report works on the following principles

The GL reconciliation report works on the following principles  a. Payments which have been credited into the GL Cash Account but not  Reconciled against a Bank Statement Line in the current period - these  payments are deducted from the Bank Statement Closing Balance.  b. Payments which have not been credited into the GL Cash Account but are  Reconciled against a Bank Statement Line in the current period - these  payments are added to the Bank Statement Closing Balance.  c. Payments which have not been credited into the GL Cash Account and are  not Reconciled against a Bank Statement Line but appear on a Bank Statement  in the current period - these payments are added to the Bank Statement  Closing Balance.  Please note that transactions available for reconciliation is very different  from GL report on the principles listed above.  The accounting is only done for the payment creation, ie, accounting line  only for AE...

R12 BANK TABLE AND QUERY

SELECT    HOU.NAME OPERATING_UNIT,                   BNK.BANK_ACCOUNT_NUM,                   BRNCH.BANK_NAME,                   BRNCH.BANK_BRANCH_TYPE,                   BRNCH.BANK_BRANCH_NAME,                   BRNCH.DESCRIPTION   FROM   CE_BANK_ACCOUNTS BNK,          CE_BANK_ACCT_USES_ALL SITE,          CEFV_BANK_BRANCHES BRNCH,          HR_OPERATING_UNITS HOU  WHERE       BNK.BANK_ACCO...

Logic for GL reconciliation report

The GL reconciliation report works on the following principles  a. Payments which have been credited into the GL Cash Account but not  Reconciled against a Bank Statement Line in the current period - these  payments are deducted from the Bank Statement Closing Balance.  b. Payments which have not been credited into the GL Cash Account but are  Reconciled against a Bank Statement Line in the current period - these  payments are added to the Bank Statement Closing Balance.  c. Payments which have not been credited into the GL Cash Account and are  not Reconciled against a Bank Statement Line but appear on a Bank Statement  in the current period - these payments are added to the Bank Statement  Closing Balance.  Please note that transactions available for reconciliation is very different  from GL report on the principles listed above.  The accounting is only done for the payment creation, ie, accounting line  only for AE...