INVTVTXN - Receive Error "FRM-40735: POST-QUERY trigger raised unhandled exceptions ORA-01403" When Viewing Material Transactions

(Doc ID 1306504.1)

Last updated on SEPTEMBER 10, 2015

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.
Form:INVTVTXN.FMB - View Transactions


Symptoms

The View Transactions form (Material Transactions form) issues the following error when querying some receipt transactions.
The issue occurs when the source of the transaction belongs to a different operating unit to which the current responsibility or user does NOT have access.

Error

FRM-40735: POST-QUERY trigger raised unhandled exceptions ORA-01403


Steps

Video - Showing Example Error (03:09)

  1. Create a Purchase Order in one operating unit.
  2. Receive the material.
  3. View material transactions.
  4. Works fine so far.
  5. Change to a different responsibility that uses another operating unit.
  6. View material transactions.
  7. Receive the error.

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