Argus Safety 8.0.1 Multi-tenant - BI Publisher 11g Reports Fail Submitting From Argus Safety

(Doc ID 2314862.1)

Last updated on NOVEMBER 20, 2017

Applies to:

Oracle Argus Safety - Version 8.0.1 and later
Information in this document applies to any platform.

Goal

 BI publisher PBRER/DSUR and other BI Reports fail when submitting from Argus using tenants.


Trying to process a DSUR report using BIP, the process does not complete.
It hangs/fails at the point of "Request submitted to BIP for report Executing".

The issue is not observed for the Master tenant, but it is observed for other tenants

Checking the bipublisher log file we find the following error:

[INSTANCE_JOB_ID=1102] oracle.xdo.XDOException: oracle.xdo.XDOException:
java.sql.SQLException: ORA-20010: PKG_AGG_RPT.f_before_data - EnterpriseID
is not selected[[
ORA-06512: at "BIP_OWNER.PKG_AGG_RPT", line 2581
ORA-06512: at line 4

Steps to Reproduce

  1. Log into 'Argus Global Application'
  2. Navigate to 'Global Enterprise Management' Tab and click on 'Add New Enterprise' button
  3. Add the 'Enterprise Name', 'Enterprise Short Name' and contact Information and click on Next button
  4. In the 'Argus Safety Copy Configuration Data Source Sub tab', select 'Copy Enterprise Configuration From' Master tenant
  5. Click on Create button and then click on Next button
  6. 'Available users to copy' will be displayed under the 'Associate Users' tab
  7. Select enterprise and add users from 'Available users to copy' to 'Users associated to this Enterprise'
  8. Click on Save and click on OK in the popup message window
  9. Navigate to 'Application Access' tab, select the new Enterprise created in the Enterprise Dropdown and click on Open button
  10. Navigate to Reports > Periodic Reports > CTPR
  11. Create a new PBRER or DSUR report
  12. Click Print, In Report Batch Printing > Run Using field, select BI Publisher
  13. Navigate to Reports > Compliance > Background Periodic Report Status, observe status sits at "Executing" at step "Request submitted to BIP for report Executing"

Solution

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