My Oracle Support Banner

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

Last updated on FEBRUARY 25, 2019

Applies to:

Oracle Utilities Customer Care and Billing - Version and later
Information in this document applies to any platform.


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.

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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.