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 AI and Analytics

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

Top Leaders

Gianni Ceresa 329

Malik Sikandar Hayat 155

Brendan T 105

bae15 105

User_TD15Q 75

Top Posts

OAS 2026 SSO/SAML Configuration Documentation
Hi Team, We would like to raise an enhancement request for the SSO/SAML configuration guidance for OAS 2026. We have already raised multiple SRs regarding OAS 2026 SSO configuration. However, we are facing difficulties getting the required guidance, as the available documentation does not clearly cover the OAS 2026 SSO…
Historical Reporting in OAC
We are planning to archive the Contract and Lease data currently sourced from the External Source as Contract and Lease accounting functions are being migrated to Oracle's CLM and Lease Accounting modules. At this stage, only active and partially closed records are being converted into Oracle and the remaining historical…
Trying to average a calculation row in a table
The difference column is a calculation, and I would like to average that row.
Complex filter issue. How do I do this
We are trying to convert our OAS reports to OAC and one of the parameters in the where clause of the report is what I am trying to make in OAC. I created a calculation as follows and I am trying to put it into a filter . The code validates EVALUATE('GREATEST ( TRUNC ( NVL (%1, TO_DATE (''1/1/2013'', ''mm/dd/yyyy'') ) ),…
Parameter Referencing is not working in OACS DV
Hi , I am calling one parameter in another parameter and it is not working. 1st parameter is showing values, while calling the 1st parameter in second it is not showing any values. Regards, Sree Hari M