Search 800 + Posts

Jun 10, 2018

EBS to Zuora Rev-Pro Integration

This is short overview about how to Integrate Oracle EBS with Zuora Rev-Pro Revenue engine.

Scope of this integration is limit to extraction of 
  1. Booking and 
  2. Billing data 
from Oracle EBS and load into Zuora/Rev-Pro revenue stage table. Once in stage table Zuora standard process will pick the data for further processing.

As explained in below process flow 
  1. Create adapters to extract/transform booking and billing data from EBS and load into Pre-Staging table. We can write our own adapters or leverage the adapters provided by Zuora
  2. One in Pre-Staging table, design and develop Validation Rule engine to validate data in Pre-Stage table as per user organization requirements.
  3. Design and develop report to show the outcome of Validation process.
  4. User Interface (This is option steps) , create a User Interface for user/business to 
    1. Review data in pre-stage and if required Correct errors ( in Pre-Stage)  manually.
    2. Trigger Re-validation from UI
  5. Develop a process to Transfer valid data from Pre-Staging table to Stage table.

Note –
  1. Though data collection process is similar for majority of customer, but data validation rule engine designed and developed based on customer specific requirements.
  2. Any Manual data correction will be recorded in AUDIT tables.


  1. Your website is very good and nice information was provided in your site, thanks for sharing.
    Oracle SCM Training in Ameerpet, Hyderabad

  2. You really did a great job. I found your blog very interesting and very informative. I think your blog is great information source & I like your way of writing and explaining the topics. Keep it up.More information please visit our website.Oracle Fusion Cloud Financials Training

  3. Wow! what an informative blog. Your blog had all the relevant points and useful information that was required for the same topic. It was really interesting. I'm thankful that you shared this blog and your knowledge with us. Here is a referred link same as yours oracle fusion scm training.

  4. Our knowledge is truly enhanced after reading this. It was quite useful. we are truly glad that you shared this with us. Here is a referred blog that I have found same as yours   oracle fusion financials training. while browsing, i came across this one, it's useful and will be providing necessary knowledge too.