Reserving More than One Line for Sales Order Generates Error: APP-FND-1048 Use of This Combination Restricted by Where Clause '(RESERVABLE_TYPE = 1) and inventory_item_id = nvl(:parameter.inventory_item_id, inventory_item_id) ); '

(Doc ID 1450769.1)

Last updated on AUGUST 05, 2015

Applies to:

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


On : 12.1.3 version, Onhand and Availability

When attempting to reserve the Sales order with more than one line from reservation form, got following error:

Error :APP-FND-1048 Use of this combination restricted by WHERE clause ' (RESERVABLE_TYPE = 1 and inventory_item_id = nvl(:parameter.inventory_item_id, inventory_item_id) ); '



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

1. Inventory>On Hand, Availability>Reservations

2. Reserve the Sales order with more than one line from reservation form




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