OBIEE 11G Write Back

Please follow the steps listed below to configure Write Back in OBIEE.

Step1: Enable Write Back. Add the tag below any where in between  the serverinstance tag of instanceconfig.xml


Restart OBIPS for this change to be effective.

Step2: Add WriteBack privileges to the user/Group/Role.

Step3:WriteBack Template.

Things to do before you start the Template:

Identify the colums that are to be referenced. we can use the colum position or by colum id as you see them in the XML definition.
We must include both insert and update stmts in the template.
Make sure we document the template name so that we may not conflict with any other.
Also it is the best practise to include the commit statement( <postUpdate>COMMIT</postUpdate> ).
Template to be placed in the path:

Given below is the writeback template for 5 Colums.

Write-Back Template example:

<?xml version="1.0" encoding="utf-8" ?>
<WebMessageTables xmlns:sawm="">
<WebMessageTable lang="en-us" system="WriteBack" table="Messages">
   <WebMessage name="SetQuotaUseID">
         <writeBack connectionPool="Supplier">
            <insert>INSERT INTO regiontypequota VALUES(@{c0},@{c1},'@{c2}','@{c3}',@{c4})</insert>
            <update>UPDATE regiontypequota SET Dollars=@{c4} WHERE YR=@{c0} AND Quarter=@{c1} AND Region='@{c2}' AND ItemType='@{c3}'</update>
   <WebMessage name="SetQuota">
         <writeBack connectionPool="Supplier">
            <insert>INSERT INTO regiontypequota VALUES(@1,@2,'@3','@4',@5)</insert>
            <update>UPDATE regiontypequota SET Dollars=@5 WHERE YR=@1 AND Quarter=@2 AND Region='@3' AND ItemType='@4'</update>


  1. where do we need to add the commit statement..Please mention clearly while blogging something..

    Thanks & Regards,

  2. Consider adding those tags only if Auto commit on db is disabled. If you need to add please do so after insert or update

    1. Hi I am new to OBIEE. I don't understand how to write the template. Many articles on the web says we should save the template in D:\OracleBI\web\msgdb\customMessages
      Could you please explain how to create the template very first time?

      Thank You

  3. the blog was very helpful for us thanks for sharing keep it up
    oracle fusion financials training