Can not apply prepayment to an invoice due to error: APP-SQLAP-97088

(Doc ID 954906.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

Oracle Payables - Version 12.0.1 to 12.1.0 [Release 12.0 to 12.1]
Information in this document applies to any platform.


Can not apply prepayment to an invoice due to error when queried standard invoice and tried to apply the prepayment invoice.

"APP-SQLAP-97088: You cannot apply the prepayment to this invoice because the prepayment application GL Date entered is before the GL Date used on the prepayment or invoice distributions. Please enter a GL Date that is after or equal to the latest GL Date used on the prepayment and invoice

Note that it is successful when queried the prepayment invoice and applied the standard invoice. Though the user guide says it is not possible to apply, system allowed and the behaviour is not consistent.

The system should not allow prepayment application from both the options.

1. Created prepayment invoice with GL date 16-Sep-09 and paid
2. Created Standard invoice with GL date 18-Sep-09
3. Applied prepayment to the invoice with default date of 12-Oct-09 (system date)
4. Queried the prepayment, Unapplied the invoice and tried to reapply giving GL date as 18-Sep-09 Got error "APP-SQLAP-97088: ..." 

System is not behaving consistently.


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