My Oracle Support Banner

POST QUERY TRIGGER EXCEPTION ON RECEIVING TRANSACTION SUMMARY FORM (Doc ID 2697589.1)

Last updated on AUGUST 18, 2020

Applies to:

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

Symptoms

On : 12.1.3 version, Receiving

When user is trying to Find - Receiving Transactions Summary they got below error for the details given

ERROR
-----------------------

FRM-40735 : POST-QUERY trigger raised unhandled exception ORA-1403

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1) Navigate to Inventory -> Receiving -> View Receiving Transactions
2) Give Item Details, select Transactions Radio Button
Click on Find
3) Above error is displayed

(Or)


1) Navigate to Inventory -> Receiving -> View Receiving Transactions
2) Give Item Details, select Headers Radio Button
Click on Find
3) Header form open, click on Transactions Button.

4) Form Opens with Item and Transaction Type details as blank.

 

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!


In this Document
Symptoms
Cause
Solution
References


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