R12 Intercompany Accounts Set Up

In R12 the Intercompany Accounts setup is broken out from GL and included in the Advanced Global Intercompany System (AGIS) product (Don’t worry you don’t need any additional license for this product). There is a separate set up screen for Intercompany and Intracompany Accounts. The same set up pages are available through the Accounting Set Up Manager as well as AGIS so you can pick your navigation path.

The Intracompany accounts are defined for pairs of Balancing Segment Values (BSV) within the same ledger; this set up is similar to the 11i approach and we upgrade 11i Intercompany accounts to Intracompany accounts here. You don’t need to uptake the Legal Entity Configurator product(new in R12) to define these.

In order to enter Intercompany Accounts you need use Legal Entity Configurator to define your Legal Entities and map them to ledgers and/or BSV. You then define accounts to use when certain pairs of Legal Entities trade.

In R12 you can now define a separate payable and receivable account for each Inter/Intracompany trading relationship. In 11i you would just define the due to/due from account and that account was used for both the payables and receivables I had with the specified trading partner.

These will be used for any AGIS transactions you create and also by the automatic intercompany balancing in GL and SLA. Doing the Intercompany balancing at the transaction level in SLA is a big enhancement for R12 and one I will talk about and give examples of in another post.

Author: David Haimes

I'm Senior Director in the Oracle Research and Development Organization, with close to 20 years working in various roles on the development of the Financial Management product suite.  Since the summer of 2016 my focus is exclusively on working with customers and longer-term design work, particularly around next-generation functional and technical architecture. My task is to figure out NOW what the financial management system of the next 3, 5 or more years should look like and start working toward it.  At the moment the majority of my time is spent working on Blockchain or Distributed Ledger Technologies (DLT), leading the effort for all of SaaS applications.  I'm also interested in AI, Machine Learning and new UX and interaction paradigms such as chat bots. I started out in Oracle UK and found my way out to Oracle's Redwood Shores, California HQ in May 2000.  My previous role was product owner for Fusion Accounting Hub, General Ledger, Intercompany and Legal Entity products in Oracle Fusion Financials and eBusiness Suite General Ledger. 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.

