I’m a Director working in Oracle Financial Applications Product Development. I started out in Oracle UK and found my way out to California in 2000. I’m interested in technology both inside and outside of Oracle and am always thinking of how I can incorporate new ideas, technologies, methodologies or innovations into my work here at Oracle.
My current role is product owner for General Ledger, Intercompany and Legal Entity products in Oracle Fusion Financials. I have also worked on EMEA Globalizations, Federal and Public Sector Financials, XML Payments and a variety of projects on other products down the years.
The primary focus of this blog is Intercompany and Oracle Financials, but I certainly reserve the right to post about anything I see that is interesting or potentially useful. If there are particular topics you would like me to cover than let me know.
You might also see me on twitter as dhaimes, or friendfeed as mrhaimes
Tag or fave the blog on technorati 
You can get updates from this blog in your email, just click here
or you can 
Subscribe in a reader
Stumble It!
veteran? you make me feel old… LOL
David, i’m looking to talk to someone about working with Oracle and intercompany accounting with foreign currencies. Is there a way to contact you directly?
thanks,
dave
David
The stuff that explained the difference betwen inter-co and intra-co was wonderful.I am sure most of the organizations use them interchangeably.
Are you aware of any such blogs on Order management too?
Regards
Naveen
Hi Naveen,
Welcome to the blog, glad to have you on board.
I am not aware of any order management blogs. Might be worth posting the question to the Order Management OTN forum
http://forums.oracle.com/forums/forum.jspa?forumID=119
somebody there will know of any OM related blogs that might be around.
Do you have any inputs/documents pertaining to changing the chart of accounts. We have been instructed to change the existing CoA to a new CoA. The approach we have adopted is: first classify the accounts as ‘changeable’ and ‘non-changeable’. The changeable accounts will be identified and a journal entry affecting the existing account and the new account will be passed. But we do not have an approach for the unchangeable accounts. Unchangeable accounts are those which have been defined during the setup/options level. It would be of great help if you could, with your vast experience, throw some light on this and suggest a better approach.
Thanks and Regards
Mahesh Adiga
Mahesh,
Is the requirement to change your chart of accounts and change al accounts in the system? Are you planning to use a new set of books for this?
No David. We are planning to use the existing CoA for this. Only the description ofr the accounts change. The major problem, as i mentioned earlier, is changing the account segment values for all those accounts done during the initial setups.
Thanks and Regards
Mahesh Adiga
Hi
We are implementing R12 and have ledger with monthly calendar. But at the same time finance wants to have weekly reporting. So the option we are thinking is to define secondary ledger with a weekly calendar. Would you suggest this approach or is there any other better way of doing this? Any implications of defining secondary legder just for weekly reporting?
Many Thanks.
Hi,
You could do that – the secondary ledger should be at balance level only to keep the data volumes and processing impact to a minimum.
You could also use GCS to move the balance data to another ledger.
See no reason why these would not work, but seems there has to be a better way to store a weekly balance of your accounts… let me ask around.
David,
Your an innovator, great blogg, i looking to down load the latest version of AIM , do you know the latest version would it require a password ? if so how can this be obtained .
Regards,
Patc
Patric
Sorry no idea where to get AIM or if it is free. Try metalink maybe.
[...] About Me [...]
[...] About Me [...]
Dave
This is David Murray. I lost contact with you a long time ago. I am now living in Australia. What are you up to?
Hi Dave,
I read your comments and posts , it is of great help. thank you.
I have couple of questions:
1) We have requirement to clasify the loans from shor term to long term, How can we maintain loans in oracle, and is there a way to clasify them?
2) Can we have multiple version of budgets, Like ver1 is first time we created, and ver2 is any changes in budgets like increasing the amount, and we need actual against ver1 and ver2 report? is it posible?
thanks
ghouse
Hi Dave,
1. Do you happen to have a checklist of questions one might ask the business before deciding the Org Structure setups (Ledgers, LE, OU, etc.) ? (both for US and EMEA) ?
2. One of the client is using US Ledger with one OU – and transacting in all currencies. They would like to setup another OU for European countries. In what conditions one would recommend having a seperate OU for each country ? Can they setup one OU for all European countries ? any drawbacks ?
By the way enjoyed reading your articles and looking forward to new postings.
thanks
gopal
Hi David,
I read lot of interesting stuffs on your blog. However,
I can’t find anything on how oracle GL R12 proceed with intercom/intracom elimination when consolidating!!
Not only netting off inter-pay and inter-rec but also reduce the expense/revenue accounts which have been overstated by the intercom/intracom trxns.
Could you explain this feature in details pls.
Thks!
roopesh
Hi Dave,
Mate, we have to undergo a change in 11i COA. I know that we need to define new SOB and then transfer everything to this new one. But I am sure it is not going to be as simpler as saying this.
Do you know if there is a checklist which gives a sequence in which the transformation should be done so as to avoid any data corruption?
Your advice on this will be greatly appreciated.
Thanks,
Manish
[...] by more people than just the two of us. We quickly recruited Amy to our plan, and, inspired by David’s why development should blog series, we started to look into what blogging was all [...]