How to create chart of account value sets in OTBI report?

Uyen Pham

How to create chart of account value sets in OTBI report?

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/24809/how-to-create-chart-of-account-value-sets-in-otbi-report

Hi @Uyen Pham,

Welcome to the Oracle Analytics Community.

Please take a look into the following Oracle Doc which might be useful.

https://docs.oracle.com/en/cloud/saas/financials/24c/faigl/value-sets-for-charts-of-accounts.html

Hope this help.

Thank you.

Nathan CCC

Hi Uyen,

That is not possible in OTBI. OTBI is read only. Because we are using the hosted Software as a Service version of Oracle Business Intelligence in Oracle Transaction Business Intelligence OTBI in Oracle Fusion Cloud Applications. In our version the feature in OBI to allow "writeback" has been turned off on purpose by our vendor. You are not allowed to create anything in the application database using OTBI. The only writes that OTBI does is the automatic usage tracking etc that go to the S_NQ tables.

The only option you have (to do this in OTBI) I think is to create an Action in OTBI. With this action you may call some other thing outside of OTBI that may be able to insert update delete to the application database tables and views like chart of account value sets. Like a web service, java method, script, http request etc.