My Oracle Support Banner

SQL Error Code 000099997 Occurred in Module CIPPPAYS:GB000 FETCH While Applying Payment (Doc ID 2199899.1)

Last updated on AUGUST 12, 2020

Applies to:

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


On RMB v2. 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.

The following stacked messages were reported as the LoggedException was rethrown: 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

SQL Error code 000099997 occurred in module CIPPPAYS:GB000 FETCH

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

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

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


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

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