APP-FND-01048 Error During Cycle Count Entry (Doc ID 1910214.1)

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.
INCAAC
INCAAA
INCACI
INCACS

Symptoms

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)))) )  '

Cause

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