nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Writeback user and date

Jack

We have a requirement as to writeback data to DB table and also we have to write back data to table as who and when that data has been inserted or updated

How we can audit who and when writeback data from a report and date in obiee 11g

Find more posts tagged with

Accepted answers

All comments

Thomas Dodds

Well played!

Jack

Thank You for your reply, Can i give user and data directly in writeback template as below

<update>update table set c1='VALUEOF(NQ_SESSION.USER)' ,c2=NOW()</update>

[Deleted User]

Christian Berg wrote:2.) Why not just put the USER variable into a column? VALUEOF(NQ_SESSION.USER)?

^--- Column

Jack

we can use VALUEOF(NQ_SESSION.USER), but that column which i used in report is not able to enable writeback