Last updated on AUGUST 21, 2016
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.
Following error is appearing during Cycle Count Entry
APP-FND-01048: Use of this combination is restricted by WHERE clause '(EXISTS (SELECT ITEMS.INVENTORY_ITEM_ID
FROM MTL_CYCLE_COUNT_ITEMS ITEMS, MTL_CYCLE_COUNT_HEADERS HEADERS
WHERE ITEMS.CYCLE_COUNT_HEADER_ID = :cc_manual_schedules.CYCLE_COUNT_HEADER_ID AND ITEMS.INVENTORY_ITEM_ID = MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID AND (MTL_SYSTEM_ITEMS_B.SERIAL_NUMBER_CONTROL_CODE in (1, 6) or (HEADERS.SERIAL_COUNT_OPTION != 1 AND MTL_SYSTEM_ITEMS_B.SERIAL_NUMBER_CONTROL_CODE not in (1, 6)))) ) '
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