Monday 6 July 2015

Oracle Cash Management Setups

Oracle Cash Management module helps you to streamline the reconciliation process and manage the cash cycle effectively. 

Below are the basic functionalities and the setups to start with Cash Management module.

Step 1. Create Cash Management Responsibility
Responsibility: System Administrator
Navigation: Security > Responsibility > Define         


  Exclude Menus/Functions which are not required.

Step 2: Define Profile Option Values for Cash Management responsibility
Navigation: System Administrator > Profile > System 

1. MO: Operating Unit
2. MO: Security Profile
3. GL Ledger Name
4. GL: Data Access Set
5. SLA: Additional Data Access Set

Step 3: Assign Cash Management Responsibility to Users
Security > User > Define

Query the user and assign Cash Management responsibility created in Step 1.

Step 4: Assign Legal Entity to the Cash Management Responsibility
Assigning the Legal Entity to Cash Management responsibility gives the access to legal entity for cash management setups.

This is very important setup and with out this setup, you can not access the legal entity details to setup CM system parameters. 

Responsibility: User Management
Navigation: Roles & Role Inheritance


Search the page with below values:
Type: Roles & Responsibilities
Category: Miscellaneous
Name: Cash Management Super User (The CM responsibility Name) 
Application: Cash Management

Click on Update icon against Cash Management Super User responsibility.


Click on Security Wizards.



Click on Run Wizard icon for CE UMX Security wizard. Add the Legal Entity ‘XX India Private Limited’ and select Use, Bank Account Grants Maintenance and Bank Account Transfers check boxes.




Click on Apply to save the changes.

Step 5: Define Cash Management System Parameters


Setup the System Parameters to configure your Cash Management system according to your business requirements. 

Navigation: Cash Management Superuser > Setup > System > System Parameters




Legal Entity: The Legal Entity name.
Ledger: The ledger name for Cash Management accounting transactions. If there are multiple ledgers assigned to your Legal Entity, System Parameters should be setup for each ledger.
Begin Date: Cash Management shows payment, receipts, journals, and open interface transactions details from the Begin Date.
Show Cleared Transactions: If you check this check box, cleared transactions will be available for reconciliation along with uncleared transactions.
Add Lines to Automatic Statements: If you check this check box, users can add lines to existing automatically loaded bank statements.

Archive/Purge: Use the Archive and Purge check boxes to allow Autoreconciliation program to automatically purge/archive the data from Bank Statement Interface tables once the information has been successfully transferred to the bank statement tables.

Exchange Rate Type: Cash Flows and Bank Account Transfer transactions use the exchange rate specified here.
Bank Statement Cash flow Rate Date: The cash flow program uses the date specified here to get the exchange rate details.
Bank Transfer Rate Date: The Bank Account Transfers use the date specified here to get the exchange rate details.


Bank Account Transfers Authorization: Specify whether the authorization is required to settle bank account transfers.

Step 6: Define Bank Transaction Codes
Define the bank transaction codes that your bank uses to identify different types of transactions on its statements. Bank Statement Loading will fail if the bank transaction codes are not defined in the system which are there in the bank statement files.

Cash Management Superuser > Setup > Banks > Bank Transaction Codes



Step 7: Define Bank Statement Mappings
Bank Statement Loader program uses this Bank Statement mappings template to map the Bank statement fields. For Example, the first lines in below image means, the 5th position on second records represents the Statement number.

Cash Management Superuser > Setup > Banks > Bank Statement Mappings



Step 8: Define Cash Flow Mappings
Cash Management module provide the feature of Cashflows to generate the cash flow transactions and generate the Journal entries in the system. 

This feature is mainly used when there is no payment/receipt/journal to reconcile against a bank statement line. Instead of creating a manual journal entry, you can use this feature to create cashflow transactions you can reconcile with bank statement lines and subsequently the journal entries get created.

Cash Management Superuser > Setup > Banks > Bank Statement Cashflow Mappings



As a prerequisite, there should be transaction codes exist in the system, for which the GL accounts are assigned in cash flow mappings. The journal entries will get created by using this account.

Once the transaction codes and cashflow mappings present in the system, users need to run Bank Statement Cashflow creation program to generate the cash flows for a particular bank account for which the statement lines exist with Cash Flow transaction codes.

Step 9: Setup Autoreconciliation Tolerances
Cash Management Superuser > Setup > Bank Accounts

