Error "APP-SQLAP-10000: occurred in Apply_Prepay_Line<-Apply Prepayment Form with parameters (& PARAMETERS) while performing the following operation: Distribute Tax" While Applying Prepayment to Standard Invoice (Doc ID 2754749.1)

Last updated on APRIL 16, 2023

Applies to:

Symptoms

PROBLEM STATEMENT
====================

When attempting to apply prepayment to Standard invoice
the following error occurs.

ERROR
-----------------------
Error "APP-SQLAP-10000: occurred in
Apply_Prepay_Line<-Apply Prepayment Form with parameters (& PARAMETERS) while performing the following operation:
Distribute Tax"

While Checking FND the below error is found

Application cannot be done as thier is no TDS attached in Prepayment invoice


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
a) Create a Prepayment with two item lines
Example
Item Line 1 100000 and
Item Line 2 18000
b) Attach the Section code and tax category manually in TDS(Tax deduction at Source) Tax Details for Item line 100000
c) Validate the same
d) TDS and CM(Credit Memo) gets generated
e) Create a Standard Invoice with Item line 100000 and attach GST Tax(Say 18%) miscellaneous 18000
f) Attach the Section code and tax category manually in TDS Tax Details for Item line 100000
g) Validate the same
h) TDS and CM gets generated
i) Now apply the first line 100000 of Standard Invoice to 100000 of Prepayment Invoice.There is no issue and application goes through
k) Now apply the remaining 18000(Miscellaneous) of Standard Invoice against 18000(second line) of Prepayment

The same ends in error

Cause

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