20 thoughts on “R12 Intercompany Accounts Set Up”

  1. Hi!
    Your guide is fine, but don’t you think you could do it more complete if you add print screens of the application?? It’s just a suggestion

    Greetings!

    Like

  2. Lukis55

    I appreciate your feedback. In some articles where I go into more detailed set up descriptions I have included screen shots for reference. Please surf around the blog for more of these articles

    However the intent of this blog is not to replace the detailed steps available in the User guides but to provide context of what set up you might need in what situation.

    Like

  3. Currently I’m on searching for solution to propose for the management having a system in handling their intercompany trx, however they need to know how much averagely the costs will be incurred.

    Like

  4. Azlina,

    It is impossible for me to give an estimate of cost to implement functionality without detailed information.

    Maybe some other readers have data that they might share on costs of similar projects they have undertaken, but User groups and such like are a better place for that I suspect.

    I think you need to do an in depth study based on your organizations specific needs.

    Like

  5. David,
    I must say your site is very informative and great!!
    A screen shot is an easy way to explain what you inteand to say. Your argument that the blog is not to replace the UG :) makes sense but then why the blog itself on a specific topic? guess it is to make a simple approach more understandable to ppl who are new to R12. Thus would make an request to add a screen shots if not too details to field level but an over and screen shot with the amout of knowledge you have would be of good help to all …

    Like

  6. David, is it possible to implement an intercompany solution withouth having to add a new segment to our accounting string? Everything I have read, says we need an intercompany balancing segment but we don’t have any extra segment available in our string. What would you suggest for a solution?

    Thanks

    Like

    1. You do not need an Intercompany segment. AGIS and Intercompany balancing will work fine without an Intercompany segment, so no need to change your chart of accounts to use the functionality.

      For a new chart of a accounts I would recommend an Intercompany segment as it will make reporting easier, but it is optional and Oracle Intercompany features do NOT require it.

      Check out this post for a discussion on it

      https://davidhaimes.wordpress.com/2007/11/20/intercompany-segments-and-vision-demo-data/

      Like

  7. I have been researching the multiple balancing segments and everything that I am reading indicates that you can use multiple balancing segments under a single legal entity however it seems like you can only have one intercompany balancing account for AP and AR for each legal entity. Can you verify whether this is correct or if I am missing something. I see references in the AGIS user guide that indicates “However, when you select the value All Other, the Balancing API determines and substitutes the correct balancing and intercompany segment values at the time of balancing. For example, if you enter an account code combination 01.4000.02, it actually means xx.4000.yy, where xx is the balancing segment value of the debit balancing segment value on the journal and yy is the balancing segment value of the credit balancing segment value on the journal. The Balancing API substitutes these values during balancing.”
    However this is described under the section Balancing Details Tab and not where it explains how and where to setup AP and AR intercompany balancing accounts so I am unsure whether the same rules apply for these accounts or not.

    Like

    1. Lance,

      You have done your research well. I’ve added answers your questions below, I hope this clarifies things for you.

      Q: everything that I am reading indicates that you can use multiple balancing segments under a single legal entity.
      A: Yes, this is correct.

      Q: it seems like you can only have one intercompany balancing account for AP and AR for each legal entity.
      A: No, you can have different ones for each balancing segment value

      Q: I am unsure whether the same rules apply for these accounts or not.
      A: Yes same rules apply for Intercompany Accounts too.

      Like

  8. Ok. Let me see if I have this straight. If I have multiple BSV’s under a single LE then my AP & AR accounts are defined under the Intracompany Balancing rules whereas if I have each BSV under a separate LE then they are defined under the Intercompany Accounts.
    Our 11i setup was to have one LE with multiple BSV’s however each BSV is actually a separate LE. Is the recommendation for R12 to setup each LE separately, assign them their appropriate BSV’s and account under the Intercompany rules?
    If so what is the downfall (if any) of keeping the 11i setup and and accounting for our Intercompany as if it were Intra company?

    Like

      1. Hi David,

        We are Implementing Intercomapny / Intracompany on 12.0.6.

        The Business Stucture is like
        We have One Ledger.Under this we have three LE’s.Now Under Each LE wehave OU’s as child because we need both LE and OU’s as Balancing Segment.Now we have transactions between LE”s and OU’s(Within same LE and as well as across LE’s.How to setup this scenario.(Intercompany / Intracompany).
        Do we need to have seperate ledgers for respective LE’s?

        Like

  9. hi every one i am finance student curently working with oracle finance r12 , i want your help so can any one give me ur notes on oracle r12 finance or any link or websit its and humble request from your brother thankz alot

    Like

  10. Hi Sir,

    We have a requirement to populate intercompnay accounts for about 180 LE. Therefore the count comes to 180*179*6 (3payable & 3receivable) which comes to huge count. We are doing this manually daily and we are hardly being able to complete only 1 LE per day. Can you please suggest us if there is any alternate method to populate these intercompany accounting. For ex.. any API, any script or any solution you have in mind through which we can automatically populate all the accounting in 1 go. Please reply…

    Regards,
    Ranjith

    Like

  11. Hi David,

    We are Implementing Intercomapny / Intracompany on 12.1.3

    The Business Structure is like this:
    We have four Ledgers with different value sets.Under this we have seperate Legal Entities. Each COA structure has segment for inter company. Can u pls explain me how we can do the intercompany transactions between these legal entities (different ledgers)

    Amila

    Like

  12. Hi David,

    I have one doubt regarding AGIS.

    whether AGIS can process intercompany transactions across HR Business Groups.

    Please clear my doubt.

    Regards
    Madhukar D

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s