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 MARCH 29, 2019

Applies to:

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

Symptoms

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:
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
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)

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.