WIP Issue Transaction Error - APP-FND-01048: Use of this Combination Restricted (Doc ID 2923780.1)

Last updated on MARCH 08, 2023

Applies to:

Symptoms

When trying to select Subinventory during WIP issue, the following error occurs.

ERROR

APP-FND-01048: Use of this combination restricted by WHERE clause ' ( inventory_item_id in (select wro.inventory_item_id from wip_requirement_operations wro, wip_operations wo,wip_entities we where wro.organization_id = 226 and wro.wip_entity_id = 8172398 and wo.wip_entity_id = wro.wip_entity_id and we.wip_entity_id = wro.wip_entity_id and wo.operation_seq_num = wro.operation_seq_num and (we.entity_type <> 5 or (we.entity_type = 5 and nvl(wo.disable_date,sysdate+1) > sysdate) ) and wro.repetitive_schedule_id is null and ((1 = 1 and wro.wip_supply_type = 1 and wro.quantity_per_assembly > 0) or (1 = 33 and wro.wip_supply_type = 1 and wro.quantity_per_assembly < 0) or (1 = 2 and wro.wip_supply_type in (2,3)) or (1 = 27 and wro.wip_supply_type = 1 and wro.quantity_issued > 0 and wro.quantity_per_assembly >= 0) or (1 = 34 and wro.wip_supply_type = 1 and wro.quantity_per_assembly < 0 and wro.quantity_issued < 0))) ) '.
--------------------------------------------------------------
ORA-01403: no data found

 
STEPS

1. Responsibility: Work in Process
2. Go to WIP Material Transaction form
3. Enter job number and transaction type wip issue
4. Select subinventory
5. Click on continue and receive the above error

Cause

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