Knowledge Center

Knowledge Center > What's New > Zuora RevPro 3.4 Release Notes

Zuora RevPro 3.4 Release Notes

Table of contents
  1. Release 3.4.2.0
    1. New Features
      1. Ability to Submit Reports from the Period Close Screen 
        1. Task Definition UI
        2. Period Close/Open Launch UI
    2. Enhancements
      1. Remove Dependency On the Link Identifier to Process MR Lines That are Not Linked to Any Specific Transactions
      2. Support Comparing Values Between Fields on Mass Action Criteria Screen
      3. Enhancement of Job Status UI
      4. Support Audit Requirement on Accounting Setup Screen
      5. New SSP Derivation Methods to Support Prospective Allocation  
    3. Resolved Issues
      1. MJE Transfer Accounting Issue
      2. Negative SO Lines Within FV Range Calculation is Incorrect
      3. SO Full Cancelation Should not Trigger Price Change Contract Modification Rule
      4. Zero Dollar Line Getting Released in Both SO and Invoice for Quantity Based Event VC Issues 
      5. Errors Occurred While Creating LT ST Reclass in General Motors Instance
      6. Revenue Recognition Issue
      7. Accounting Detail Report Missing Adjustment Liability Entries for Some Lines Period Close Template Issue
      8. Conversion Waterfall API Issue
      9. Incorrect Allocation Entries While De-linking and Linking Using Custom Code
      10. Bundle Explosion Issue
      11. Ext_Sell_Price Should Not be Doubled
      12. Accounting Segments Got Corrupted in the Revision Period
      13. SSP Stratification Report Has Incorrect Compliance Values
      14. Unreleased Contract Value on Impairment Current Issue
      15. Impairment Entries Issue 
      16. For Multi-Currency RC Issue
      17. Export Utility Issue
      18. Cost Accounting Segments Became Null While Sending a SO Update
      19. MJE Tied to RC Line Amount And Schedules Not Matched
      20. Credit Memo Collected for Time Based Lines After Period Close Showed Unreasonable Amount in for Adjustments Accounting Entries
      21. Unable to Release Revenue With Negative Amount After SO Update
      22. The Sweep Unposted schedules Program was Completing With Error
      23. Bundle Configuration Expects Item Num When It is Not a Bundle Criteria and Bundle Criteria Has to be Populated for Child Lines
      24. Unable to Freeze the Accounting Setup in Revpro 3.3.5.3
      25. Reporting UI Rendering After Disabling Seed Layout
      26. Transfer Account Task Submitted From Period Close Template Requires Space in Parameters
      27. Ducommun Instance
      28. Cost Update not Working for Ducommun Instance
      29. Fully Returned Order was Having CV
      30. Unreleased Contract Value 
      31. CM-R brought after CM-R Cancelation For the Same Line was not Working
      32. Removed CV AMOUNT = 0 Check on Transfer Accounting in Prospective Case
      33. Increased Key Attribute Column Length in rpro_ln_event_g Table
      34. Material Rights Columns Populated With Wrong Amounts
      35. Whole Order has been through Complete INV, RORD, CMRO.  
      36. RevPro Cost Entries for SO Update
      37. CDW Segment Issue
      38. RORD Issue
      39. Cost issue about Capitalization upon booking.
      40. The Run Report Role Privilege Tree was Having Inconsistent Behavior  
      41. Allocation Entries not Created
      42. Contract Modification was not Triggering to Retrospective 
      43. Export from Holds Section in the Daily Dashboard is Incomplete
      44. Unfreeze Issue
      45. Credit Memo and Credit Memo Cancelation Collected Together was not Working
      46. CM-R Cancelation Issue
      47. To add the Invoice Line ID column to the Billing Report
      48. Posted RC Issue
      49. RORD Reversal schedules Issue
      50. Export Getting System Error for Summary level Accounting
      51. The Review Summary View on Transfer Batches
      52. Correct Lookup Seed issue
      53. Data Query Utility Issue
      54. Cumulative percentage based events
      55. Period Close Template Issue
      56. Mass Action Batch Creation Period was Wrong
      57. Update on Unbundled Line was not Updating Child Line
      58. Negative SO Issue with Event Release  
      59. Cost Update With Retain by Percent Issue
      60. Credit Rebill Issue
      61. Added Alias to Allocated Release Amount Field In Label and Rep Fields
      62. System Error While Running Unreleased POB Report
      63. SSP Stratification Report Did not Show SSP Percent Details
      64. Hold not Applied While Updating SO 
      65. Exclude Ghost lines to calculate sell_amt in RC Header table
      66. Add RC Line and Bill Fields to the On Hold Accounting Report
      67. Role Privilege Report Differs from Role Privilege Tree in UI
      68. Revenue Share Account Derivation
      69. Cost is Released Immediately not Following Ratable Method
      70. Forecast is Getting Generated for De-link Lines Also in an RC
      71. Rounding Issue in User Defined Schedules  
      72. Capitalized Cost Does not Match the Initial Entry for COST.
      73. Initial Entry Incorrectly Created When CM-C Brought After RORD
      74. Event Release Through QTY not Updating History With Processed QTY
    4. Pre-requisites and System Requirements
    5. Upgrade Path
    6. Testing Strategy Recommendations 
    7. Other Impacts
  2. Release 3.4.1.0
    1. New Features
      1. Data Query Utility
        1. Query Data
        2. Saved Query
        3. Query Log
    2. Enhancements
      1. Enhancement to POB Grouping When Lines Are Re-arranged 
      2. Remove Beg CA/CL Columns From RC Rollforward Non-detailed Layouts 
      3. Transfer Accounting Validation Taking Long Time
      4. Enhancement to Period Close/Open Template
        1. Display Mandatory Parameters Checkbox for Programs
        2. Upon Creating a New Template Default Assign Tasks Order Changes in Close Template
        3. Ability to Resubmit the Job on Canceled Status
        4. Job Submission Error
      5. Ability to Create an MJE That is Tied to an RC or Line
        1. MJE Batch Screen Enhanced
        2. JE Detail Screen Enhanced
        3. Accounting Summary Screen (RC Level)
        4. Accounting Detail Screen (RC Level)
        5. Waterfall Tab Enhanced (RC Level)
        6. Reporting Changes
    3. Resolved Issues
      1. Allocation Not Happening When Unfreeze Done For Manual RC
      2. Schedules WERE Created As Ratable For Immediate POB When an Updated SO Came
      3. CM Brought After CM Cancellation For the Same Line is Not Getting Collected
      4. System Not Creating Incorrect Accounting Entries For Prospective Change
      5. Partial Monthly Accounting Method For RORD
      6. Incorrect Derivation of SSP For CM-R Causing Allocation Issue
      7. Events With Quantity Release Getting Processed For $0 Selling Price And $0 Allocated Price
      8. Cost Release Not Align With Event Release
      9. Collection Went to Warning When Prospective Triggered During INV and CMC in the Same Batch
      10. Ext_Lst_Prc Not Populated Correctly For Overstated Order
      11. Collect SO and Overstated INV With Partial CM-R in the Same Batch
      12. COST REVERSAL RORD and CM-RO Issue
      13. Other Cost Not Following the Ratable Method Defined in the Cost Treatment of POB
      14. Un-released Contract Value
      15. Link/Move Line is Not Updating RC POB ID on Schedules
      16. Not Able to Process Point in Time DEF Records For a Ratable Revenue Schedule
      17. Ext_Lst_Prc is Incorrect After Bringing CM-R Referencing Original_SO_Line_ID
      18. Forecast Error ORA-01476: Divisor is Equal to Zero
      19. Collection Fails When CM-R for 0$ SO Lines
      20. Revenue Deferral Issue With Credit Rebill
      21. Allocatable Ext Price is Bumping After Reallocation in Prospective Treatment
      22. SO Update Issues Without Financial Changes and Unreleased Revenue is a Negative Value
      23. Accounting Detail Layout Tab in Workbench is Throwing Error Eue to Ref RC ID
      24. Adjustment Waterfall Amount Not Matching CV Amount In Line
      25. Data Collection Issue for Contract Modification Lines That Were Associated With SSP Template Based on Custom Attribute Fields (NUM1)
      26. BI Views API Returning 1000 Rows Even Though Value is Set as 10000
      27. NCR(Multi - Org) Exception When Trying to Run the Transfer Accounting Master Job
      28. Forecast Waterfall Incorrect When the Ratable Method is Sliding
      29. Relative Allocation Issue: List Price is 0 and SSP is Based on Sell Price
      30. $0 Line Allocation Schedules Release % Rounding Off is Incorrect 
      31. Creating New Profile to Restrict Overstated Invoice Amount
      32. Credit Memo Collected For Time Based Lines After Period Close Shows Weird And Unreasonable Amount in For Adjustments Accounting Entries
      33. EXT_LST_PRC is Becoming NULL When % Based FV is Based on ATR Fields
      34. Unable to Update Cost Def Segments/Cost Rev Segments From Inbound Screen
      35. SSP Analyzer: Compliance Check Did Not Complete Even After 20 Hours
      36. Recognize the Threshold Unreleased Value With the Last Qty Release
      37. Incorrect Revenue Recognized When CM-R is Part of the RC
      38. Report Downloads: an Extra Comma Gets Added to Headers
      39. Not Able to Defer Standalone CM
      40. Mulitple CM-Rs Getting Collected For the Same Invoice Line
      41. CM Cancellation With Bundle- Reversal Entry is Not Created
      42. Cost is Not Being Released When a Negative Value is Uploaded For Cost Amount
      43. Performance Issue With Link
      44. RC Template Name in Concurrent Program Wss of 30 Char Length
      45. Cost Apply Formula & Apply Value
      46. While Updating, Transfer Accounting Errors Out With "Not a Single or Group by" 
      47. CDK Global-Transaction Run in to WARNING Status During EVENT Upload Before Invoice Creation
      48. Incorrect Contract Mod Rule Collected For Price Decrease Scenario
      49. Cost Following UDS Though Setup Says Immediate
      50. Negative INV Line Showing Up as Unbilled Revenue Waterfall and Unreleased in Billings Tab
      51. Waterfall Date Value in Excel is Not Reflecting the Actual Period
      52. SO Cancelation Not Working For Bundle Lines
      53. RORD Reversal For Past Period is Not Working
      54. Quantity based Event, Changes the Retain Type From Amount to Percent Release
      55. Workbench: Search by RC ID and SO Taking a Long Time
      56. Chegg: Issue With SSP Hierarchy With Formulae
      57. CT Mod End Date is Not Changing When New SO is Added to an Existing RC
      58. Mass Actions Reallocate For Bulk RC is Not Happening
      59. Issue While Changing POB After Linking POB Action
      60. Allocatable Ext. Price Functional is Flipping to $0 for MR Ghost Lines When RC is Re-allocated
      61. Hold Issue With Delink
      62. Ext_Lst_Prc Doubled When Debit Memo Brought After CM-R
      63. Adjustment Waterfall is Not Showing Correctly
      64. PGA Memory Issue in POB Rel Immediate Program
      65. Processed Amount Incorrectly Calculated For Zero Dollar Lead Line
      66. Contract Mod Did Not Do Prospective Treatment (Rather Creates a New RC) When a Single Line POB Falls Outside SSP Range
      67. Cost Rule Applied After the Rule End Date
      68. Prospective Allocation is Not Giving Expected Waterfall Results When Sell Price is Increased And Then Decreased in Same Revision Period
      69. Invoice Level COGS is Not Working in Case of Partial Billing
      70. Introduce RC Line_ID Column in BI View rpro_bi3_rc_hold_v
      71. RC Batch ID Missing in the Reports
      72. Manage Mass Actions Upload File Issue
      73. Std Cost in INV Line Only
      74. Manual-JE Details Does Not Satisfy Approval Rule Criteria 
      75. Carve Adjustment and Forecast WF For $0 Lines Not Matching
      76. Incorrect Allocated Release Amount on Workbench For Ghost Lines
      77. Functional EX Rate Rounding Issue in Hosted Sub Waterfall Report
      78. Holds Filter in the Transactions Workbench
      79. Allocation Issue
      80. Cumulative Percentage Based Events Not Releasing Revenue For All POB Lines Because of COMMIT_TRANS_COUNT Profile Setting
      81. Limitation to Add Organizations For a Single Role - NCR
      82. Run ID is Not Stamped in The Schedule Request Table
      83. Release Action Display Issue
      84. System Allowing to Click on Save Button Even When the Accounting Setup is Not Changed
    4. Pre-requisites and System Requirements
    5. Upgrade Path
      1. Testing Strategy Recommendations 
    6. Other Impacts

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

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 package.

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 the following error:

"ERROR: ORA-06533: Subscript beyond count-ORA-06512: at REVPRO30.RPRO_RC_PRD_DEFBAL_PKG", line 2350"

When we reset L_INCR_IDX : to 1 in RC_SCHD_PRD_SWEEP, the above error was getting fixed but encountering the following error during summarize call:

"ERROR: ORA-30036: unable to extend segment by 8 in undo table space 'APPS_UNDOTS1'-ORA-06512: at "REVPRO30.RPRO_RI_PRE_SUMM_PKG", line 441"

The summarize should call for 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 the following error:

"ERROR: ORA-06533: Subscript beyond count-ORA-06512: at "REVPRO30.RPRO_RC_PRD_DEFBAL_PKG", line 2350". 

When we reset L_INCR_IDX :=1 in RC_SCHD_PRD_SWEEP, the above error is getting fixed but the following error appeared:

"ERROR: ORA-30036: unable to extend segment by 8 in undo tablespace 'APPS_UNDOTS1'-ORA-06512: at "REVPRO30.RPRO_RI_PRE_SUMM_PKG", line 441"

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 package.

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 lenghth 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 displayed 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 Package.

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 Package

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.

Last modified

Tags

This page has no custom tags.

Classifications

(not set)