tag:blogger.com,1999:blog-6484465525647257447.post7432251025451202489..comments2024-01-17T05:41:50.098-08:00Comments on Oracle Intercompany Financials: Can I assign an Operating Unit to Multiple Legal Entities?David Haimeshttp://www.blogger.com/profile/08553294104727744220noreply@blogger.comBlogger32125tag:blogger.com,1999:blog-6484465525647257447.post-17122930645779759002008-04-15T07:22:05.000-07:002008-04-15T07:22:05.000-07:00I inadvertently assigned the incorrect balancing s...I inadvertently assigned the incorrect balancing segment value to legal entity and proceeded to define the MO structure. All Application setups are not completed. <br>I can change the description of the balancing segment value, but I cannot update the legal entity to reflect the correct balancing segment value.<br><br>One USD ledger is defined<br>Two Legal Entitles are defined<br>Two Operating Units are defined<br>Multiple Inventory Orgs defined<br>LE A segment value is 112<br>LE B segment value is 111<br><br>I need LE A segment value to be 111<br>And LE B segment value to be 112<br>I have logged a SR with Oracle Support. Why can BSV not be changed once the record is saved?<br>MaryMarynoreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-82876232655252516332008-04-15T07:32:12.000-07:002008-04-15T07:32:12.000-07:00I think the idea is to prevent update one transact...I think the idea is to prevent update one transactions have been created - switching the BSV assignment with transactions in progress would be a big problem for processing and also reporting on completed transactions would be problematic.<br><br>In the UI it is difficult for us to know if a BSV has been used or not in either a transaction or another Set Up, so this is why changing assignment is not allowed.<br><br>If you have not entered any transactions at all, or done any other dependent set up - it might be worth considering changing this via the back end (be careful with this of course, it's never recommended by Oracle)David Haimeshttp://davidhaimes.wordpress.comnoreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-36108813397955224242008-04-17T19:46:38.000-07:002008-04-17T19:46:38.000-07:00HI David,I created a new ledger and assign LE &...HI David,<br><br>I created a new ledger and assign LE & 2 operating units to it, after that i run replicate seed data request and created security profile & run security list maintenance in HR.<br>I assigned security profile to payable responsibility by mo: sec. profile option.<br><br>When i switched responsibility and click on invoice batches/expense reports then it gives error message: You do not have access privileges to any operating unit or check if mo: security profil or mo: oper unit include any operating unit.<br><br>Can you plz explain the reason ?<br><br>Thanks.Aman Khannoreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-63784254711130693242008-09-29T06:20:34.000-07:002008-09-29T06:20:34.000-07:00Javier,A further thought. If you want to secure b...Javier,<br><br>A further thought. If you want to secure by LE, but don't want to maintain all the Set Up across multiple OU. Maybe is it better to consider having one OU per LE to drive security and work on a custom way to synch the setup data across the OU maybe - this is a different approach but gets the same end result of security be LE but minimizing the set up overhead?David Haimeshttp://davidhaimes.wordpress.comnoreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-42135231168263703462008-09-28T04:09:37.000-07:002008-09-28T04:09:37.000-07:00Apologies DaveI think I mis-typed my email address...Apologies Dave<br><br>I think I mis-typed my email address please can you revert back to me on my query about a single OU and security in R12Javiernoreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-16827885186275452432008-09-25T20:02:47.000-07:002008-09-25T20:02:47.000-07:00Great Blog: Can I assign an Operating Unit to Mult...Great Blog: <br>Can I assign an Operating Unit to Multiple Legal Entities? This is a really good question.<br>One which is not well documented.<br>We are in a design phase, in which the business have given us a requirement to have a single BG a number LE's in a Global roll out under a single primary ledger and each LE BSV attached to a single operating unit.<br>How would you secure AP and AR transactions/suppliers/customers between LE's?<br>Or is the Only answer use another Operating Unit<br><br>Your thoughts are much appreciatedJaviernoreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-28332789751416412802008-09-29T01:31:08.000-07:002008-09-29T01:31:08.000-07:00If you want to secure transactions in AP and AR yo...If you want to secure transactions in AP and AR you need to use OU to partition them.<br>If you are in a shared service center type environment then using 1 OU for all the LEs will work fine as you can still run all your reports at the LE level etc.David Haimeshttp://davidhaimes.wordpress.comnoreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-40237854432889217612008-09-29T06:40:07.000-07:002008-09-29T06:40:07.000-07:00Hi DavidThis is a nice thought, Oracle have a prod...Hi David<br><br><br>This is a nice thought, Oracle have a product called iSetup perhaps this might cover synch/multiple OU set up...this is an alternative idea however if there is no automated way....other than config monkeys...replicating the same config then might rule this option out. <br>Under a single OU adding a new LE/country becomes a BSV in a single corporate primary ledger and if necessary a new secondary ledger for stat purposes. <br><br>JaviJaviernoreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-83240206391953530452008-09-30T04:30:49.000-07:002008-09-30T04:30:49.000-07:00Hi DavidI am going to go down the Custom.PLL route...Hi David<br><br>I am going to go down the Custom.PLL route -The custom .pll will be dependant on a profile option ‘Legal Entity', which should be updateable at the responsibility. All Financial responsibilities should have a value of ‘Yes’ and any Superuser responsibility lthat needs access to all the transactions will have a ‘No’ or blank against this custom profile, which will then not enforce this custom .pll on ‘Transactions’ and ‘Transaction Summary’ windows. Payment Windows, Receipt Windows, AP invoice windows etc....<br><br>JavierJaviernoreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-26325591515902660242008-09-30T06:17:44.000-07:002008-09-30T06:17:44.000-07:00Javier,That seems like a neat solution, It would b...Javier,<br><br>That seems like a neat solution, It would be great if you keep me and other readers updated with how it works out. It would make a great blog post - you or I should write it up.<br><br>Thanks,<br>DavidDavid Haimeshttp://davidhaimes.wordpress.comnoreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-10554277667774671462008-10-06T05:01:28.000-07:002008-10-06T05:01:28.000-07:00Hi DavidI am in the process of writing the functio...Hi David<br><br>I am in the process of writing the functional specs as soon as I have a clear approach be sure I will update this post!<br><br>Best Regards<br><br>JavierJaviernoreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-29727675763647313032008-12-02T14:30:30.000-08:002008-12-02T14:30:30.000-08:00Deepak,What is the requirement here - what will yo...Deepak,<br><br>What is the requirement here - what will you use the address - Operating Unit association for?David Haimeshttp://davidhaimes.wordpress.comnoreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-68578667152309432462008-07-14T18:55:14.000-07:002008-07-14T18:55:14.000-07:00Thanks a lot David for your reply..I guess I had I...Thanks a lot David for your reply..<br>I guess I had <br><br>I would like to know whether we can assign an item created in Master Organization of an Operating Unit (OU1) to an inventory organization of a different Operating Unit(OU2) in multi-org setup...?Neetinoreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-4887338074073140082008-07-13T23:18:51.000-07:002008-07-13T23:18:51.000-07:00Hi ,Can we transfer item created in Inventory org ...Hi ,<br><br>Can we transfer item created in Inventory org of one operating Unit to Inventory org of another Operating Unit, in case of Multi -Org Setup...?Neetinoreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-72143919637849396792008-07-14T13:53:14.000-07:002008-07-14T13:53:14.000-07:00NeetiInventory has Intercompany functionality that...Neeti<br><br>Inventory has Intercompany functionality that is based on Operating Units. This generates Intercompany Invoices for the transfer of goods across Operating Units, I think that's the feature you would be interested in.David Haimeshttp://davidhaimes.wordpress.comnoreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-65794438854935487512008-07-01T02:26:16.000-07:002008-07-01T02:26:16.000-07:00Bernardo,AP and AR can create balanced entries, as...Bernardo,<br><br>AP and AR can create balanced entries, as long as your set up is correct.<br><br>However you do the have the option of defining intercompany accounts, they you will get the balancing when you account for each transaction.David Haimeshttp://davidhaimes.wordpress.comnoreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-36689541438602080482008-06-29T19:31:07.000-07:002008-06-29T19:31:07.000-07:00Thanks for your reply.Our biggest reservations are...Thanks for your reply.<br><br>Our biggest reservations are around accounting: will AP and AR create sub-ledger balanced entries (without intercompany accounts)? I think it will but the documentation Ive seen is not clear enough to dissipate all doubts. Have you seen docs on this subject?<br>Around the sequencing issue, we are willing to allow the user to select the document sequences (with defaults) and this is in the Netherlands which is not as strict as Italy.<br><br>Regards,<br>BernardoBernardo Pedrosonoreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-53833653303447593672008-07-21T05:09:17.000-07:002008-07-21T05:09:17.000-07:00Thanks a million for a most informative blog. I ha...Thanks a million for a most informative blog. I have a query on a certain situation. We have 5 branches, each operating totally independently, which are all part of the same legal entity. Each branch would like to independently control the close of their AR and AP periods. This, as I understand it, can only be accomplished by assigning each operating unit to its own ledger. However, as there is only a single legal entity, is there any way in which to accomodate this requirement in Oracle R12? Can a single legal entity reference multiple ledgers and, if so, are there any implications I should be aware of?Marknoreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-10867158986091947162008-06-27T02:00:32.000-07:002008-06-27T02:00:32.000-07:00Bernardo,Yes it is very common to have multiple ba...Bernardo,<br><br>Yes it is very common to have multiple balancing segments in a single OU and you should certainly consider it but there are a couple of caveats:-<br><br>Do you need to secure access to these balancing segments individually in the subledger? If so they may need an OU each.<br><br>Do you have any requirements for gapless sequencing for any of these balancing segments (common if they are in some European countries, e.g. Italy)? If so you may need to give them an OU of their own.<br><br>Hope this helps<br>DavidDavid Haimeshttp://davidhaimes.wordpress.comnoreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-28873654964773543032008-06-26T22:30:09.000-07:002008-06-26T22:30:09.000-07:00I have a question regarding this: is it possible a...I have a question regarding this: is it possible and/or advisable to have multiple balancing segments in one OU? <br>I'm in release 11.5.10 and I have to add several small companies with very low volumes of sub-ledger transactions. It seems to me that multiple balancing segments in an OU would suffice. <br><br>ThanksBernardo Pedrosonoreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-87756363593417508262008-08-05T02:43:59.000-07:002008-08-05T02:43:59.000-07:00DanAutomatic i/c balancing will work across LE so ...Dan<br><br>Automatic i/c balancing will work across LE so you should avoid creating dummy LE such as 'europe'. It does not work across Ledgers, so all the LE/BSV you want to balance automatically need to be in the same ledger and the same OU.<br><br>You may have an issue in some European countries with your sequencing if you need gapless sequencing for each LE as this is only available by Ledger/OU - that is a big gotcha for many European LE in a single ledgerDavid Haimeshttp://davidhaimes.wordpress.comnoreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-88330649739599057462008-07-25T00:52:33.000-07:002008-07-25T00:52:33.000-07:00Hi Mark,I am laying out the migration of 2 - 11.5....Hi Mark,<br><br>I am laying out the migration of 2 - 11.5.10.2 and 1 - 11.0.3 environments into one r12. The company has legal entities all over the world and account for them in these enviornments. They have established around 40 OU's in their 3 environments which are mostly by country.<br><br>My question is: When diagraming out the Ledgers, LE's and OU's for system design for the world-wide r12 footprint i am not always sure if i should group countries into LE's (a.k.a "Europe" which runs multiple LE's through the OU) or not?<br><br>They have to be able to Auto-Balance I/C within the OU and from what i have tested and learned you have to have all of the BSV's assigned either within a single LE or all to the ledger to be able to take advantage of the I/C Auto Balance features.<br><br>Their are no situatuations in which they would want to restrict auto-balancing of I/C.....Its a rare need and i would accomplish with a secutiry rule if i needed to restrict it anyway! <br><br>I'm just trying to make sure i haven't missed anything in my research and thought you would have a good viewpoint i would value to hear.<br><br>Thanks in advance,<br><br>DanDan Chttp://Googlenoreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-21111760619014886422008-06-14T18:12:15.000-07:002008-06-14T18:12:15.000-07:00Thanks good documentThanks good documentSefa Şahinhttp://www.dehaa.comnoreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-735890149833073502008-07-23T15:38:28.000-07:002008-07-23T15:38:28.000-07:00Mark,If each branch is in it's own ledger you&...Mark,<br>If each branch is in it's own ledger you'll have to do consolidation to get results for the Legal entity, you will have to set up each OU and do stuff like create 5 supplier sites (1 per OU) for each of your suppliers. you will not be able to use automatic balancing to deal with Intacompany. These are the first extra pieces of work that come to mind and I'm sure there is a lot more trouble in store. We don't usually see people trying to create more ledgers and OU than they totally have to, so I'd say avoid this.David Haimeshttp://davidhaimes.wordpress.comnoreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-78858800760450804302008-12-02T12:26:21.000-08:002008-12-02T12:26:21.000-08:00Hi David,Can we assign a Single Operating Unit TO ...Hi David,<br><br>Can we assign a Single Operating Unit TO multiple addressDeepak Dhimanhttp://www.sudhirgensets.comnoreply@blogger.com