My Oracle Support Banner

CREATED_BY and LAST_UPDATED_BY Audit Columns in XDO_LOBS Are Not Populated Correctly (Doc ID 750476.1)

Last updated on FEBRUARY 19, 2024

Applies to:

BI Publisher (formerly XML Publisher) - Version 11.5 to 11.5 [Release 11.5]
Information in this document applies to any platform.
Oracle XML Publisher - Version: 11.5.10
04-Mar-2010


Symptoms

When reviewing audit columns in  XML/BI Publisher table XDO_LOBS discovered the CREATED_BY and LAST_UPDATED_BY columns contains incorrect data.  Columns do not match the FND_USER.USER_ID in XDO_TEMPLATES_TL and XDO_TEMPLATES_B.

Steps to Reproduce:
The issue can be reproduced at will with the following steps:
1. Make a change to a Administrator Template record or add a new record in the Templates form of XML/BI Publisher Administrator.
2. Query the tables xdo_templates_b, xdo_templates_tl amd xdo_lobs to check the columns data.
.

Changes

 

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
Changes
Cause
Solution
References

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