Can not apply prepayment to an invoice due to error: APP-SQLAP-97088 (Doc ID 954906.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Symptoms

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
distributions."

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.

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

STEPS TO REPRODUCE
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: ..." 

BUSINESS IMPACT
System is not behaving consistently.

Cause

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