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 and later
Information in this document applies to any platform.


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

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
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.

It should trigger batch for payment distribution.

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.

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.


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