My Oracle Support Banner

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

Last updated on SEPTEMBER 07, 2021

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

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.