Showing posts with label Oracle Intercompany. Show all posts
Showing posts with label Oracle Intercompany. Show all posts

Sunday, November 16, 2008

FSAH and AGIS Intercompany Implementation thoughts

Written by David Haimes

As Intercompany transactions are very likely to cross systems they are a good candidate for integration in a 'Hub' of some sort.

In R12 the Financials Services Accounting Hub (FSAH) allows integration of third party systems to Oracle and is incredibly powerful and flexible.

Let's use a simple example:

Company A and B both use two different Ledgers. A Sales Invoice is issued by Company A (to Company B) for $5,000


The accounting needs to be created as below, they need to be booked with the same accounting date in the same period.


In Company A



Debit Intercompany AR $5,000
Credit Intercompany sales $5,000

In Company B

Debit Expense or inventory (per content), $5,000
Credit Intercompany AP, $5,000

So there's a number of options that come to mind (in no particular order).

1) Using Oracle Accounting Hub you can account for transactions form third party systems, it uses the Subledger accounting engine to process accounting events defined for the third party system. If your invoice systems are third party applications, you could create 2 events (one for each company/ledger/party to the transaction) for the sales invoice and get the full accounting out of the single system integration.

2) Enter these transactions in AGIS, the specific accounting will be entered/generated and approvals from company A and B obtained before AGIS either books it direct to GL or generates the Invoice for company A and B if required.

3) It may not be ideal to force users to navigate to a different screen (or change some import process, EDI, XML feed etc) to issue Intercompany invoices from other invoices as in 2) above. So continue to enter in your regular sales invoice system but run a process which detects an invoice is Intercompany and cancels it, then generates a transaction for it in AGIS (via the Open Interfaces) or FSAH.

I don't think any one of these is right for all situations, detailed analysis of the particular implementation environment and requirements needs to be done to figure out the best approach. If you have any thoughts, better suggestions or experience then please share them in the comments.

Thursday, September 18, 2008

Financials Sessions at Oracle Open World 2008

A lot of people are asking when various sessions are, readers of this blog are probably interested in Oracle EBS financials, Helle posted on Oracle Mix a couple of useful links. I recommend looking at this pdf which lists all the financials sessions including demogrounds, apps lounges, presentations etc.

My session is listed there, I look forward to seeing some of your there.

Thursday 25th, 3:00 p.m.

Moscone West 2006

Are Intercompany Processing and Reconciliation Currently Pain Points for Your Enterprise?

David Haimes, Oracle; Helle Hennings, Oracle

I blogged last year about the meet the Experts Lounge, well this year it has been renamed to Applications Lounge. I haven't been asked to attend this year, so if you want to ask me any questions or provide feedback you'll have to come to the session above, find me at the DEMOgrounds, the Blogger Meetup or follow me in twitter, or use this blog all year round - remember customer interaction is not just for Oracle Open World, it's for life.

Thursday, August 21, 2008

Advanced Global Intercompany System R12 White Paper

There is a white paper available on metalink (metalink note 418649.1) that describes in detail each set up step you need to perform to set up AGIS.  It is a very nice document with screen shots to show you every step of the way and there are also some viewlets that show you the set up in progress.

This is a pretty good starting point if you are setting up AGIS

Friday, August 15, 2008

Fixed Assests Intercompany in R12

[caption id="attachment_182" align="alignleft" width="258" caption="Fixed Asset?"]Fixed Asset?[/caption]

Something I often forget to mention is the enhancement of Intercompany functionality in Fixed Assets (FA) that has been provided in R12. So here is my attempt to explain it, based on an old email discussion with the FA team, I wouldn't describe myslef as an FA expert, but if there are any comments or questions I might be able to find an FA expert to get an answer. :)

In 11i FA stores reference accounts in two setup entities; Book Controls and Categories. The intercompany Payables and Receivables accounts were stored directly on the book, only the natural accounts segment were stored for these two accounts. The Account Generator definition would combine the natural account with other sources to get a full account combination. Out of the box, those sources were a default ccid which is also on the book and a ccid from the asset assignment. So the balancing segment is derived from the asset assignment, the natural account from the values on the book, and other segments from the default account.

The intercompany would kick in for two transaction types "Transfer" and "Unit Adjustment". However, other transactions could result in intercompany impacts, but they would not be generated in FA so GL would do the balancing when the accounting was posted there.

So in R12 FA uses the AGIS Intercompany balancing feature, which is

Sunday, July 13, 2008

Intercompany Session at Oracle Open World

The content catalog is available so you can go and search for sessions.

There's an Intercompany session (S299151), it is not scheduled yet and as I am one of the presenters I can tell you it definitely isn't written yet, next week I'll get started on that with my copresenter from strategy, Helle.  the details of the session are below.  If you have any suggestions about what we should cover, how we might cover it or anything else for the session it would be great to hear from you - add them to the comments and let's see if we can try and tailor the presentation to the audience a little.










































