Report Generation

Report generation in Transportation and Global Trade Management Cloud can be triggered as follows:

• Ad Hoc Reports: For ad hoc reports, an HTTP request is sent to the application server which sends an HTTP request to the report server and assumes the response, if successful, contains report content. This content is piped back through HTTP to the browser. The content may also be distributed via email, IPP printing, and/or stored with an associated business object.
• Scheduled Reports: Scheduled report requests, or requests triggered by a workflow agent, similarly send a HTTP request to the report server. The response content is distributed via email, printed via IPP, or stored with an associated business object. The scheduling of the reports has nothing to do with the scheduling capabilities of the external report server. The scheduling is Transportation and Global Trade Management Cloud’s own scheduling which is used for forming the report requests and receiving the response.

Streamlined support is available when generating reports on a remote Oracle Analytics Publisher server or a server farm. Requests are sent directly from the application server to Oracle Analytics Publisher via a SOAP web service call. Results or errors are returned by the service.

Report Formats: In Oracle Analytics Cloud, the following report formats aren't supported while generating reports from Oracle Analytics Publisher and Oracle Transportation Management:

• Excel (html): Web page
• Excel (mhtml): Single File Web Page
• Excel (.xls): Excel 97-2003 Workbook

Any report in OTM or BI Publisher using these report formats will need to be updated to work.