My Oracle Support Banner

Uploading Attachments to OTM With Four Digit File Extensions (i.e. XLXS and DOCX) Fails (Doc ID 1522290.1)

Last updated on JULY 06, 2020

Applies to:

Oracle Transportation Management - Version 6.0 and later
Information in this document applies to any platform.


OTM is not accepting .xlxs extension files when trying to upload using "business process automation" menu in OTM .
it accepts the files with extension XLS and DOC but not XLXS and DOCX.We get the error "GLOGOWNER"."DOCUMENT"."DOCUMENT_MIME_TYPE".

The issue can be reproduced at will with the following steps:

1 - Log onto an OTM system.
2 - Navigate to: Business Process Automation > Document Manager > New > Document detail.
3 - Enter an ID
4 - Click Upload.
5 - Navigate to and selecte the .xlsx file.
6 - Click Upload.
7 - The Mime Type field is autopopulated with:
8 - Click Finished.

Get Error
2013-01-15 05:11:42.353 214218 Error Exception insert into document 
 java.sql.SQLException: ORA-12899: value too large for column "GLOGOWNER"."DOCUMENT"."DOCUMENT_MIME_TYPE" (actual: 65, maximum: 50)

java.sql.SQLException: ORA-12899: value too large for column "GLOGOWNER"."DOCUMENT"."DOCUMENT_MIME_TYPE" (actual: 65, maximum: 50)


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.