R12:AP:Payables Open Interface Import Error JAI_AP_IDA_TRIGGER_DTC_PKG.BRIUD_DTC_T1 "Application Cannot Be Done As Their Is No TDS Attached In Standard Invoice" JAI_TAX_PROCESSING_PKG.DETERMINE_RECOVERY RETURN_STATUS:E
(Doc ID 3008878.1)
Last updated on OCTOBER 23, 2024
Applies to:
Oracle Payables - Version 12.2.11 and laterOracle Financials for India - Version 12.2.11 and later
Information in this document applies to any platform.
Symptoms
While Importing Standard invoices with prepayment application having TDS on prepayment invoice through Payables import program, the Payables open interface import program is getting completed with following 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
JAI_TAX_PROCESSING_PKG.DETERMINE_RECOVERY RETURN_STATUS = E
Expected Error raised for Trx_id58183188
Return Status after Recovery Determination : E
The issue is occurring when the prepayment references are used in AP Interface table.This would allow prepayment application during import of invoices, but the TDS information is not populated on the standard invoice in the AP Interface table. The prepayment application is happening during execution of Payables open Interface Import program.
The issue can be reproduced at will with the following steps:
1.Populate the Invoice header and line information on AP Interface tables(i.e in AP_INVOICES_INTERFACE,AP_INVOICE_LINES_INTERFACE)
2.Navigate to Payables responsibility.
3.Submit the Payables Open Interface Import program.
4.The Payables open interface import program is getting completed with error.
Changes
Upgrade from 12.1.3 to 12.2.11
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 |