C1-PNDBL Issue After Account Bill Cycle Change

(Doc ID 2424222.1)

Last updated on JULY 19, 2018

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.6.0.1.0 to 2.6.0.1.0 [Release 2]
Information in this document applies to any platform.

Symptoms

On : ORMB 2.6.0.1.0 version, BI - Billing

C1-PNDBL issue after account bill cycle change

Customer is set up with Daily (WPDY) Bill Cycle and has two completed bills under the month of May. Within the same month, account bill cycle was changed to Yearly 01-June to 31-May (YR06). Then 3-step billing (C1-PNDBL, C1-BLGEN, C1-BLPPR) was run to generate a bill for the current bill cycle schedule.

Expected result:
New bill will be created for the YR06 bill cycle. C1-PNDBL job will complete successfully.

Actual result:
C1-PNDBL job ended in Error status due to more than 1 row returned by S_COMPBILL sql. However there is no error information in stderr logs.



ERROR
-----------------------
WARN (com.splwg.base.support.cobol.DBLocalCobolSQLProcessBackend) more than one row returned from select statement with SQL:
  'SELECT BILL_ID, BILL_STAT_FLG, BILL_CYC_CD, WIN_START_DT, CRE_DTTM FROM CI_BILL WHERE ACCT_ID = ? AND WIN_START_DT >= ? AND WIN_START_DT <= ? AND BILL_STAT_FLG = ? AND ADHOC_BILL_SW = 'N' /* SQL for COBOL program 'CIPBBLGB', SQL name 'S_COMPBILL' */' with bind parameters:
Parameter 1 (Char)'0402371157'
Parameter 2 (Date)'2017-06-01'
Parameter 3 (Date)'2018-05-31'
Parameter 4 (Char)'C '
with last row return values:
(String) '040231142306'
(String) 'C '
(String) 'WPDY'
(DateTime) '2018-05-24-00.00.00.000000'
(DateTime) '2018-05-23-13.58.46.000000'

14:06:12,780 [CobolThread 15] INFO (COBOL.CIPBBLGB) ====================================
14:06:12,780 [CobolThread 15] INFO (COBOL.CIPBBLGB) SQL error in CIPBBLGB
14:06:12,781 [CobolThread 15] INFO (COBOL.CIPBBLGB) 2018-05-31-14.06.11 User : SYSUSER


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create two WPDY bills on 24-May-18 and 25-May-18.
2. Update Bill Cycle to YR06 and run C1-PNDBL. Batch job fails but with no stderr log.
3. Set ADHOC_BILL_SW=’Y’ on above two bills.
4. Re-run C1-PNDBL. Batch job ends successfully with new bill created for new Bill Cycle.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
This issue is affecting merchants whose account set up is updated to change the bill cycle and has a significantly big impact since it has already been encountered in production.

Changes

 

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