My Oracle Support Banner

Receive Error 'ORA-01403: no data found' When Attempting To View Organization Item in Item Form (INVIDITM) (Doc ID 977428.1)

Last updated on MAY 23, 2019

Applies to:

Oracle Item Master - Version 11.5.10.0 and later
Information in this document applies to any platform.
FORM:INVIDITM.FMB - Define Item Information


Symptoms

When attempting to access an Organization Item from the Organization Assignment window of Master Item form or from the Organization Item form itself (INVIDITM), the following error occurs.

ORA-01403: no data found
-or-
FRM-40735:When-new-record-instance trigger raised unhandled exception ORA-01403

Steps

  1. Navigate: Inventory > Items > Master Item
  2. Query for an item
  3. View organization assignments: (M) Tools : Organization Assignments
    Notice there are multiple assignments
  4. Select the record for a child organization
  5. Click Org Attributes
  6. Receive the reported error

       Alternatively,

  1. Navigate: Inventory > Items > Organization Items
  2. Query for the item
  3. Receive the reported error

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!


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