No Key Was Generated Error In 126.96.36.199
(Doc ID 2463141.1)
Last updated on OCTOBER 01, 2020
Applies to:Oracle Utilities Customer Care and Billing - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
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.
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