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

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

View Assigned Business Object page

Assign Options

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

Assign Individual Business Objects page

Assigned Business Objects on View 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

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.