Friday, October 1, 2010

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 statement line.

7) Transactions from all the views below are consolidated into CE_AVAILABLE_TRANSACTIONS_V for bank statement reconcillation

CE_101_TRANSACTIONS_V -- GL journal entry lines

CE_185_TRANSACTIONS_V -- Treasury Transactions

CE_200_TRANSACTIONS_V -- AP payments

CE_222_TRANSACTIONS_V -- AR cash receipts

CE_260_TRANSACTIONS_V -- Bank statement lines available for reconciling bank errors

CE_801_TRANSACTIONS_V -- Payroll payments

21 comments:

  1. hi amit,
    Can you please share any sample code (Loader script/custom validations code )for this interface along with the required validation before run the the interface.


    Thanks,
    Rafee
    sk.rafee@gmail.com

    ReplyDelete
    Replies
    1. Hi Amit,

      Can you please send the same to patra.sunita3@gmail.com.

      Regards,
      Sunita

      Delete
  2. Hi Rafee,
    Sent sample code to your mail id. Thanks !!

    ReplyDelete
    Replies
    1. Hi Amit,

      Can you please send me the above sample code as well. vbhupath@hotmail.com.

      Thanks

      Delete
    2. Hi Amit,

      Do u have any sample code for customized AutoReconciliation Process. I Want to Develop a Custom Code for Reconciliation of Particular receipts only.

      Thank you for your time Bro.

      Please share related material on Eng.saif09@gmail.com .

      Delete
  3. Hi Amit,
    Can you please share the code to my email as well.
    pvnaidu2010@gmail.com

    Thanks
    Viren

    ReplyDelete
  4. Hi Viren,
    Sent code to your mail id, plz chk...

    ReplyDelete
  5. Hi Amit,

    Please mail the source code to arkeyapps@gmail.com

    Thanks
    Arkey

    ReplyDelete
  6. hi amit,
    We are using R12.1.3.
    I ran standard bank loader program and data is loaded form temp table to interface tables CE_STMT_INT_TMP to CE_STATEMENT_HEADERS_INT/CE_STATEMENT_LINES_INTERFACE.But data is not loaded into CE_STATEMENT_HEADERS/CE_STATEMENT_LINES.I didn't found any errors in CE_HEADER_INTERFACE_ERRORS/CE_LINE_INTERFACE_ERRORS.Can you please give any hint why data is not moved from interface tables?I didn't found any errors in Bank Statement Import log/out files.But AutoReconciliation Execution Report erroring out but not giving any data in outfile.Here is the log file.Can u please provide any inputs to debug this issue.
    sk.rafee@gmail.com

    +-----------------------------
    | Starting concurrent program execution...
    +-----------------------------

    Arguments
    ------------
    P_BANK_BRANCH_ID='12345'
    P_BANK_ACCOUNT_ID='456'
    P_STAT_NUMBER_FROM='070110'
    P_STAT_NUMBER_TO='070110'
    P_SQL_TRACE='N'
    P_DISPLAY_DEBUG='N'
    ------------

    APPLLCSP Environment Variable set to :

    Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
    AMERICAN_AMERICA.UTF8

    ' '

    Enter Password:
    MSG-00001: CE_INVALID_BANK_ACC
    REP-1419: 'beforereport': PL/SQL program aborted.
    REP-0069: Internal error
    REP-57054: In-process job terminated:Terminated with error:
    REP-1419: MSG-00001: CE_INVALID_BANK_ACC
    REP-1419: 'beforereport': PL/SQL program aborted.


    Report Builder: Release 10.1.2.3.0 - Production on Fri Apr 20 10:08:23 2012

    Copyright (c) 1982, 2005, Oracle. All rights reserved.


    +---------------------------------------------------------------------------+
    Start of log messages from FND_FILE
    +---------------------------------------------------------------------------+
    +---------------------------------------------------------------------------+
    End of log messages from FND_FILE
    +---------------------------------------------------------------------------+
    Program exited with status 1
    Concurrent Manager encountered an error while running Oracle*Report for your concurrent

    ReplyDelete
  7. Hi rafee check the bank account once may b its wrong.

    Hope this will help you.....

    For more materials visit http://kommaoracleapplications.blogspot.in/

    ReplyDelete
  8. Great job keep updates see oracle global consultants for business consulting.

    ReplyDelete
  9. While looking for you to purchase insurance, It is confusing Equally to what firm would be the Best to buy your current insurance from. whether That isn't bad enough, a person furthermore be asked to decide no matter whether to buy your own insurance by a good insurance broker or even a good insurance company. insurance news

    ReplyDelete
  10. Hi Amit

    Can you share the sample code for custom loader and custom validations

    Thanks
    Seshu
    mail: svsseshukumar@gmail.com

    ReplyDelete
  11. Hi Amit

    Can you share the sample code for custom loader and custom validations

    Thanks
    Prasanta
    mail: pkrhyd@gmail.com

    ReplyDelete
  12. Hi Amit

    Can you share the sample code for custom loader and custom validations

    Thanks
    Shaibaan
    mail: mudassirshaibaan@gmail.com

    ReplyDelete
  13. Hi, Do you have code which can change payment status from NEGOTIABLE to CLEARED automatically (any API), I know, manually we can do from from end, manual clearing. We DO NOT want to reconcile the payments. Send me your help on vikas.me@gmail.com. Thanks.

    ReplyDelete
  14. Hi Amit,
    Can you please share the code to my email as well.
    basu.patil1509@gmail.com

    ReplyDelete
  15. Credit rating score reporting isn't always something however oracle fusion procurement way wherein viable avail with alternatives to provide the client or the economic enterprise agency with all of the credit score and debt facts
    oracle fusion procurement hcm online training
    oracle fusion cloud hcm training

    ReplyDelete
  16. The blog is a limelight for people.The more I read, the more I fell deep into it.
    Binance affgadgets

    ReplyDelete
  17. Some things are good. Some are great. Then comes this blog.
    Initial Coin Offering

    ReplyDelete
  18. You know your projects stand out of the herd. There is something special about them. It seems to me all of them are really brilliant run 3

    ReplyDelete

Note: Only a member of this blog may post a comment.