Error "APP-AR-11526 Encountered an error in JAi_AR_TAX_DET_PKG .determine_manual_ar_tax. Unexpected exception ORA-01400: cannot insert null into JA.JAI_RGM_RECOVERY_LINES.EVENT_TYPE_CODE" while Completing Imported AR Transaction With GST Taxes (Doc ID 2751679.1)

Last updated on SEPTEMBER 27, 2024

Applies to:

Symptoms

When attempting to Complete AR credit memo,
the following error occurs.

ERROR
-----------------------
An unexpected error has occurred. Please contact your system administrator

Encountered an error in JAI_AR_TAX_DET_PKG.determine_manual_ar_tax.
Unexcepted exception: ORA-01400: cannot insert NULL into
("JA"."JAI_RGM_RECOVERY_LINES"."EVENT_TYPE_CODE")


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Oracle Receivables
2. Transaction > Transactions > Create a Credit memo
3. Try completing the credit memo.

Cause

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