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

(Doc ID 1522290.1)

Last updated on MAY 01, 2017

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 (document_gid,document_xid,document_def_gid,document_url,document_type,document_mime_type,document_distribution_gid,document_filename,requested_audit_trail_gid,requested_time,received_time,owner_data_query_type_gid,owner_object_gid,usage_type,domain_name,report_gid) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?); [GECORP.TEST-001, TEST-001, null, null, BLOB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet, null, test.xlsx, null, null, 2013-01-15 10:11:42 UTC, ORDER RELEASE, GECORP.410000368-002, ATTACHMENT, GECORP, null]
 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)


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