Getting error in material requirements form APP-FND-01048: Use of this combination restricted by WHERE clause (Doc ID 1128863.1)

Last updated on AUGUST 25, 2020

Applies to:

Symptoms

When attempting to change the basis in Material Requirement form from the Discrete job form, the following error occurs.

ERROR

APP-FND-01048: Use of this combination restricted by WHERE clause ' (((:WIPMRMDF_CONTROL.see_eng_items_flag = 2 AND ENG_ITEM_FLAG = 'N')
OR (:WIPMRMDF_CONTROL.see_eng_items_flag = 1))
AND BOM_ENABLED_FLAG = 'Y' AND
(PJM_UNIT_EFF.UNIT_EFFECTIVE_ITEM(INVENTORY_ITEM_ID,
ORGANIZATION_ID) = 'N')
AND BOM_ITEM_TYPE = 4 ) '.

STEPS

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

1. WIP>DISCRETE>Discrete job > Fetch the job
2. Click on Components button
3.Click on UOM / per assembly and see the error.

Changes

Cause

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