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 (Doc ID 1269015.1)

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***

Symptoms

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.


ERROR

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.


STEPS

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

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