Skip to main content

Zuora RevPro 3.4 Release Notes

Zuora

Zuora RevPro 3.4 Release Notes

This article provides a summary of new releases, features, enhancements, and resolved issues in the Zuora RevPro application.

Release 3.4.4.0

The release 3.4.4.0 of Zuora RevPro includes the following new features, enhancements, and resolved issues.

New Features

No new features for 3.4.4.0.

Enhancements

Multi-Organization Programs For The Jobs

There are no corresponding multi-org enabled jobs to add them to Period Open/Close templates.

A new wrapper program for Multi-Org is created separately. Use the following programs in the period-close template when we are closing at book level:

  • RevPro3.0 Reporting Summarize Current Period for Multi-Org   
  • Revpro3.0 Current Period Post summarize Data for Multi-Org 
  • RevPro3.0 Reporting Current Period Close for Multi-Org 
  • RevPro3.0 Reporting Current Period Open for Multi-Org 

Please note that we did not create new Multi-Org program for RevPro3.0 LTST Reclass. This must run separately out of period-close template.

RC Details Report Related Updates

In this release, the following new fields are available in multiple reports. You do not need to create label_id for these fields because Labels are already created.

FLD_NAME

Report Names

PRNT_REF_LN_ID

Add these 8 FLD_Names in the following reports:

  • RC Rollforward Report
  • Waterfall Report
  • OnHold Accounting Report
  • Accounting Report
  • SSP Exception Report
  • RC Hold/Release Report
  • Revenue Contract Detail Report
  • Role Privileges Report
  • Approvals Report
  • Billing Report
  • Booking Report
  • Orphan Transactions Report
  • Manual POB Report
  • Manually Created Revenue Contracts
  • Unreleased POB(s) Report
  • POB(s) Released Report
  • Failed RSSP Transaction Report
  • Revenue Contract Move Report
  • POB Dependencies
  • Cost Stratification
  • Cost Transactions
  • Cost Transaction Changes
  • VC Template
  • VC Transaction Changes
  • VC Transactions
  • SSP Update Report
  • Cost Capitalized Rollforward Report
  • Revenue Book Comparison Report
  • VC Rollforward Report
  • Billing RollForward Report
  • Billing Waterfall
  • Events Report
  • Revenue Insight
  • VC Actions
  • VC Insight
  • Cost Insight
  • Line Staging Report
  • Mass Action Batch Report
  • Unbilled Fx Report
  • Disclosure - Contract Level
  • Unbill RollForward Report
  • Contract Modification Report
  • MJE Details Report
  • Reduction Orders Report
  • User Access Report
  • VC Events Process Report
  • Transactions Processing Report
  • Transfer Accounting Errors Report 
  • Audit Trail Report
  • User Assignment Report
  • SSP Stratifications
  • SSP Optimizer Range
  • RC Workbench TimeLine Report
LT_CA_ACCOUNT
CONTRA_AR_ACCT
CA_ACCOUNT
GET_MATERIAL_RIGHTS_FLAG(INDICATOR)
GET_RAMP_UP_FLAG(INDICATOR)
RAMP_IDENTIFIER
IMPAIR_RETRIEVE_AMT

Add this field in the following reports:

  • RC Rollforward Report
  • Waterfall Report
  • Accounting Report
  • SSP Exception Report
  • RC Hold/Release Report
  • Revenue Contract Detail Report
  • Billing Report
  • Booking Report
  • Orphan Transactions Report
  • Manual POB Report
  • Manually Created Revenue Contracts
  • Unreleased POB(s) Report
  • POB(s) Released Report
  • Failed RSSP Transaction Report
  • POB Dependencies
  • Cost Transactions
  • Cost Transaction Changes
  • VC Transaction Changes
  • VC Transactions
  • Cost Capitalized Rollforward Report
  • Revenue Book Comparison Report
  • VC Rollforward Report
  • Billing RollForward Report
  • Billing Waterfall
  • Revenue Insight
  • VC Actions
  • VC Insight
  • Cost Insight
  • Unbilled Fx Report
  • Transfer Accounting Errors Report
GET_IMPAIRMENT_TYPE_FLAG(INDICATORS)

Add this field in the following reports:

  • RC Rollforward Report
  • Waterfall Report
  • Accounting Report
  • SSP Exception Report
  • Revenue Contract Detail Report
  • Billing Report
  • Booking Report
  • Orphan Transactions Report
  • Manual POB Report
  • Manually Created Revenue Contracts
  • Unreleased POB(s) Report
  • POB(s) Released Report
  • Failed RSSP Transaction Report
  • POB Dependencies
  • Cost Transactions
  • Cost Transaction Changes
  • VC Transaction Changes
  • VC Transactions
  • Cost Capitalized Rollforward Report
  • Revenue Book Comparison Report
  • VC Rollforward Report
  • Billing RollForward Report
  • Billing Waterfall
  • Revenue Insight
  • VC Actions
  • VC Insight
  • Cost Insight
  • Transfer Accounting Errors Report
LT_DEF_ADJ_ACCT

Add this field in the following reports:

  • RC Rollforward Report
  • Waterfall Report
  • Accounting Report
  • SSP Exception Report
  • RC Hold/Release Report
  • Revenue Contract Detail Report
  • Billing Report
  • Booking Report
  • Orphan Transactions Report
  • Manual POB Report
  • Manually Created Revenue Contracts
  • Unreleased POB(s) Report
  • POB(s) Released Report
  • Failed RSSP Transaction Report
  • POB Dependencies
  • Cost Transactions
  • Cost Transaction Changes
  • VC Transaction Changes
  • VC Transactions
  • Cost Capitalized Rollforward Report
  • Revenue Book Comparison Report
  • VC Rollforward Report
  • Billing RollForward Report
  • Billing Waterfall
  • Revenue Insight
  • VC Actions
  • VC Insight
  • Cost Insight
  • Mass Action Batch Report
  • Unbilled Fx Report
  • Unbill RollForward Report
  • Reduction Orders Report
  • Transfer Accounting Errors Report

 

FV Batch Related Updates

Label and Report Label details have to be updated in the FV Batch. In the SSP Update Report, SSP Batch field is updated in the header of the downloaded report.

Expiration Based POB Report  

To identify whether a POB is released based by event or by expiration, POB Setup field and Expiration field are provided with the following fields:

  • POB Setup: Release upon event
  • Expiration: Based on a date attribute

Audit Trail Report Related Report

In the Audit Trail Report, old value and new value are displayed as abbreviated value Instead of expanded form. For example, Forecast Template displays the Old value as L and New Value as F(Here L represents LIFO and F represents FIFO)

Pop-up Windows

The following are the enhancements that are required:

  • Ability to have pop-up of POB template from the RC workbench to walk through that setup. 
  • Ability to have pop-up of RC grouping rule from the RC workbench to walk through that setup

Currently we have to navigate to the setup and show but we lose track of RC which we were displaying. 

So the following pop-ups are enabled:

  • Pop Up for POB Template: Display context menu action "View POB Template" on POB level, when selected open the version of the POB Template UI to which the POB is associated
  • Pop Up for RC Grouping Rule Template: Display context menu action "View RC Grouping Rule" on RC level, when selected open the version of the RC Grouping Template UI to which the RC is associated is formed.

Stage and Base Tables Related Update

This is related to Zuora integration in Zuora Orders. Any amendment to subscription is tracked through an action type and they are:

  • Create Subscription
  • Add Product
  • Remove Product
  • Update Product
  • Terms & Conditions

When data is interfaced to Revpro, this may be one of the reporting attributes that customers would like to see in the UI and reports as applicable.

This action type can be associated with the following transaction types:

  • SO
  • RORD
  • PORD
  • INV
  • CM-R
  • CM-C
  • CM-RO
  • CM

Recommendation is to add a field to the stage and transactions tables and the field is made available in the following screens:

  • Transaction Upload UI
  • Transactions Layout
  • Waterfall Layout(UI)
  • Accounting Details Tab Layout

Initial Reporting Entry not Reversed Fully  

In Bundle scenarios, we have data augmentation rule to replace the contract liability account for one of the two child lines in the bundle. System creates initial reporting entry to reclassify the entry. In case of contract cancelations, when the credit memo for cancelation is processed, the initial reporting entry does not get fully reversed which results in a balance in contract liability account

Including Allocation Apply Method and Allocation Apply Fields in SSP Report  

For the following SSP Reports, we are adding the Allocation Apply Method and Allocation Apply Fields:

  • Transactions- SSP Stratifications
  • Transactions- SSP Optimizer Range
  • SOX and Audit- SSP Update Report

Variable Considerations Setup Change

This enhancement is related to variable considerations (VC) eligibility. If the transaction line's VC Eligible Flag is marked as Yes, the system should trigger the 2-step verification.

There are a few changes to this functionality and they are listed below:

  1. To validate of all the eligible transaction lines (CV Eligible Flag = Yes) fall within the RC Level Range, the system derives the line level TP% based on the Ext Sell Price or Allocatable Price / Ext SSP Price. To calculate the RC Level, it is the total sell price or total allocatable price / Total Ext SSP Price, which includes all the lines regardless of the CV Eligible Flag value. If all the line level TP% falls within the RC Level Range, the system will not perform the 2nd step verification. To continue to Step 2 verification even when all the lines are within RC Level range in the Step 1 verification, this is controlled by using a profile option. When the profile is enabled, the system will perform the 2-step verification even when all transactions are within RC Level Range or Within SSP Range.
  2. Currently, when performing the 2-step verification, for the revenue contract with multiple VC lines, at the time of 2-step verification, if one of the VC line is excluded from the allocation, other VC lines are also automatically excluded from the allocation at the time of verification.
  3. During the revision period, if a change ONLY to the VC line is performed and no other changes exist in the revenue contract, and if the line was excluded from allocation in the earlier revision period or contract initial timeline, then the system will not allow the line to be re-assessed or re-allocated. During the revision period, if a new VC line is added to the revenue contract, this line will go through re-assessment when any changes happen.
  4. Multiple lookup options are provided for the VC_CHK_REV_PRD profile end-users to specify when to re-assess the VC line to go through the 2-step verification. i.e., whether the VC line included in allocation earlier needs to be included for re-assessment when a change to any line occurs.
  • Never Re-Assess: The system will never reassess the line if a VC line is included earlier in allocation.
  • Re-Assess when Retrospective: The system will reassess the line if the change is a retrospective change.
  • Re-Assess only If VC Line is not fully satisfied: The system will reassess only if a VC line included earlier in allocation is not fully satisfied.

From And To Dates For Account Details Report

Currently the standard RevPro Account Details Report has only one date parameter 'Plan Period Start Date' which has list of periods and quarters. User can run the report only for a specific period or a quarter. In many cases they need to run it for multiple periods, or across quarters or over a year. They therefore need flexibility to input From and to periods or some way in which they can input larger time periods and not have to manually run the report over and over again and then combine the outputs as they want this as one report from audit perspective.

The enhancement is to add a static value Period Date Range in the LOV of the Plan Post Period, upon selecting the Date Range, display Period Start Date and Period End Date.

When user enters the Period Start Date and Period End Date, generate the output based on the dates entered but ignoring the Plan Post Period Value. Also, when submit download is performed, have the respective parameters captured in the csv file.

Pop-up Screen For Viewing POB Template and Grouping Rules

New enhancement is to have a pop-up of POB template from the RC workbench to walk through that setup and another pop-up of RC grouping rule from the RC workbench to walk through that setup. Currently we have to navigate to the setup to view and we lose track of the RC.

  • Pop-up for POB Template: Display context menu action "View POB Template" on POB level. When selected, it opens the version of the POB Template UI to which the POB is associated.
  • Pop-up for RC Grouping Rule Template: Display context menu action "View RC Grouping Rule" on RC level, when selected open the version of the RC Grouping Template UI to which the RC is associated is formed

LT/ST Report with Accounting Schedules

Currently there is a limitation on how many lines we can export and users also don't have a report which gives them LT/ST schedules similar to Accounting Detail. 

Instead of adding a new report, a new context menu action link "Download LT/ST Schedules" is included. 

Following are the new fields introduced in the LT/ST Reclass screen along with a context menu action link "Download LT/ST Schedules" and they are: 

  • Sales Order Line Id
  • Account Name
  • Cumulative Carve
  • Carve Amount
  • Allocated Amount
  • Cumulative Allocated Amount

Improve Schedule Job Process

The following are the improvements done in scheduled job process:

  • Provide user to download job output for most of the interfaces wherever applicable
  • Provide user to download log, instead of the current feature which only allow to view.
  • Use request id in all the log table, transaction table to have unique identifier across processes.

 

Resolved Bugs

Terminate Jobs Issue

For the Inquiry role in Revpro, only specified role privileges are in-spite of not having the privilege to terminate and cancel the job, it still allows it.

Terminate job and cancel job role privileges should be added to terminate and cancel the job.

This issue is resolved.

Warning in Event Collection

Status appears as "Warning" while running the Event Collection job. However re-running the Event Collection changes the status as "Completed".
This issue is resolved.

Revenue Share with CM-R Scenarios

The revenue reversed for CM-R is not distributed among the segments according to the defined revenue share but reversal is done LIFO. Cost reversal picks up segments from the transaction, not from the distribution defined.

This issue is resolved.

Parent Line of the Unbundled Lines is Going to Contract Modification

While loading a bundle line into existing RC and CT mod triggering 'SSP not within range create new RC' for one of the child line , in old RC for parent bundle line ct mod rule triggered , By this RPD we fixed , when Parent Bundle Line have sell prc and list prc as 0 ( means it is consumed fully and created child lines), that parent line not suppose to go through CT mod Rule.

This issue is resolved.

CST Line Not Included in Bundle Explosion

CST line type is not included in bundle explosion. CST line uploaded should be subject to bundle explosion. CST for an uploaded Sales Order Line ID should be split (as per the pre-defined percentage in bundle explode upload file) between the child lines.

This issue is resolved.

VC Action Value As Code

VC Actions Report has a column VC Action where we see the code (e.g A,B,C,D,E,F,G) but the user understandable description is not displayed.

This issue is resolved.

Impairment Amount Incorrect

Due to unreleased contract value in the Revenue Contract, the impairment amount calculation is incorrect.

This issue is resolved.

Extended Fair Value not Getting Updated

If partial CM is first collected and then the partial CM-R is collected, Zuora RevPro marks the return flag as 'Y'. If its 'Y' then system does not calculate the Ext_fv_price. 

This issue is resolved.

Data Collection Issue

Stage records are getting the following error message:

"PARENT REFERENCE WAS NOT FOUND"

If an SO is delinked and linked to other RC, then rpro_rc_grp_dtl_g is having multiple entries with different RCs and it retrieves multiple RC ids during UPDATE_STG_RCID in data collection and failing to update RC id in stage.

This issue is resolved.

Netting Process Time

Netting process performance is very slow. It is taking long time to complete a job.

This issue is resolved.

Re-allocate not Refreshing Summary Fields and Overview Tab

When Re-allocation is performed, Zuora RevPro is not refreshing the summary fields and the overview tab automatically.

This issue is resolved.

System not Reversing Allocation Entry

While Creating a manual Revenue Contract, when an RC line has multiple currencies, Zuora RevPro is not reversing allocation entries.

This issue is resolved.

Unable to Release Remaining Revenue

Remaining revenue is not getting released.

This issue is resolved in Process Action API.

Summary Dashboard Reflects Incorrect Revenue Unreleased Amount

In the summary dashboard, Unreleased Revenue By Event chart shows a high amount for Upon Booking event. But when we run the unreleased POBS report, very less amount is shown as unreleased for Upon Booking event. The summary dashboard is misleading as it does not reflect the correct unreleased amount by event.

This issue is resolved. 


Multi-Org Batch Collection

When higher count of organization data is pushed into stage table, data collection master job is submitted and an error message appears.

This issue is resolved.


Revenue Share with CM-R Scenarios

Revenue reversed from the respective segments as the Distribution is defined. But cost reversal pick up segments from the transaction are not from the defined distribution.

This issue is resolved.

Data Collection Goes to Warning

While collecting the SO, Overstated Invoice and CM-C, data collection shows a warning.

This issue is resolved.

Error in Ratable Method 

Batch collection are varied for each scenarios with SO/INV/CM. Even though Error has occurred, data is collected.

This issue is resolved.

Accounting Report Error

When we compare the downloaded Accounting Report, the number of records are not matching with the scheduled Accounting Report.
While downloading the report, period name or period quarter parameter is available in the dynamic query. So the report is pulling Current period data only. But while scheduling the report, period name or period quarter parameter is missing in the dynamic query. So the report is pulling all period's data.

This issue is resolved.

Netting Program with Multi Org - Status not getting Updated

When you submit the multi-organization task of period close template, it is getting processed and showing the status as completed in the background jobs but status update is not getting reflected in the Period Open/Close UI.

This issue is resolved.

Wrong Adjustment Amount in Waterfall Report

Waterfall report is executed successfully but the adjustment field is showing wrong amount for Prior Amt.

This issue is resolved.

COGS EX Rate not Updated For RORD

COGS is not displayed in Waterfall report when it is run for functional currency in RORD scenario.COGS ex rate is not updated in schedule when RORD happens. 

This issue is resolved.

Decimal Error 

Profile option for Amount format id setup is two decimals only. Revenue and adjustment accounting entries created after netting program are in three decimals. This is creating posting issue in SAP. All schedules and accounting values should have only two decimals.

This issue is resolved.

Rounding Issues With UDS

Rounding issue with user-defined schedule is causing over-release of revenue.

This issue is resolved.

Impairment Scenarios not Found in RC Roll Forward Report

Impairment scenarios for all impairment types are not found in the RC Roll Forward report. 

This issue is resolved.

Duplicate Seeded Period Name

Duplicate Period Name is seeded in the default layout of the manually created Revenue Contract. So an SQL error appears.

This issue is resolved.

Old Allocation Entries in Waterfall Table Auto Deleted

While running Reporting Current Summarize, old Allocation entries are getting deleted from the Waterfall table. Line has initial allocation entry with old period and adjustment revenue entry is created in current open period by releasing the revenue line.

This issue is resolved.


User Defined Schedules With Updated SO- Unreleased Contract Value and Prospective not Stamped

Release Percent not Updated Correctly

Release percent is not updated correctly at the line level when we cancel the backlog with RORD

This issue is resolved.

Non Zero SO with Zero Dollar Invoice Schedule Error

When a non zero SO line and multiple invoice line with zero dollar is collected, process it through event by releases. Schedule is created with errors.

This issue is resolved.

System Error Occurred During Processing

Currency code is not populating in the head table for some of the batches during batch collection process but line level currency code is populated. Analyzed the issue and could see some gap where the exception is not handled properly. Wherever the function is called without passing the currency code, this issue arises.

This issue does not happen in manual uploads and it happens only when the data comes through integration.

Job Status Utility

Identify status of each parent and thread child jobs for a wrapper.

This issue is resolved.

Password Configuration

Minimum length of the password is not working correctly.

This issue is resolved.

Contract Ratable Issue

While processing prospective revenue, it should not to go into Contract Ratable when it is prospective.

This issue is resolved.


Contract Impairment Issue

Contract impairment is not getting triggered after processing a RORD transaction in the revision timeline. Impairment Type for the RORD line is sent as 'CONTRACT IMPAIRMENT'. The expectation is that impairment should get triggered and the reclass of adjustments should be performed between contract liability to impairment account. Since the impairment is not triggered, some unreleased contract value is shown in the workbench summary.

This issue is resolved.

Selection Of Non-mandatory Filters In Waterfall Report. 

Zuora RevPro does not allow the user to omit the non-mandatory filters in the Waterfall Report. 

This issue is resolved.


Netting MJE Call from Oracle not Working for Multi Org

When there is an application level netting process where it has Oracle ERP and multi org is also enabled. When we run the Netting Process from the UI (Accounting), Netting for MJE is not created. 

This issue is resolved.

Return Value Too High

When you run the Zuora RevPro Reporting Summarize Current Period for Multi-Org, the return value is too high.

This issue is resolved.

Rebooked Revenue Schedules

The rebooked revenue schedules for the line is created only from the future period, not from the current period.

This issue is resolved.

Switch Allocation- Carves not Netting

Unreleased value is populated and adjustment revenue entries are not matching with adjustment liability entry.

This issue is resolved.

Data Collection Process Terminates with Oracle Error

Auto POB assignment during data collection process terminates with Oracle Error.

This issue is resolved.

Booking Report Custom Report(POD Report)SHOWS MJE LINES & ONLY SHOWS

In Booking Report there is a Custom Report called POD report. It shows no results but booking report is working as expected.

This issue is resolved.

RORD Data Collection Issue

RORD Collection is done with complete amounts. RORD Collection Fails with the following errors:

  •  STAGE_TABLE_ERROR - "Oracle Internal Error- Check Log for more info"
  • SUBMIT JOBS - "One or More Child processes are in Warning state"

This issue is resolved.

FS - RC Move Report Error

In the Revenue Contract Move Report, there are lines which did not even participate in the link-delink activity. The expectation is to show lines which were moved from a certain RC to another i.e. RC From and RC To should be always different.

This issue is resolved.


Override Transaction Dates With Manual Release Dates

Users cannot override the system dates when they are releasing the revenue. Even if the dates are provided at the time of release, system overrides the provided dates with the POB setup dates.

Zuora Revpro should allow override of revenue dates and honor the same irrespective of the revenue timing rules.

This issue is resolved.

Unprocessed Release Events

Events were processed and moved from events stage table to history table but revenue was not recognized. This issue is occurring intermittently and revenue is getting recognized when we run the event Master job again by pushing the same  records in to event stage table.

This issue is resolved.


Reports not Working In Global Admin Role

Reports are not working when they are submitted from Global admin role. It is prompting below error message when we tried to run the report globally by selecting the Org name as “All”.

We have selected one Org name from the drop-down list and clicked on “Submit Download”.

The reports are not coming out of “In-Progress” status. However all the reports are working fine from Org specific roles.


Override Transaction Dates With Manual Release Dates

Users don't have the ability to override the system dates when releasing the revenue manually. Even if the dates are provided at the time of the release, system overrides the provided dates with the POB setup dates. So the revenue released is incorrect.

This issue is resolved.

Batch Collection Error

While collecting a batch that consists of SO lines, invoice lines, CM-R lines and CM-R cancelation with a credit, a warning message appears.

This issue is resolved.

Uploaded POB Lines Disappears 

When a Multi Org is enabled, the user is not able to see the uploaded POB lines in Assignment by Attributes upload template.

This issue is resolved.

Batch Collection Warning Message

While performing Batch Collection for CM and CM Cancelation, a warning message is displayed.

This issue is resolved.

Revenue not Released And Scheduling Error

100% revenue is not released for Events lines with the same start and event date. 

If the SO line's start date and end date and event's start and end date is spread across 2 periods, the full amount for both the periods are getting scheduled in the current open period.

This issue is resolved.

Cost Billed Rec Amount Issue

While canceling a CM-C, Cost Billed Rec amount is not getting updated.

This issue is resolved.

Mass Action by amortize Schedules - Duplicate Entries are Created

Reversal schedules are created for the dates defined in POB schedules. New schedules are created for the same dates instead of the dates given in the mass action.

This issue is resolved.

Customer Name Not Created In RC Workbench

When SO lines are collected based upon the POB, revenue is released 100% and schedules are created. In addition to this while collecting full invoice for SO lines, CM-R for 4 SO lines in same batch
reversal schedules are created. Customer name is not getting created in RC workbench.

This issue is resolved.

Issue with VC Formula Utility API to calculate VC Amount

The VC Formula Utility API does not calculate the VC Amount if the formula columns are based on NUM1........NUM16 fields. 

This issue is resolved in the Formula Utility API.

Exchange Rate Date not Populated

For RORD cost schedules, Standard Cost and  Ex Rate Date is not populated. Exchange Rate is populated for initial cost entries and unbilled reversal. For Revenue reversal the date is populated.

This issue is resolved.

Issues in Waterfall Report

Waterfall report is not working even after loading Waterfall conversion data. The Revenue_account_segments value is not getting updated correctly and that is the reason for the problem in the report.

This issue is resolved

Period Close Issue

Multi-Org jobs are added in the Period Open/Close template and the Netting Process job is initiated. It starts the netting process jobs organization wise and all of them got completed without any issues. But the status is not getting updated in the Period Close template and system is not allowing to initiate the next task in the list.

This issue is resolved

Terminate Jobs Issue

The Inquiry role in Revpro does not have privileges to terminate and cancel a job but currently the user is allowed to terminate and cancel.

This issue is resolved.

Amount Details Are Blank In RC Header

The RC has Invoice and CM collected during the same period. So there is no Allocation and waterfall. In the RC line table, Allocatable, Def Amt, Rec Amt and CV amount are blank. 

This issue is resolved.

Pre-requisites and System Requirements 

The minimum patch level that is required to apply this patch are given below:

Patch #

3.4.3.0

Build #   

3430

Combo Build

34302497

Patch Type

Incremental

Released Date

02/07/18

 

Upgrade Path

RevPro being a product offering will be maintained in terms of bug fixes and feature/functionality additions on an ongoing basis. These are delivered to the customers in the form of support packs. These Support packs will be available for the customers in their own Zuora customer portals provided. Customers need to login into their own portal and download the patches for installing it.

Testing Strategy Recommendations  

In any upgrade situations, Zuora recommends installing the Support packs in a Test or a QA instance and identify the impact of the patches from a business process perspective and only then transport to Production instance.

Release 3.4.3.0

The release 3.4.3.0 of Zuora RevPro includes the following new features, enhancements, and resolved issues.

New Features

There are no new features in 3.4.3.0 release.

Enhancements

Skip Contract Modifications

This functionality allows customers for specific transaction lines to restrict from triggering contract modification rules due to amendments.

A new field is added to the stage and to the SKIP_CT_MOD_FLAG base table when you set to Yes for the transaction. Zuora RevPro only performs re-allocation and does not trigger contract modification rules triggering prospective or retrospective allocation.

Request For Confirmation Pop-up Window While Terminating Scheduler Jobs

