Excel Templates - Admin Setup

Overview

The Admin setup lets you control the configuration that applies to all the users in your organization.

Unlock the Admin Panel

The Admin Panel contains a number of the operations required to set up the template. These operations are password protected as they need only to be completed by the administrator and should not be available for modification by everyday users. Click here to view detailed steps to unlock the Admin Panel.

Set Up BI Reports

Simplified Loader templates use BI Reports to retrieve data from Oracle Fusion. BI Reports need to be set up once for each template for each environment. This can only be completed by a user with access to the BI Administrator role. Click here to view detailed steps to set up BI Reports.

User Registration

User registration for Simplified Loader is administered using Lookup Values. The System Administrator within your organization must first define the template-specific Lookup Type in Fusion ERP. The Lookup Type will be used to maintain users. Click here to view detailed steps to add users.

Setup DFF

DFF fields configured in Oracle Fusion can be set up in the Simplified Loader template with a click of a button. The DFF fields need to be set up once for each template.

1. Open Admin Panel

2. Click 'Setup DFF in Template' from the Setup DFF section. Simplified Loader will read DFF fields from Oracle Fusion and add them in the About sheet and DataSheet.

DFF Setup - Simplified Loader Excel for Oracle Fusion Cloud ERP

3. If the user is not signed in to any environment, they will receive a login form to log in to Oracle Fusion. Select the environment and log in to Oracle Fusion. If the user is already logged in, then the Setup DFF wizard will not ask for login credentials again.

4. The following popup is displayed to configure 'Display Default Values' functionality in the Simplified Loader template. Click 'Yes' to set up constant default values in the Simplified Loader template from the DFF configuration defined in Oracle Fusion. The default option is 'No'.

DFF Setup - Simplified Loader Excel for Oracle Fusion Cloud ERP

5. After completion, the user receives a confirmation message.

DFF Config confirmation - Simplified Loader Excel for Oracle Fusion Cloud ERP

6. Setup DFF section now displays the environment and time when Setup DFF wizard retrieved details from Oracle Fusion.

7. The DFF fields are added at the end of the DataSheet and About sheet.

Review DFF DataSheet - Simplified Loader Excel for Oracle Fusion Cloud ERP Review DFF About - Simplified Loader Excel for Oracle Fusion Cloud ERP

8. Like other fields, the DFF fields can be organized (e.g. moved, hidden, or deleted) in the DataSheet.

Setup mandatory fields or default values

The administrator can define mandatory fields or define default values for each operation available in the template. The default values defined by the administrator are different from the user default values entered by the user in DataSheet.

The following table highlights application behaviour when the administrator sets up Mandatory Field and Force Default values.

Mandatory Fields and Force Default - Simplified Loader Excel for Oracle Fusion Cloud ERP

1. Unlock the Admin Panel

2. Unlocking Admin Panel also unlocks the About Sheet

3. In row # 22, you will see the list of all operations supported by the template

4. Create an additional column in the About sheet. In row # 22, enter the name of this column as one of the following:

  • Mandatory Fields: <Operation Name>
  • Force Default: <Operation Name>

NOTE 1: Defining both 'Mandatory Fields' and 'Force Default' columns is not mandatory. Based on the requirement, you can define both fields or only one field.

NOTE 2: The columns for each operation should be individually defined. If the same default value applies to two operations, then define two instances of the 'Force Default' column, one for each operation.

5. In the 'Mandatory Fields' column, enter 'Y' to indicate a field as a mandatory field

6. In the 'Force Default' column, enter value against the field to define a default value

Mandatory Fields and Force Default - Simplified Loader Excel for Oracle Fusion Cloud ERP

7. Repeat steps 4 – 6 to define mandatory fields and default values for each operation.

NOTE: Mandatory Field or Default Values setup comes into effect when the user enters at least one value in the section containing mandatory fields or default value setup. For example, if Admin sets up the 'Dist Tax Name' field in the Distribution section as mandatory with the force default value 'STD TAX'. With this setup, when creating a Invoice, if the user don't enter data in any field in the Distribution section, then both mandatory field or default value checks will not be performed. This is because the entire Distribution section is omitted from processing. To overcome this limitation, the admin can define a mandatory section using the 'Mandatory Sections' feature.

Application control preferences

When a user logs in to Oracle Fusion using the Simplified Loader template, their login is validated using Lookup Type in Oracle Fusion. At the time of login, the Simplified Loader template reads the text entered in the Description field of the Lookups setup. The template uses values entered in the Description fields to control the template behaviour.

The Description fields can be set up with predefined preferences that control the template's behaviour. The administrator can choose to use one or more preferences. When using multiple preferences, enter the pipe (|) delimiter between preferences.

Version Control

The administrator can control the Simplified Loader template version used within the organization. To implement version control, the administrator must specify the template version in the lookup type description field. Optionally, the administrator can also define a short message for the user. This message is displayed to the user when the version used by the user is not same as the version defined by the administrator in the template.

