Offloading (Some) EBS 12 Reporting to Active Data Guard Instances

For most Oracle Database users, Oracle Active Data Guard allows users to:
  1. Create a physical standby database for business continuity and disaster recovery
  2. Offload reporting from the production database to the read-only physical standby database
E-Business Suite customers have been able to use Active Data Guard to create physical standby databases for their EBS environments since the feature was introduced with the 11g Database.  EBS sysadmins can use the generic Active Data Guard documentation to take advantage of the Active Data Guard standby database capabilities. 

I am pleased to announce that it is now possible to offload a subset of some ReportWriter-based reports -- but not all -- from a production EBS environment to an Active Data Guard physical standby database.  But before I go into the details of this newly-certified configuration, it's necessary to understand some details about what happens whenever someone attempts to access the E-Business Suite.

adg_diagram.png

Behind the scenes: logging into the E-Business Suite

Every E-Business Suite user is assigned one or more responsibilities.  These responsibilities govern the E-Business Suite applications (i.e. menu functions) and data that a given user can access.  For example, as a manager, I might be assigned responsibilities that allow me to review my employees' compensation and approve their expense reports.  I'm also an employee, which means that I can review my own payslips and file new expense reports.

Every time anyone logs into a running E-Business Suite instance, the following things happen:

  1. Their authenticated credentials are checked against their assigned E-Business Suite responsibilities.
  2. A user session is created in the E-Business Suite database.
  3. All activities are logged for audit and tracking purposes, even queries against existing data.

This level of security prevents E-Business Suite unauthorized users from, say, assigning stock options to themselves.  It also provides an audit trail in case someone abuses their position by attempting to cook the books in the midst of a financial industry meltdown.

This also applies to the use of external reporting tools like Oracle Discoverer.  Discoverer users must log into the E-Business Suite instance, which checks their assigned responsibilities to prevent users from running reports against data that they're unauthorized to view.

What does that mean?

Putting this together: 

  • Active Data Guard makes a read-only replication of a given database. 
  • Even the simple act of logging into an E-Business Suite database requires write access.
What's Changed in this new Active Data Guard certification?

In this new certification, it is possible to run a subset of the standard Oracle Reports delivered with the E-Business Suite against the Active Data Guard instance.  In some cases, EBS reports also perform writes against the database; those reports will not run in this Active Data Guard configuration.

We've made the following changes to support this new configuration:
  1. Created new Active Data Guard database triggers to redirect minimal required read/write activity back to the primary E-Business Suite database. 
  2. Introduced changes within the E-Business Suite's FND layer to support this new functionality.
  3. Developed Parallel Concurrent Processing configurations to manage the report executions against Active Data Guard.
Technical Prerequisites

This configuration requires the following prerequisites:
  • Oracle E-Business Suite Release 12.1.3 or later
  • Oracle Database 11.1.0.7 or 11.2.0.2 with the Active Data Guard database option
Getting access to this new configuration

Given the new state of this configuration, we'd like to stay very close to customers implementing this in their E-Business Suite environments.  Although the documentation is published externally, the required EBS patches are currently being distributed in a controlled availability release.  To get access to these patches, please log a formal Service Request with Oracle Support to request a password to access this patch.  While working with Oracle Support to obtain the password, you should also send an email to "ebs_adgrel_us at oracle.com" so that we can monitor your Service Request in Development.

References
Related Articles

Comments:

Steven,

That's great news. Given that much of the reporting in R12 has moved to BI Publisher, are you working on a similar feature for BI Publisher?

Regards,
Alan.

Posted by Alan Goodall on January 06, 2011 at 06:05 PM PST #

Hi, Alan,

We're trying to walk before we run. Not in the short term, but this is something that we'd like to review in the future.

Regards,
Steven

Posted by Steven Chan on January 07, 2011 at 05:48 AM PST #

Steven,

Any plans for certification of this feature with Release 11i?

Looks great for Release 12.1.3!

Thanks.

John

Posted by John Stouffer on January 10, 2011 at 10:18 PM PST #

John,

No, I'm afraid not. EBS 11i is now in Extended Support, so our strategy will be to ensure that customers on that release will be able to continue using EBS 11i while they plan their upgrades to R12.

