My Oracle Support Banner

Error "Private API: Create_Offer_Adjustmentstart" And "The input parameter for the API call did not include a comparison operator for the WHERE clause." When Creating Offer Adjustment (Doc ID 2639567.1)

Last updated on FEBRUARY 18, 2020

Applies to:

Oracle Trade Management - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

On : 11.5.10.2 version, Offers

On a specific accrual offer, when creating adjustment, receiving following error message


ERROR
-----------------------


Private API: Create_Offer_Adjustmentstart
Private API: Validate_Offer_Adjustment
Inside Uk_Items::Create
The input parameter for the API call did not include a comparison operator
for the WHERE clause.



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to Applications
2. Go to Oracle Trade Management User responsibility
3. Navigate to Trade Planning > Offer > xxxx AND yyyy  >Adjustment > Adjustment
Offer Adjustments
  Offer Name: xxxx  AND yyyy

Observe the above error



Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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