Is the COE What-If Data Case Sensitive?

(Doc ID 2119727.1)

Last updated on MARCH 24, 2016

Applies to:

Oracle Retail Clearance Optimization Engine - Version 14.0.3 and later
Information in this document applies to any platform.


On merchandise_hierarchy_tbl.client_load_id, the value is uppercase.  However, the What-If web service sends the merchandise and location keys in lowercase.  The Oracle Retail Clearance Optimization Engine (COE) query to check whether the received product/location exists fails due to this case sensitivity.  What should be done to resolve this?


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