My Oracle Support Banner

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 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

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
Symptoms
Changes
Cause
Solution
References


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