APP-FND-1048 : Use of This Combination Restricted Error Message When Submitting Charges (Doc ID 1265954.1)

Last updated on APRIL 10, 2023

Applies to:

Symptoms

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

ERROR
-----------------------
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)) ) '


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

Changes

Cause

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