Categories
xlsx generated from BIP need MIME type as application/vnd.openxmlformats-officedocument.spreadsheet
Excel output (.xlsx) generated from BI Publisher/Oracle Analytics Publisher has MIME Tyep set to “application/zip”. There was no issue in opening this excel output generated from BI Publisher in Excel. But, when tried to associate this generated Excel Output from Oracle Transportation Management Cloud (OTM) application, getting error
--------
Error: The uploaded file NSBP.OU I 164NSBP_CUSTOMER_BILL_ANNEXURE_FINAL has invalid contents of type application/zip and mentioning
(allowedTypes=[application/xml, image/png, application/msword, application/pdf, application/vnd.ms-word, image/jpeg, application/x-tika-ooxml, image/gif, text/xml, application/vnd.openxmlformats-officedocument.wordprocessingml.document, application/x-tika-msoffice, text/html, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet, image/tiff, text/csv, application/vnd.ms-excel, image/x-wap-wbmp, text/plain]) Acceptable types of files are: [application/xml, image/png, application/msword, application/pdf, application/vnd.ms-word, image/jpeg, application/x-tika-ooxml, image/gif, text/xml, application/vnd.openxmlformats-officedocument.wordprocessingml.document, application/x-tika-msoffice, text/html, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet, image/tiff, text/csv, application/vnd.ms-excel, image/x-wap-wbmp, text/plain] (actualType=application/zip, file=NSBP.OU I 164NSBP_CUSTOMER_BILL_ANNEXURE_FINAL)
-----------------------
OTM team is in urgent need and is looking for mime type as “application/vnd.openxmlformats-officedocument.spreadsheetml.sheet” for the excel output (.xlsx) from BIP/OAP.