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
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.
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