My Oracle Support Banner

While Applying Prepayment to Standard Invoice Encountered Error "APP-SQLAP-10000: occurred in Apply_Prepay_Line<-Apply Prepayment Form with parameters (& PARAMETERS) while performing the following operation: Distribute Tax" (Doc ID 2956700.1)

Last updated on JUNE 23, 2023

Applies to:

Oracle Financials for India - Version 12.1 and later
Information in this document applies to any platform.

Symptoms

Encountered Error while applying prepayment Invoice to standard invoice.

ERROR :

Unexpected error occurred during Tax calculation Exception : user-defined exception. Please correct the problem or contact your system administrator.
APP-SQLAP-1000: occurred Apply_Prepay_Line<-Apply Prepayment Form with parameters(&Parameters) while performing the following operation; Distribute Tax

FND Debug log messages:

Encountered an error in JAI_AP_IDA_TRIGGER_DTC_PKG.BRIUD_DTC_T1 Error on ap_invoice_distributions_all : ORA-20007: Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : Error from jai_ap_dtc_generation_pkg.generate_dtc_invoices :ORA-01476: divisor is equal to zero

STEPS:

1. Navigate to India Local Payables --> Invoice --> Invoice.
2. Create  a prepayment and attach applicable TDS(Tax Deduction at Source) section code and tax category manually or default TDS section code using defaulting mechanism.
3. Validate the prepayment and make payment.
4. Now create a Standard Invoice and attach attach applicable TDS section code and tax category manually or default TDS section code using defaulting mechanism.
5. Validate the Standard Invoice and apply prepayment.
6. Observe error.

Changes

 

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


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