My Oracle Support Banner

FLUID/ MOBILE "Advanced Search" Changes Item Value to Datetimestamp Value in DB2 Environment (Doc ID 2286274.1)

Last updated on NOVEMBER 23, 2019

Applies to:

PeopleSoft Enterprise SCM eProcurement - Version 9.2 and later
Information in this document applies to any platform.


When utilizing Mobile/ Fluid "Advanced Search" while creating an ePro Requisition in a DB2LUW environment, INV_ITEM_ID is seen as a date and applying a datetimestamp format to it.

Steps to Replicate:

1. Log into DB2LUW environment
2. Configure system for Fluid/ Mobile navigation
3. In Advanced Item Search > Description enter a portion of item description
4. Get error message: 'A fatal PeopleCode SQL error occurred. Please consult your system log for details'
5. When reviewing the trace, find that datetime is being substituted into an INV_ITEM_ID


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

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