My Oracle Support Banner

key generation programs batch CIPVSVAI completed with 0 records proceed (Doc ID 2432768.1)

Last updated on AUGUST 13, 2018

Applies to:

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

Goal

On : 2.5.0.2.0 version, ENV - Environment

we followed the Admin Guide v2.5 to insert conversion data , we succeed inserting person , account and service point

when we tried to insert service agreement it passed the validation and the key assignment but during the insertion batch CIPVSVAI it completed with 0 record processed.

we checked the log for the insertion we noticed that the insert statement for CX_SA view is joining with CK_SA_REL table that we are not using.

The SA type that we are using is E-RES of the demo environment and it is not using the SA relationship and we confirmed we have run all the steps for validation and key generation and it all run successfully.
 

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.