Error when Adjusting Tax in Invoice FRM-40735 ON-INSERT Trigger ORA-01403
(Doc ID 2126892.1)
Last updated on MARCH 14, 2022
Applies to:Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.
You are attempting to adjust only the Tax on an Invoice and receive the following error:
Error FRM-40735: ON-INSERT trigger raised unhandled exception ORA-01403
Steps to Reproduce:
Navigation: Transactions > transactions
1. Query invoice
2. Try to adjust invoice using Type= TAX
Receivable Activity setup = Accounting
GL Account Source = Tax Code on Invoice
Tax Rate Code Source = Invoice (X) Recoverable
Debug log shows the following error:
You have also checked the validation on ASSOCIATED_SALES_REP using the following query:
This shows the PERSON_ID is NULL, as this is an employee, so it is not related to salesrep status.
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
|1. Bug Summary|
|2. Fixed Files|
|3. Recommended Patches|
|4. Solution Steps|
|Still Have Questions?|