APP-FND-01048: Use of this combination restricted by WHERE clause ' ( nvl(disable_date, sysdate + 1)> sysdate AND category_id IN when adding a new purchasing category on Category Associations Form
Last updated on OCTOBER 28, 2016
Applies to:Oracle Enterprise Asset Management - Version 11.5.10 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 29-Sep-2013***
When attempting to associate purchasing category: 17.40.21-NIE for structure Name: PKWIU with maintenance cost element on Category Associations Form (CSTFCCEEA), the following error occurs.
APP-FND-01048: Use of this combination restricted by WHERE clause ' ( nvl(disable_date, sysdate + 1) > sysdate AND category_id IN (select category_id from mtl_category_set_valid_cats where category_set_id = :parameter.category_set_id) ) '.
APP-FND-01388: Cannot read value for profile option FND_INDICATOR_COLORS in routine &ROUTINE.
The issue can be reproduced at will with the following steps:
1. Enterprise Asset Management Responsibility
setup => category Associations => New (B)
Purchasing Category : 17.40.21-NIE
OK => error message shows up
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms