No Key Was Generated Error In 2.4.0.2
(Doc ID 2463141.1)
Last updated on AUGUST 06, 2022
Applies to:
Oracle Utilities Customer Care and Billing - Version 2.4.0.2.0 and laterInformation in this document applies to any platform.
Goal
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 |