My Oracle Support Banner

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.

Symptoms

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.

 Example Case

 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.

ap_payment_schedules_all
INVOICE_ID DUE_DATE
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.

 



Changes

 

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