E-BI Publisher: BI Publisher Audit Entries Are Not Captured In Database Schema DEV_IAU_VIEWER.BIPUBLISHER_V and Generated Unable to get a Unique Sequence Number using query:SELECT ID_SEQ.NEXTVAL FROM DUAL Error
(Doc ID 2742095.1)
Last updated on FEBRUARY 05, 2025
Applies to:
BI Publisher (formerly XML Publisher) - Version 12c to 12c [Release 12.0]Information in this document applies to any platform.
Symptoms
Recently moved BI publisher Repository from 12c database server to other 19c database server.
Audit entries are not captured in database schema dev_iau_viewer.BIPublisher_v.
Captured below error:
The issue can be reproduced at will with the following steps:
1. Migrate database from 12c to 19c.
2. Check BI Publisher audit entries.
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |