Redwood Experience for HSDL

Enrich the user experience with the new Spreadsheet Business Object Access page developed using the Redwood tool set. This page is built from the ground up using Visual Builder Studio (VBS) to give you a unique experience of Oracle applications.

The Spreadsheet Business Object Access page is used to configure the business objects your HSDL template-designer roles can create and import templates for.

To access the Redwood version of this page, navigate to My Client Groups > Data Exchange work area and click Spreadsheet Business Object Access task.

Spreadsheet Business Object Access task

This is the main landing page used to identify the role to assign business object and/or product area access.

Spreadsheet Business Object Access page

Below are the details of the fields on this page:

• Field	Description	Search / Filter	Sorting
  Role Name	The name of the role	Search by partial role name	Default - ascending Ascending / Descending
  Role Code	The code that identifies the role	Search by partial role code	Ascending / Descending
  Description	The description of the role	NA	NA
  Roles with Assigned Business Objects	A "Yes" badge indicates if the role has any business object / product area mappings	Yes/No filter chip to filter the roles that have business object mappings	NA

•  

  Name	Action
  Edit	Show the View Assigned Business Objects for the selected role

View Assigned Business Objects page 

When you click on the Edit icon under the Action column for a Role Name in the HCM Data Loader Business Object Access page, it draws out the View Assigned Business Objects page. It displays the business objects and product areas assigned to the selected role.

View Assigned Business Object page

Assign Options

Below are the details of the fields on this page:

.

• Name	Description
  Assign Individual Business Objects	To select one or more business objects that the role can create and import templates for.
  Assign Business Objects By Product Area	To assign a product area to a role to allow the role can create and import templates using the business objects within that product area
  Assign All Business Objects	To create spreadsheet templates for all business objects
  Delete	Used to remove the existing role mapping records

.

The information below displays possible values for various role mapping records and created using the assign options on the table on this page:

• Name of the column / Assign option record entry	Product Area	Business Object	Description	Action
  Assign Individual Business Objects	The translated name of the product area the business object belongs to	The translated name of the business object	The description of the business object	NA
  Assign Business Objects By Product Area	The translated name of the product area	All except excluded	All current and future business objects in the product area that haven't been excluded	Record level action: Edit: Opens the Business Objects within the Product Area drawer to make any updates to the selected business objects within the product area
  Assign All Business Objects	All	All	All business objects. To load security-related data, the user must also have a function security privilege	NA

• Search: You can search for assigned business objects using partial business object name.

• Filter: Use the Product Area filter chip to display the list of values of the existing product areas mapping including product areas for business object mappings as well.

Below are the details of the Assign pages:

Assign Individual Business Objects page:

Select one or more certified (non-translation) business objects that the role can create and import templates for, and when the role isn't already assigned all business objects.

.

Assign Individual Business Objects page

Assigned Business Objects on View page

Below are the details of the fields on this page:

• Field	Description	Search/Filter
  Business Object	The translated name of the business object.	Partial value search
  Product Area	The translated name of the product area the business objects belongs to.	List of values search
  Assigned by Product Area	A "Yes" badge is used to indicate if the business object is already available to the role via a product area assignment.	NA
  Description	The translated name of the business object.	NA
  Assigned Business Objects	Used to display the selected business object records	Filter

• Action	Description
  Checkbox against each business object	Used to select the checkbox to assign the business object to the selected role. The checkbox is pre-selected for business objects already directly assigned to the role.
  Save	Used to save and create the business object mapping to the role for any newly selected business object, delete business object assignments to the role for any business objects that have been de-selected, and return to the View Assigned Business Objects page.
  Cancel	Used to cancel all the changes and return to the View Assigned Business Objects page.

Assign Business Objects by Product Area page

Assign a product area to a role to allow the role to create and import spreadsheet templates for the business objects within that product area, and when the role isn't already assigned all unrestricted business objects, or all business objects.

Assign Business Objects by Product Area page

.

.

.

• Field	Description	Search/Filter
  Product Area	The translated name of the product area the business objects belongs to.	List of values search
  Assigned	A "Yes" badge indicates if a business object is already available to the role through a direct business object assignment.	NA
  Excluded Business Objects	Comma-delimited list of the name of the business objects that have been excluded from the product area. i.e., unchecked business objects within a Product Area while assigning the product area to the role	NA

• Action	Description
  Edit	Used to open the Business Objects Within the Product Area page to view the pre-selected business objects and exclude some if needed.

Below are the details of the fields on the Business Objects Within the Product Area page:

• Field	Description	Search/Filter
  Business Object	The translated name of the business object	Partial value search
  Description	The translated name of the business object	NA

• Action	Description
  Checkbox against business object	All business objects should be selected by default, the user can uncheck individual business objects
  Save	Used to create a product area mapping for the role and product area selected.  Create exclusions for each business object that's deselected from the list. Note: You can't create an empty product area mapping by deselecting all the business objects.
  Cancel	Closes the page without creating the product area mapping.

Assign All Business Objects page

 To create spreadsheet templates for all business objects, assign when the role isn't already assigned all business objects. 

.

Assign All Business Objects page

Below are the details of the fields on the Assign Business Objects by Product Area page:

• Action	Description
  Assign	Used to create a mapping row for the role to access all objects on the View Assigned Business Objects page
  Cancel	Used to close the message to return the View Assigned Business Objects page

The new Spreadsheet Business Object Access page lets you experience Redwood’s high-fidelity interactions. It offers fewer clicks, better performance and increased cohesiveness.

With the role-based configuration of business objects and product areas, you can restrict which business objects user roles can create and import spreadsheet templates for, restricting user access to the objects they need to work with to fulfill their roles.

Steps to Enable

In order to work with the new Spreadsheet data loader pages, you must first enable the profile option. By default, the profile option is delivered as disabled. If you want to use the new HCM Data Loader pages, you need to set the profile option to Yes.

Redwood Pages	Profile Options
HCM Data Loader Business Object Access	ORA_HRC_HDL_CONFIG_ACCESS_REDWOOD_ENABLED

To enable the profile option, navigate to the Setup and Maintenance work area:

1. Search and click the Manage Administrator Profile Values task.
2. Search and select the profile option as indicated in the table above.
3. Select the Level as Site.
4. Enter Yes in the Profile Value field.
5. Click Save and Close.

Key Resources

For more information on configuring access to design and maintain HCM Spreadsheet Data Loader (HSDL) templates, read: Configure Access to Design and Maintain HCM Spreadsheet Data Loader (HSDL) Templates

Access Requirements

This user interface is secured by the following function security privilege:

Name	Code	Description
Manage HCM Spreadsheet Data Loader Business Object Access	HRC_MANAGE_HSDL_BO_ACCESS_PRIV	Allows access to HCM spreadsheet data loader business objects to be controlled.