1. Get the version details of the template that you want to use within your organization. Click here to know how to get the template version.

2. In Oracle Fusion, navigate to the Lookup Type associated with the template.

3. Enter preference LatestVersion[TemplateVersion<;Optional message>]. Replace the text TemplateVersion with the version that you wish users to use. To include an optional message, use a semi-colon and add a short message.

Version Control - Simplified Loader Excel for Oracle Fusion Cloud ERP

4. When the user logs in, the login process reads content from both the Lookup Type's description as well as the user-level Lookup Value's description to validate the template version before uploading any data. The user receives the following message if the version specified by the administrator does not match the template version used by the user.

Version Control Error - Simplified Loader Excel for Oracle Fusion Cloud ERP

Allowed Operations

The administrator can control user's access to the operations available in the template. To implement access control define AllowedOperations preference and specify the permitted operations. To specify multiple operations, use AllowedOperations preference with multiple comma-separated operations. The default value of AllowedOperations preference is ALL.

Example: The Payables Invoice template provides the following operations

Operations - Simplified Loader Excel for Oracle Fusion Cloud ERP

Preference AllowedOperations[Get Invoice Details, Create Invoice, Update Invoice] will allow the user to perform three operations mentioned in the preference.

Allowed Operations - Simplified Loader Excel for Oracle Fusion Cloud ERP

If the user clicks on the 'Update Invoice' operation, they will receive the following error message.

Allowed Operations message - Simplified Loader Excel for Oracle Fusion Cloud ERP

Disallowed Operations

The administrator can control user's access to the operations available in the template. To implement access control define DisallowedOperations preference and specify the operations not permitted for a user. To specify multiple operations, use DisallowedOperations preference with multiple comma-separated operations.

Example: The Payables Invoice template provides the following operations

Operations - Simplified Loader Excel for Oracle Fusion Cloud ERP

Preference DisallowedOperations[Delete Invoices] will stop the users from performing the Delete Invoices operation.

Disallowed Operations - Simplified Loader Excel for Oracle Fusion Cloud ERP

If the user clicks on the 'Delete Invoices' operation, they will receive the following error message.

Disallowed Operations message - Simplified Loader Excel for Oracle Fusion Cloud ERP

Integration mode (TransactAs preference)

Enabling Integration mode allows the user to perform operations as a centralized user. The following figure demonstrates how login credentials are selected when the Integration mode is enabled.

1. Open Admin Panel

2. In the Enable Integration Mode section, select the environment and enter the Integration user's username and password. The Integration username and password is only used for transactional purpose and not for querying data.

Integration Mode - Simplified Loader Excel for Oracle Fusion Cloud ERP

3. Click 'Get Code to enable Integration Mode'. This will display Enable Integration Mode window with unique code based on the entered username and password.

Integration Mode Codes - Simplified Loader Excel for Oracle Fusion Cloud ERP

4. Setup preference in the associated Lookup Type using TransactAs[ObfuscatedCode] or TransactAs[SRVR]. NOTE: Before using SRVR as a preference value, the administrator must click on the 'Click to store the login code with Simplified Loader' button.

Integration Mode config - Simplified Loader Excel for Oracle Fusion Cloud ERP

5. The default value for TransactAs preference is SELF. Preference TransactAs[SELF] indicates that the transaction should be performed using the user's login credentials logged in to the Simplified Loader template. TransactAs{SELF] is the default behaviour.

Override application control preferences at the user level

The Preferences defined above can be set up at the Lookup Type (global) level or Lookup Code (user) level. When the same preference is defined at the Lookup Type and Lookup Code levels, the Lookup Code level preference takes precedence.

For example, the following setup will enable Integration mode for all users using the template linked to the given lookup.

Override Preference - Simplified Loader Excel for Oracle Fusion Cloud ERP

The following screenshot demonstrates setup with preference override at the user level.

Override Preference - Simplified Loader Excel for Oracle Fusion Cloud ERP

Customize data selection criteria

If you have an specific requirement to restrict data, please contact Simplified Loader support by logging an incident using the Support Portal.

Custom validations & data enrichment

If you have an specific data validation & enrichment requirements, please contact Simplified Loader support by logging an incident using the Support Portal.

Disable data load

Simplified Loader templates can be shared with other recipients for data input. Before sharing the template with other recipients the administrator can optionally disable all data load operations. By disabling the data load operation, the recipient can enter data and use the downloaded lookup values, but they won't be able to exchange data with Oracle Fusion using the Simplified Loader template. This feature provides an extra layer of protection on top of the controls implemented using Lookup Type.

Disable Transactions - Simplified Loader Excel for Oracle Fusion Cloud ERP

Under such circumstances, if the recipient was to attempt to log in, the following message will appear:

Disable Transaction Error - Simplified Loader Excel for Oracle Fusion Cloud ERP