My Oracle Support Banner

INVTOTRX - ORA-01403 Finding Replenishment Move Orders Because Users Deleted Kanban Cards With Status 'IN PROCESS' And Orphan Open Move Order (Doc ID 219518.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Inventory Management - Version 11.5.10.CU2 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
Form:INVTOTRX.FMB - Transact Move Orders
Form:INVKBCRD.FMB - Kanban Cards


Symptoms

Querying move orders results in the following error.
Creating Kanban Replenishment Move Orders and subsequently transacting them in Transact Move Orders Screen.

Error
ORA-01403: no data found.
FRM-40735: POST-QUERY trigger raised unhandled exception ORA-01403.


Steps
1. Create Kanban Replenishment Move Order
2. Go back to the Kanban cards you created
3. Change one of the cards status to cancel
4. Delete the card
5. Try to transact the move order for the above kanban
6. Receive the 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.