My Oracle Support Banner

Schedule Report In OBI Publisher 12c With SQL Authenticator Error: ScheduleJob.execute :: Failed to impersonate user (Doc ID 2565405.1)

Last updated on SEPTEMBER 27, 2019

Applies to:

BI Publisher (formerly XML Publisher) - Version 12c to 12c [Release 12.0]
Information in this document applies to any platform.


On 12c version, Enterprise : Scheduler
When attempting to schedule a report in BI Publisher when using the database as the authentication provider (SQL Authenticator),
the following error occurs in the bipublisher.log:

The issue can be reproduced at will with the following steps:
1. Configure a custom SQL Authenticator.
2. Schedule a report with any user other than the weblogic user.

The issue has the following business impact:
Due to this issue, users cannot schedule reports in the newly built production environment




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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