How to Increase the URL Field Length for WSH_ITM_VENDOR_SERVICES (Doc ID 2179253.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Shipping Execution - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

Working on an ITM integration project (EBS-GTM).
Have come up against a limitation where the URL field on WSH_ITM_VENDOR_SERVICES has DATA_TYPE VARCHAR2(100 BYTE)
Unfortunately the URL is 105 characters long.

Is there a way or a patch that will allow the URL field to accept longer values? 

Solution

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