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

Last updated on MARCH 13, 2017

Applies to:

Oracle Work in Process - Version 11.5.10.2 and later
Information in this document applies to any platform.
***Checked for relevance on 29-MAY-2012***

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.

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