Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forum› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OAC Classic WRITEBACK functionality

Accepted answer
41
Views
2
Comments
user5741487
user5741487 Rank 1 - Community Starter
in Oracle Analytics Forum

When using WRITEBACK, can the OAC userid be captured and used in the XML template to store in the target table who made the update? If so, how is that specified in the XML template? Similarly, can we use sysdate in the XML template to store the timestamp of when the update was made?

Best Answer

  • GayathriAnand-Oracle
    GayathriAnand-Oracle Mod
    Answer ✓

    You can expose 2 additional columns in the report which are non-editable columns - one will have formula for USER session variable and other for repository variable (which would capture sysdate) and include these column ids or position in the insert template.

Answers

  • user5741487
    user5741487 Rank 1 - Community Starter

    Thank you GayathriAnand, your suggestion worked well for what I needed to do. Created a custom column in the analysis with the formula: valueof(NQ_SESSION.USER). And in the XML, i use sysdate right in the SQL to capture the date/time of the update.