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 laterInformation in this document applies to any platform.
Symptoms
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:
Responsibility: Receivables
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:
EXCEPTION: ar_process_adjustment.insert_adjustment()
EXCEPTION: arp_process_adjustment.insert_adjust_cover()
******************************
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.
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 |
1. Bug Summary |
2. Fixed Files |
3. Recommended Patches |
4. Solution Steps |
Still Have Questions? |
References |