Session ID:S299151
Session Title:Are Intercompany Processing and Reconciliation Currently a Pain Point for Your Enterprise?
Session Abstract:Having problems reconciling your intercompany activity? Would you like better documentation and visibility into your various intercompany activities? Are acquisitions or changing legal structures making intercompany processing more expensive and time-consuming? Attend this session, which discusses and demos capabilities of Oracle Advanced Global Intercompany System in Release 12 and implementation options such as using this application as a standalone hub for all your intercompany activity across multiple ERP instances from multiple vendors.
Track:APPLICATIONS, Oracle E-Business Suite
Focus Areas:Not Applicable
Session Type:Conference Session
Product Area:Financial Management
Duration:60 minutes
Room:Rm 2006
Speaker(s)/Company:David Haimes, Oracle.; Helle Hennings, Oracle

Friday, June 13, 2008

R12 Best Practices White Paper

I noticed today on Stephen Chan's blog that this White Paper is available on metalink

Best Practices for Adopting Oracle E-Business Suite, Release 12 (Metalink Note 580299.1)

I haven't reviewed the document yet, despite there being a section on AGIS. As soon as I resolve the problem I'm having with my metalink login I will take a look. I understand it was pulled together by Anne Carlson, who I know reads this blog becasue she mailed me just today with a question about it, I'm hoping some of the useful posts from this blog made the cut.

I want to use this opportunity to plug two other guides that are new in R12 and I highly recommend you read if you are looking at upgrading to R12.

Oracle Financials Concepts Guide, Release 12 (Part No. B28873-01


Oracle Financials and Oracle Procurement Functional Upgrade Guide: Release 11i to Release 12 (Part No. B31543-01)


I discuss them a little more along with a few other resources in this post.

UPDATE (June 16th):

I reviewed the White Paper and the AGIS section is fairly sparse - I will be contacting the author to try and get more detail in there.

However on the whole I think it's a great document and essential reading for anyone looking to implement  or upgrade to R12.  Now if we can just publish that information on a blog, then we'll truly have a living document, I'll ask that question of the document owners.

Monday, March 24, 2008

AGIS Out of the Box

outofthebox.jpg

When I was about 10 years old I got a new electric train set for Christmas, but before I got to play with it I had to pinch a plug from one of my siblings toys and fit the only available (and dangerously mismatched) fuse in it. Then I had to read a complicated set of instructions to assemble a delicate set of parts and it was a minor miracle that I had it working before the New Year.

Now when I buy something new, the first thing I do is open the box, turn it on and press buttons to work out how to use it, if I get stuck I maybe look to see if they have a quick start guide. Consumer goods manufacturers make things very intuitive and ready to work right out of the box these days and we have grown to expect that. Remember that iMac add? step 1: plug into power, step 2: plug into a phone line, step 3: - there is no step 3! Wow can I have an ERP system like that please?

When designing AGIS for R12 we tried to minimize the time it would take to get started entering transactions in an initiative we internally called 'AGIS out of the Box'. I have to give credit to this idea to my former bosses Joe and Terrance for initiating this, but the whole team stopped, sat down and thought about what we could do to allow users to open the box and start using AGIS right away.

We came up with a few ideas

1) No profile options

Wednesday, February 13, 2008

Intercompany Invoicing in AGIS

One of the key features introduced with the new Advanced Global Intercompany (AGIS) in R12 of Oracle E-Business Suite is the ability to create documentation for Intercompany transactions. The correct documentation is required in many countries for Intercompany trading, this essentially means I need to provide a Receivables Invoice for the Legal Entity Providing the goods or service and a payables invoice for the receiving Legal Entity. These invoices should have any taxes that are applicable in the jurisdictions, for that type of service.

We do not firce you to create invoices for all Intercompany Activity, you can still create just a GL Journal entry if you prefer. The AGIS transactions flow is illustrated in the diagram below.

invoice-required.jpg

You can see that we check if invoices are required and there are two places that we look for that.

Friday, February 1, 2008

Using BIP for Interactive Reconciliation Reports

Written by Bidisha Silveira

I'm going to give a little more detail on how the Interactive Financial reports David described here were put together. In 4 simple steps (with pictures!)

Step 1:

The Reconciliation Data Extract background program is submitted which collects all the data and generates an xml file

Step 2:

To view the reconciliation data we use a page built in OAFramework. The BI Publisher region to view the formatted report is embedded in this page.

When you click submit the xml file generated from Step 1 along with details of the layout template and the type of output required (eg Excel or html or pdf) is passed to the BI Publisher engine. The BI Publisher engine processes this information and displays the formatted output on the current page.

Recon 1

Now you are ready to go. The first report displays the summary of the Payables and

Monday, January 28, 2008

Defining Intracompany Balancing Rules

Written by Rohit Kathuria and David Haimes

In order to take advantage of the automatic Intercompany balancing during GL posting and SLA Accounting you first need to define the accounts you want us to use.

Intercompany and Intracompany Accounts in R12 are defined in two different Set Up Pages, the Intracompany Balancing Rules are what we had in 11i for Intercompany Accounts (confusing I know) - this is where you will find the rules you had in 11i of you are upgrading from 11i. If you don't want to take advantage of the Legal Entity Configurator product and define Legal Entities and map them to your accounting structure, you can still go ahead and use the intracompany rules. If you start to map your Legal Entities to Ledgers and/or Balancing Segment Values (BSV) then you will want to be sure you complete the job, so there is no ambiguity in your setup. Consider the example below

