Welcome to Zuora Product Documentation

Explore our rich library of product information

Schedule Revenue Sync jobs

Learn how to schedule and configure Revenue Sync jobs to integrate billing data with Zuora Revenue.

  1. If you have the legacy scheduled RevPro3.0 Zuora Data Transformation programs running, terminate the existing programs.
  2. Navigate to Data Interface > Revenue Sync . The Revenue Sync page is displayed.
  3. Click Schedule a revenue data sync . The Schedule Revenue Sync Job dialog is then displayed.
  4. In the Schedule Program tab, complete the scheduler settings based on your needs. See Schedule jobs to understand what each configuration field means. If you just terminated a Data Transformation job scheduler, you can configure the fields based on the legacy job configuration.
  5. In the Program Parameters tab, specify the following information:
    • If you have multiple Zuora Billing entities, select an entity from the Entity dropdown list. If not, the entity name is automatically populated.

    • In the Last Updated Date Range section, select an end date for the date range where the data is synced. You can specify the start date when you run a Revenue Sync job for the first time in this org. Subsequently, the start date defaults from the last run end date and becomes unavailable for editing.

    • In the Filters section, specify one or more filter conditions.
      1. In the Field dropdown list, select the field to be used in the filter condition. The populated fields include both standard fields and custom fields.
      2. In the Operator dropdown list, select the operator for the filter. For example, = .

      3. Enter the field value in the Value field.
      4. If multiple filter conditions are required, click + Add Filter to add more filter conditions. You can specify up to 5 filters.
  6. Click Submit Job . If the scheduled Revenue Sync job is successfully submitted, the corresponding item is displayed in the Revenue Data Sync History table.

If you want to change the start date or filter condition after a Revenue Sync job is already scheduled, you must first cancel this job. To cancel a scheduled Revenue Sync job, hover over the job listed on the Schedule Jobs page and click the 'X' icon .

Note:
  • The Revenue Sync job is available since Zuora Revenue 37.002.02.00, and deprecates the previous Data Sync and Data Transformation jobs for Billing - Revenue Integration.
  • Data from th legacy program can also be displayed in the Revenue Data Sync History table. So if you scheduled or run the previous Data Transformation jobs, the historical data of the job will be listed in the Revenue Data Sync History table.

All data in the specified date range that meets the filter conditions are synced and transformed into the Line Staging tables. You can view all Line Staging data by navigating to Data Interface > Inbound . Note that duplicate records might exist in the Line Staging tables. The Data Collection job will remove duplicate lines during the collection process.

If the job encounters an error or completes with warnings, hover over the job item in the Revenue Data Sync History table and click the magnifying lens icon to check the error details. The sub-jobs are categorized into different objects. To resolve errors, you can take measures based on the suggested action in the corresponding Action column.

To check the filter used for the job, hover over the job item in the Revenue Data Sync History table and click the funnel icon. Note that the filter format for configured Revenue Sync jobs is different from the filter format for migrated Data Sync jobs:

  • For configured Revenue Sync jobs, the filter format is the filter condition you specified in the Filters field. For example, Account.AccountNumber = 'A-S00000142' .
  • For migrated Data Sync and Data Transformation jobs, apart from the specified filter condition, it also includes the transaction type and the template name. For example, ORDER~Booking Template~Subscription.Name in (''''A-S00000144'''', ''''A-S00000145'''')~~ .

After you manually run or schedule the Revenue Sync job, you can start collecting data into Zuora Revenue. For more information, see Collect data for Billing - Revenue Integration.