CCB Billed Usage Fact - Number of Rows Extracted and Loaded are Different (Doc ID 784736.1)

Last updated on OCTOBER 18, 2016

Applies to:

Oracle Utilities Customer Care and Billing - Version: 2.2.0 and later   [Release: 2.2 and later ]
Information in this document applies to any platform.

Symptoms

While testing Extract-Transform-Load (ETL) for Billed Usage Fact, we found the batch job extracts 142 records but only 109 records are loaded.

Investigating further we discovered the Bill Date value is blank for those 33 records that were not
loaded. We checked the source system and found that those bills were in "pending" status.

STEPS
The issue can be reproduced at will with the following steps:
1. Extract Billed Usage Fact in Initial Load Mode and Load to OUBI.
2. Check the number of rows extracted and loaded.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms