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
- Booking and
- Billing data
As explained in below process flow
- 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
- One in Pre-Staging table, design and develop Validation Rule engine to validate data in Pre-Stage table as per user organization requirements.
- Design and develop report to show the outcome of Validation process.
- User Interface (This is option steps) , create a User Interface for user/business to
- Review data in pre-stage and if required Correct errors ( in Pre-Stage) manually.
- Trigger Re-validation from UI
- Develop a process to Transfer valid data from Pre-Staging table to Stage table.
- Though data collection process is similar for majority of customer, but data validation rule engine designed and developed based on customer specific requirements.
- Any Manual data correction will be recorded in AUDIT tables.