Material Workbench (INVMWBIV) Facing Error: "FRM-40735: APPTREE_EVENT trigger raised unhandled exception ORA-01006" (Doc ID 2087331.1)

Last updated on DECEMBER 14, 2015

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Problem Statement
When attempting to search on-hand quantity at Material Workbench form, the following error occurs.

Error
FRM-40735: APPTREE_EVENT trigger raised unhandled exception ORA-01006.

Steps to Reproduce

  1. Navigate to Inventory : On-hand, Availability > On-hand Quantity
    The search form of Material Workbench shows.
  2. Select Organization
  3. Select Item
  4. Check Material Locations:
    - On-hand
    - Receiving
    - Inbound

    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