Posts

Showing posts from 2020

How to secure report by making view only access to employee

Image
In this article i am going to tell how to secure report by giving view only access to people. To achieve this, first we need to have an existing report. Here i am taking a report which is already built Now we need to customize the url inorder to give view only access. Replace the below path in bold with the following one in bold. analytics/saw.dll?bipublisherEntry&Action=open&itemType=.xdo&bipPath=%2FCustom%2F with  xmlpserver/Custom/ and add the remaining path of your report or letter where it is located. The report of letter will end with .xdo format. Now to give view only access enter the following query at the end of URL i.e. at the end of .xdo . The URL end should like the following  way  .xdo?_xpf=&_xpt=0&_&_xmode=2 Now create a page entry with static url and paste the url which we customized as above and add it to the springboard. This way we can give view only access to report. Please leave a comment if you have queries.

Different types of Roles and security

There are different types of roles in fusion, lets see what is a role and the types of roles used. A Role can perform the transactions based on the privileges assigned to that role. There are 4 different types of role. 1. Abstract Role 2. Job Role 3. Data Role 4. Duty Role Abstract Role : This Role is commonly used to all the employees in an organization. For example, every employee(Like line manager, Manager, HR etc...) in Organization is an employee. This is the basic role every one has. Job Role: This Role defines the set of responsibilities that an employee should have Data Role: This Roles deals with Data. For example, an employee with this role can only see data of particular Department or Business unit or Legal employer etc... Duty Role: Duty Role is combination of Abstract role and Job role. An employee can have Abstract role without Job role but employee cannot have Job role without Abstract role Thanks for the reading the post. If you like the p

What is the difference between Update and Correct?

In fusion when ever we want to perform certain transactions we see Update and Correct. Both Update and Correct will modify the record, whenever update is selected a row or record is created and no record is created when Correct option is selected. Check out my next post Roles and security . Thanks for the reading the post. If you like the post please subscribe and if you need Oracle fusion training both technical and functional  please fill the contact form.

How to create a report using OTBI (single subject area)

Image
A report is useful to fetch the data. Based on the requirement we need to select the subject area to fetch the data. If you are new to fusion technical this post will make you understand how to create the report using OTBI.  Lets take an example with the following requirement, i need list of employees whose assignment status is "Active - payroll eligible", whose hire date is after 01-jan-2018. Lets see how to create a report. Login to the application as BI admin https://hosturl.oraclecloud.com/analytics After logging to the application, following screen appears Click on New – Analysis Select workforce management - worker assignment real time subject area to get the above mentioned desired output Select the worker folder under the subject area Double click on the Assignment status Double click on Employee ID and Enterprise Hire date Now let use filters to achieve our requirement. Click o

Followers

Contact Form

Name

Email *

Message *