Error in AP Invoice Validation

Error in AP Invoice Validation


Quest: Error in AP Invoice Validation

In R12 getting below error while validating invoice
APP-SQLAP-10000: User Defined Exception occured in
Error from trigger JAI_AP_IDA_BRIUD_T1
with parameters (&PARAMETERS)
while performing the following operation:
Encountered an error in JAI_AP_IDA_TRIGGER_PKG.BRIUD_T1
Error on ap_invoice_distributions_all: ORA-20007 Error - trigger ja_in_ap_aida_before_trg on
ap_invoice_distributions_all : Applications cannot be done as the section code is different in both the
documents

Sol: I guess this error will e coming up when you applying a Prepayment to a standard invoice and then validating
it..
Check the TDS tax ID that is attached to the Prepayment and the Standard Invoice..
Both the Tax id's should belong to the same section..If not this error message will pop up...
The error will also come up if TDS is attached to Prepayment and not attached to Standard Invoice or vice versa

Quest: We are not applying prepayment to this invoice. We are validating it only.

Result: I rechecked and found that prepayment applied but those lines discarded. I guess that is causing an issue here.

Suggestion: Does that prepayment have TDS Tax ID's attached?
I suggest you cancel this Standard Invoice and create a fresh Invoice as a workaround

RE: Actually Invoice has TDS in Additional Info for India but prepayment doesn't. I removed TDS from Invoice then
it validated successfully. Is that okay to do that ?

RE:Yes that is fine

Quest: We are also having same case. User has applied the prepayment and discard the line. We we are not able to validate or cancel the invoice.
What should we do ??
RE: As far as i know, discard functionality is not supported under earlier localization as well as GST


Sol: Below prepayment application error is getting resolved by applying patch 26638636:R12.JAI.B.
ERROR