My Oracle Support Banner

R12: AP: Applying Prepayment Errors with APP-SQLAP-10000 System Could Not Create Ta Occurred Apply_Prepay_line<-Apply Prepayment Form while performing the following operation: Distribute tax (Doc ID 2501135.1)

Last updated on DECEMBER 19, 2022

Applies to:

Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to apply a prepayment to a standard invoice, the following error occurs.

R12: AP: Applying Prepayment to Invoice: APP-SQLAP-10000 System Could Not Create Ta Occurred Apply_Prepay_line<-Apply Prepayment Form while performing the following operation: Distribute tax



The FND LOG displays the following error:

Period Name not there in plsql table: 
"APP-SQLAP-97420: Payables cannot cancel this invoice because the GL date of at least one distribution is in a closed period, and no open or future periods are defined. 
Please ask the appropriate person in your organization to define an open or future period. Payables can then use the next valid accounting date as the GL date on the reversal distributions. (DATE=)"
-20001: ORA-20001: APP-SQLAP-97420: Payables cannot cancel this invoice because the GL d

 

Cause

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
Symptoms
Cause
Solution
References


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