Fusion PIM: Using CreationDate as Parameter in FindItem Method of ADF Service: ItemServiceV2

(Doc ID 2051610.1)

Last updated on MARCH 11, 2016

Applies to:

Oracle Fusion Product Model - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.9.2.0 version, Import Items

When attempting to perform a date delimited fetch through ItemServiceV2
the following error occurs.

ERROR
-----------------------
JBO-56010: Comparision Operation > is invalid for ViewCriteriaItem of attribute CreationDate.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
We are using web service Item Service V2 for finding items in Oracle Fusion apps.
While passing the attribute parameter creationDate in request payload we want to find items that were created in between a date range.
When we try to pass operator as < (>), > (<) or between we get below error:



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