BI Publisher Siebel Reports are Failing with SBL-RPT-50524 for Other Users Than SADMIN in Newly Created Environment (Doc ID 2889390.1)

Last updated on AUGUST 16, 2022

Applies to:

Symptoms

In a newly created environment, the Siebel-BIP reports' executions are successful for SADMIN user but are failing for any other user. The errors are highlighted in the XMLPReportServer_<timestamp>.log:

Also, it has been observed that once a report is generated as SADMIN user, the same report is working for any other user.

The issue can be reproduced at will with the following steps:
1. Integrate Siebel with BI Publisher (by following Doc ID 2332902.1).
2. Upload and associate with views the report templates.
3. Run reports.

Changes

Not providing XMLP* responsibilities in new Siebel-BIP environment.

OR

Accidentally remove XMLP* responsibilities.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.