Error when Adjusting Tax in Invoice FRM-40735 ON-INSERT Trigger ORA-01403 (Doc ID 2126892.1)

Last updated on DECEMBER 03, 2019

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.

Cause

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