SQL Error Code 000099997 Occurred in Module CIPPPAYS:GB000 FETCH While Applying Payment

(Doc ID 2199899.1)

Last updated on NOVEMBER 08, 2016

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.

Symptoms

On RMB v2.4.0.0.0 version, PY - Payment:

Payment service is throwing error when creating payment for bill with more than 10K bill segments from UI/Batch.

Actual Behavior
-------------------------
While applying payment on large bills (Bills having 10000+ bill segments) in production, below error in “CIPPPAYS” cobol program occurs.
PFA of batch logs for more reference.

The following stacked messages were reported as the LoggedException was rethrown:
com.splwg.base.support.cobol.host.sql.CobolSQLParamMetaData.populateOutput(CobolSQLParamMetaData.java:182): Error binding output ParamMetaData {name='xPS-COUNT', type='S9', size=4, scale=0, column=1, isNullUsed=true, offset = 4}
MetaData :SQL Metadata {
  inputs: [
  ParamMetaData {name='xPAY-ID', type='C', size=12, scale=0, column=-1, isNullUsed=false, offset = 4}
],
  outputs: [
  ParamMetaData {name='xPS-COUNT', type='S9', size=4, scale=0, column=1, isNullUsed=true, offset = 4}
]}

The root LoggedException was: Integer 10230 is too large to write into cobol buffer field with size 4

ERROR
-----------------------
SQL Error code 000099997 occurred in module CIPPPAYS:GB000 FETCH

Expected Behavior:
-------------------------------
Payment service should create payments for big bills with 100K+ bill segments.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to RMB
2. Search for bill with more than 10K bills
3. Create payment using payment event or payment portal
4. Error is thrown from COBOL service

BUSINESS IMPACT
--------------------------------
The issue has the following business impact:
Critical as Users are unable to apply big payments.

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