We plan to focus on EBS 12 for the delivery of new capabilities like this support of ADG for reporting.

Regards,
Steven

Posted by Steven Chan on January 11, 2011 at 12:17 AM PST #

For the paralell Conc Mgrs running a report/job against the DG DB. Will FSG's work against this DG DB? You mentioned only some R12 reports can use this feature.

Posted by Jeff Shervey on January 31, 2011 at 04:16 AM PST #

Jeff,

No, reports generated by the Financial Statement Generator (FSG) are not covered by this configuration. Only a subset of reports created by ReportWriter will run against the Active Data Guard instance.

Regards,
Steven

Posted by Steven Chan on February 07, 2011 at 01:08 AM PST #

Hello Steven, Its good to know Active Data Guard now supports a subset of reports on the standby instance. Just wanted to update you regarding a recent test I've done using "SNAPSHOT DB" that can be opened for Reporting in "READ/WRITE" mode. Basically we can convert the Physical Standby to a SNAPSHOT DB whereby Oracle internally creates guaranteed retention point, open in READ/WRITE mode. Also the SNAPSHOT DB can be re-converted back to Physical Standby, restart the managed recovery process. Would like to know if someone has done any testing on 11g SNAPSHOT DB with EBS R12? Also any plans from Oracle to support / certify this for EBS R12? Thanks! Ashwin

Posted by Ashwin on May 19, 2011 at 12:14 AM PDT #

Hello, Ashwin, We haven't done any explicit certification tests combining the E-Business Suite with Snapshot databases. I would expect this to work. If you encounter any issues with this configuration, you can log Service Requests against the Snapshot product directly. Regards, Steven

Posted by Steven Chan on May 19, 2011 at 02:41 AM PDT #

Hi Steven,

Thanks for the thread. I think this new feature would be extremely useful.

My question here is what the current position is in terms of supporting BI publisher reports in EBS 12.1 given that BIP will be the majority in the 12.1 environment.

From your last reply on this topic, I got a feeling that it was not supported back in Jan, 2011. Is that right?

Cheers,
Kurt

Posted by guest on September 22, 2011 at 02:47 PM PDT #

Hi, Kurt,

Running BIP reports against this kind of Active Data Guard setup isn't supported yet. It's something that we'd like to be able to support, though -- this is a common request.

We're still working through some technical issues around redirected writes. I'll post more updates here as we make progress on this.

Regards,
Steven

Posted by Steven Chan on September 23, 2011 at 04:50 AM PDT #

Hi Steven

It is now April 2012, has there been any progress in running BIP reports against ACTIVE DATA GUARD.

Regards

Bernie

Posted by guest on April 19, 2012 at 01:42 AM PDT #

Hi, Bernie,

We've been focussed on getting EBS 12.2 out, so we haven't had a chance to work on this yet. It's still on our list of future projects.

Regards,
Steven

Posted by Steven Chan on April 19, 2012 at 04:42 AM PDT #

Is there an ER out on working with Bi Publisher, or should one be done so it is recorded formally.

Bernie Breski

Posted by guest on April 19, 2012 at 05:02 AM PDT #

Hi, Bernie,

No worries: it's recorded formally and is in the queue for evaluation already.

Regards,
Steven

Posted by Steven Chan on April 19, 2012 at 05:57 AM PDT #

Hi Steven,
My customer looks for running Discoverer report connect to eBSO users on Read-Only database. It is not working.
They saw your Article in this blog, said it is possible.
Could you please share concept of trigger, which table need to be inserting or updating in the trigger?
I log SR with Oracle Support, they said it is not supported to run Discoverer connect to eBSO users on Read-Only database.

Regards,
Jesse.

Posted by Jesse Archery on April 22, 2012 at 06:36 PM PDT #

Hi, Jesse,

