ERP BI - How to create a simple BI publisher Report | get a sequence number using bip 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

Finish

Action》Edit Report

View list 

Select output format as Data(csv)

Save Report

Go back to Catalog

Open

You can see its showing the expected invoice id.

OIC | Add Package Name for an Integration

We can put Integrations inside a package using below two methods:

1. At the time of Integration development(For new Integrations)
2. After Integration Developement(for existing integrations)

Steps in detail:

At the time of Integrations development:

Login to console >> Integrations 

Click Create Integration

Select a pattern 

Provide Integration name and a Package name(new or choose existing one). And click create.

After Integration Development:

Login to OIC console >> Choose Integration >> Deactivate

Click Edit

Menu >> Primary info

Change the package name

Save and close

Acrivate the Integration.

Expand and see the package has been changed.

OIC | Package Migration | Multiple Integration Migration

Here we will see how to do package migration from one instance to another instance.

To migrate mutiple integrations in a package, the integrations must be defined inside a package name. If we forget to put package name while creating the integration then we can give the package name after the integration development also.

Check below blog how to add the package name after the development:

oic-add-package-name-for-integration

Steps in detail:

To show it, I have created here two scheduled integrations and put same Package name as test.package.

Go to Packages

Select your package test.package and click export.

Click export and it will download the whole package of integrations as .par file.

Now Login to another Instance and  go to Packages to import.

Click Import.

Choose the .par file.

Click Import and configure.

In my case, there is no connections or library etc. If in real scenario, there is any connections etc that we need to configure here and then click back button "<" to come out of the window.

Now activate the integrations.

Package Migration done.