Happy Business Starts Here

Technical changes of summarization tables

Muhan
Zuora Documentation

Technical changes of summarization tables

As part of the architecture improvement that will be delivered in RevPro 37.001.00.00, technical changes are made to some summarization objects. The product predefined programs and jobs are updated based on these changes.

 

If you have any customized programs or jobs that involve summarization objects, please make a note of these changes and also the customized one-time summarization script to ensure that these changes do not introduce any errors.

 

Changes

The summarization table names are changed as indicated in the table below. 

Previous table name

New table name

Table usage

rpro_ri_acct_summ_g

rpro_ri_acct_summ_s1

The base table for all the summarized data. 

rpro_ri_acct_summ_t

rpro_ri_acct_summ_s2

The temporary table used for summarization during the runtime. 

rpro_ri_wf_summ_g

rpro_ri_wf_summ_s1

The base table for all summarized waterfall data.

rpro_ri_wf_summ_t

rpro_ri_wf_summ_s2

The temporary table used for waterfall data during the runtime. 

 

Impact

The following synonyms are created for the summarization base tables. Beginning from RevPro 37.001.00.00, the TRUNCATE command cannot be used on these synonyms. 

  • rpro_ri_acct_summ_g
  • rpro_ri_acct_summ_t
  • rpro_ri_wf_summ_g
  • rpro_ri_wf_summ_t

 

If the previous table names are still being used with the TRUNCATE command in any of your customized script or job, it will error out. 

 

User action

If you have used the TRUNCATE command on any of these summarization tables (rpro_ri_acct_summ_g and rpro_ri_wf_summ_g), please replace them with the new table names. 

 

If the previous tables are used in the customized script or job but the TRUNCATE command is NOT used on them, then no action is required.

As indicated in the table below, the previous way of using the TRUNCATE command needs to be updated to the new way.

Previous way

New way

TRUNCATE TABLE rpro_ri_acct_summ_g;

TRUNCATE TABLE rpro_ri_acct_summ_s1;

TRUNCATE TABLE rpro_ri_acct_summ_s2;

TRUNCATE TABLE rpro_ri_wf_summ_g;

TRUNCATE TABLE rpro_ri_wf_summ_s1;

TRUNCATE TABLE rpro_ri_wf_summ_s2;


For Zuora staff to find more details regarding the latest one-time summarisation script, please check the JIRA ticket: RD-6761 after the 37.001.00.00 release

2 REPLIES 2
rashmidi
Student

Re: Technical changes of summarization tables

Hi Zuora team,

 

Can you clarify if these technical changes of summarization tables will be part of revpro version upgrade 37.001.00.00 if we are using RevPro on cloud.

Will this be part of RevPro upgrade process if we use RevPro on cloud.

 

Do we need to do any changes from our side.

Srinivas
RevPro Support

Re: Technical changes of summarization tables

This will be part of the standard release 37.001.00.00 for the cloud.  No action required by customers.  The only request is not run One Time summarization programs created in prior versions without checking support.

 





If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √