Thursday, March 3, 2022

Cloud ERP | How to create an OTBI report | create BI publisher report

Here, we will show you how to create a BI report. Basically we will generate an unique Invoice id based on SQL sequence from dual.

SQL query:

Select AP_INVOICES_S.nextval invoice_id from dual

Steps in detail:

Login to ERP and Navigate to Tools >> Reports & Analytics

Browse Catalog

Create a new folder "Poc" under /Shared Folder /custom/Integration

New >> Data Model

Click "+" sign and Select SQL Query.

Provide Name, select data soirce and SQL query >> ok

Data >> view

Data 》 Save as Sample data

Save Data Model

Go back to Catalog

Now you can see data model is ready.

New 》Report

Select the created data model 》 Next

Select Table 》 Next

Drag and drop field names from data source 》 Next


Action》Edit Report

View list 

Select output format as Data(csv)

Save Report

Go back to Catalog


You can see its showing the expected invoice id.

1 comment:

  1. Really good work there. Informative and helpful. Appreciate it. But might be looking for Odoo Custom Module Development in North Carolina


Featured Post

11g to 12c OSB projects migration points

1. Export 11g OSB code and import in 12c Jdeveloper. Steps to import OSB project in Jdeveloper:   File⇾Import⇾Service Bus Resources⇾ Se...