Previously, a single click on the Terminate icon in scheduler job monitor page terminates the job immediately without any warning. To avoid terminating the jobs unintentionally or while clicking on some other icon, a confirmation pop-up window is available so that only after confirmation, the job is terminated.

The ENABLE_CONTRACT_RATABLE Issue

The ENABLE_CONTRACT_RATABLE profile now only impacts the unbilled conversion instead of impacting all the ratable methods.

Cancel Flag in Reduction Order Report

You can now cancel the Reduction Order with the Cancel flag as Y. Two ways to adjust the Reduction Order:

  • Send the Reduction Order update amount
  • Remove the Reduction Order with the Cancel Flag as Y

For example, a customer sends in a Reduction Order of -$100. When Zuora RevPro receives the Reduction Order with a cancel flag, it deletes the entire line of the Reduction Order. We are retaining the $100 amount instead of setting it to 0. It is not clear whether the line has the reduction order value or it has been canceled completely. Whenever a reduction order is canceled, the amount will be set to 0 in the reduction order line. When the report is run, the reduction order line value is 0 and the Cancel flag is Y. This conveys that the Reduction Order is set to 0 because of the cancelation.

The new field, Cancel Flag is seeded in the RC Bill Table for the RORD transaction type. 

You can use the proper sequences to add the CANCEL_FLAG field in the following reports:

  • Revenue Contract Detail Report
  • Cost Transactions
  • POB Dependencies
  • Unreleased POB(s) Report
  • POB(s) Released Report
  • Booking Report
  • Reduction Orders Report
  • Billing Report
  • VC Transactions
  • Failed RSSP Transaction Report
  • VC Transaction Changes
  • Cost Transaction Changes
  • Manually Created Revenue Contracts
  • Manual POB Report
  • Orphan Transactions Report
  • RC Hold/Release Report
  • SSP Exception Report
  • Contract Modification Report
  • Mass Action Batch Report
  • VC Actions
  • RC Rollforward Report
  • Cost Capitalized Rollforward Report
  • Revenue Insight
  • VC Insight
  • Cost Insight
  • Billing Waterfall
  • Revenue Book Comparison Report
  • VC Rollforward Report
  • Waterfall Report
  • Billing RollForward Report
  • Unbill RollForward Report
  • Unbilled Fx Report
  • Accounting Report
  • Transfer Accounting Errors Report

You can insert the rrb.indicators column in the following reports:

  • Accounting Report
  • Billing Report
  • Billing RollForward Report
  • Billing Waterfall
  • Reduction Orders Report

The COL_NAME of this label should be INDICATORS, and the label and report_label should be Rc Bill Cancel Flag.

CV_ELIGIBLE_LVL2_FLAG Is Available In RC Details Report

Now, the CV_Eligible_LVL2_Flag allocation type is seeded to the Revenue Contract Details Report. With this feature, you can find out whether the line is eligible for allocation and available for level 2 allocation. Also, you can find out which lines are eligible for step 2 allocation.

Condensed Ratable Method To Consider Invoice Date

The new ratable method, Condense - Using Invoice Date, is added to the POB Template screen in the drop-down of Ratable Method. This can be selected only when release event is Upon Billing. If the ratable method is selected as Condense - Using Invoice Date, then as per the above scenario, Zuora RevPro will do a catch up from the invoice date to the prior period, and book it in the current period.

Note that when it is Invoice Date, it is not the start date on the invoice. But it is the INV_DATE of RPRO_RC_BILL_G.

New Role Reporting Assignment

When a new role is created in Zuora RevPro, all the reports are assigned to the new role by default so that you need not go through the time-consuming process of adding the report one by one. 

Once all the reports are assigned, you can also de-select any specific report to remove.

Workbench Field To Indicate Revenue Recognized To Date

Previously, system was requesting fields in the workbench to indicate Revenue Recognized to date on a line level. Also, this should be segregated into Contractual Recognized to Date and Adjustment Recognized to Date. 

Now, in the Transaction layout, the Revenue Recognized To Date field is newly added in the Workbench. A new virtual column in RPRO_LABEL is introduced that calculates the Revenue Posted to Date based on the current open period. This column is added to the Transaction layout as well but it needs not be in the standard layout. You can select it in the custom layout.

Differentiate Billed And Unbilled Revenue In Revenue Insight Report

Previously, Revenue Insight report displayed the revenue activity only for a specific month. Now, revenue activity is shown as billed and unbilled revenue instead of showing the total revenue. 

Remove Dependency of Link Identifier While Computing MR

Previously, whenever calculating the Material Right for a support line for the remaining term, you had to populate the Link Identifier to indicate whether the support line was a hardware or a software line. But for Subscription based businesses, the support lines were not linked to any hardware or software. Now, the dependency on Link Identifier is removed but you can still calculate the material rights.

Display Error Messages When Events Is Not Processed 

Explanatory error messages are placed in the event table when an event is not processed. Based on the type of the invalid event, the relevant error messages are displayed in the event table.

Resolved Issues

RC Retro Allocation

When unreleased contract value was populated and the allocation schedules were deleted and recreated, carves did not net for the latest period. For prospective allocation, the reversal schedules were displayed even though no retrospective allocation was triggered.

This issue is resolved in the RC Collect API.

Data Collection While Processing the Error Records From Stage

When the stage validation is identified for the records and updated the processed flag to display an error message, if few transactions where CM-C lines were without parent invoice line Id, the data collection program was terminated abnormally with an error message.

This issue is resolved in the RC Collect API.

Fixing the fld_name for MJE Flag

Waterfall Report records are displayed with MJE Flag as Y or N for waterfall submit download.

This issue is resolved.

Populating RC_POB_ID For Cost Scheduled After Cost Update

RC_POB_ID was not populated for the standard cost and formula based cost when the cost was updated.

This issue is resolved.

Collection of SO, INV, CM In the Same Batch With Upon Booking

When the Enable_CM_DEF_KNOCK_OFF profile was enabled, Ext Sell Price became zero and Def Amount was also zero.

This issue is resolved.

Switch Lead Line Option

While switching leading line option, Zuora RevPro took a long time and UI got frozen.

This issue is resolved.

Negative SO Data Stays In Stage With an Error Message

The following error message was displayed if the negative SO data stayed in stage:

"Extended Sell Price of the updated SO is lesser than the Invoice amount."

This issue is resolved.

POB Level Hold Is Not Getting Applied In Newly Created RC

After the linked line with POB held the condition into a new RC, the POB level revenue hold was not applied even though the delink or link happened at the POB level. After the RC creation, the POB level hold was not applied in the newly created RC.

This issue is resolved.

Incorrect Allocation Schedule

Allocation schedule was not created correctly for zero dollar prospective line. 

This issue is resolved.

Labeled Retro And Causing Retro Allocation

As per SSP, the carve out were created for zero dollar and the allocation schedules were created for 10 months based on the release percentage. RC posted and moved to the next period. Brought one prospective change for non-zero dollar line. Zero dollar line became carve in a new version. But the allocation schedules did not have a proper catch up due to no schedule in the last period. This issue got identified when reviewing a set of RC from SFDC, which showed irregular waterfall for zero dollar lines.

This issue is resolved.

ENABLE_CONTRACT_RATABLE Profile Issue

After enabled the ENABLE_CONTRACT_RATABLE profile, revenue was released in Ratable compilation issue. Schedules were created ratably for revenue and were contract ratable for Cost.

This issue is resolved.

Bookings Report

Only Contract Liability and Revenue accounts were available in Booking Report. The Adjustment Liability Accounts and Adjustment Revenue Accounts were not available.

This issue is resolved. The Adjustment Liability and Adjustment Revenue Accounts are now available in all reports where ever revenue account and contract liability account are populated. Also, all GL Accounts from RPRO_RC_LINE_G are available in Bookings Report.

INV Contract Ratable Did Not Work Correctly

An invoice was spread ratable even though the SO was Contract Ratable.

This issue is resolved.

Waterfall Report Was not Part of Workbench Waterfall

After you run all the month end processes before collecting data in a month, the Net Revenue and Allocation waterfall report did not match with the Waterfall from Workbench.

This issue is resolved.

Adjustment Entries Were Missed

In Contract Modification, if the remaining qty or term was greater than the credit term, or qty for Non-distinct POB- adjustment entries were missed, after you have posted the RC, performed Unfreeze, switched allocation, and changed the allocation from retrospective to prospective, the prospective allocation was triggered. Posted entries remained as such and new entries were created. The unreleased contract value was populated. The line had only adjustment revenue entries and did not have adjustment liability entries.

This issue is resolved.

Collection of SO,Full INV and CM-C- Cost Schedule are Created with Negative value in Waterfall

Collect 2 SO lines, Line 1 with a Non-Bundle item, Line 2 with a Bundle item based upon the POB- Upon booking. Bundle got split and schedules are released as expected. Collect Full Invoice for 2 lines and Full CM-C for 2nd SO line in same batch. Cost schedules unbilled conversion happens as expected in schedule. In waterfall the Cost schedules are created in negative amount. Collect CM-C for line - 1(non-bundle), revenue and cost schedules' unbilled conversion happens as expected -In waterfall the Cost schedules are created as negative amount.

This issue is resolved.

Standard Filters Were Not Copied Over For Custom Layout

When you copied the contract modifications layout, the standard filters were not copied over.

This issue is resolved.

Collection of Updated SO with Change in Attribute- Revenue Was Released 100%

While collecting 4 SO lines into Manual POB, retained amount with the Immediate Open Period method. Release RC manually 50%. RC was released 50% and schedules are created. Collect Updated SO for line 1 by updating ATR6 alone. Revenue is released 100% for all lines.

This issue is resolved.

POB with Contract Ratable- Partial INV Collection Revenue Was released 100%

Collect 4 SO lines released Manually - Contract Ratable POB. Manually release 50% for all the lines.
Collect partial INV for all the lines (25%). The unbilled conversion happened ratably and the revenue was released 100% for all the lines (no manual action done).

This issue is resolved.

POB With Contract Ratable- Un-billed Conversion For Partial INV Happened Ratable

If you collected partial invoice for all the lines, the unbilled conversion happened ratably and the revenue was released 100% for all the lines (no manual action done) even with the profile enabled.

This issue is resolved.

Returned POB In Canceled Orders

When the SO was collected with Return POB and Cost amount, the partial invoice with partial cost amount, a 0$ SO was collected with cancel flag and return flag as 'Y'. Collected updated SO was with partial invoice amount and partial cost amount. Cost amount was not changed based on updated SO amount.

This issue is resolved.

Disable Allocation

When you made the RC as ineligible for allocation by using the Disable Allocation functionality in workbench, disabling allocation did not work due to Zuora RevPro did not remove the allocation.

This issue is resolved.

Overstated Invoice For Negative Amount 

The overstated invoice was generated and EXT_LST_PRC was not updated.

This issue is resolved in the RC Collect API.

Releasing Revenue Through Quantity Based Event 

The over usage quantity did not send back the quantity to events staging. This was an unbilled reversal ENABLE_CONTRACT_RATABLE issue.

This issue is resolved.

Amount Based Event Did Not Work With Multiple Lines

The amount based event for multiple lines that had total contract value (sum of multiple lines) and sent the amount event, which released/satisfied only one line, the event did not get processed and the following error message was displayed:

"Warning: Non cumulative zero amount event data found."

Order by tab was to sort multiple lines by given order by attribute but it did not do or order multiple lines. It always went by order of uploading sequence of lines.

This issue is resolved.

Ext Sell Price Was Incorrectly Displayed In Waterfall Tab For POB Waterfall Level

EXT_SLL_PRC was incorrectly displayed in the Waterfall tab of RC workbench when you selected POB as Waterfall Level and generated waterfall. The extended sell price displayed the distinct value of ext_sll_prc for each POB rather than summing up the values within each POB. But, the total in waterfall showed the correct value.

This issue is resolved.

Fix the Cost Columns in RPRO_RI_INSIGHT_DTL_V

The cost columns in RPRO_RI_INSIGHT_DTL_V should not be multiplied by -1.

This issue is resolved. As we are not following multiplication now, it is removed for the following columns:

  • T_TL_COST_AT
  • T_TL_COST_AT_QT
  • T_TL_COST_AT_UT
  • T_TL_COST_AT_YT
  • F_TL_COST_AT
  • F_TL_COST_AT_QT
  • F_TL_COST_AT_UT
  • F_TL_COST_AT_YT
  • R_TL_COST_AT
  • R_TL_COST_AT_QT
  • R_TL_COST_AT_UT
  • R_TL_COST_AT_YT
  • T_TL_COST_AT_UN
  • F_TL_COST_AT_UN
  • R_TL_COST_AT_UN
  • T_TL_COST_AT_PS
  • F_TL_COST_AT_PS
  • R_TL_COST_AT_PS

Cost SO Invoice Sequence Issue

When an invoice was in the first line and SO was in the next line from the upload file, Zuora RevPro only considered invoice cost as the full cost amount.

This issue is resolved.

Mass Actions Upload Issue

While updating an SSP, you downloaded the data and uploaded the changed value. An exception error was displayed and the uploaded data was not saved.

This issue is resolved in Mass Action Upload page.