Oracle Support is correct. We have not validated running Discoverer reports against an EBS instance on Active Data Guard yet. We expect that certain reports (those that don't require database writes for temporary summary calculations) will work fine. We expect that reports that require writes to the database will not work.

We have plans to test this and document the procedures for this configuration in the future. Stay tuned.

Regards,
Steven

Posted by Steven Chan on May 01, 2012 at 08:19 AM PDT #

Steven,

Any update on procedures for this configuration? We are looking to run both DISCOVERER and OBIEE against ADG stand-by for EBS. I also assume that saving reports would be a problem unless EUL is defined outside of EBS database. Doing this would also invalidate Responsibility based security. Any help or direction would be appreciated.

Posted by Dan on June 26, 2012 at 01:02 PM PDT #

Dan,

Thanks for the inquiry. The information as provided in this blog article is still current.

We are researching additional features that would include Discoverer and OBIEE reporting in an Active Data Guard instance. Oracle's Revenue Recognition policies prohibt me for discussing dates.

Please continue to monitor this blog for updates.

Thanks.
Elke

Posted by guest on June 29, 2012 at 09:42 AM PDT #

Is it possible to run SQL queries on an Active Data Guard instance?

Thanks
Leon

Posted by guest on July 25, 2012 at 04:39 AM PDT #

Leon,

Thanks for the inquiry. Yes, Active Data Guard allows you to open a physical standby database and perform read-only queries while redo is applied to the physical standby database.

Thanks.
Elke

Posted by Elke Phelps (Oracle Development) on August 01, 2012 at 03:24 PM PDT #

Steven,
Do you have any updates to running Discoverer on ADG, configuration requirements and limitations?

Thanks!
Vie

Posted by Vie303 on November 28, 2012 at 08:43 AM PST #

Vie,

Thanks for the inquiry. We are actively working on a certification project for Discoverer with Active DataGuard for E-Business Suite. Due to Oracle's revenue reconginition policies, dates and time lines cannot be disclosed.

Please continue to watch or subscribe to this blog for new announcements regardging this certification effort.

Thanks.
Elke

Posted by Elke Phelps (Oracle Development) on November 28, 2012 at 10:08 AM PST #

Just curious to know Oracle EBS R12.2 is planning to release soon.then what is the role of Oracle Fusion Applications . Do you think both the application will run in the same Organization as co-exisitence solutions is provided by Oracle .
Need to know what is the roadmap of Oracle ,Oracle EBS R12.2 or Fusion application R11.1.4(RUP 3) ?

Thanks
Saroj

Posted by guest on December 11, 2012 at 11:16 AM PST #

Saroj,

Thank you for the inquiry. EBS has strong roadmap and dedicated development team as part of Oracle’s Application Unlimited commitment for continued support and innovation for all of its application product lines. EBS is working on the next major release 12.2, which is targeted for delivery in the next 12 months.

EBS plans for many releases after the initial release of EBS 12.2, with rollup packs (RUPs) targeted every 8-12 months, which will include functional enhancements, user interface modernizations, and technology updates to lower the cost of ownership and improve performance.

EBS customers should look at Fusion Applications to fulfil any business requirement that cannot be met today with the EBS footprint. There are a number of good co-existence scenarios of Fusion Application modules with the EBS deployment. Typical Fusion co-existence modules include Fusion Talent Mgt Cloud, Fusion CRM Cloud, and Fusion Distributed Order Orchestration (DOO) with pre-built integration between EBS and these Fusion Apps.

Oracle’s general recommendation to EBS customers is to:
o Upgrade to the latest release - EBS 12.1.3
o Leverage new capabilities of 12.1.3
o Extend the EBS footprint with new EBS solutions to meet their business requirements
o Evaluate co-existence of Fusion Application modules with their EBS deployment

Thanks.
Elke

Posted by Elke Phelps (Oracle Development) on December 12, 2012 at 03:09 PM PST #

Thanks Steven for the thread.

I am looking for your advise of whether it has become supported to run Discoverer connect to eBSO users on Read-Only database.

Regards,
Murad

Posted by Murad on May 21, 2013 at 04:14 PM PDT #

Murad,

Thanks for your inquiry. We are actively working on a certification project for Discoverer with Active DataGuard for E-Business Suite. Due to Oracle's revenue reconginition policies, dates and time lines cannot be disclosed.

Please continue to watch or subscribe to this blog for new announcements regardging this certification effort.

Regards,
Elke

Posted by Elke Phelps (Oracle Development) on June 03, 2013 at 06:40 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
4
5
6
7
8
9
10
11
12
13
14
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today