My Oracle Support Banner

Payment Transfer Request Is Not Searchable Through Payment Request UI (Doc ID 2740545.1)

Last updated on JANUARY 04, 2021

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.9.0.0.0 to 2.9.0.0.0 [Release 2]
Information in this document applies to any platform.

Symptoms

With Oracle Revenue Management and Billing (ORMB) version 2.9, a payment request gives an error while performing a payment transfer from the Account's Payment Event Summary UI. However, when the user searches for the Payment request number 'requestxxxx' in Payment request search UI, the payment request is not searchable. The payment request is present in the Payment Request Table. On debugging the issue there is no payor account in the payment request clob column. There is a condition in the payment request search where payment request payor account id is joined with the CI_ACCT id table. If payor account id is not present then the search zone did not return result.
 

ERROR
-----------------------

Error Message - “Payment Request requestxxxx in status DRAFT created by user SYSUSER already exist for Entity Account and Entity ID entityxxx.”

Cause

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