While applying prepayment getting Error : Application cannot be done as thier is no TDS attached in STD invoice

(Doc ID 2239308.1)

Last updated on NOVEMBER 07, 2017

Applies to:

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

Symptoms

On : 12.2.4 version, India AP Localizations

Unable to apply prepayment

Getting below message while applying prepayment. Screen shot attached for reference

APP-SQLAP-10000 System Could Not Create Ta Occurred Apply_Prepay_line
ERROR
-----------------------
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 :
Application cannot be done as thier is no TDS attached in STD invoice




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create standard invoice with TDS
2. Create prepayment invoice with TDS
3. Try to apply prepayment on standard invoice and check the result

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot apply prepayment on standard invoice

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