Whenever we want to fetch huge amounts of data from BIP report (More than 10MB) in OIC, we usually get payload limitations error. To avoid this error, we have below two options: (A) Schedule BIP report and send File to FTP server and then read data from FTP in segment in OIC. (B) Retrieve BIP […]
Service Limits for File Adapter in OIC
The File Adapter lets you read from or write to files on an on-premises system (e.g., local file server or shared folder) via a Connectivity Agent. There are two main operations: Each has different size limits, depending on whether a schema/structure is used. For Read File operations: Polling with a connectivity agent: Download File operations:
BIP Roles in Oracle Fusion
Oracle Business intelligence roles apply to both Oracle Business Intelligence publisher and Oracle Fusion Transactional Business Intelligence (OTBI). They grant access to business intelligence functionality such as ability to run or authors reports. Role Name Description BI Consumer Role Runs Business Intelligence reports. BI Author Role Creates and edits reports. BI Administrator Role Performs administrative […]
Create BIP report with Dependent Parameters
In this section, we will see how to create BIP report with dependent parameters in fusion. Let us create sample BIP report with two parameters: Navigation—-> Tools—>Reports and Analytics Go to Browse Catalog—>New —–>Data Model. Create SQL Query to create Data Model. Go to Diagram—->SQL Query. Give Name, Data Source and Type of SQL as […]
How to Schedule BIP Report with EMAIL Delivery with Zip Attachment
In the last section, we have seen how to schedule BIP report with email delivery. While sending output to destination, we can send the output in Zip format. To send output in Zip format, we need to enable below checkbox while scheduling BIP report. Now let us submit this schedule BIP report. Here we can […]
How to Schedule BIP Report with EMAIL Delivery
BIP scheduling is used to run the BIP report at specified intervals. We can have different delivery options for BIP report scheduling like EMAIL, FTP, or UCM (CS), FAX, web folder, printer. In this section, we will see how to schedule BIP report with email delivery option. Let us create sample BIP report for AP […]
How to use login ID session variable in Oracle BI publisher report (System Variables)
We can use information about current user in BIP report data model using system Variables. The user information is stored in system variables as shown below: System Variable Description xdo_user_name User ID of the user submitting the report xdo_user_roles Roles Assigned to user submitting the report. Example: XMLP_ADMIN_XMLP_SCHEDULER. xdo_user_report_oracle_lang Report language from user’s account preferences. […]
How to Download and Install ADFDI for Oracle Fusion
In this section, we will see how to download and install ADFDI for Oracle Fusion in local desktop. ADFDI stands for Application Development Framework Desktop Integration. ADFDI is integrated with MS excel to fetch and upload data to Oracle Fusion application. To use ADFDI with excel, we need to setup ADFDI in local desktop. To […]
Lightweight Directory Access Protocol (LDAP)
Lightweight Directory Access Protocol (LDAP) LDAP Stands for Lightweight Directory Access Protocol (LDAP) directory. All user accounts information is maintained in LDAP directory. LDAP also holds information about roles provisioned to users. During Implementation, any existing information about users and their roles must be copied from LDAP directory to Oracle Fusion application tables. As part […]
Role Based Access Control (RBAC) in Oracle Fusion
Role Based Access Control (RBAC) Oracle Fusion Security is based on Role Based Access Control model. Role based Access control defines who can do what on which functions or sets of data under what conditions. In Role Based Access Control, we provide users with roles which are assigned access privileges to protected resources. There are […]