Sunday, January 20, 2008

New Grant based Security in AGIS

 


Managing a large number of responsibilities can become a complex, time consuming and expensive activity. It is also very frustrating for users if they have to constantly switch responsibility if they have a number of roles, this is a big issue in 11i Global Intercompany System as you could only have one Balancing Segment Value (BSV) per GIS responsibility and there can be a large number of BSV often with one person responsible for entering and approving intercompany transactions for many bsv. For example there may be a controller responsible for approving all transactions for the dozens of EMEA subsidiaries.


When we created the new Advanced Global Intercompany Product in R12 we set out to address this issue and came up with a whole new transaction security model.

Monday, January 7, 2008

Why do I need another period ?

In R12 we introduced AGIS periods that control the transactions entered in AGIS, this is a feature that is often misunderstood. The usual question is - Why do I want another period? I'll give some ideas why you might want one, but if you decide you don't need one, don't worry we made it optional so you don't have to use it. If you decide to use it just pick one of your GL Calendars to use for your Intercompany periods, if you never enter a calendar in the system options periods will not be enabled and you can enter transactions whenever you want with no interference from the system.

So, I ask again - Why do I want another period ?

Monday, December 17, 2007

Legal Entity Configurator - Why?

LEIn Oracle Ebusiness Suite 11i, the Legal Entity is tied closely to a set of books and operating Unit, so your Legal Structure has to be defined in the way you set up your apps partitions (OU, Set of Books etc.). In R12 financials breaks away from that with the introduction of the Legal Entity Configurator allowing you to model your Legal Structure separately from the partitions in your ERP system. Then you mark certain items with an owning LE, rather than use the OU or set of books to derive the LE. So let's see what this buys you.

Monday, December 10, 2007

Can I assign an Operating Unit to Multiple Legal Entities?

The short answer is sort of. Which is not much help to anyone, hopefully you will have a few moments to read on and I can explain myself. This post assumes that you understand the relationship between Legal Entities and Ledgers which I discussed in an earlier post.

XLE brandIn R12, a new Legal Entity Configurator was introduced in financials and Legal Entities defined here are are assigned to Ledgers and/or Balancing Segments (Company Codes). However it is not possible to assign a Financials Legal Entity to an Operating Unit, you can only define a Default Legal Context (DLC) to an Operating Unit. This assignment can cause confusion as it is only possible to assign one DLC, but I can use more than one LE in that Operating Unit. The key word in DLC is default.

Wednesday, December 5, 2007

Intercompany Reconciliation Reports just got Interactive

In R12 the Advanced Global Intercompany System was introduced and one of the main goals was to make the reconciliation process more efficient. Intercompany is often the top barrier to a fast period close, because you have to be sure you eliminated it all to zero, so your parent company does not report a profit from trading internally. Fail to do this and you might go to jail, I have no legal training but when it comes to accounting irregularity I understand claiming it was an honest mistake is not much of a defense.

Monday, December 3, 2007

What can we do for you ?

I have an Intercompany group on Oracle Mix and I want to invite all readers of this blog to join and start posting ideas, discussions and also sharing experiences.

It doesn't have to be specific to Oracel products, it could be ideas for new features, better collateral or whatever you want to start discussions about and maybe have voted on by other members.

So far things are quiet in there, I am reluctant to post my ideas, because frankly I think you probably have quite enough of my thoughts on this blog and those inside Oracle development probably know my thoughts by now. The Idea of Oracle mix is to have you, the customer (or potential customer) lead and join in the discussion.

Wednesday, November 28, 2007

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.

Tuesday, November 27, 2007

Intercompany Segment in Secondary Ledgers

I was recently asked - Do I need to define an Intercompany Segment in my secondary ledger if the primary it is attached to has an Intercompany Segment?

Monday, November 26, 2007

Intercompany Vs Intracompany

When I present about Oracle Intercompany products I always start with a couple of slides explaining the difference between Intercompany and Intracompany and why we might care about the difference. This is sometimes obvious but often the two terms are used interchangeably or the term Intercompany is used generically to discuss Inter and Intra company (Oracle Apps is certainly guilty of the latter). So here goes...

InterCompany Transactions are between two or more related internal legal entities with common control, i.e. in the same enterprise (Inter = Latin for "BETWEEN")

IntraCompany Transactions are between two or more entities within the same legal entity (Intra = Latin for "WITHIN")

So that's it then and a free latin lesson to boot. No? Want more?

get-out-of-jail.jpg

Well the real difference is that Intracompany processing is determined by company management, whereas Intercompany has to follow the law.

Thursday, November 22, 2007

New Intercompany features in R12

R12 introduces the new product Advanced Global Intercompany System (AGIS), which takes forward the features provided by GIS in 11i GL and adds a number of important new capabilities. The major new capabilities are:

  • Creation of Documentation (ie. Payables and Receivables Invoices) for AGIS transactions