Duration Zero Was Not Considered in Forecast

Forecast considered P1 as the first period instead of P0.

This issue is resolved.

FV Analysis Error While Unfreezing RC

One of the SO table structure was not populated correctly. So a technical error message was displayed.

This issue is resolved.

New POB Not Within Range Was Not Available in UI

In the Contract Modification, the new POB Not Within Range was not available in UI and the revenue was still in the deferred state.

This issue is resolved.

Child Lines Criteria Field Should Not Be Null

Bundle configuration did not allow the child lines criteria field as null.

This issue is resolved.

Manual Deferral Upon Delink

Delink a line from an RC and hold in the orphan category. When we try to manually defer another line in the RC revenue process is running into no data found.

This issue is resolved.

Export Functionality in Revenue Contracts Tab Did Not Work

When we navigated to Workbench > Revenue contracts and searched for an RC, the results were displayed in the UI. But when exporting the results in an excel file, the customer Id was not able to export the results and an error message was displayed.

This issue is resolved.

Accounting Segment Issue 

When a Transfer Accounting Batch with RC ID was set as criteria and the batch was transferred, the schedules transferred and Post Batch ID was stamped to MJE tied schedules of RC. These were reflected in Review Summary and Review Detail of the Transfer Accounting Batch.

This issue is resolved.

When a Role Is Not Defined For a Responsibility

When a role was not defined for a responsibility in Revpro, the system assigned Super User privileges to that responsibility. This was a major security issue.

This issue is resolved.

Revenue Summary Tab Did Not Populated

Values were not displayed in the Revenue Summary tab. It was not available in the UI but only available in the backend.

This issue is resolved in Revenue Summary Page.

Accounting Tab at the Line Level Was Blank

The accounting tab at the line level was empty after we applied 3.4.2.0 patch for all RCs.

This issue is resolved in Accounting Tab.

New POB Within SSP

For a new POB within SSP, the Create and Close options did not work.

This issue is resolved in the RC Collect API.

Contract Mod Rule 'New POB Within SSP Range for New RC' Triggered But the INV Lines Were in Old and New RC

The INV line loaded with SO lines (Subscription & Implementation) where the subscription line triggered was 'New POB within SSP - New RC' rule. Both of the SO lines went to the new RC but the INV line instead of going to the new RC, was shown up in both New RC and Original RC.

This issue is resolved in the RC Collect API.

Enhancement on Soft-Freeze Check

This issue was about the soft-freeze check on the jobs during month-end. If the job did not allow to run during period close, an error message was displayed. And if that job happened to be scheduled to run at a regular interval, it was not scheduling again.

This issue is resolved in Job Scheduler API. The logic of soft-freeze had is changed. When the job is scheduled, the execute_job selects the job status in P (Pending) for execution. You can modify the query to only pick up the records that are ready to be executed. Add the condition of check_soft_freeze () such that it will only pick the records, which are allowed to run. The idea is to continue jobs, which are allowed to run and keep others in pending state, if not allowed to run.

CM-R Offset Different MR Ghost Line

CM-R offset different MR ghost line and updated doc_line_id, item_num, and few fields instead of the original ghost line linked to the respective MR line.  

This issue is resolved.

Audit Issue With POB Assignment by Attributes

The following error message was displayed when collecting POB that was assigned based on Attribute setup:

"Error : ORA-06553: PLS-306: Wrong number or types of arguments in call to 'GET_LABEL_COMBO'"

This issue is resolved in the Audit Trail API.

POB Immediate Program

The processed flag of the POB immediate program was not set to Y when release % went over 100%. Due to this, the program picked up these lines and released again causing additional revenue for 0$ lines. 

This issue is resolved in the POB Immediate Release API.

Period Open/Close Template

When a task had an error, and you skipped the task and moved to next task, Zuora RevPro allowed to move to next task but the status of the skipped task did not update as skipped.

This issue is resolved in Period Close/Open Page.

Role Privilege

The Data Augmentation Rule was not enabled but in Export. The invoice discount was on Full CM. In the Role privileges screen with Role privileges report, it was observed that discrepancy for Data Augmentation rule missed in UI.

This issue is resolved in Role Access Privilege Page.

Transfer Accounting

In Transfer accounting, the log did not display an error message when an error occurred. 

This issue is resolved in Role Access Privilege Page

Rec_Amt Got Doubled

Rec_Amt got doubled when Positive RORD line was collected twice. 

This issue is resolved in the RORD Process API.

Negative SO Update

Negative SO amount was updated from -2000 to 0 when the price was updated to -2000 with an invoice of -2000, but SO Sell price showed -4000. Revenue was released as 100% even though the revenue was set to release upon Event.

This issue is resolved in the RC Collect API.

Negative SO Line Cleared Def Amt

When a negative SO was released and there was a change in the start date of negative SO Line in modification period, if POB was set to Expiry, DEF_AMT was showed as zero and the immediate release program did not release.

This issue is resolved.

Duplicate POB Schedules Were Created

While creating user-defined POB schedules, duplicate entries were created.

This issue is resolved in User Defined Schedule Page.

Incorrect Cost Waterfall And Accounting Entries 

Incorrect Cost Waterfall and Accounting Entries were created when the contract was updated (Price and Term Change).

This issue is resolved.

RORD with Cancel Flag Could Not Set To Zero

RORD with cancel flag did not set the Sell Price and List Price for RORD to zero.

This issue is resolved in the RC Collect API.

Issue In the SO Cancelation

The SO Cancelation did not work for Negative SO line. 

This issue is resolved in the RC Collect API.

Revpro Home Page Issue

With the current configuration, logo on non-prod instance was removed after refreshing to differentiate prod and non-prod instances.

This issue is resolved.

Transfer Accounting Wrapper Program Should Not Be Mandatory

Transfer accounting wrapper program parameter was defined as mandatory but it should not be a mandatory parameter. 

This issue is resolved in Transfer Accounting API.

SSP Template Error

You could make any changes in the SSP template if any batches existed in the template. 

This issue is resolved in SSP Template page.

Run Gather Stat Log To be Updated In the Log Table  

No log was created in the log table when running the gather statistics performed or not on the two staging table.

This issue is resolved.

Data Query Utility Was Not Available For Super User

The Data Query Utility menu was not available even after enabling the Data query Utility for the Revpro super user role.

This issue is resolved.

Issue About Goods and Service with Multiple Rule Condition

When five SO Lines were collected with Product Family as QA_HW, all the lines were grouped under the same POB but the POB Name was blank.

This issue is resolved.

Cost Schedules Were Created With Revenue Schedules ID

When a bundle template was created with the item number as criteria, and the bundle was collected for one parent and two child lines in the following ratio:

  • Parent - 10%
  • Child 1- 40%
  • Child 2 - 50%

The two bundle SO lines were collected based upon the POB- Upon booking. The bundle was split and schedules were updated. The full invoice was collected for the two lines and full CM-C for the second SO line in the same batch. Bld amt for the first SO line was updated as expected but the second SO line reversal schedules were created for revenue and cost. Bld rec amt for the second SO line was removed as expected in LN_cost table and Bld rec amt was updated as zero for the second SO line. No deferred amount was populated. In revenue line, cost schedules were created but cost schedules were created in revenue line ID.

This issue is resolved.

Catch Up Cost Issue

The batch collection showed a warning message when updating SO and a new SO line was collected in the same batch for bundle scenario.

This issue is resolved.

Bundle With Full CM-R With Cost- Def Amount Was Available

A bundle was created for 1-parent and 2-child lines (P1-10%, c1-40%, c2-50%) based upon the criteria item number. Collect the bundle for 1-parent and 2-child lines, and bundle cfg was valid till 31-07-2012. Same bundle configuration was collected with bundle valid from 01-08-2012. The current open period was July-12. 2 bundle SO, Full invoice lines with cost amt based upon the POB - Upon booking contract ratable was collected. Full CM-R with RSD 1/08/2012  (cost amt in -ve) in same batch was also collected. Rec amt, allocated, and allocatable gets updated as expected. Reversal schedules were created and Def amt is populated in LN_COST table for the first SO line. Though cost released was 1000, cost capitalized was populated as 1500.

This issue is resolved.

Incorrect Waterfall

Incorrect values were found in the waterfall when a SO update happened for the price reduction.

This issue is resolved.

SO Bundle Split

When the SO was modified, it should follow the existing SO lines bundle configuration.

This issue is resolved.

Rebill Not Updated For Child Lines

The overstated invoice was created and REC_AMT was updated with a higher value for parents line instead of zero in Line table. In Line table, REC_AMT was updated with zero for child lines instead of the actual value. 

This issue is resolved.

Cost Waterfall Issue

The standard cost did not follow the revenue and if there was a change in the term for the updated SO, it was not reflected in the Cost Waterfall.

This issue is resolved.

Release Percent Not Updated For Zero Dollar Lines

Release Percent did not update on Zero dollar lines upon release. Entries were created in schedules and rpro_rc_pob_act_g, but rel_pct was still zero in rpro_rc_line_g.

This issue is resolved.

SSO Enhancement

PTC was raising an issue to create the Revpro user without removing the domain name. For example, they want the username in Zuora RevPro to be "<user_a>@domain.com" instead of just <user_a>, since they would have users with the same prefix. But with different domain names as part of their email and it became easy to provision a user in their system and gained access to an already existing user.

This issue is resolved.

Version Layouts Showing Wrong Amounts

When you run the version comparison layout in the workbench, all the amounts sometimes were incorrect.

This issue is resolved.

POB Level Holds Disappeared

POB level holds disappeared after linking or delinking to a new RC.

This issue is resolved.

Schedules Issue

Schedules were created with three decimals for RORD line and it showed as negative 0$ in the UI waterfall even though the transaction currency was USD.

This issue is resolved.

User Defined Schedules With Updated SO Unreleased Contract value

Revenue was not released due to the invoice was not collected.

This issue is resolved.

Holds Not Reassigned While Linking/Delinking

After creating a manual RC, holds did not apply at the line level although the holds were applied prior to the creation of manual RC. Available Holds should be retained even after the creation of manual RC.

This issue is resolved.

Data Query Utility

Data Query Utility menu was not available even after enabling the Data Query Utility for the Revpro super user role.

This issue is resolved.

Accounting Segments Column Size Issue

Accounting segment columns are not of the same size.

This issue is resolved.

Workaround To Release Revenue Manually

When a POB is consolidated and if it has two lines, the revenue is released 100%. The lead line is canceled fully during the revision period and a new line is added in the same POB. Revenue did not get released for the new line and the system did not allow manual release as the status of POB was Fully Recognized. 

This issue is resolved.

Unbilled Conversion Did Not Happen For Cost Schedules

Deferral entries were not reversed ratably. Deferral for cost did not happen for the amount that was not billed during unbilled conversion. Part of the reversal for the deferred revenue happened in the current month even though the deferral exceeded the available revenue in the concerned period.

This issue is resolved.

Zero Dollar Release Period

For a 0$ EXT Sell Price line, revenue actions details were incorrect. The Release period was in the prior period and not in the revenue period.

This issue is resolved.

Manual-JE Details Did Not Satisfy Approval Rule Criteria

When Submit Approval was selected in MJE, the status changed to Approval Canceled and you could not proceed further due to no approval rule criteria were defined. CM with Cost Ln Cost with Def did not update correctly.

This issue is resolved.

Zero Dollar Lead Line Followed Ratable When POB Was Contract Ratable

Even though the POB was based on Contract Ratable, the Zero Dollar Line, which was Lead Line followed the Ratable and the Non-Lead Line Line#1 followed the POB Contract Ratable method.

This issue is resolved.

Holds Not Assigned For Manual RC

After creating a manual RC, holds did not apply at the line level although the holds were applied prior to the creation of manual RC. The available Holds should be retained even after the creation of manual RC.

This issue is resolved.

Revenue Liability Entry 

After SO updated, revenue liability entry was created with the unbill account segments. Since release by percent system deferred the revenue, the deferred schedules for liability entry unbill account segments were updated.

This issue is resolved.

REF_RC_ID 

REF_RC_ID was not stamped as part of Contract Modification.

This issue is resolved.

Rep ID For MJE Flag

Rep ID for MJE Flag in RPRO_REP_FIELD_G table is updated. 

Revenue Did Not Defer After Unbilled Reversal

When Invoice was brought after SO release, the deferral did not happen.

This issue is resolved.

Partially Billed $0 Line Having Carve In

In an RC, SO line ID was only 75% billed (3 quantities of 4 ordered). It was a $0 line and due to other system issues, the system released 100% of the carve in. While deferring 25% of the POB, only 75% of the carve in should be recognized. But the system did not allow to defer partially billed $0 line having carve in.

This issue is resolved.

RC Batch In WARNING Status 

When an RC Batch went into WARNING status, while right-clicking, the system did not give the Reallocate Batch option. You should be able to reallocate even if the batch ended with a warning as it successfully collected data using that batch.

This issue is resolved.

Other Cost Release Issue

When a line was created with two other cost release with an event, if any one of the cost events was collected then both the costs were released. In consolidated POB, child cost event was not processed after running event release process job.

This issue is resolved.

Compute Rev Pct Issue

