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

Last updated on JULY 12, 2017

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information 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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms