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.
APP-SQLAP-97088
APPREPAY.pld


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

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