My Oracle Support Banner

R12: AP: Cash Requirement Report Is Not Pulling The Discount Due Date Invoices (Doc ID 2769077.1)

Last updated on APRIL 13, 2023

Applies to:

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


When running the Cash requirements report there is a difference in the output when payment date equal to null vs
when payment data is manually populated with a value of sysdate + 1

An additional invoice appears on the report when running with sysdate + 1

Steps to reproduce


  1. Created new PPR template 
  2. Enter an invoice
  3. change the due date and discount date on the payment schedule
    discount date 23-MAR-2021.  due date 23-APR-2021
  4. Then ran the Cash Requirements report without a payment date populated. This invoice will not appear in the output
  5. Ran the report again with payment date populated and the invoice does appear in the output.




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

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