R12 Bills Payable Maturity Date Earlier Than Payment Date For PPR (Doc ID 1301529.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

Customer has created a Payment using a Payment Process Request (PPR), where the Maturity Date is in a Closed Period and earlier than the Payment Date.

Steps
Create PPR and Select Invoices with Payment Method applicable to Bills Payable
Stop the PPR to Review Proposed Payments.
Change Maturity Date - application allows to set Maturity Date to a date before the Payment Date and before the system date.

Example
IBY_PAYMENTS_ALL. maturity_date = 07-MAR-2010
IBY_PAYMENTS_ALL. payment_date = 24-FEB-2011
AP_PAYMENT_SCHEDULES_ALL. due_date = 03-MAR-2011

Payment Terms are 30 Days from invoice date.

User Updated Maturity date on Proposed Payment to 07-MAR-2010 (when they meant for it to be 07-MAR-2011)
No Warning issued and Build Payments completes successfully.
PPR Status = Assembled Payments.

This issue does not occur when creating a Payment using the Payables Payment Entry form, the user receives the message
APP-SQLAP-10622: The bill payable maturity date must be on or after the payment date.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.