My Oracle Support Banner

No Key Was Generated Error In 2.4.0.2 (Doc ID 2463141.1)

Last updated on OCTOBER 01, 2020

Applies to:

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

Goal

**Disclaimer:** This KM article may include the following abbreviations:

CCB - Oracle Utilities Customer Care and Billing
FA - Field Activity

 

During creation of audit table entries, the system attempts to create an ID for the audit entry 10 times and fails, causing whole FA Completion process to fail.

Steps to Recreate:

Configure the system such that there is a COBOL to Java call, and then a call to generate an Id for a new record. The example in CCB was:

Ensure that the CIPZADTA audit program is plugged in the CI_ACCT table:
- Go to Admin - T - Table
- Search for CI_ACCT table
- In the main tab, verify that audit program CIPZADTA is plugged in

Then proceed in adding an Account:
- Navigate to Main Menu | Customer Information | + Account.
- Navigate to Persons tab.
- Add a Person.
- Click Save.
- Error "No key was generated." was encountered. Category: 25 Number: 11304

As seen in the logs:
* WARNING:  EITHER TABLE/ID CI_AUDIT_K                    /AUDIT_ID
              IS GETTING FULL OR NEEDS TUNING.

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!


In this Document
Goal
Solution
References


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