After an SO update, the increased incorrect amount was created with the wrong segment details.

This issue is resolved.

Rel_Pct Calculated Incorrectly 

When overstated invoice was collected for pob-upon_booking or upon_billing, then rel_pct was calculated incorrectly.

This issue is resolved.

RORD Followed By Overstated Invoice Did Not Work

When overstated INV was collected after collecting RORD, then the corresponding changes were not reflected in RPRO_RC_LINE_G.

This issue is resolved.

Netting Entries Incorrect

Netting entry credited CA with a different amount due to the reverse calculation. So the CA amount was negative and CL amount was doubled up after the netting entry.  

This issue is resolved.

Unbill Reversal For Cost Was Incorrect

The unbilled reversal happened for invoices with zero cost. So bld def and bld rec are updated incorrectly.

This issue is resolved.

Netting Entries Posting

Netting entries were not selected for posting and you were unable to transfer the netting line.

This issue is resolved.

RORD Update Did Not Update Attribute Columns

Very few attributes were only updated with the latest RORD records. For example, Batch ID was updated but many attributes were not updated with the latest records.

This issue is resolved.

Invoice Qty Were Not Updated For CM-C and CM-Cancellation

While collecting CM-C and CM-Cancellation for the invoice in the same batch, Billec Rec and Def were updated as expected but the Inv Qty was updated as zero.

This issue is resolved.

Missing Details In SSP Stratification Report