Query Bank Account name and select Update Account option. Navigate to Account Controls.
 Under Auto Reconciliation Tolerances > Payments section, Setup Tolerance amount, Tolerance Percentage, Foreign Tolerance Differences and Tolerance Differences.

Step 10: Setup Cash Clearing Account
Cash Management Superuser > Setup > Bank Accounts

Query Bank Account name and select Update Account option. Navigate to Account Access > Options.



Step 11: Setup Entered Currency Balancing Account

The Entered Currency Balancing Account is used by Subledger Accounting to balance foreign currency subledger journals by the entered currency and balancing segment value. Without this account defined, system can not derive the CCID for foreign currency transactions.

Navigation: General Ledger Super User > Setup > Financials >Accounting Setup Manager > Accounting Setups

Query the Ledger. Click on Update Accounting options.


Click on Update Ledger Options. Under Subledger Accounting section, add Entered Currency Balancing Account.




31 comments:

  1. Hi,

    This blog is very interesting. Now I have started working on Functional side. I have done my practice based on your blog and this very good blog.

    Could you please share some setup documents if you have, it would be really helpful for me.

    my mail id manjunathptc(at)gmail(dot)com

    ReplyDelete
    Replies
    1. Haven't you heard about cyber hacking company blank ATM card and how other people had benefited from it? I am Williams vivian by name, i want to share a blog and forums on how to get real blank ATM card,thank to cyber hacking company who helped me with an already hacked ATM CARD and i was so poor without funds that i got frustrated. One morning as i was browsing on the internet, i saw different comments of people testifying of how cyber hacking company helped him from being poor to a rich man through this already hacked ATM CARD. I was skeptical if this was true, i decided to contact him to know if he is real he proved to me beyond all doubts that its was really for real so i urgently receive my blank ATM card. Contact his email cyberhackingcompany@gmail.com and today am also testifying on how cyber hacking company helped me. I never believed in it until the card was sent to me, which am using today Contact the company now and become rich. Email: cyberhackingcompany@gmail.com 

      Delete
    2. iI’m lauriel from New York, United States. I lost my job a few months back after my divorce with my wife. I tried everything positive to make sure I took good care of my kids but all failed, and I was in debt which makes everything worse. I was kicked out of my home and i had to live with my neighbor after pleading with her to allow me to stay with her for some days while I figured out how to get a home which she agreed to, but no one was willing to help anymore. I bumped into this page from google and I was excited about this, then I contacted the hackersBill Dean. I had just $200, so I pleaded with them to help me because of my condition but they never accepted. I believed in this, so I managed to pawn a few things and got $500. I ordered the $10,000 card and I got my card delivered to me by Ups 4 days later. I never believed my eyes! I was excited and upset as well, I managed to withdraw $2000 on the ATM and $2500 the second day. I went to Walmart and a grocery store and bought a couple of things for $3000. The card got blocked the third day and I contacted them and I was told it's a mistake from my end. I’m so happy, I have started all over again and have a good apartment with my kids you can contact him through is via email (globalatmcardhackingservice@gmail.com)or his whatsap contact (+1 301-887-5071)

      Delete
  2. This is a very good article straight to the point

    ReplyDelete
  3. I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in ORACLE CASH MANAGEMENT, kindly contact us http://www.maxmunus.com/contact
    MaxMunus Offer World Class Virtual Instructor led training on ORACLE CASH MANAGEMENT We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
    For Demo Contact us.
    Saurabh Srivastava
    MaxMunus
    E-mail: saurabh@maxmunus.com
    Skype id: saurabhmaxmunus
    Ph:+91 8553576305 / 080 - 41103383
    http://www.maxmunus.com/


    ReplyDelete
  4. Thanks for the given information you are providing content very usefull to users.
    Learn Register the Report from Back End in Oracle Apps R12 Actual cost of this course is 9,999/- But now Kuncham Software Solutions Pvt ltd is giving you Free access. Limited period offer Hurry-up Enroll Now at Udemy.


    Hurry-Up Enroll Now and get Free Access to the Entire Course

    ReplyDelete
  5. I'm  here to share my testimony of what a good trusted loan company did for me. My name is Nikita Tanya, from Russian and I’m a lovely mother of 3 kids I lost my funds on trying to get a loan it was so hard for me and my children, I went online to seek for a loan assistance  all hope was lost until one faithful day when I met this friend of mine who recently secured a loan from Le_Meridian Funding Service She introduced me to this honest loan company who helped me get a loan in within 5 working days, I will forever be grateful to Mr Benjamin, for helping me get back on feet again. You can contact Mr Benjamin via email: lfdsloans@lemeridianfds.com, they do not know I’m doing this for them, but i just have to do it because a lot of people are out there who are in need of a loan assistance  please come to this company and be saved.WhatsApp:(+1 989-394-3740)

    ReplyDelete

  6. Thanks for sharing,excellent information.It is very useful for me to learn and understand easily.Tableau is a powerful and fastest growing data visualization tool used in the Business Intelligence Industry. Business Intelligence Industry suggest to take tableau course to enhance their skills
    tableau training institute in bangalore

    ReplyDelete
  7. Are you looking for a business loan, personal loans, mortgage loans, car loans, student loans, unsecured loans for consolidation, project finance etc ... Or simply refuse loans from a bank or financial institution for one or more reasons? We are the right solutions for credit! We offer loans to companies and individuals with a low and affordable 2% interest rate. Therefore, if you are interested in an urgent and secured loan. For more information, please email us today: Via: Elegantloanfirm@hotmail.com.

    ReplyDelete
  8. The Le_Meridian Funding Service went above and beyond their requirements to assist me with my loan which i used expand my pharmacy business,They were friendly, professional, and absolute gems to work with.I will recommend  anyone looking for loan to contact. Email..lfdsloans@lemeridianfds.com  Or lfdsloans@outlook.com.WhatsApp ... + 19893943740.

    ReplyDelete
  9. My name is Sara Johnson, I live in california U.S.A and i am a happy woman today? I told my self that any Loan lender that could change my Life and that of my family after been scammed severally by these online loan lenders, i will refer any person that is looking for loan to Them. he gave happiness to me and my family, although at first i found it hard to trust him because of my experiences with past loan lenders, i was in need of a loan of $300,000.00 to start my life all over as a single parents with 2 kids, I met this honest and GOD fearing loan lender online Dr. Dave Logan that helped me with a loan of $300,000.00 U.S. Dollars, he is indeed a GOD fearing man, working with a reputable loan company. If you are in need of loan and you are 100% sure to pay back the loan please contact him on (daveloganloanfirm@gmail.com and Call/Text: +1(501)800-0690 ) .. and inform them Sara Johnson directed you.. Thanks. Blessed Be.

    ReplyDelete
  10. Nice article. Thanks for sharing this informative article. Bankin is a advance digital payment app. Using this service you make payment anywhere across globe.
    Digital Payment App
    www.bankin.app/blog/paypal-vs-skrill/
    www.bankin.app/blog/best-money-transfer-apps/
    www.bankin.app/blog/transferwise-vs-paypal/

    ReplyDelete
  11. The biggest advantage when you buy lottery online Singapore is that if you win, you are automatically announced by phone call , whatsapp or wechat.

    ReplyDelete
  12. If you are an online gambling player . Surely you have already heard the name MAS8.

    ReplyDelete
  13. Banyak para penjudi newbie yang terkadang masih belum mempunyai keputusan pasti untuk memainkan permainan dalam mengawali sesi judi mereka. Tetapi kami ingin membuka pengetahuan Anda tentang permainan judi slot atau yang sering terdengar sebagai judi slot games Indonesia sebagai pembuka sesi judi terbaik Anda.

    ReplyDelete
  14. HOW I GO MY DESIRED LOAN AMOUNT FROM A RELIABLE AND TRUSTED LOAN COMPANY LAST WEEK. Email for immediate response: drbenjaminfinance@gmail.com Call/Text: +1(415)630-7138 Whatsapp +19292227023

    Hello everyone, My name is Mr.Justin Riley Johnson, I am from Texas, United State, am here to testify of how i got my loan from BENJAMIN LOAN INVESTMENTS FINANCE(drbenjaminfinance@gmail.com) after i applied Two times from various loan lenders who claimed to be lenders right here this forum,i thought their lending where real and i applied but they never gave me loan until a friend of mine introduce me to {Dr.Benjamin Scarlet Owen} the C.E.O of BENJAMIN LOAN INVESTMENTS FINANCE who promised to help me with a loan of my desire and he really did as he promised without any form of delay, I never thought there are still reliable loan lenders until i met {Dr.Benjamin Scarlet Owen}, who really helped me with my loan and changed my life for the better. I don't know if you are in need of an urgent loan also, So feel free to contact Dr.Benjamin Scarlet Owen on his email address: drbenjaminfinance@gmail.com BENJAMIN LOAN INVESTMENTS FINANCE holds all of the information about how to obtain money quickly and painlessly via Whatsapp +19292227023 Email: drbenjaminfinance@gmail.com and consider all your financial problems tackled and solved. Share this to help a soul right now, Thanks

    ReplyDelete
  15. Do you need an urgent loan of any kind? Loans to liquidate debts or need to loan to improve your business have you been rejected by any other banks and financial institutions? Do you need a loan or a mortgage? This is the place to look, we are here to solve all your financial problems. We borrow money for the public. Need financial help with a bad credit in need of money. To pay for a commercial investment at a reasonable rate of 3%, let me use this method to inform you that we are providing reliable and helpful assistance and we will be ready to lend you. Contact us today by email: daveloganloanfirm@gmail.com Call/Text: +1(501)800-0690 And whatsapp: +1 (315) 640-3560

    NEED A LOAN?
    Ask Me.

    ReplyDelete
  16. HELLO, I am Rebecca Michaelson by name living in Europe. Here is a good news for those interested. There is away you can earn money without stress contact (THOMAS FREDDIE) for a blank [ATM CARD] today and be among the lucky once who are benefiting from this cards. This PROGRAMMED blank ATM card is capable of hacking into any ATM machine anywhere in the world. I got my master card from a good Hacker on the internet, with this ATM Card I am able to collect $5000 dollars every day via contacts:
    +1 (985) 465-8370 {thomasunlimitedhackers@gmail.com}
    I was very poor but this card have made me rich and happy, If you want to get this opportunity to become rich and establish your business then apply for this Master card, I am so happy about this because i got mine last week and I have used it to get $240,000.00 dollars from THOMAS FREDDIE UNLIMITED Hackers is giving out the card just to help the poor and needy and they ALSO OFFER FINANCIAL ASSISTANCE. get yours from THOMAS FREDDIE UNLIMITED HACKERS today. Kindly contact them by Email thomasunlimitedhackers@gmail.com

    Thank You and God bless

    ReplyDelete
  17. Programmed ATM Cards
    Do you know that you can hack any ATM machine !!!
    We have specially programmed ATMs that can be used to withdraw money at ATMs, shops and points of sale. We sell these cards to all our customers and interested buyers all over the world, the cards have a withdrawal limit every week.
    Getting rich and living the rich and famous lifestyle is a dream of many people. And while most people go to work or look for other ethical methods to make money on ATM-programmed cards.
    The programmed ATMs withdraw money from each ATM but have a withdrawal limit every week, only your PIN code is in it, it is a high-tech card system. The PROGRAMMED ATM card works on all card-based ATMs, anywhere in the world.
    Email: atmservices44@aol.com
    Email: hacklords.investors@gmail.com

    ReplyDelete
  18. GET RICH WITH BLANK ATM CARD ... Whats-app: +1(209)-643-1515

    I want to testify about Oscar White blank ATM cards which can withdraw money from any ATM machines around the world. I was very poor before and have no job. I saw so many testimony about how Oscar White hackers send them the ATM blank card and use it to collect money in any ATM machine and become rich. ( oscarwhitehackersworld@gmail.com ) I email them also and they sent me the blank ATM card. I have use it to get 75,000 dollars. withdraw the maximum of 4,500 USD daily. Oscar White is giving out the card just to help the poor. Hack and take money directly from any ATM machine vault with the use of ATM programmed card which runs in automatic mode.
    Email:oscarwhitehackersworld@gmail.com
    Text & Call or Whats-app: +1(209)-643-1515

    ReplyDelete
  19. Dear Sir / Madam

    Do you need funds to start up your own business? Do you need loan to settle your debt or pay off your bills or start a nice business? Do you need funds to finance your project? We Offers guaranteed loan services of any amount and to any part of the world for (Individuals, Companies, Realtor and Corporate Bodies) interest rate of 2% within 1 year to 50 years repayment duration period to any part of the world. We give out loans within the range of $1,000 to $100,000,000 USD. Our loans are well insured for maximum security is our priority.

    For application and more information send replies to the following

    Lender's Name: Scott Tucker
    Lender's Email: scotttuckerloanfund@gmail.com
    What app Number: +16182279611

    ReplyDelete
  20. THANKS, THANKS, THANKS A LOT

    ReplyDelete
  21. INSTEAD OF BITCOIN INVESTMENT SCAM WHY DON'T YOU CONTACT MR OSCAR FOR A REAL BLANK ATM CARD
    oscarwhitehackersworld@gmail.com or whats-app +1(209)-643-1515.

    My name is Morgan Williams am from Alabama United State,this is so real and wonderful, at first i thought is a scam , because have been scam by several people claiming they can help me invest my money in bitcoin trading , that is how i lost my $25,000 last week on investment , but with the help of Mr Oscar White Blank ATM Card oscarwhitehackersworld@gmail.com , i was able to withdraw $50,000 from ATM machine without trace more than the money i lost last week , indeed Mr Oscar your Blank ATM card is real and genuine , i will keep telling people about you as i promise to do , if you are in any financial problem to pay up bills and start up a new life , kindly contact Mr Oscar white on how you can obtain his Blank ATM card , he does not charge big , trust him and contact him today through email oscarwhitehackersworld@gmail.com ,whats-app +1(209)-643-1515

    ReplyDelete
  22. I would like to thank Lapo Micro Finance for giving me a loan. I was deceived several times trying to get a loan until I came across Lapo Micro Finance who provided me with a loan worth $ 23,000 to care for my sick child. If you need a real lender today, contact Lapo and don't be fooled.Contact email: lapofunding960@gmail.com
    Whatsapp +447883183014

    ReplyDelete
  23. GET RICH WITH THE USE OF BLANK ATM CARD. I'm here to testify about how I used a BLANK ATM CARD that I got from a hacker to make money and also have my own business today. Go get your blank ATM card today and be among the lucky ones. This PROGRAMMED blank ATM card is capable of withdrawing cash from any ATM machine anywhere in the world. It has really changed people's lives for good and now I can say I am rich and I can never be poor again. You can withdraw the maximum of $5,500 daily i can proudly say my business is doing fine and i have up to $ 1,000 000 (1 millions dollars in my account) Is not illegal, there is no risk of being caught, because it has been programmed in such a way that it is not traceable, it also has a technique that makes it impossible for the CCTV to detect you.. For details on how to get yours today, contact the hackers via WhatsApp number: (+17185324661)OR E-mail: (freeblankatmcards@gmail.com)

    ReplyDelete
  24. Awesome blog, Gratitude for sharing it. Contact dynamic netsoft technologies for Treasury Management

    ReplyDelete
  25. (NO MEMBERSHIP FEE TO JOIN ILLUMINATI), I am giving a testimony on how i became rich and
    famous today… i was deeply strangled up by poverty
    and i had no body to help me, and also i searched for
    help from different corners but to no avail… I see
    people around me getting rich but to me i was so
    ashamed of my self so i met a man on my way he was
    very rich and he was a doctor so he told me something
    and i think over it through out the day so the next day
    i looked up and i keep repeating what he said to me.
    ” if you want to get rich quick and be famous” you
    need to cross your heart and do what is in your mind
    so i tried all i could in other for me to do as he said
    so later on i told my fellow friend about this same
    thing then my friend was interested in my suggestions
    so i decided to look in the internet and i found an
    email of an angent Jackson illuminatiriches50085@gmail.com and
    we decided to contact them and fortunately we did as
    them instruct us to do and later, them told us to get some
    requirements and all the rest… so this initiation took
    us just a week and later on the great Illuminati gave
    us $7,000,000.00 to start up our lives…. and now am
    testifying that if in any case you want to join any
    great Illuminati all you need to do is for you to contact
    him on whatsapp +1(409)2993890.

    ReplyDelete
  26. Do you need an urgent loan of any kind? Loans to liquidate debts or need to loan to improve your business have you been rejected by any other banks and financial institutions? Do you need a loan or a mortgage? This is the place to look, we are here to solve all your financial problems. We borrow money for the public. Need financial help with a bad credit in need of money. To pay for a commercial investment at a reasonable rate of 3%, let me use this method to inform you that we are providing reliable and helpful assistance and we will be ready to lend you. Contact us today by email: daveloganloanfirm@gmail.com Call/Text: +1(501)800-0690 And whatsapp: +1 (501) 214‑1395

    NEED A LOAN?
    Ask Me.

    ReplyDelete
  27. Welcome to CapturedCurrentNews – Latest & Breaking India News 2021
    Hello Friends My Name Anthony Morris.latest and breaking news

    ReplyDelete
  28. Low morning nor can once room nothing. Chair partner interest article nothing other wife.breaking news in india today

    ReplyDelete