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:
Tuesday, January 3, 2023
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:
Subscribe to:
Posts (Atom)
Featured Post
OIC - Moving a File using FTP connection now throws IO operation failed error
Error usecase: Moving a File using FTP connection now throws IO operation failed error. The integration has been working for weeks, with a f...
-
Please find the following links for OIC hands on and relevant information: Oracle Integration Cloud Introduction | Benefits | Services offer...
-
OIC interview Q & A: 1. FBDI approach with an example https://soalicious.blogspot.com/2022/02/oic-erp-supplier-bulk-import-and.html 2. ...
-
Stage or vfs or virtual file system is a temporary location in the oic local file system which stores temporary files required for processin... -
Usecase: Here, we will extract the data from HCM and then download the data from UCM uaing Flow Actions Service and Generic Soap Service To... -
Usecase: Here, we will see how we can download the import Payables Invoices report. That is we will download report equivalent .xml file w... -
UseCase: Here, we will show you how to split an input, received as comma separated string values( here, emails) into array of values using c... -
What is Throttling: Throttling is termed as "regulate the flow". Oracle Service Bus has throttling feature and by using that f... -
Usecase: Here, we will demonstrate the detailed implementation steps for AP Invoice FBD Import from polling the file from source >> cr...
-
UseCase: While mapping the elements in the mapper using XSD structure of the file contents, getting below 2 types of translation errors: Err... -
Credential Store Framework (CSF) is used in OWSM to manage the secure credentials. CSF provides a way to store, retrieve, and delete cred...