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 08, 2017

Applies to:

Oracle Financials for India - Version to [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
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,
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..


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.