My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References

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