FRM-40735: PRE-INSERT Trigger Unexpected Exception ORA-06502 While Saving Invoice Line (Doc ID 2087031.1)

Last updated on JULY 10, 2020

Applies to:

Symptoms

PRE-INSERT TRIGGER throws ORA-06502 exception when adding a new line on a existing invoice

Issue can be reproduced by adding a new line on a existing invoice.
When user tries to save the below message appears:

FRM-40735: PRE-INSERT Trigger Unexpected Exception ORA-06502

When user enters a new line in existing invoice, the approval status of invoice is changed to Needs Reapproval.
This value is more than 30 characters

Cause

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