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.

Oracle Service Cloud to EBS Integration

High level overview of Oracle Service Cloud to EBS Integration.


 

For additional details feel free to write us at inquiry@bizinsightinc.com

Oracle Service Cloud Integration with EBS from Bizinsight Consulting Inc

Calculate Price Flag in Oracle Order Management

 Calculate Price in Oracle Order Management

The Calculate Price flag allows the calling application to fully or partially freeze the price on a pricing request line. Price may be completely frozen with no additional modifiers applied, or additional modifiers may be applied in certain phases, depending on the value of the flag. Possible values are as follows:

Flag Value	Action
Y (calculate price)	Applies all prices and modifiers to the request line.
N (freeze price)	Does not apply any prices or modifiers to the request line.
P (partial price)	Only applies prices or modifiers in certain phases.

When the calculate price flag is set to partial price, the search engine observes the freeze override flag on the phase. 

When the calculate price flag is set to yes the search engine applies eligible modifiers in the phase to the request line. 

When the calculate price flag is set to no the modifiers in the phase are not considered for application to the request line. 

Additional Details : 

Calculate Price Flag: Calculate Price: Use the pricing engine to determine price. Calculate price and freight charges at the time of pricing. 

Freeze Price: Never use the pricing engine to determine price. Do not calculate price or freight charges. 

Partial Price: Use the pricing engine to determine price. Calculates only freight charges at the time of pricing.

If you split an order line into multiple lines and want to retain the original price on both the original line and new lines, change your Calculate Price Flag to either Freeze Price or Partial Price before initiating a user split.

The following table shows the value of the Calculate Price Flag before and after a user or system initiated split.

Calculate Price Flag before and after a User or System-initiated Split

Calculate Price Flag	Original Line before split: Calculate Price	Original line before split: Partial Price	Original line before split: Freeze Price
Original line after user initiated split	Calculate Price	Partial Price	Freeze Price
New line after user initiated split	Calculate Price	Partial Price	Freeze Price
Original line after system initiated split	Partial Price	Partial Price	Freeze Price
New line after system initiated split	Freeze Price	Freeze Price	Freeze Price

 This query will provide the name of pricing phases that have freeze_override enabled.

select pricing_phase_id, name, 
        freeze_override_flag, user_freeze_override_flag
from qp_pricing_phases
where (freeze_override_flag = 'Y' and user_freeze_override_flag is null)

or user_freeze_override_flag = 'Y';