My Oracle Support Banner

Error "ORA-01400: cannot insert NULL into ("AR"."RA_INTERFACE_LINES_ALL"."CURRENCY_CODE")" While Saving AR TDS (Tax Deducted at Source) Certificates Form. (Doc ID 2793788.1)

Last updated on AUGUST 26, 2021

Applies to:

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


When attempting to save TDS Collection form,
the following error occurs.

ORA-01400: cannot insert NULL into ("AR"."RA_INTERFACE_LINES_ALL"."CURRENCY_CODE")
FRM-40735: ON-INSERT trigger raised unhandled exception ORA-01400.

The issue can be reproduced at will with the following steps:
1. Navigate to India Local Receivables
2. India Localization > Collection > TDS Certificates
3. Provide details and save. Observe error


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

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