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

Last updated on MARCH 08, 2017

Applies to:

Oracle Financials for India - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
FORM:APXINWKB.FMB - Invoice Workbench

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms