1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Bank setup

Discussion in 'Oracle Financials' started by Bharat, May 10, 2012.

  1. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi all,

    Can anyone please provide me some documents or setup steps on bank creation in R12.1.3.
     
  2. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    It is pretty straight forward. I shall upload tonight.
    cheers
    Ramji
     
  3. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
  4. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi ramji,

    I think that document contains bank account creation steps. But I want to create new bank here. Can you please provide me on that if any.
     
  5. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    I think I have uploaded a few more along with that. Pls check the documents and if not on there I will upload for you.
    cheers
    Ramji
     
    Bharat likes this.
  6. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Sorry for that ramji... I have just seen the below document in given link and responded to that. I will check that now.
     
  7. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi bhai,

    I have tried to create bank, but unfortunately after entering contact information the form is not getting saved and throwing below error:
    The following SQL error occurred: ORA-06508: PL/SQL: could not find program unit being called.
    Please help me on this.
     
  8. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Its a known issue. Invalid objects. Custom and Std plls need to be recompiled.
    cheers
    Ramji
     
    Sadik likes this.
  9. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi bhai,

    DBA people are trying to recompile all pll's, but they are saying that only few of them are compiled and others are not getting compiled. In this case what need to do to overcome this.
     
  10. byharris5@comcast.net

    byharris5@comcast.net Active Member

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    100
    Location:
    Northern CA
    Setup Step Step Type Oracle Application and Applicable Guide
    Set up internal bank accounts and related payment documents. required Oracle Cash Management, Bank and Account Administration: Define Bank Accounts, Oracle Cash Management User Guide.
    Set up bill-to location and operating units. required Legal Entity Configurator, Oracle Financials Implementation Guide. See Legal Associations, Oracle Financials Implementation Guide, Creating Establishments, Oracle Financials Implementation Guide, and Updating Establishments, Oracle Financials Implementation Guide.
    Set up external bank accounts. conditionally required

    Note: External bank accounts are supplier bank accounts. This step is required if the Payments user and/or the Payables user wants to transfer funds electronically to supplier bank accounts. This step is not required if the Payments user and/or the Payables user only wants to print checks.

    Oracle Cash Management, Creating Banking Details, Oracle iSupplier Portal User's Guide, Oracle iSupplier Portal User's Guide.
    Set up a tax reporting entity. required Oracle Payables, Oracle Payables User Guide. See Reporting Entities, Oracle Payables Implementation Guide.
    Define conversion rates. conditionally required when using multiple currencies Oracle General Ledger, Oracle General Ledger User's Guide. See Defining Conversion RateTypes, Oracle General Ledger User's Guide.
    Prerequisites

    Before you can setup Oracle Payments, you must perform following prerequisite setup steps:

    Set Up Taxes, Oracle E-Business Tax User Guide. See Setting Up Taxes, Oracle E-Business Tax User Guide.

    Set Up a Tax Registration, Oracle E-Business Tax User Guide. See Setting Up a Tax Registration, Oracle E-Business Tax User Guide.

    Set Up Legal Entities, Legal Entity Configurator, Oracle Financials Implementation Guide. See Creating a Legal Entity, Oracle Financials Implementation Guide.

    Setup Checklist for Shared Oracle Payments Setup Tasks

    The table below shows the Oracle Payments setup checklist for features used by both funds capture and funds disbursement. These shared setup steps should be setup in the sequence indicated in the table below.
    Oracle Payments Setup Checklist for Features Used by Both Funds Capture and Funds Disbursement Step Number Setup Step Step Type Oracle Application
    1. Creating Oracle Payments Users required Application Object Library
    2. Setting Up System Security Options optional Oracle Payments
    3. Setting Up or Updating Oracle XML Publisher Templates for Payment Formats or Reporting Formats.

    Note: Many such formats are seeded in Oracle XML Publisher.

    conditionally required Oracle XML Publisher
    4. Setting Up Formats conditionally required Oracle Payments
    5. Setting Up Validations optional Oracle Payments
    6. Setting Up Transmission Configurations conditionally required Oracle Payments
    7. Configuring Tunneling conditionally required Oracle Payments
    8. Setting Up Payment Systems conditionally required Oracle Payments
    9. Configuring Oracle Payments Sample Servlet optional Oracle Payments
    10. Setting Up SSL Security for Payment System Servlet Communication optional Oracle Payments
    11. Configuring the XML Framework required Oracle Payments
     
  11. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Dear Bharat,

    Did you retry doing the setup? Did you see any difference?
    Cheers
    Ramji
     
  12. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Which setup bhai. I haven't tried doing any setups hope so. I have just said to our DBA guys to recompile those plls. But they just replied that only few of them are getting compiled and rest are not getting compiled.
     
  13. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Dear Bharat,

    Retry doing the setup and see if you are getting the same message or a different one.
    cheers
    Ramji
     
  14. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi ramji,

    I have tried creating bank again but same error raising again and again.
     
  15. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Ask them to try and disable the custom plls.
    cheers
    Ramji
     
  16. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi ramji,

    Problem Statement: -
    I have tried to create bank, but unfortunately after entering contact information the form is not getting saved and throwing below error:
    The following SQL error occurred: ORA-06508: PL/SQL: could not find program unit being called.

    Solution: -
    The issue is resolved due to different timings in OS level and database level. So after that they tried to re-compile those pll's and successfully compiled. And now issue is resolved and am able to create banks, bank branches, contacts and everything.
    Thank you guys for valuable suggestions.
     
  17. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Bhatappa,

    Good you are on the ball.
    cheers
    Ramji
     
    Bharat likes this.