Receipt Batch Fails When Applying to a Claims Investigation - FRM-40735 ON-INSERT Trigger Raised Unhandled Exception ORA-29470 (Doc ID 1669882.1)

Last updated on JUNE 07, 2016

Applies to:

Oracle Receivables - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.

Symptoms

Attempting to create a Receipt Batch and then enter the receipt details, apply the receipt to a few transactions and then to a Claims Investigation, and receive the following error:

FRM-40735: ON-INSERT trigger raised unhandled exception ORA-29470

This error happens only when a receipt is created from Receipt Batch form.
Receipts created from the Receipt Workbench doesn't show any errors when creating a claims investigation.

Steps to Reproduce:
Responsibility: Receivables Manager
Navigation
: Receipts > Batches
Create Receipt Batch

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