My Oracle Support Banner

BALAPY ISSUE-CREATION OF MULTIPLE TENDER CONTROLS AND DEPOSIT CONTROLS. (Doc ID 2712965.1)

Last updated on OCTOBER 03, 2022

Applies to:

Oracle Utilities Customer Care and Billing - Version 2.6.0.1.0 to 2.7.0.3.0 [Release 2.6 to 2.7]
Information in this document applies to any platform.

Symptoms

CCB -Customer Care and Billing.

On : 2.6.0.1.0 version, ENV - Environment

BALAPY SQL S_STBATCH is different in the documentation and the runtime logs

The SQL S_STBATCH in BALAPY has an extra Select field ST.APAY_SRC_CD in the runtime logs compared to the documentation in CC&B.
This has increased the size of record to looped through, resulting to creation of multiple tender controls and deposit controls.
Customer are encountering the issue when retrieving the Tender Control to link into the Autopay record, the SQL is a single row select that is retrieving
multiple records.If the multiple Deposit Controls getting created is what's causing the creation of the multiple Tender Controls,
then that would probably resolve the problem.

Changes

Cause

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
Symptoms
Changes
Cause
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.