Error when Adjusting Tax in Invoice FRM-40735 ON-INSERT Trigger ORA-01403

Last updated on SEPTEMBER 07, 2017

Applies to:

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.

Changes

Cause