My Oracle Support Banner

RTM Allows More Than Maximum Characters for Voyage_flt_id Resulting In ORA-12899 Error (Doc ID 2458288.1)

Last updated on FEBRUARY 26, 2019

Applies to:

Oracle Retail Trade Management - Version 16.0 and later
Information in this document applies to any platform.


The issue described in this document is known to Oracle, and a fix already scheduled for future release.

This article will be updated as official patch information becomes available.


On: Oracle Retail Trade Management (RTM) 16.0.1 version, Transportation - Setup Transportation

Actual Behavior

The application allows more than the maximum allowed 10 characters for the Voyage/Flight (voyage_flt_id of the TRANSPORTATION table). As a result, the Create Transportation by Order task throws the ORA-12899 error.

Expected Behavior
The application should handle the size limitation of the voyage_flt_id not to exceed the defined maximum characters of 10.

Steps to Reproduce
The issue can be reproduced at will with the following steps:
1. Open "Create Transportation by Order" task.
2. Fill the field "Voyage/Flight" with a value that has characters more than 10.
3. Click on the "Details" button.
4. Notice the ORA-12899 Error.


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.