FRM-40735: PRE-INSERT Trigger Unexpected Exception ORA-06502 While Saving Invoice Line

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

Last updated on MARCH 16, 2017

Applies to:

Oracle Payables - Version 12.1.1 and later
Information in this document applies to any platform.

On Version 12.1.1 and above

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

STEPS

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

	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