Friday, 14 August 2015

APP-FND-01048: Use of this combination restricted by WHERE clause ' ( (DISABLE_DATE > SYSDATE or DISABLE_DATE IS NULL) AND NVL(SUBINVENTORY_CODE,'Z') = NVL _JOBS.Completion_Subinventory,'Z') )



This error message display at the time of create the Discrete work Order.


APP-FND-01048: Use of this combination restricted by WHERE clause ' ( (DISABLE_DATE > SYSDATE or DISABLE_DATE IS NULL) AND NVL(SUBINVENTORY_CODE,'Z') = NVL:)_JOBS.Completion_Subinventory,'Z') )
 
Solution:
Check the supply sub inventory and locators are active.
Navigation path to find the sub inventory
Work In Progress > Discrete > Discrete jobs > Material Control Tab : Sub inventory & Locator.

 
Navigation to find the Sub inventory.
Inventory > Setup > Organization > Sub inventories > Find and check the “Status”

 

Navigation to find the Stock Locator
Inventory > Setup > Organization > Stock Locators > Find and check the “Status”


Change the status as Active and retest it.
 
 



No comments:

Post a Comment