Reservation Details Not Visible when SO Line Status Is 'External Req Open' in INVRSVF1

(Doc ID 2114780.1)

Last updated on JUNE 14, 2016

Applies to:

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


After the application of patch 21119209:R12.INV.B, in the Item Reservations form INVRSVF1.fmb Supply Tab, the Reservation details are not visible when Sales Order Line status is 'External Req Open', returning below error when querying:

FRM-40375: POST-QUERY trigger raised unhandled exception ORA-01403.

The issue can be reproduced at will with the following steps:
1. Go to: Inventory
2. Navigate to: On-hand, Availability > Reservations
3. Query by organization and get error


Patch 21119209:R12.INV.B


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