1. Report Designer's Guide
  2. Report System

Report System

Reports in Transportation and Global Trade Management Cloud are always associated with a report system type that defines the communication type between Transportation and Global Trade Management Cloud and the external report server. The following report systems are supported in Transportation and Global Trade Management Cloud:

  • BI Publisher: A SOAP request is sent to the Oracle Analytics Publisher service and the SOAP response is parsed for content and errors. It includes details of the Oracle Analytics Server, such as report path prefix, host, port, and user credentials. These account for format, locale, and VPD user information.
  • Other via HTTP: Use Other via HTTP for non-Oracle Analytics Publisher integrations. It is assumed that the report path is a URL to the report with an optional {report} parameter that is replaced with the report path. This URL report parameter is appended as HTTP request parameters. Each request parameter name matches the name of the report parameter. This includes setting &P_DESIRED_MIME_TYPE=<requested MIME type>.
  • Oracle Analytics Cloud: For generating Reports or Documents from Oracle Transportation Management configured with Oracle Analytics Cloud, you need to add a user in the "DEFAULT" Report System as follows:
    1. Create a User in the Oracle Transportation Management User Manager.
      1. In the Nickname field enter an ID like “bipreportuser-prod” and your email address*.
      2. Add the "BICONSUMER” Business Intelligence Role.
      3. Run the Synchronize User action to create the user in IDCS (Oracle Identity Cloud Service).
    2. After you receive the Welcome Email for the new user, reset the password and sign in to IDCS.
    3. Sign into OTM as a user with the "DBA Admin" Role and navigate to Business Process Automation > Power Data > Document Generation > Report Systems.
    4. Search for the "DEFAULT" Report System.
      1. Edit that record.
      2. Add the username (not email address) created in step # 1 and the password created in Step #2.
      3. Click Finished.
    Note: You should create a different user for each OTM Production, Test and Development Environment.

It is strongly recommended that you use Oracle Analytics Publisher as the report system type. This document describes the information pertaining to the Oracle Analytics Publisher report system type.