ERPstuff - Oracle EBS Community

Dear All,

When i do validation for one of the invoice it gives me this error :

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 : There are no active thresholds defined for this vendor
ORA-06512: at "APPS.JA_IN_AP_AIDA_BEFORE_TRG", line 550
ORA-04088: error during execution of trigger 'APPS.JA_IN_AP_AIDA_BEFORE_TRG' occurred in
AP_APPROVAL_PKG.Update_Inv_Dists_To_Approved<-AP_APPROVAL_PKG.Approval<-APXAPRVLUpdate the Dist Base Amounts
with parameters (Invoice_id = 307843Run Option = 1097)
while performing the following operation:
Set Tested dists to Approved if no unpostable holds
Batch validation of the invoice failed
Error : ORA-20001: 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 : There are no active thresholds defined for this vendor
ORA-06512: at "APPS.JA_IN_AP_AIDA_BEFORE_TRG", line 550
ORA-04088: error during execution of trigger 'APPS.JA_IN_AP_AIDA_BEFORE_TRG' occurred in
AP_APPROVAL_PKG.Update_Inv_Dists_To_Approved<-AP_APPROVAL_PKG.Approval<-APXAPRVLUpdate the Dist Base Amounts .

Plz help me .

Regards,

Anand

Dear Anand,

There are 2 types of checks u need to done.

1. In payables Option Invoice tab check whether Use invoice approval process is enabled or not, if it is enabled, you need to forward it to approval person,


2. check in budgets whether sufficent fundas or available for that expense account.


regards
Anjani Kumar

Hi,

U can also check these options.

1) R U Enablee Allow Online Validation in payable options invoice tab

2) If your using approved supplier list check whether this supplier is in approved list.

Hi Anjani / Manmohan ,

In payable option Use invoice approval process and Allow Online Validation is checked . Earlier I use to book invoice and pay them for this particular supplier . All of the sudden this problem came.

Also we are not using ASL or approved supplier list .

Plz tell me how to check in budgets whether sufficient funds are available for that expense account .

Regards,

Anand

Seems you are using Indian localization so you need to check metalink Note:462545.1.

Oracle Application - India Localization - Version: 11.5.10.2
This problem can occur on any platform.
FORM:APXINWKB.FMB - Invoice Workbench

Thanks