Frequently Asked Questions

Here are some frequently asked questions.

How do I configure Oracle Analytics Publisher reports in Transportation and Global Trade Management Cloud?

This guide talks about this in more detail. Below are the high level steps.

1. Configure the Oracle Analytics Publisher Data Source.
   1. Give data source name as otmoltp
   2. Give the database username as globalreportuser.
2. Design Report in Oracle Analytics Publisher.
   1. Define a data model.
   2. Define a report with layout for the data model.
   3. Test the report using Oracle Analytics Publisher server directly.
3. Define a report system for connecting to the Oracle Analytics Publisher server or use the report system DEFAULT with property macros pointing to glog.bip.externalFarm.* properties.
   • The bi publisher user with which you created a report and user with which you want to access the report need not be the same. Please refer to Understand Publisher Users, Roles, and Permissions, Configure Users, Roles, and Data Access, and Grant Catalog Permissions sections in the Administering Oracle Analytics Publisher in Oracle Analytics Server.
4. Define the report definition with the report system.
   1. Provide the report absolute path. This will be the path in the URL for accessing the report from the Oracle Analytics Publisher server.
   2. Take the Report path prefix defined in the report system into consideration since the absolute path provided for the web service will be a concatenation of the report path prefix and the absolute path given in the report definition.
   3. Define report parameters. The parameter name should match the parameter name defined for the data model in Oracle Analytics Publisher.

Which database user is used for generating reports?

The application uses the database user pointed by the PRIMARY_THIN data source defined in Transportation and Global Trade Management Cloud for generating online reports. Typically it is glogdba.

For generating offline reports which connect to a replicated offline database, the application uses the database user pointed by the ODS data source defined in Transportation and Global Trade Management Cloud.

For generating archive reports which connect to an archive schema, the application uses the database user pointed by the ARCHIVE data source defined in Transportation and Global Trade Management Cloud.

Another important point to note here is the reports run from the Oracle Analytics Publisher server will not have any VPD context applied. Reports run from Transportation and Global Trade Management Cloud run with the VPD Context of the user running the report.

Why do I get Invalid format requested error when trying to view selected format of the report?

After designing the report and registering it with Transportation and Global Trade Management Cloud, when trying to generate the report for a particular format, if there is an error like:

oracle.xdo.webservice.exception.OperationFailedException: PublicReportService::generateReport for reportAbsolutePath [/Reports/pickup_summary/pickup_summary.xdo] failed: due to oracle.xdo.servlet.data.DataException: Invalid format requested: excel2000
[000717] Invalid format requested: excel2000

This is because the report is not enabled for the format being requested.

Follow the steps described in the following link: Part II Create Pixel-Perfect Reports and Layouts

How do I send multiple values for a parameter of the report?

Follow the steps as per the below link

Review the Designing and Publishing Pixel-Perfect Reports in Oracle Analytics Server.

When defining a new parameter enable the check box for Text field contains comma-separated values.

Why do I get OutOfMemoryError: Java heap space?

Transportation and Global Trade Management Cloud is integrated with Oracle Analytics Publisher to send the report requests and receive the generated output as response. Transportation and Global Trade Management Cloud is not equipped to manage very large responses that can be received from the Oracle Analytics Publisher server. Typically Transportation and Global Trade Management Cloud assumes that transactional reports which tie to one business object are configured.

If analytical reports are configured, these reports can return a large amount of data which in turn can occupy the space in the java heap and can lead to OutOfMemoryError.

While Transportation and Global Trade Management Cloud can receive a small amount of data for the transactional reports, it may not have enough space to handle the large amount data that can be generated in case of analytical reports.

It is recommended that you use transactional reports within Transportation and Global Trade Management Cloud for this reason. The analytical report can still be used by leveraging the Oracle Analytics Publisher report server capabilities.

How do I view all of the scheduled reports?

Use the menu link View Scheduled Jobs at Business Process Automation > Reporting > View Scheduled Jobs.

Use Business Process Automation > Reporting > View Completed Jobs to view the report jobs which were generated during the scheduled period.

Note that the scheduling that happens in the application has no relation with the scheduling that Oracle Analytics Publisher provides. Transportation and Global Trade Management Cloud uses the Oracle Analytics Publisher server only to send the report generation SOAP requests.

Scheduled reports are not being received as emails. What should I check?

A scheduled report, even though it got generated, can back up on the mail queue in the application if the mail queue does not have enough threads to process the queued items. The report once generated will be queued up for email processing. The queue used for this is “transport – SMTP”. Check the number of threads given for this queue and check the backlog on this queue. If there are backlog items on the queue, please increase the number of threads for this queue using the following property.

glog.process.threadGroup.mail

By default it has a value of 1. Please increase this value but do not increase it to a high value which will result in burdening of the mailing system.

Why are scheduled reports received as a link and not as an attachment?

Read the online help for Security Level that can be configured for each of the report.

Even if the security level allows you to attach, there is a limit of size of the reports which can be attached. The property that governs this is

glog.notify.report.maxPdfSize

You should also check the property

glog.mail.maxContentSize

Note: This is reserved property and can only be modified via the glog.properties file. This property cannot be modified for the Cloud.

This property defines the maximum content of the email size including any attachments. So if you decide to increase the first property you should check that the limit does not exceed the second property.

How do I generate reports with a bar code?

For information on how to create reports which need to print barcodes, please refer to the 2D Barcode Functions. You will be able to use only three bar code fonts shipped with bi publisher. Please refer to the above documentation for more information.

Why does the report give me the same output for the same set of parameters even though I change the user?

When a report is designed in Oracle Analytics Publisher, you need to pay attention to the caching properties of the reports. If the caching is enabled when you have the same set of parameter the report can be cached for a certain period of time. Please refer to the following link for more details.

See Set Server Caching Specifications in the Administering Oracle Analytics Publisher in Oracle Analytics Server guide.

Though it is a different application user, the report has no way of telling that it is different user unless, the user is also defined as one of the report parameters.

How do I disable report caching?

Please refer to the section “Why does the report give me the same output for the same set of parameters even though I change the user?”