Posts

Showing posts from November, 2017

How to configure DFF field and publish it to BI(OTBI) in Fusion?

Image
Hello All, A lot of times, we have a requirement to enable the DFF in fusion and make it available in OTBI subject area. Let us see how to implement this functionality? -> Login to cloud and navigate to 'Setup And Maintenance' -> Search for 'Manage Descriptive FLexfiled' task -> Click on 'Manage Descriptive Flexfields' task and search for the DFF that you want to configure. -> Click on the edit and navigate to ' Edit Descriptive Flexfield' screen ->  If you want context sensitive , Click on Mange contexts to create new context. -> Click on create(+) icon under Context sensitive segments section to create new segment and enter the required details. Name : Display Name for additional field. Code: Unique code for this segment API Name: name of the field the way you want to appear in the APIs(web services) Data Type: Data Type of the field. Table COlumn: table column where you want to store t...

How to create independent value set in fusion(Oracle Cloud)?

Image
Please check my other Post   to know what is value set Independent value set is recommended if you have a requirement to restrict DFF field user entry value with  valid values that you maintain/specify. Let's see steps to create a independent value set. -> Login to cloud, navigate to 'setup and maintenance' and search for  'Manage Value Set' task -> Click on 'Manage Value Sets' task and navigate to manage value set screen -> Click on create(+) icon and enter the value set details. Valueset code : Unique code for value set Valueset description : Description field Module: Functional Area Validation Type: Type of Valueset(Independent) Value Data Type: Data Type of value set Value Sub Type: Further classification of    Data Type of value set Maximum Length : maximum length allowed for the value Minimum and Maximum value applicable for the number and if you have the requir...

What is value set in Fusion(Oracle Cloud)? How to create a value set?

Let's see what is value set and how to create one. A value set is a group of valid values that you assign to a flexfield segment to control the values that are stored for business object attributes. We have following types value sets. Format only, where end users enter data rather than selecting values from a list Independent, a list of values consisting of valid values you specify Dependent, a list of values where a valid value derives from the independent value of another segment Subset, where the list of values is a subset of the values in an existing independent value set Table, where the values derive from a column in an application table and the list of values is limited by a WHERE clause Security Value set security only works in conjunction with usage within flexfield segments. You can specify that data security be applied to the values in flexfield segments that use a value set. Based on the roles provisioned to users, data security...

Auto provision the roles in Fusion Cloud

Image
How to auto provision the roles in Fusion application? Role is a privilege or set of privileges that provide the access to functional area(s) or data set. There are different kind of roles in fusion. Often, we have requirement to auto provision the roles to new hire, new supplier, new line manager and new customer. You can auto provision the roles using ‘Role Provisioning Rules’ in Fusion. Role Provisioning rule has three components (rule details, conditions and role assignment). Rule details: Rule name and rule effective dates. Conditions:  Set of conditions to auto provision the roles. Role assignments: Roles that you want to auto provision. Let’s see     how to configure Role Provisioning Rules. IT Security Manager role is required to create role mapping to auto provision the roles Steps to create role mapping: è Login as (implementation) user that has ‘IT Security Manager’ Role è Navigate to ‘Setup and Maintenance’ page  and...

How to import/batch load user role assignment in fusion?

Image
How to import/batch load user role assignment in fusion? During the go-live and UAT, we have requirement to load the batch of users and user assignment. If you have requirement to load  users, please check my other Post  . If you have requirement to load batch of assignments, Please follow below steps. Oracle allows you to assign one role to multiple users through cloud my service role assignment import functionality Prerequisite:     User should exist in fusion cloud     Role should exist in fusion cloud If you have to assign multiple roles, you have to create one file for each role. For example, if you have to assign ‘Project Manager’ and ‘AR Manager’ roles, you have to create one file each for  ‘Project Manager’ and ‘AR Manager’. Fusion cloud only allows csv format with File format should be as followed. You can download sample file here. Your file should contain the email addresses (Email as header column) of the users...

EBS

Coming Soon

Oracle SOA

Coming Soon

Tableu

Coming Soon

How to import (Batch Load) Users into Fusion?

Image
How to import (Batch Load) Users into Fusion? During the go-live and UAT session, there is the requirement of creating many users. You can use import users’ functionality to achieve this requirement. If you are an identity domain administrator, you can add a batch of user accounts by importing a comma-separated value (CSV) file that lists the information required to set up each user account. The CSV file is a simple text file in a tabular format (rows and columns). The first row in the file, which defines the columns (fields) in your table, must have these exact column headings: First Name Last Name Email User Login(Optional) You can create excel file as below. Username( User Login)  is optional.  If you don’t include a value in the User Login column, then the system makes the username the same as the email address  unless  the username being used or been used within the current domain. For these cases, the system adds a number to the email address t...

What is implementation user in Fusion? How to create implementation user in Fusion?

Image
What is implementation user in Fusion? How to create implementation user in Fusion? Fusion allows two (application and implementation) kind of users. Application users are associated with employee(person) and implementation users are not associated with employees. Application Implementation Consultant, implementation users have unrestricted access to large amounts of data during the implementation. After implementation, both application users and administrators can perform their tasks using less powerful roles. The Oracle HCM Cloud service administrator creates initial implementation user. Implementation users can be created from fusion application security console or OIM services. Fusion role required to create implementation user? IT Security Manager Steps to create implementation user from fusion application Security Console Click on Navigation Bar and click on 'Security Console' option You will be navigated to below screen and click users (second) ...