My Oracle Support Banner

Cobol Program CIPLARSR is Causing DB Update Failure During Rebill (Doc ID 2344803.1)

Last updated on FEBRUARY 28, 2019

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.4.0.0.0 and later
Information in this document applies to any platform.

Goal

Cobol Program CIPLARSR is affecting the rebill.
Table CI_ADM_RVW_SCH is not allowing duplicate values during rebill run. Log shows following:

INSERT INTO CI_ADM_RVW_SCH (ACCT_ID, NEXT_CR_RVW_DT, VERSION) VALUES (UPPER(?), ?, ?) /* SQL for COBOL program 'CIPLARSR', SQL name 'I_ROW' */' with bind parameters:
Parameter 1 (Char)'9796228111'
Parameter 2 (Date)'2017-12-14'
Parameter 3 (Integer)'1'
 with last row return values:

The article confirms following:
i) How table CI_ADM_RVW_SCH is getting populated. Batch or any online activity.
ii) What is the reason it is not allowing duplicate values while Cobol program CIPLARSR is trying to enter the value during bill segment creation.

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.