CCB V2.1.0 No Audit Trail Created - Update not going through Row Maintenance Program of Payment (Doc ID 806104.1)

Last updated on OCTOBER 18, 2016

Applies to:

Oracle Utilities Customer Care and Billing - Version: 2.1.0 and later   [Release: 2.1 and later ]
Information in this document applies to any platform.

Symptoms

Problem Statement:

The Payment Status Flag is not being tracked in the Audit tables.

Auditing is turned on for CI_PAY using CIPZADTA as the audit program. The Audit Delete, Insert and Update switches are turned on for the PAY_STATUS_FLG field. When creating a Payment Event, with the option do not distribute, the correct records are created in the Audit Table (Audit Action: Add; Value After Update: 10). When clicking on the Distribute Button on the Payment Event page, the payment shows a status of Freezable and has a value of 30 in CI_PAY. But when going back to the audit table, no records are created that refer to the field PAY_STATUS_FLG.

PAY_STATUS_FLG is being updated directly by an UPDATE SQL inside CIPPPAYS and CIPPPAYF.

Steps To Reproduce:
1. Turn Auditing on for CI_PAY using CIPZADTA as the audit program.
2. Turn on the Audit Delete, Insert and Update switches for the PAY_STATUS_FLG field.
3. Create a Payment Event, with the option do not distribute.
4. The correct records are created in the Audit Table (Audit Action: Add; Value After Update: 10).
5. Click on the Distribute Button on the Payment Event page.
6. Audit Query by Table/Field/Key: no records are created that refer to the field PAY_STATUS_FLG.

Business Impact:
Unable to track Payments and their statuses. If someone cancels a payment, it won’t be possible to know which user cancelled it.

Cause

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 hundreds of Community platforms