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:
Comments (Atom)
Featured Post
OIC - Using Dynamic Paths for OCI Object Storage in OIC Integrations | Handling “Subfolders” in OCI Object Storage bucket
Use Case In Oracle Integration Cloud (OIC), when working with Oracle Object Storage, “folders” inside a bucket are not real directories . T...
-
OIC interview Q & A: We have divided the interview questions into 3 sections: Non- Technical, Technical shorts and Scenario based questi...
-
Stage or vfs or virtual file system is a temporary location in the oic local file system which stores temporary files required for processin... -
Please find the following links for OIC hands on and relevant information: Oracle Integration Cloud Introduction | Benefits | Services offer...
-
In Oracle Integration Cloud (OIC), the most commonly used XSLT functions are primarily focused on transforming, filtering, and manipulating ...
-
Usecase: Here, we will demonstrate the detailed implementation steps for AP Invoice FBD Import from polling the file from source >> cr...
-
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... -
OIC generation 3 links: Oracle Integration Generation 3 New Features Integration patterns and how to define schedules About RBAC - Resource ...
-
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... -
Following are the oracle fusion job schedule processes tables which helps to extract the submitted ESS job requests: ESS_Request_History ESS...
-
Reasons to use Projects: Build, Manage and Monitor in one place. Manage integrtaion releases. Control access with RBAC. Use and customize pr...
