Cannot Search 'Order Source Reference' Field For More Than 30 Characters In 'Open Interface Tracking' (Doc ID 2024223.1)

Last updated on JULY 03, 2017

Applies to:

Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Cannot Search 'Order Source Reference' Field For More Than 30 Characters In 'Open Interface Tracking'

The issue is in the form 'Open Interface Tracking' under Import Orders in Order Management. When
trying to search with the value more than 30 characters for the field 'Order Source Reference'.  User
can enter up to 30 characters for the search.  Have to provide date range instead of 'Order Source
Reference' field for searching.

In base table OE_ORDER_Headers_all, the size of the Orig_sys_document_ref is 50. But from front
end we can not enter more than 30 characters.



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