Tuesday, January 3, 2023

Create first ESS job on BI Report | ERP Cloud

Usecase: We will create our first ESS job on BIP report and shedule the ESS job from scheduled processes and track the details from ess_request_history and ess_request_property tables.

Steps with detailed screenshots:



























ERP - Secure BI Report

We can provide permissions to specific user to use the report to make it more secure.

Report >> More >> permissions >> add user >> no access to BI admin, BI author and cosumer if needed

Detailed steps with screenshots:







Tuesday, December 20, 2022

ERP - BI Report Export | Send to UCM | Send as Email Attachment

Usecase: Here, we will see the following -

  • How to schdule BI report and send using email attachment and also send to UCM.
  • How to check schedule report history
  • How to check BI ess job run from scheduled process
  • How to see export file to UCM
  • See other delivery options in administration settings.

Detailed steps with Screenshots:

























Monday, December 19, 2022

ERP - BI report Migration

BI report migration is very simple. We need to archive the data model and report from one instance and unarchive to higher or another instance.

Steps:











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...