Receipt Batch Fails When Applying to a Claims Investigation - FRM-40735 ON-INSERT Trigger Raised Unhandled Exception ORA-29470
Last updated on MAY 15, 2018
Applies to:Oracle Receivables - Version 220.127.116.11 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms