Categories
- All Categories
- 99 Oracle Analytics News
- 9 Oracle Analytics Videos
- 14.3K Oracle Analytics Forums
- 5.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 55 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations Gallery
- 4 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Write back functionality Issue

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.
I have entered the below text in the above report, but disappeared after click of SAVE button.
I am using OBIEE 11.1.1.7 version. DB is ORACLE DB.
Regards,
Chandra.
Answers
-
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....
0 -
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
0 -
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.
0 -
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.
Regards,
Chandra.
0 -
Please confirm do i need to count hidden columns also.
0 -
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.
0