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

(Doc ID 2087031.1)

Last updated on JANUARY 16, 2018

Applies to:

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

Symptoms

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

 



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