View Transaction Summaries Transaction Details Error FRM-40735: POST-QUERY TRIGGER RAISED UNHANDLED EXCEPTION ORA-01403 Due to Negative Transaction_source_id in MMT (Doc ID 1525054.1)

Last updated on FEBRUARY 01, 2017

Applies to:

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

Symptoms

Steps to reproduce the error:

1. N) Inventory> TRANSACTIONS>TRANSACTIONS SUMMARIES

2. Select an Org, click OK

3. Query an Item, populate Transaction Dates
Click button Summarize, Transaction Summaries Form opens

4. Click button Transactions Details, and get error below:

FRM-40735: POST-QUERY TRIGGER RAISED UNHANDLED EXCEPTIONS ORA-01403

To Troubleshoot:
Go to Help > Diagnostics > Examine (Apps password may be needed)
Go to
block = system
field = last query

Value field: Copy and paste the query that is been run into a tool such as Toad, SQL developer, etc

Review the output, obtain the MMT.Transaction_id from the query and run the query below:

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