R12:AP:AP_INVOICES_ALL.PAYMENT_STATUS_FLAG Becomes P In Format Payment Instructions

(Doc ID 2098669.1)

Last updated on JANUARY 25, 2016

Applies to:

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

Goal

Payment status flag is set to 'P' when
an invoice is 'Partially Paid', which
is specifically what is happening when
2 split payments on an invoice.

And, in the case of the same time, CREATION_DATE of the AP_CHECKS_ALL table occurs.

AP_INVOICES_ALL

PAYMENT_STATUS_FLAG:P

 

AP_PAYMENT_SCHEDULES_ALL

PAYMENT_NUM PAYMENT_STATUS_FLAG

1           Y

2           Y

 

AP_CHECKS_ALL

CHECK_ID CREATION_DATE

60004     2017/06/02 15:45:49

60003     2017/06/02 15:45:49

Solution

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