Last updated on AUGUST 19, 2009
Applies to:Oracle Utilities Customer Care and Billing - Version: 2.2.0 to 2.3.0
This problem can occur on any platform.
SQL error 156 occurs when using the data derivation algorithm IPFCRAGG. SQL Error Code 156 in
CIPISAGX XQ010 SELECT.
-- Steps To Reproduce:
The intention of this setup was to produce a curve from the interval registers. This was done by
setting up a new Interval Profile type that uses the Algorithm IPFCRAGG.
From the SA Page, the Derive Interval Data button is clicked.
Error encountered during processing.
Interval Profile Type (new)
Add above to existing Interval Profile rel type
SA Type E-INTREG has Interval Profile Relationship Type = KWH CON
Using SA below, added Interval Profile Rel type for KWH CON
New Interval Profile ID (blank)
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms