JA_IN_AP_AIDA_BEFORE_TRG Error At the Time of Applying Prepayment to an Invoice
(Doc ID 462545.1)
Last updated on MARCH 01, 2019
Applies to:Oracle Financials for India - Version 220.127.116.11 to 18.104.22.168 [Release 11.5]
Information in this document applies to any platform.
FORM:APXINWKB.FMB - Invoice Workbench
Trying to apply Prepayment against an invoice fails with the following of the errors may be noticed:
Error - 1
"APP-SQLAP-10000: ORA-20010: Error - trigger ja_in_ap_aida_before_trg on
ap_invoice_distributions_all: ORA-20006 : Error - trigger
ja_in_ap_aida_before_trg on ap_invoice_distributions_all : "Threshold group identifier is not found against the prepayment Invoice TDS tax, cannot proceed."
ORA-06512 at "APPS.JA_IN_AP_AIDA_BEFORE_TRG",line 312
ORA-04088: error during execution of trigger
'APPS.JA_IN_AP_AIDA_BEFORE_TRG' occurred in
insert_prepay_dist<-Apply prepayment and prorate<-Apply Prepayment Form
with parameters (P_prepay_dist_id = xxx, P-invoice_id = xxx, P_apply_amount = xxx,
while preforming the following operation:
Insert New Prepayment distribution
Error - 2
APP_SQLAP-10000: ORA-20010 Error: trigger: ja_in_ap_aida_before_trg on
Ora-4088: ERROR during execution of trigger
APPS.JA_IN_AP_AIDA_BEFORE_TRG on ap_invoice_distributions_all:Effective tax
paid amount cannot be negative..
Application of Budget patch would bring up the first Error
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