R12: Maturity Date On Bill Payable Payment Is Incorrect
(Doc ID 1956497.1)
Last updated on JUNE 17, 2019
Applies to:Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.
When calculating the Maturity Date for Bill Payments Including Credit Memos the Due Date or Discount Date of the Credit Memo is also included for consideration.
In the Build Payments Log File find...
IBY_PAYGROUP_PUB.performMaturityDateCalculation:Earliest available due date
for payment 242792 is 22-AUG-14
IBY_PAYGROUP_PUB.performMaturityDateCalculation:Setting maturity date to due
date 22-AUG-14 for payment 242792 because no discount date available.
In the Check_iby Diagnostic find Payment 242792
The Payment Shows
PAYMENT_DATE MATURITY_DATE PAYMENT_DUE_DATE
08-AUG-2014 00:00 22-AUG-2014 00:00 02-JUL-2014 00:00
It pays the following documents.
INVOICE_ID1 01-OCT-2014 00:00 s*
INVOICE_ID2 01-DEC-2014 00:00 s*
INVOICE_ID3 15-NOV-2014 00:00 s*
INVOICE_ID4 31-JUL-2014 00:00 c
INVOICE_ID5 06-AUG-2014 00:00 s
INVOICE_ID6 01-OCT-2014 00:00 s*
INVOICE_ID7 04-AUG-2014 00:00 s
INVOICE_ID8 02-AUG-2014 00:00 c
INVOICE_ID9 30-NOV-2014 00:00 s*
INVOICE_ID10 02-OCT-2014 00:00 s*
INVOICE_ID11 09-JUL-2014 00:00 c
INVOICE_ID12 30-SEP-2014 00:00 s*
INVOICE_ID13 05-OCT-2014 00:00 s*
INVOICE_ID14 22-AUG-2014 00:00 c*
INVOICE_ID15 15-OCT-2014 00:00 s*
INVOICE_ID16 02-JUL-2014 00:00 c
s = standard invoice
c = credit memo
* = Due Date > Payment Date
Therefore the MATURITY DATE has been taken from INVOICE_ID = INVOICE_ID14 which is
a Credit Memo.
It would seem that the Payment Due Date is set to be the Oldest Due Date and
then the Maturity Date is the first due date after the payment date,
irrespective of whether it is a standard invoice or a credit memo.
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