Reservation Details Not Visible when SO Line Status Is 'External Req Open' in INVRSVF1
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms