Oracle Business Intelligence

Products Banner

Write back functionality Issue

Received Response
32
Views
6
Comments

Hi,

I have a report with writable columns. After entering text in the 3 write back columns, the text is disappearing.

I have queried in the oracle database. It's not updated.

pastedImage_0.png

I have entered the below text in the above report, but disappeared after click of SAVE button.

pastedImage_1.png

I am using OBIEE 11.1.1.7 version.  DB is ORACLE DB.

Regards,

Chandra.

Answers

  • Robert Angel
    Robert Angel ✭✭✭✭✭

    Writeback is a fair old length of pipe.

    1. check your user has rights

    2. check the connection pool can writeback

    3. check the insert in the associated file against the db to ensure the syntax is valid

    4. check the field mappings in the associated file to the fields in your answers report correspond

    5. Wonder why you are not using a tool more suited to purpose like Apex for this....

  • User_JL3CW
    User_JL3CW ✭✭✭✭✭

    Hi,

    1. check your user has rights  - YES

    2. check the connection pool can writeback - HOW TO CHECK THIS?

    3. check the insert in the associated file against the db to ensure the syntax is valid

    -

    I have used UPDATE statement in write back xml file.

    I have tested update statement in oracle database. It's updating properly.

    4. check the field mappings in the associated file to the fields in your answers report correspond

    - Mappings are proper.

    Regards,

    Chandra

  • Robert Angel
    Robert Angel ✭✭✭✭✭

    On 2  - the connection pool that you underlying table connects to in the rpd, it has been a while but I am fairly certain you have to configure there to enable writeback, as I usually create a specialised connection pool for the purpose.

  • User_JL3CW
    User_JL3CW ✭✭✭✭✭

    Hi,

    Configure means...In the connection pool setting i have given DB user credentials and in the Write Back Tab it shows as shown below attached.

    pastedImage_0.png

    Regards,

    Chandra.

  • User_JL3CW
    User_JL3CW ✭✭✭✭✭

    Please confirm do i need to count hidden columns also.

  • Robert Angel
    Robert Angel ✭✭✭✭✭

    Yes, you do.

    And this is from memory, but check the connection settings also, I am fairly sure there is an allow writeback tickbox in the back end also... I don't have access to OBIEE here to check.