JA_IN_AP_AIDA_BEFORE_TRG Error At the Time of Applying Prepayment to an Invoice (Doc ID 462545.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

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
From Prepayment
with parameters (P_prepay_dist_id = xxx, P-invoice_id = xxx, P_apply_amount = xxx,
p_last_update_login)
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 
ap_invoice_distribution_all: ORA:20007.. 
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..

Changes

Application of Budget patch would bring up the first 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.