Payment Transfer to Bill with Large Number of Bill Segments Failing to Trigger Batch C1-PAYBT

(Doc ID 2308665.1)

Last updated on SEPTEMBER 25, 2017

Applies to:

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

Symptoms

On RMB v2.4.0.1.0 against FW v4.2.0.3, BI - Billing

Payment transfer to bill with large number of bsegs failing and  batch C1-PAYBT not getting triggered.

ACTUAL BEHAVIOR  
---------------------------------
Payment transfer to bill with large number of bill segments is failing after freezing the application window. It shows following error after a while:

-------------
SYSUSER - 811558-5031-1 2017-05-11 01:28:11,584 [[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] INFO  (support.context.FrameworkSession) (Server Message)
Category: 5
Number: 3
Call Sequence: ;CIPFMEVN;CIPFFITR;CIPPMBWN;CIPPMBWX;CIPPMDRX;CIPPOI2X;CIPPDDRX;CIPPPAYS;CIPPYXFN;CIPPPAYP
Program Name: CIPPPAYP
Text: SQL Error code 000099997 occurred in module CIPFMEVN:XA100 SELECT
Description: Please contact your system administrator.
-------------

Batch C1-PAYBT is not getting triggered for payment distribution and processing.

EXPECTED BEHAVIOR
-------------------------------------
It should trigger batch for payment distribution.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) Add a payment to Excess Credit contract
2) Transfer this payment to invoice using BILL-W match type
- Screen Freezes after that and application does not respond. It is not triggering the C1-PAYBT batch for payment transfer.
- Application throws an error after some time.

BUSINESS IMPACT
-------------------------------
The issue has the following business impact:
Due to this issue, users cannot complete payment transfer with large number of bill segments and affecting billing process.

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