Error ORA-01403, FRM-40735: POST-INSERT trigger raised unhandled exception ORA-06508 While Creating Items (INVIDITM)

(Doc ID 2066771.1)

Last updated on MAY 18, 2016

Applies to:

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


On : 12.1.3 version, Item Issues

When attempting to create items through the Master Item form (INVIDITM), the following error occurs at saving.

ORA-01403: no data found
FRM-40735: POST-INSERT trigger raised unhandled exception ORA-06508.

The issue can be reproduced at will with the following steps:
1. Go to Inventory: (N) Items : Master Items
2. Create a new item
3. Save
Getting the reported error


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