The Latest Oracle E-Business Suite Technology News direct from
Oracle E-Business Suite Development & Product Management

Offloading EBS 12.2 Reporting Using Active Data Guard

Steven Chan
Senior Director

Oracle Active Data Guard is now certified with Oracle E-Business Suite 12.2.  This certification supports the ability to offload some production reporting from your production EBS 12.2 environment to an Active Data Guard instance. For example, you can use Oracle Discoverer and Concurrent Manager to run selected reports against an Oracle Active Data Guard physical standby database instance. 

Detailed steps for setting up Active Data Guard with Oracle E-Business Suite 12.2 are provided in the following My Oracle Support Note:

Active Data Guard ADG + EBS

In addition to Discoverer and Concurrent Manager, you may have other reporting tools that you would like to use with the Oracle Active Data Guard database instance.  In general, you should be able to use the reporting tool if it does not require write access to the Active Data Guard instance. 

Pending Certifications

This certification covers non-RAC instances only.  Updates for environments that use Real Application Clusters are still pending.

Oracle's Revenue Recognition rules prohibit us from discussing certification and release dates, but you're welcome to monitor or subscribe to this blog. I'll post updates here as soon as soon as they're available.

Related Articles

Join the discussion

Comments ( 6 )
  • Pankaj Sharma Tuesday, September 13, 2016

    Is it supported on the R12.2.4 also ?

    We are presently on R12.2.4 and plan to implement the DR using Active Data Guard 12c.

  • Steven Chan Tuesday, September 13, 2016


    Please see the link to the Note in the article above. It states that 12.2.4 is covered.



  • viral Thursday, January 18, 2018
    Hello Steven,

    Can we point concurrent node to database which is replicated via oracle goldengate and offload reporting ?


    Viral Patel
  • Steven Chan Thursday, January 18, 2018
    Hello, Viral,

    We don't have any guidance on how to do that. This would be a customization. Given that it's a customization, the approach's success will depend upon the implementer's skill.

    For support implications of customizations, see:


  • Jibu Thursday, September 6, 2018
    Is the use of Active Data Guard in EBS 12.2.X with 11g/12c database with RAC configuration certified ?
  • Taoqir Saturday, December 5, 2020

    How can we offload standalone form and reports 12 reporting from active dataguard?

Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.