If SSP stratification report had many new columns when the Submit Download option was used, the number sign (#) was displayed in several columns including SSP tmpl above mid pct, SSP tmpl below mid pct, SSP Batch Compliance Pct, and SSP Batch Grp Line in Grp.

This issue is resolved.

Unreleased POB Report

Unreleased POBs Report ended with an error message. Alias name was missed in the report query. Table alias name was not found in the highlighted column in the report query. The Rel Pct column was available in RPRO_RC_LINE_G and RPRO_LN_COST_G tables.

This issue is resolved.

Retrospective Allocation

The retrospective allocation was triggered initially even if the new POB rule was set as Prospective.

This issue is resolved.

Release 3.4.2.0

The release 3.4.2.0 of Zuora RevPro includes the following new features, enhancements, and resolved issues.

New Features

Ability to Submit Reports from the Period Close Screen 

You can now launch month-end related reports, which are specific to closing process at the time of period close or prior to this release. You have to move out of the screen, submit the report, validate the data and then come back into the period close screen to move to the next step of the process. This helps you from navigating to multiple screens and multiple steps to perform a specific task.

The following areas have been enhanced:

  • Task Definition UI
  • Period Close/Open UI
Task Definition UI

When you log in to RevPro and navigate to the New Task screen, you can see a new drop-down value under the Task Type field.
New Task Screen1.png

Select Reporting from the Report/Job Name list, under activity type field, system Category Type and Report Name.

New Task Category2.png

Upon selecting the category from the Category list, RevPro filters the report name.

New Task Report Job Name3.png

Period Close/Open Launch UI

Once the period close task template is assigned to a book or org, which has the reporting task associated, it will be displayed on the launch screen, as shown in the figure below.
Period Status4.png

Click on Action Type, and select the Initiate Task option and the Submit Report context menu action.

Period Status Submit 5.png

Upon selecting Submit Report, a window is displayed with the respective report parameters.

Submit Download6.png

When the report is submitted through the Period Close/Open process, the data is available through Submit download. When clicking Submit Download, the report output is generated as a file.

Enhancements

Remove Dependency On the Link Identifier to Process MR Lines That are Not Linked to Any Specific Transactions

Prior to this release, to process Material Rights, when a transaction was interfaced to RevPro, you must provide the link identifier value to identify the MR line. The MR line was referencing to a specific transaction in RevPro. This might not be applicable to various business. So as part of this release, MR functionality has been enhanced to remove the dependency, where going forward a link identifier value need not be populated to process the MR.

Support Comparing Values Between Fields on Mass Action Criteria Screen

You can now define the criteria for comparing two columns on a transaction on the Mass Action Criteria Screen. Previously, this was limited to where the criteria can only be defined to compare a value with a specific field.

Field Name Operator Operand
ATR1 = 'XYZ'

If we need to compare two fields on the transaction, then it is not possible. So it is recommended to add another field next to the Field to Compare With operand field and enable this field on the criteria screen for the >, <, <=, >=, <>, = operators.

You can either enter the operand or field to compare with, but you cannot have both the values available. RevPro needs to validate and displays at the time of creating the criteria.

The Criteria UI is enhanced to support the new requirement, a new column is added to the Field to Compare With page.
New Batch7.png

Enhancement of Job Status UI

The background jobs can now be launched from the Schedule Jobs menu option. The Job Status screen is enhanced to color code the jobs that in the error, warning, and completed successfully statuses. This enhancement provides you the additional visibility on the status checks:

  • Error Status displayed as Red
  • Warning Status displayed as Yellow
  • Incompatible displayed as Yellow

Job Group8.png

Support Audit Requirement on Accounting Setup Screen

You can now keep track when users unfreeze and freeze the accounting setup on the Accounting Setup Screen. This is a critical action upon unfreezing. RevPro allows you to change the accounting configuration from the audit standpoint. It is important to track who and when performed this action. This action will be made available in the audit trail report.

Applicatiion Setups9.png
 

New SSP Derivation Methods to Support Prospective Allocation  

Additional methods to derive SSP date is introduced in this release. You can now choose the following methods to indicate how to derive the SSP date for prospective allocation:

  • Revision Period Date - The date is derived based on the RC Modified Period/Quarter. If it is RC Modified Period, then use the first day of RC Modified Period. If it is RC Modified Quarter, then use the first day of the RC Modified Quarter.
  • Line Level Contract Modification Date – If a user provides a value in CT_MOD_DATE on the line, then that date is considered for the Derivation of Date. Otherwise, RevPro considers the first day of the revision period.
  • RC Level Contract Modification Date – RevPro uses the CT_MOD_DATE of the line, which is triggering the contract modification and uses the same date on all the lines. If multiple lines are triggering the contract mod, RevPro uses the MIN of CT_MOD_DATE. If the dates are not available, then use the first day of the revision period.

Contract Mod10.png

These new methods are added to the Derive SSP/RSSP Date under the Revision Timeline section.

Resolved Issues

MJE Transfer Accounting Issue

No records were transferred during MJE transferring accountings. But in the schedule table, it was generating the post batch ID for MJEs. Whereas those lines were not found in Transfer Batch/Accounting Report or GL Interface table.

This issue is resolved in Transfer Accounting API.

Negative SO Lines Within FV Range Calculation is Incorrect

For negative SO lines (Quantity Ord -Ve), FV price was uploaded as a positive value since Qty was -Ve. The price that was below fmv price and above fmv price was calculated as -Ve.

To verify whether the lines are within the range or out of the range, RevPro used the formula Altcbl between Below Fv and Above Fv. A line should be within fv range. But the system calculated out of range as -80 that was greater than -100.

This issue is resolved in SSP Allocation API.

SO Full Cancelation Should not Trigger Price Change Contract Modification Rule

If a price was changed, the contract modification rule was getting triggered when a SO is fully canceled. 

This issue is resolved in Contract Modification API.

Zero Dollar Line Getting Released in Both SO and Invoice for Quantity Based Event
VC Issues 

If you collected $0 SO line with ten ordered quantity and $0 Invoice line with two ordered quantity, the revenue was released by quantity based the event with two ordered quantity. The schedules was created from both the SO and invoice.

This issue is resolved in Revenue Process API.

Errors Occurred While Creating LT ST Reclass in General Motors Instance

The following errors occurred when creating LT ST reclass in general motors instances:

  • At line 253 RR1 to RRL, alias and in grouping clause should be changed.
  • Schedule type flag in IN CLAUSE quotes was missing.
  • The rrl.lt_def_cogs_acct column was missing.
  • Grouping columns RLC should be added instead of rrl (lt def account).
  • Using clause should contain four parameters instead two parameters to the below query:

    OPEN CUR_LTST_DATA FOR L_SQL_STMT USING L_LONG_PRD_ID,P_BOOK_ID;

This issue is resolved in LT/ST API.

Revenue Recognition Issue

The revenue was recognized automatically after an invoice got processed in the second period even though no release event was sent. The lines were in the schedules, but no details in the POB Actions table.

This issue is resolved in RC Collect and Revenue Treatment API.

Accounting Detail Report Missing Adjustment Liability Entries for Some Lines
Period Close Template Issue

For few RC Lines, adjustment liabilities were not displaying in the accounting detail report even though that entry was showing as posted in schedules table. 

This issue is resolved in Revenue Process API.

Conversion Waterfall API Issue

The current conversion waterfall was processing all the schedules even if the amount was zero. This needed to be validated and Zuora RevPro should create a waterfall when there was only the schedule amount. The system was also set the start and end dates as waterfall start and end dates instead of the entries where the amount is <> 0.  

This issue is resolved in Conversion Waterfall API.

Incorrect Allocation Entries While De-linking and Linking Using Custom Code

The incorrect allocation entries were created while de-linking and linking using the custom code.

This issue is resolved in RC Manual Actions API.

Bundle Explosion Issue

When CM-R and INV were collected in the same batch, the Ext_Sell_Price got doubled. Also, the SO and INV were collected in the same batch to the existing SO lines.

This issue is resolved in RC Collect API.

Ext_Sell_Price Should Not be Doubled

When SO and INV were collected in the same batch to the existing SO lines, Ext_Sell_Price got doubled.

This issue is resolved in RC Collect API.

Accounting Segments Got Corrupted in the Revision Period

During the revision period, the accounting segments got corrupted. 

This issue is resolved in Revenue Treatment API.

SSP Stratification Report Has Incorrect Compliance Values

SSP Stratification Report did not show SSP Percent, Above SSP Percent, and Below SSP Percent details.

This issue is resolved in SSP Stratification Report.

Unreleased Contract Value on Impairment Current Issue

On a multi-currency allocation, after setting impairment type to 1, the line level exchange rate was used instead of the allocation exchange rate, due to which the system showed up unreleased contract value. This was because the accounting was correct but WB displayed all the details in the functional currency and the incorrect rate was displayed.

This issue is resolved in Impairment API.

Impairment Entries Issue 

Impairment entries were not created if the RC was having two Impairment lines.

This issue is resolved in Impairment API.

For Multi-Currency RC Issue

For multi-currency RC, the Impairment entries were created wrongly and the accounting details adjustments currency was also incorrect.

This issue is resolved in SSP Allocation API.

Export Utility Issue

In Export Utility, the maximum row count for report grids was increased from 500 to 10000

This issue is resolved in all tabular grids in the Workbench by increasing the export limit to 10k.

Cost Accounting Segments Became Null While Sending a SO Update

While submitting a SO update, the cost accounting segments became null.

This issue is resolved in Revenue Process & RC Collect API.

MJE Tied to RC Line Amount And Schedules Not Matched

While creating an MJE with waterfall template without linking to any RC ID, schedules were not getting created and it did not match the line amount.

This issue is resolved in MJE API.

Credit Memo Collected for Time Based Lines After Period Close Showed Unreasonable Amount in for Adjustments Accounting Entries

When the Sales Order and invoice has been collected in one period and the revenue has been recognized in the same period, the transfer posting was completed for that period. The current period was closed and the new period was opened. Credit memo for time-based line got collected in a new period. Adjustment entries showed the incorrect amount for time-based lines. The waterfall was correct but the amount could not be justified.  

This issue is resolved in Allocation Accounting Entries API.

Unable to Release Revenue With Negative Amount After SO Update

When a SO was created with negative value and then a SO update was made with SO price increasing from the amount of the SO.

The sequence of uploading is as follows:

  1. TSYS Incentives ASO
  2. TSYS Incentives ASOUpd - SO value increased from -100K to -200K

With the negative SO amount, when we bring in SO update, Zuora RevPro is marking the release pct as 100% and unreleased revenue to 0.

This issue is resolved in Revenue Process API.

The Sweep Unposted schedules Program was Completing With Error

The Sweep Unposted schedules program was completing with an error message. The summarize should call each RC ID instead of bulk.

This issue is resolved in Sweep Process API.

Bundle Configuration Expects Item Num When It is Not a Bundle Criteria and Bundle Criteria Has to be Populated for Child Lines

The Sweep Unposted schedules program is completing with an error message.

This issue is resolved in Bundle Explosion and File Upload API.

Unable to Freeze the Accounting Setup in Revpro 3.3.5.3

Not able to freeze the Accounting Setup before performing setup related activities.

This issue is now fixed on the Accounting Setup page.

Reporting UI Rendering After Disabling Seed Layout

When any of the seed layouts was disabled, the report page was displayed with all the filters and layout fields as blank.  

This issue is resolved in Reporting Framework API.

Transfer Account Task Submitted From Period Close Template Requires Space in Parameters

The Transfer Account task run without any issues when it was accessed from Schedule Jobs. But while running the same task using the period close template, space should be provided in the program parameters. 

This issue is resolved in Period Close Launch page.

Ducommun Instance

The collected Updated SO has increased in standard cost and Ext_Sell-Prc. Initially reported issue that was zero for BLD_DEF_AMT and BLD_REC_AMT in ln_cost was now updated with an amount. In LN Cost BLD_REC_AMT was not updated as per the Event Release for Revenue Released for Invoice.

This issue is resolved in RC Collect API.

Cost Update not Working for Ducommun Instance

Cost Released Percent did not follow the revenue release percent in all periods. It allocated the lesser percent of released cost amount in all period and the balance was adjusted in last month.

This issue is resolved in RC Collect & Revenue Process API.

Fully Returned Order was Having CV

When the updated RORD collected for the transaction that already has the complete, RORD was getting the CV Amount and also the RORD contract AR entries were deleted.

This issue is resolved in Reduction Order API.

Unreleased Contract Value 

When a complete RORD for a line with Type 1 impairment was collected, the impairment was not triggered and duplicate initial entries were not created for the new carves.

This issue is resolved in Impairment API.

CM-R brought after CM-R Cancelation For the Same Line was not Working

Initial entry and schedules were created for Invoice and Initial entry reversal and reversal schedules were created for CM-R. While collecting CM-R cancelation in batch 2, initial entry was created but schedules were not created for any of the lines and Def, Rec, Billed Def and Rec and Allctble were Zero.

This issue is resolved in RC Collect API.

Removed CV AMOUNT = 0 Check on Transfer Accounting in Prospective Case

For impairment RC in prospective allocation, the CV would not net to 0 in RC line. Due to the transfer accounting check, these RCs were placed on hold. As there was already check on initial reporting entries of allocations, the hold should be placed.

This issue is resolved in Transfer Accounting API.

Increased Key Attribute Column Length in rpro_ln_event_g Table

The key_atr columns length was 50. The Sales Order Line ID was greater than 50 for ZoZ. Table column length should be increased.

This issue is resolved in data model change to increase the length of the columns.

Material Rights Columns Populated With Wrong Amounts

The following columns were populated for material rights:

  • rec_amt
  • def_amt
  • bld_def_amt
  • bld_rec_amt
  • unit_sll_price
  • rel_pct

As Rel_pct was copied as 100%, the lines were not getting released.

This issue is resolved in Material Rights API.

Whole Order has been through Complete INV, RORD, CMRO.  

Whole order has been been through complete RORD and CMRO, but still was balance found in the Contract Liability.  

This issue is resolved in Reduction Order API.

RevPro Cost Entries for SO Update

If the event was cross-referenced with the accounting detail, only half of the cost amount per the invoice was released. Once again if we cross-referenced the SO update with the accounting detail, it reversed the COGS but then left no COGS amount booked and there was no COGS entry.

This issue is resolved in RC Collect API.

CDW Segment Issue

If you bring in an SO, then INV and then CM-C, the account assignments for COGS and DCOGS were getting flipped.

This issue is resolved in Revenue Process API.

RORD Issue

For $0 line (Prospective RC), if we bring $0 partial RORD then we are not able to reallocate or Unfreeze RC.

This issue is resolved in Reduction Order API.

Cost issue about Capitalization upon booking.

Some part of the updated revenue stayed in def (reported already) even though the POB was released. Upon Booking, cost followed the same but the def and rec did not sum up to the total updated Cost amount. The Standard cost update for Line 1 was updated in Cost amount, but the REC amount was not equal to the updated amount. 

This issue is resolved in Cost Accounting API.

The Run Report Role Privilege Tree was Having Inconsistent Behavior  

The following inconsistent behaviors occurred for Run Report Role privilege tree:

  • Roles and Privileges - Role Privilege Tree Run Report was showing inconsistent behavior:
    • It was working as expected only in the SYSADMIN role.
    • Custom Created Roles were showing inconsistent Behavior.
  • SSP Upload Batch End Date could still be updated even though the SSP upload had Read Only Access.

This issue is resolved in Role Privilege Report.

Allocation Entries not Created

For prospective RC, $0 line rc_version was not stamping correctly in schedules, because of this the allocation entries were not created.

This issue is resolved in RC Collect API.

Contract Modification was not Triggering to Retrospective 

Contract Modification was not triggering to Retrospective when the price and term got decreased in the SO update and even though the line is 0% released. The Term was showing correctly in the rpro_rc_line_g table. But in the UI, its got rounded off.

This issue is resolved in Contract Modification API.

Export from Holds Section in the Daily Dashboard is Incomplete

The export option in the Holds section in the Daily Dashboard listed the pending holds in an excel format but it exported only 501 rows. If a line in RC had more than one hold, it was not shown in the exported excel.

This issue is resolved in Daily Dashboard screen.

Unfreeze Issue

UI was not allowed to select the Unfreeze or Freeze. Other options like Retain Allocation Method/Switch Allocation Method was not found. When SO, INV & CM-R on attribute based SSP(Populate NUM filed column) was collected, and while unfreezing, the carves, and allocated amount were incorrect.

This issue is resolved in RC Collect API.

Credit Memo and Credit Memo Cancelation Collected Together was not Working

Credit Memo and Credit Memo Cancelation collected together was creating negative unreleased amount on the RC ID even though the revenue of the contract was completely recognized.

This issue is resolved in RC Collect API

CM-R Cancelation Issue

CM-R Cancelation was not displayed on the Billing Tab (bottom screen) UI when a line was selected.

This issue is resolved in Transaction Workbench Page.

To add the Invoice Line ID column to the Billing Report

Invoice Line ID column was missing on the Billing Report. This had to be included.

This issue is resolved in Billing Report

Posted RC Issue

For a posted RC, if partial INV was brought, the system was creating duplicate allocation entries.

This issue is resolved in SSP Allocation API.

RORD Reversal schedules Issue

RORD schedules were created only for Liability account even if it was an unbilled SO.

This issue is resolved in Revenue Process API.

Export Getting System Error for Summary level Accounting

Navigated to Workbench and filter based on the RC_ID, Revenue Contract under Accounting tab, when Export button was accessed, it threw a system error.

This issue is resolved in Accounting Summary page of RC Workbench.

The Review Summary View on Transfer Batches

The Review Summary view on transferring batches was not summarizing.

This issue is resolved in Review Summary Page of Accounting Transfer Batch.

Correct Lookup Seed issue

When a Line for which Forecast was generated and de-linked, the system was still retaining the forecast for the De-linked line.

This issue is resolved in Seed Data.

Data Query Utility Issue

When Reports > Data Query Utility was accessed, the system displays the following error:

"A System Error Occurred During Processing. Contact RevPro Administrator."

This issue is resolved in Data Query Page.

Cumulative percentage based events

Cumulative percentage based events were not getting processed for SO lines having sell price as 0 even though SO lines had carve in amounts on them.

This issue is resolved in Event Process & Revenue Process API.

Period Close Template Issue

Period Open/Close Templates Task for Report was allowing to submit without initiating the task and allowing to proceed to next task.

This issue is resolved in Period Closure API.

Mass Action Batch Creation Period was Wrong

The CRTD_PRD_ID for mass action batch was getting stamped incorrectly. Instead of stamping it with the current open period, it was populated with information based on batch creation date.

This issue is resolved in Mass Action API.

Update on Unbundled Line was not Updating Child Line

If there is an update coming in to a Bundle line, it was not un-bundling again to update the information on the child lines. It was updating the parent line only.

This issue is resolved in RC Collect API.

Negative SO Issue with Event Release  

When the SO amount was negative amt, and when there was an update, the system aws marking release pct as  100% and unreleased revenue to 0.

This issue is resolved in Revenue Process API.

Cost Update With Retain by Percent Issue

Cost Update with retaining by percent was not working as expected.

This issue is resolved in Revenue Process API.

Credit Rebill Issue

Credit Rebill issue in occurring in bundles.

This issue is resolved in Bundle Explosion API.

Added Alias to Allocated Release Amount Field In Label and Rep Fields

Added alias to Allocated Release Amount label (Derived Column). Currently, due to the missing alias (rrl) for allocated release amount, the users were not able to see any data in the downloaded file of transactions workbench.  Also, the Unreleased POB(s) By Name report has also been reported by PS team that there are errors. This was because the column ambiguously defined error in the same column.

This issue is resolved in UnReleased POB Report.

System Error While Running Unreleased POB Report

Following error message appeared while running the Unreleased POB Report.

"A system Error Occurred During Processing. Contact RevPro Administrator."

This issue is resolved in UnReleased POB Report.

SSP Stratification Report Did not Show SSP Percent Details

SSP Stratification Report did not show SSP Percent, Above SSP Percent, and Below SSP Percent details.

This issue is resolved in SSP Stratification Report.

Hold not Applied While Updating SO 

When revenue is released partially, hold is not getting applied while updating an SO.

This issue is resolved in Holds Process API.

Exclude Ghost lines to calculate sell_amt in RC Header table

Sell_amt in rpro_rc_head_g is including ghost lines ext_sll_prc and this is causing issues for large contract value holds. Even if the contract value is less than threshold value of the hold, RC is kept on hold due to inclusion of ghost lines.

This issue is resolved in RC Workbench API

Add RC Line and Bill Fields to the On Hold Accounting Report

Available fields in the On Hold Accounting Report is not valid. Add RC line and Bill fields in the report.

This issue is resolved in On Hold Accounting Report fixed.

Role Privilege Report Differs from Role Privilege Tree in UI

In the Role Privilege Report, "Role Privilege" column does not match Role Privilege Tree in UI. There are additional lines that exist in the report, but those lines are not available in the UI. Roles and Privileges report includes the sub menu, "Netting Process" but this menu does not exist in the UI
This issue is resolved in Role Privilege Report.

Revenue Share Account Derivation

The accounts segments has to be derived based on the setups in Revenue Distribution.

This issue is resolved in Revenue Process API

Cost is Released Immediately not Following Ratable Method

Auto cost is applied for all the lines and they are only capitalized but not released. Revenue for all lines are scheduled immediately in the open period. Collect event for the cost lines are without dates. Cost is released 80% in the immediate period and not following ratable per line/ln_cost date.

This issue is resolved in Revenue Process API.

Forecast is Getting Generated for De-link Lines Also in an RC

When a Line for which Forecast is generated is de-linked, system is still retaining the Forecast for the De-linked line.

This issue is resolved in Forecast API.

Rounding Issue in User Defined Schedules  

When the Ext Sell Price is brought for User Defined Schedules, in the schedules, the price has 3 decimals instead of 2 decimals.

This issue is resolved in Revenue Process API.

Capitalized Cost Does not Match the Initial Entry for COST.

Cost recognition is not matching to the total Initial entry created. We have a scenarios where the Cost was for 140.4 brought in as part of SO and INV. However the Transaction currency is JPY and the Cost currency is USD. Cost is setup to follow Revenue. When the Cost is recognized, we are seeing the schedule is created as 140 dollars only. The 0.4 is missing. 
This issue is resolved in RC Collect & Revenue Process API.

Initial Entry Incorrectly Created When CM-C Brought After RORD

When CM-C is collected after RORD, the schedules are created for the full SO/INV amount instead of reducing the RORD amount from SO/INV amount.

This issue is resolved in RC Collect & Revenue Process API.

Event Release Through QTY not Updating History With Processed QTY

For over usage events, the events history table is not populating rel_qty correctly. 

This issue is resolved in Event Process API.

Pre-requisites and System Requirements

The minimum patch level that is required to apply this patch are given below:

Patch # 3.4.1.0
Build #    3410
Combo Build 34102497
Patch Type Incremental
Released Date 02/Nov/2017


Upgrade Path

Zuora RevPro being a product offering will be maintained in terms of bug fixes and feature/functionality additions on an ongoing basis. These are delivered to the customers in the form of support packs. These Support packs will be available for the customers in their own Zuora customer portals provided. Customers need to login into their own portal and download the patches for installing it.

Testing Strategy Recommendations 

In any upgrade situations, Zuora recommends installing the Support packs in a Test or a QA instance and identify the impact of the patches from a business process perspective and only then transport to Production instance.

Other Impacts

No other impacts identified in the patch.

Release 3.4.1.0

The release 3.4.1.0 of Zuora RevPro includes the following new features, enhancements, and resolved issues.

New Features

Data Query Utility

This is a new feature in form of utility being introduced where customers or partners can run basic queries to query the data from the tables, instead of logging to the database, which is not practical to provide backend access specifically on Cloud to the partners, which may be a compliance issue.

This is a simple utility which helps with taking input as a query and displays the result set in the grid.

one.png

Upon selecting the Data Query Utility, user interface opens with the following tabs.

Query Data

In this tab, you can enter the query and execute the same to get the result set.two.png

Saved Querythree.png

Enter a valid name for the query.four.png

All the queries that are saved will appear in the Saved Query drop down or in the tab Saved Query.five.png

Query Log

This tab captures all the queries entered in the Query Data window.six.png

Enhancements

Enhancement to POB Grouping When Lines Are Re-arranged 

Prior to this release, when any line moved from one POB to another POB manually within the RC, upon any change to the Revenue Contract, the system re-applies the POB rules, which leads to moving back the line to its original POB, as part of this release. If the line is moved manually, the system will mark such lines as manually moved and restrict the system from regrouping to avoid customers to identify those lines and again move them back to the POB where it is manually moved to.

Remove Beg CA/CL Columns From RC Rollforward Non-detailed Layouts 

Existing Revenue Contract Rollforward report has been enhanced to remove the specific columns such as Beginning CA/CL balance and Ending CA/CL balance for the standard layouts where the CL balance are displayed at the POB and account level.

At the POB and Account level, the system does not calculate the CA/CL balance.

Transfer Accounting Validation Taking Long Time

Transfer accounting process has been tuned to optimize the performance when launched for high volume customers, standard indexes have been created by identifying the areas, which caused the performance.

Enhancement to Period Close/Open Template

Existing Period Close/Open process has been enhanced.

Display Mandatory Parameters Checkbox for Programs

For this requirement, when a background job is launched from the Period Close/Open template, the Mandatory Flag check box is displayed against the parameter so that user is aware of the fact that it is a mandatory parameter, which needs to be entered.

Upon Creating a New Template Default Assign Tasks Order Changes in Close Template

When a new period close template is created, the system does not default the period close tasks in the sequence, which is recommended by the product. The sequence to be followed is the Earlier Recommended sequence when seeded in the standard close template is shown below:

Seq # Task Name
10 RevPro3.0  Sweep Unposted Schedules
20 RevPro3.0  Current Period Post Summarize Data
30 RevPro3.0 Netting Process
40 RevPro3.0 Accounting Transfer Master
50 RevPro3.0   Reporting Current Period Close

Also, the sequence will set with an increment of one, instead of incrementing it by one.

The new sequence to be followed is as follows:

Seq # Task Name
10 RevPro3.0 Netting Process
20 RevPro3.0 Accounting Transfer Master
30 RevPro3.0  Sweep Unposted Schedules
40 RevPro3.0  Current Period Post Summarize Data
50 RevPro3.0   Reporting Current Period Close
Ability to Resubmit the Job on Canceled Status

When the job is in canceled or terminated, RevPro provides the job resubmit option similar to Error status.

Job Submission Error

When the job is submitted again from the period close/open template, the system throws errors with too many rows, this issue is fixed as part of this enhancement.

Ability to Create an MJE That is Tied to an RC or Line

This is a major enhancement to the existing MJE process in the product. Prior to this release, customers can upload MJE into RevPro and post them to GL along with the revenue contract schedules. Based on your requirements that link the MJE being uploaded in RevPro to a specific Revenue Contract Line to adjust the balances, which were performed offline. RevPro has enhanced the MJE process and the following components are impacted due to this change.

MJE Batch Screen Enhanced

When the Download template is selected for MJE Type Waterfall ONLY, the system has to include the following columns in addition to what we have now:

  • Link To RC Id
  • Link to Sales Order Line Id
  • Linked to RC Line Id

The Link to RC Id and Link to Sales Order Line Id columns are mandatory. The existing table RPRO_JE_LINE_G is altered to capture the new fields. 

seven.png

JE Detail Screen Enhanced

Once MJE is uploaded, the system has to display the columns related to RC # and Sales Order Line Id in the JE screen.

eight.png

When the MJE is linked to RC and RC Line, the system will perform the unbalanced check at RC level and not at the line level, as part of this enhancement we have not taken up the change to have multi-currencies in the MJE file. After uploading the MJE and approval of MJE, schedules are created and linked to the Revenue Contract Line. The existing Revenue Contract Workbench has been enhanced to display the same.

Accounting Summary Screen (RC Level)

This screen is enhanced to display the MJE schedules, a new drop-down field is added to the screen where you can choose the method to display the MJE schedules associated with the Revenue Contract Line.

nine.png

  • Summarize Method: This option allows you to indicate the system how to display the MJE schedules.
  • All: When this option is selected, the system will display the regular revenue contract schedules and MJE schedules too. The amounts are not summarized between regular accounting entry which is system generated and manually uploaded. 

    In this option, when MJE schedules are displayed, they are referred back to the MJE Batch through which they were uploaded to avoid you to navigate back to the MJE screen for verification.

    ten.png

     

  • Include MJE Schedule: This option allows to include the MJE amount and summarizes based on the Accounting Type, Period, Currency, and Account Number. If the regular schedule and MJE schedule have the same combination value, the amounts are inclusive of MJE.
  • MJE Schedule Only: When this option is selected, the system will display only the accounting schedules related MJE. When this option is selected, this will point back to the MJE Batch through which the schedules were uploaded.

    eleven.png

  • Regular Schedules Only: When this option is selected, the system will display the regular revenue contract schedules excluding the MJE schedules.
Accounting Detail Screen (RC Level)

Similar to Accounting Summary, this screen is enhanced to display the MJE schedule. Options are the same.

twelve.png

  • Summarize Method: This option allows you to indicate the system how to display the MJE schedules.
  • All: When this option is selected, the system will display the regular revenue contract schedules and MJE schedules too. The amounts are not summarized between regular accounting entry, which is system generated and manually uploaded. In this option, when MJE schedules are displayed, they are referred back to the MJE Batch through which they were uploaded to avoid user to navigate back to the MJE screen for verification.

    thirteen.png

  • Include MJE Schedule: This option allows to include the MJE amount and summarizes based on the Accounting Type, Period, Currency, and Account Number. If regular schedule and MJE schedule has the same combination value, the amounts are inclusive of MJE.
  • MJE Schedule Only: When this option is selected, the system will display only the accounting schedules related MJE. When this option is selected, this will point back to the MJE Batch through which the schedules were uploaded.
  • Regular Schedules Only: When this option is selected, the system will display the regular revenue contract schedules excluding the MJE schedules.
Waterfall Tab Enhanced (RC Level)

The Waterfall tab is enhanced to include the MJE schedules.

fifteen.png

Reporting Changes

The following reports are enhanced to support the requirements:

  • Accounting Details Report
  • MJE Details Report
  • Waterfall Report

Resolved Issues

Allocation Not Happening When Unfreeze Done For Manual RC

When unfreeze option is selected on the type Manual Revenue Contract, the re-allocation is not triggered.

Code fix provided for Unfreeze API.

Schedules WERE Created As Ratable For Immediate POB When an Updated SO Came

When a upsell or downsell is performed for a POB whose ratable method is Immediate – Using Open Period, the system amortized the revenue ratably instead of booking it in the current open period.

Code fix provided for Revenue Process API.

CM Brought After CM Cancellation For the Same Line is Not Getting Collected

When a credit memo is interfaced to RevPro stage for a line after a Credit Memo cancellation, the system is not processing the new credit memo from the stage.

Code fix provided for RC Collect API.

System Not Creating Incorrect Accounting Entries For Prospective Change

When a prospective change is performed and ratable method is Immediate, the system amortized the amount over a period of time.

Code fix provided to Revenue Process API.

Partial Monthly Accounting Method For RORD

When RORD is processed, the system considered the accounting method as Daily by default though the accounting method on the POB is partial monthly.

Code fix provided Revenue Process API.

Incorrect Derivation of SSP For CM-R Causing Allocation Issue

When CM-R is processed, to determine whether the Line is within SSP range or not, the system is not considering the transaction price. Instead, sell price is considered due to which incorrect flagging happened, as part of CM-R sell price is not adjusted.

Code fix provided for FV Allocation API.

Events With Quantity Release Getting Processed For $0 Selling Price And $0 Allocated Price

The system released revenue for the lines where the contractual revenue is $0 and no carves existed.

Code fix provided to Event Process API.

Cost Release Not Align With Event Release

When cost is released independent of revenue, upon processing cost based event, the system did not consider the percent of release to release the cost.

Code fix provided for Revenue Process API.

Collection Went to Warning When Prospective Triggered During INV and CMC in the Same Batch

Data collection process is completed in warning when INV and CM-C were processed together which is a case of overage.

Code fix provided for RC Collect API.

Ext_Lst_Prc Not Populated Correctly For Overstated Order

When a CM-R is processed, the list price is adjusted. But when the invoice is processed which is an overstated order, the system did not update the list price.

Code fix provided for RC Collect API.

Collect SO and Overstated INV With Partial CM-R in the Same Batch

When a CM-R is processed, the list price is adjusted. But when the invoice is processed which is an overstated order, the system did not update the list price.

Code fix provided for RC Collect API.

COST REVERSAL RORD and CM-RO Issue

If RORD and CM-RO is processed reversing standard cost, when booking reversal entries, the system considered the account segments from the SO line instead of from the Cost Line.

Code fix provided for Reduction Order API.

Other Cost Not Following the Ratable Method Defined in the Cost Treatment of POB

When cost is independent of Revenue, the system did not consider the ratable method associated with cost type. Instead, the system considered the ratable method associated with the POB.

Code fix provided for Cost Processing API.

Un-released Contract Value

When impairment schedules were created due to prospective allocation and now a change in the revenue contract triggering retrospective, the system did not reverse the impairment schedules, due to which unreleased contract value is incorrect.

Code fix provided for FV Allocation API.

Link/Move Line is Not Updating RC POB ID on Schedules

When a line is moved from one pob to another pob, or delinked and linked to a new pob, the system did not update the POB ID in the Schedules with the latest pob value.

Code fix provided for RC Action API.

Not Able to Process Point in Time DEF Records For a Ratable Revenue Schedule

When a deferral event is interfaced with the start date and end date as the same period, the system did not defer the revenue for that specific period correctly.

Code fix provided for Revenue Process API.

Ext_Lst_Prc is Incorrect After Bringing CM-R Referencing Original_SO_Line_ID

When a CM-R is processed referencing to Sales Order Line and not to any invoice, list price is calculated as negative.

Code fix provided for RC Collect API.

Forecast Error ORA-01476: Divisor is Equal to Zero

Forecast process is completed in an unhandled exception.

Code fix provided for Forecast API.

Collection Fails When CM-R for 0$ SO Lines

Data collection process is failed when CM-R is processed for the SO Lines where the sell price is $0.

Code fix provided for RC Collect API.

Revenue Deferral Issue With Credit Rebill

When CM-C is processed and revenue is released upon billing, the system is not calculating the DEF amount correctly.

Code fix provided for Revenue Process API.

Allocatable Ext Price is Bumping After Reallocation in Prospective Treatment

The system increased the Allocatable Ext Price based on the unscheduled adjustment amount available for the line in case of perspective. When the reallocation is performed, it added up the same amount to the allocatable price.

Code fix provided for FV Allocation API.

SO Update Issues Without Financial Changes and Unreleased Revenue is a Negative Value

The issue occurred when a POB had multiple lines and a lead line is released 100% and one of the non-lead lines is a $0 line. When you brought the SO update to the $0 for an attribute, POB is retained % and the line had allocations.

Code fix provided for Revenue Process API.

Accounting Detail Layout Tab in Workbench is Throwing Error Eue to Ref RC ID

When selecting Ref RC ID in the Accounting Detail tab layout, the page is completed in error.

Code fix provided for Accounting Detail Page UI.

Adjustment Waterfall Amount Not Matching CV Amount In Line

Incorrect allocation entries created for the Line when manually released.

Code fix provided for Revenue Process API.

Data Collection Issue for Contract Modification Lines That Were Associated With SSP Template Based on Custom Attribute Fields (NUM1)

This fix addressed the issue where the SSP is calculated based on an attribute instead of the list price during contract modification. When a change is processed, data collection process is completed in warning.

Code fix provided for RC Collect API.

BI Views API Returning 1000 Rows Even Though Value is Set as 10000

Based on the profile the API returned the number of rows, even when the profile is set to 10000 system returning only 1000 rows per pull.

Code fix provided for BI3 API.

NCR(Multi - Org) Exception When Trying to Run the Transfer Accounting Master Job

Due to the incorrect setting of RevPro context, when the program is run for multi-org, the job is completed in error.

Code fix provided for Accounting Transfer API.

Forecast Waterfall Incorrect When the Ratable Method is Sliding

An incorrect forecast waterfall generated when the ratable method is selected as Sliding.

Code fix provided for Forecast API.

Relative Allocation Issue: List Price is 0 and SSP is Based on Sell Price

When SSP is based on Sell Price, where the list price is 0 and Sell price had a value, such lines were not participating in allocation.

Code fix provided for FV Allocation API.

$0 Line Allocation Schedules Release % Rounding Off is Incorrect 

When the percentage of allocation release is between 0 and 0.5, the system rounded it to 0 due to which incorrect release of revenue happening.

Code fix provided for Revenue Process API.

Creating New Profile to Restrict Overstated Invoice Amount

This profile option ALLOW_OVERSTATED_INVOICE is to restrict of updating Sell Price and Quantity through an overage invoice.

Code fix provided for RC Collect API.

Credit Memo Collected For Time Based Lines After Period Close Shows Weird And Unreasonable Amount in For Adjustments Accounting Entries

Sales order and invoice had been collected in one period 0052019. Revenue had been recognized in the same period. Transfer posting is completed for the period. The current period is closed and a new period is opened. Credit memo for the time-based line had been collected in the new period which is opened.  Adjustment entries showed some undesirable or unreasonable and weird amount for time-based lines. Through waterfall is not impacted because of this undesirable amount. Waterfall is still correct but the amount could not be justified. Overall contract value is 160K USD but accounting entries show 40 million USD. This issue is happened irrespective of whatever credit rule we used. We tried this on Fixed Duration and Prorate both.

Code fix provided for Revenue Process API.

EXT_LST_PRC is Becoming NULL When % Based FV is Based on ATR Fields

The system updated the ELP (Extended List Price) to zero when SSP is calculated based on Attribute fields.

Code fix provided for FV Allocation API.

Unable to Update Cost Def Segments/Cost Rev Segments From Inbound Screen

The system is not allowed to update the Cost Def and Cost Rev Segments from the Inbound User Interface.

Code fix provided for Inbound User Interface.

SSP Analyzer: Compliance Check Did Not Complete Even After 20 Hours

SSP Analysis led to a performance issue, certain queries taking a long time to execute.

Code fix provided for SSP Analysis API by providing hints.

Recognize the Threshold Unreleased Value With the Last Qty Release

An SO line with quantity 365 and sell price $4230.62 got processed and RC got created successfully.
The revenue is recognized by Qty on this RC. Even after releasing the total quantity is 365, there is a small dollar amount in the unreleased contract value ($1.33).

Code fix provided for Revenue Process API.

Incorrect Revenue Recognized When CM-R is Part of the RC

When CM-R is processed, the system did not calculate the total revenue recognized which is Revenie To Dat correctly.

Code fix provided for Revenue Process API.

Report Downloads: an Extra Comma Gets Added to Headers

When reports were downloaded, the headers automatically got an extra comma at the end. This became an issue especially when the output is consumed automatically by downstream systems.

Code fix provided for Submit Download API.

Not Able to Defer Standalone CM

For a standalone credit memo, upon deferring, the system did not defer the revenue.

Code fix provided for Revenue Process API.

Mulitple CM-Rs Getting Collected For the Same Invoice Line

When multiple CM-R were collected for a specific Invoice, the system did not validate if the total CM-R amount is greater than the invoice amount and failed the record.

Code fix provided for RC Collect API.

CM Cancellation With Bundle- Reversal Entry is Not Created

When CM cancellation is performed on the bundle lines, for the child lines the initial entry booked earlier for the CM is not reversed.

Code fix provided for Revenue Process API.

Cost is Not Being Released When a Negative Value is Uploaded For Cost Amount

When the Cost (CST file) is uploaded with Positive Amount cost is being Capitalized and Released as expected. But when the CST file is uploaded with Negative Amount Cost is being Capitalized, but the cost is not being Released.

Code fix provided for Revenue Process API.

Performance Issue With Link

When linking lines to POB, the system performed a full table scan on RC Line which leads to performance issue.

Code fix provided for RC Action API.

RC Template Name in Concurrent Program Wss of 30 Char Length

RC Template Name for the concurrent program is limited with 30 characters, size to be increased to 240 characters.

Code fix provided for Oracle Apps script when defining the executable.

Cost Apply Formula & Apply Value

If apply_value is NULL in the cost rules, the system did not apply other costs.

Code fix provided for Cost Accounting Process API.

While Updating, Transfer Accounting Errors Out With "Not a Single or Group by" 

When GL Interface setup had any group functions, it failed during transfer accounting process, for the group functions such as MAX/MIN it is recommended to use the Dynamic as the Source Type.

Code fix provided for Transfer Accounting Process.

CDK Global-Transaction Run in to WARNING Status During EVENT Upload Before Invoice Creation

When SO, INV and EVENT is collected successfully, after closing and opening the period, upon processing of Invoice, data collection process is completed in error. The system called RORD API and when RORD is not available, error occurred.

Code fix provided for RORD API.

Incorrect Contract Mod Rule Collected For Price Decrease Scenario

Incorrect Contract Modification rule collected for price decrease scenario.

Code fix provided for RC Collect API.

Cost Following UDS Though Setup Says Immediate

When cost is independent of revenue and the ratable method configured as Immediate, upon releasing of cost, system amortized cost based on the revenue.

Code fix provided for Revenue Process API.

Negative INV Line Showing Up as Unbilled Revenue Waterfall and Unreleased in Billings Tab

Negative line revenue is displayed as Unbilled revenue in the waterfall.

Code fix provided for Revenue Process API.

Waterfall Date Value in Excel is Not Reflecting the Actual Period

When waterfall data is exported to excel, the period name is displayed incorrectly in the excel.

Code fix provided for Export API.

SO Cancelation Not Working For Bundle Lines

SO cancelation on the bundle line, cancelled the parent line but not the child lines.

Code fix provided for RC Collect API.

RORD Reversal For Past Period is Not Working

When RORD is processed based on the past periods, where Rule Start Date and End Date were in past periods, the system did not do the catch up and booking the reversal in the current period.

Code fix provided for Revenue Process API.

Quantity based Event, Changes the Retain Type From Amount to Percent Release

For quantity based released, when a price change occurred, the system adjusted the percentage of release. In this case, the system treated it as Retain Percent.

Code fix provided for Revenue Process API.

Workbench: Search by RC ID and SO Taking a Long Time

Search on the WB is taking too long to display RC(s).

Code fix provided for Search API.

Chegg: Issue With SSP Hierarchy With Formulae

For a RC if there were transaction lines for which SSP to be calculated based on SSP formula and SSP %, the system considered the SSP formula for all the lines.

Code fix provided for FV Allocation API.

CT Mod End Date is Not Changing When New SO is Added to an Existing RC

During contract revision period, when a new SO transaction is collected, the system did not trigger the contract modification rule, instead, treated the amendment as the initial timeline.

Code fix provided for Contract Modification API.

Mass Actions Reallocate For Bulk RC is Not Happening

When Re-Allocation performed across RC(s) using Mass Action, the process failed due to certain RC(s) which were not eligible for reallocation, which needed to be excluded.

Code fix provided for Process RC API.

Issue While Changing POB After Linking POB Action

When a De-Linked Line is linked to a RC, the system created Auto POB and then the line is moved to another POB. Upon the action, the line is moved out of the Auto POB, but did not get linked to the POB.

Code fix provided for Link POB Action API.

Allocatable Ext. Price Functional is Flipping to $0 for MR Ghost Lines When RC is Re-allocated

Upon re-allocation, Ghost Lines that were created as part of MR functionality where the Transaction price which is considered for allocation gets reset to 0.

Code fix provided for FV Allocation API.

Hold Issue With Delink

When a POB is delinked from RC and had holds applied at the time of delink. When creating a manual RC and upon linking the POB to this RC, holds were not getting applied.

Code fix provided for Create Manual RC API.

Ext_Lst_Prc Doubled When Debit Memo Brought After CM-R

After processing SO and INV, if a CM-R is collected, the system adjusted the list price on the SO. When a debit memo is collected later in form of INV, the system doubled up the List Price and Sell Price on the SO.

Code fix provided for RC Collect API.

Adjustment Waterfall is Not Showing Correctly

When a credit memo is processed with the credit rule as “F” with fixed dates, and if it is impacting the revenue in the past periods, the system performed retrospective allocation, as part of the allocation, allocation entries were incorrect.

Code fix provided for FV Allocation API.

PGA Memory Issue in POB Rel Immediate Program

PGA Memory issue in POB Rel Immediate program.

Code fix provided for Revenue Process API.

Processed Amount Incorrectly Calculated For Zero Dollar Lead Line

In an unconsolidated POB, when ZERO dollar line is a lead line then the processed amount is calculated wrong. For example, since the processed amount for Zero Dollar line is taken as 100 for 100% release it increments the revenue by 100. It is shown incorrectly in the REVENUE ACTIONS tab in the workbench.

Code fix provided for Event Process API.

Contract Mod Did Not Do Prospective Treatment (Rather Creates a New RC) When a Single Line POB Falls Outside SSP Range

When a POB is outside SSP range and the contract mod rule stated as perspective, the system created a new RC for the POB.

Code fix provided for RC Collect API.

Cost Rule Applied After the Rule End Date

Incorrect check against the validity of the cost rules.

Code fix provided for Auto Cost API.

Prospective Allocation is Not Giving Expected Waterfall Results When Sell Price is Increased And Then Decreased in Same Revision Period

When a upsell and downsell happened in the same contract revision period, as part of prospective allocation, revenue waterfall displayed incorrect results.

Code fix provided for Revenue Process API.

Invoice Level COGS is Not Working in Case of Partial Billing

When you did the following operations:

  1. Bring a SO for $1500.
  2. Bring partial invoice for $750 and std cost for $500.
  3. Bring partial invoice for another $750 and std cost for $500.

Assumption:

  • POB should be released based on Upon Billing.
  • Standard cost should be brought in only on INV.

Expected Result:

Standard Cost should be fully released at invoice level upon billing.

Actual Result:

System releasing prorated cost at one invoice and full cost at another invoice though the line is fully invoiced.

Code fix provided for Revenue Process API.

Introduce RC Line_ID Column in BI View rpro_bi3_rc_hold_v

RC Line Id column is missed in the BI view.

Code fix provided for BI View RPRO_BI3_RC_HOLD_V.

RC Batch ID Missing in the Reports

RC Batch Id to be made available in the reports.

Seeded columns to the following reports:

  • RC Rollforward Report
  • Waterfall Report
  • Accounting Report
  • SSP Exception Report
  • RC Hold/Release Report
  • Revenue Contract Detail Report
  • Billing Report
  • Booking Report
  • Orphan Transactions Report
  • Manual POB Report
  • Manually Created Revenue Contracts
  • Unreleased POB(s) Report
  • POB(s) Released Report
  • Failed RSSP Transaction Report
  • POB Dependencies
  • Cost Transactions
  • Cost Transaction Changes
  • VC Transaction Changes
  • VC Transactions
  • Cost Capitalized Rollforward Report
  • Revenue Book Comparison Report
  • VC Rollforward Report
  • Billing RollForward Report
  • Billing Waterfall
  • Revenue Insight
  • VC Actions
  • VC Insight
  • Trial Balance Report
  • Cost Insight
  • Mass Action Batch Report
  • Unbilled Fx Report
  • Unbill RollForward Report
  • Contract Modification Report
  • Reduction Orders Report
  • Period FX Waterfall
  • Transfer Accounting Errors Report

Manage Mass Actions Upload File Issue

Unhandled exception when file is downloaded and uploaded as part of mass action activity.

Code fix provided for Mass Action API.

Std Cost in INV Line Only

When a SO without Cost and an Invoice with Cost is processed together, incorrect cost accounting is performed.

Code fix provided for RC Collect API.

Manual-JE Details Does Not Satisfy Approval Rule Criteria 

When there is no approval rule associated with the MJE, upon submitting for approval, the system set the MJE status to Approval Cancelled.

Code fix provided for MJE API.

Carve Adjustment and Forecast WF For $0 Lines Not Matching

Incorrect rounding logic led to a mismatch between the total carve adjustments and total waterfall amount based on the carve adjustment.

Code fix provided for Forecast API.

Incorrect Allocated Release Amount on Workbench For Ghost Lines

The system used Allocated amount instead of CV Amount to derive the Allocated release amount.

Code fix provided for the derived column.

Functional EX Rate Rounding Issue in Hosted Sub Waterfall Report

The system rounded the F Exchange Rate on the waterfall report.

Code fix provided for Waterfall Report Query.

Holds Filter in the Transactions Workbench

Currently, in the transaction tab of WB, there is no option to filter the transactions which had hold applied.

Code fix provided for Revenue Contract WB to allow filter on the transactions.

Allocation Issue

For a $0 transaction line, when RORD for $0 is processed, the system did not perform allocation.

Code fix provided for RORD API.

Cumulative Percentage Based Events Not Releasing Revenue For All POB Lines Because of COMMIT_TRANS_COUNT Profile Setting

The system not processing high volume events, when the profile is set to 0, the system only processed 100 POB(s) and left the remaining in the stage.

Code fix provided for Event Process API.

Limitation to Add Organizations For a Single Role - NCR

When trying to add orgs, the system is not allowed the number of orgs to be added when more than 30.

Code fix provided for Utility API.

Run ID is Not Stamped in The Schedule Request Table

RUN ID is not stamped in the schedule request table when job errors out.

Code fix provided for Job Scheduler API.

Release Action Display Issue

When release of revenue is performed manually, the system displayed it as released through an event.

Code fix provided for Revenue Process API.

System Allowing to Click on Save Button Even When the Accounting Setup is Not Changed

When there is no change performed in the accounting setup UI, the system allowed you to save which led to incorrect Accounting segment assignment.

Code fix provided for Accounting Setup UI.

Pre-requisites and System Requirements

The minimum patch level that is required to apply this patch are given below:

Patch # 3.3.5.0
Build #    3350
Combo Build 33502497
Patch Type Incremental
Released Date 09/25/17


Upgrade Path

RevPro being a product offering will be maintained in terms of bug fixes and feature/functionality additions on an ongoing basis. These are delivered to the customers in the form of support packs. These Support packs will be available for the customers in their own Zuora customer portals provided. Customers need to login into their own portal and download the patches for installing it.

Testing Strategy Recommendations 

In any upgrade situations, Zuora recommends installing the Support packs in a Test or a QA instance and identify the impact of the patches from a business process perspective and only then transport to Production instance.

Other Impacts

No other impacts identified in the patch.