APP-FND-1048 : Use of This Combination Restricted Error Message When Submitting Charges

(Doc ID 1265954.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Teleservice - Version and later
Information in this document applies to any platform.
***Checked for relevance on 07-Jan-2014***


When attempting to submit charges of a particular item in charges tab of SR form (CSXSRISR.fmb)
the following error occurs.

APP-FND-01048: Use of this combination restricted by WHERE clause ' ( ORGANIZATION_ID = cs_std.Get_Item_Valdn_Orgzn_Id AND MATERIAL_BILLABLE_FLAG IN (SELECT bc.billing_type FROM cs_billing_type_categories bc, cs_txn_billing_types bt WHERE sysdate between nvl(bc.start_date_active,sysdate) and nvl(bc.end_date_active,sysdate) AND sysdate between nvl(bt.start_date_active,sysdate) and nvl(bt.end_date_active,sysdate) AND bt.billing_type = bc.billing_type AND bt.transaction_type_id = nvl('12', bt.transaction_type_id) AND bc.billing_type = nvl('E', bc.billing_type)) ) '

The issue can be reproduced at will with the following steps:
Find SR form--> Charges tab--> save the record


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