My Oracle Support Banner

R12: AP: Attempting to Query TDS Invoices in the Invoice Workbench Errors with FRM-40735: POST-QUERY Trigger Raised Unhandled Exception ORA-01403 (Doc ID 2642185.1)

Last updated on SEPTEMBER 16, 2024

Applies to:

Oracle Payables - Version 12.1.3 to 12.1.3 [Release 12.1]
Oracle Financials for India - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Unable to query TDS invoices in the Invoice Workbench.  When the attempt is made, the following error occurs:

FRM-40735: POST-QUERY trigger raised unhandled exception ORA-01403

The issue can be reproduced at will with the following steps:
1. Navigate to Payables India localization
2. Go to Invoices > Entry > Invoices
3. Try to query the invoice


Can also present as:

On Canceling the Parent invoice,TDS credit memo invoice not getting cancelled
and the status is "Selected for Validation"

Steps to Replicate
------------------
a) Cancel Base Invoice that has TDS applicability 
b) Check the status of TDS credit memo

 

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
Cause
Solution
References


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