Payment Is Split Due to the Payment Details (Doc ID 1523305.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Payments - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When generating electronic payment files in the payment file it is needed to show the list of invoices paid.

For this reason under Payment Process Profiles, under tab, “Payment Creation” tab, field “Payment Detail Formula” has formula “CALLING_APP_DOC_REF_NUMBER||','”

Based on this formula the pad invoice numbers as CONCATENATED string are stored in database table IBY_PAYMENTS_ALL field PAYMENT_DETAILS.

Field PAYMENT_DETAILS has type and length VARCHAR2 (4000 BYTE) in mentioned above database table.

When creating payments instead to be created 1 single payment system somehow splits automatically the payments when the CONCATENATED string in field PAYMENT_DETAILS of database table IBY_PAYMENTS_ALL gets too long.

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