Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Cross Instance Data Transfer

Posted on March 31st, 2008 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

Do you know, there is on feature called "Cross Instance Data Transfer" in GL which enables you to transfer subsidiary data to your remote parent instance over your corporate intranet. How it sounds..

Normally big enterprises manage their business operations in different database instances which need an automated way to transfer data from remote subsidiary database instances to a central consolidation database instance.Therefore this feature can be utilized for transferring Instance data.

Lets understand what you can do with this:

  • You can do automatic transfer of consolidation data from one instance to another using db links
  • This will import and post consolidation journals in one step process.

Therefore, the Global Consolidation System(GCS) facilitates the consolidation of data from remote subsidiary ledger database instances to a central consolidation database instance. Using db links, Global Consolidation System allows you to automatically transfer consolidation data from one instance to another, as well as optionally import and post the data automatically in the consolidation database instance.

  • You can also use the feature of notifying users of the transfer status using Workflow Notifications.

This feature automates the entire process and also includes workflow notifications providing notification of the cross instance consolidation status. Global companies with operations on multiple database instances can use this feature to consolidate their subsidiaries in a more efficient and automated manner.

the next question in mind is what about security of this feature?

  • You create a specific user name for the central consolidation database instance with limited access to specific objects in the database
  • Subsidiaries use this user name to define database links for cross instance data transfers

Therefore using this security, there is no need to re-enter your username and password every time you transfer consolidation data, saving time and redundancy. And, the username/password is now validated at the time you sign on to the EBS.

Reference Notes

  • 186235.1 :About Oracle General Ledger Mini-pack 11i.GL.G
  • Chapter 7, Global Consolidation System, Oracle General Ledger User Guide

Related Posts

Posted in Oracle General Ledger | No Comments »Email This Post Email This Post | Print This Post Print This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.