Mobile App – First Time Setup

Getting Started - Introduction/Overview

Simplified Loader offers two ranges of the mobile app: Transactional and Dashboard. The Transactional range includes apps that enable users to complete real-time transactions from their mobile, whereas the Dashboard app allows them to view and drill down on data stored in Oracle Fusion.

Simplified Loader offers two methods to set up a mobile app.

1. Using the Company Code and Passcode. Setup performed using this method allows the user to control users and app behaviour centrally. To complete setup using Company Code and Passcode, you will need Excel template corresponding to the mobile app Excel. Please follow the steps below to complete setup using Company Code and Passcode. It is recommended that the steps are carried out in the order presented.

Step 1. Unlock the Admin Panel (Step performed using corresponding Excel template)

Step 2. Complete Connection Setup (Step performed using corresponding Excel template)

Step 3. Set Up BI Reports using Excel (Step performed using corresponding Excel template)

Step 4. Set Up Roles and Privileges

Step 5. Complete User Registration

2. Using Oracle Fusion URL: Using this method, the user can perform all setup steps from within the mobile app. The pre-requite to setup mobile app using this method are login credential with access to BI Administration role.

Step 1. Add Environments using Mobile App

Step 2. Set Up BI Reports using Mobile App

Step 3. Set Up Roles and Privileges

Unlock the Admin Panel

Step performed using corresponding Excel template.

The first step in setting up a Simplified Loader Template is to unlock the Admin Panel, which is located in the Setup section of the Simplified Loader toolbar.

The Admin Panel contains a number of the operations required to set up the Template. These operations are password protected as they need to be completed by the user responsible for the initial set up of the Template and therefore should not be available for modification by day-to-day users.

1. Navigate to the Simplified Loader Admin Panel button in the Setup section of the Simplified Loader toolbar.

2. By default, the Admin Panel is protected by a password.

The Admin Password is required to make any updates to either the Admin Panel or the About worksheet.

The default password is admin. To change the password, enter the current password and new password and then click the Change Password button.

3. To use the features available in the Admin Panel, unlock the Template by entering the Current Password and click the Unlock Template button.

After unlocking the Template, the user receives the following message

Clicking OK on this window will close the message and the Admin Panel.

4. Click on the Admin Panel menu option again to reopen. This will enable all options available to use. If required, changes can now be made to the About sheet. Once the Template is unlocked, it remains unlocked for the session.

5. Whenever the Admin Panel has been unlocked, then closing the Template will result in the following message being displayed.

This is a reminder to the administrator that they need to save the file to ensure that the Admin Panel is locked before exiting the Template.

Click OK to make the window disappear. The following message will then appear.

6. Click on the Save button before exiting the Template.

Complete Connection Setup

Step performed using corresponding Excel template.

Simplified Loader templates exchange data with Oracle Fusion. The method used by Excel to do so can differ from one PC to another. The Simplified Loader Connection Wizard helps identify the appropriate configuration for the Simplified Loader template to ensure a seamless data exchange with the Oracle Fusion applications. Follow the steps below to locate and store the appropriate connection setting within the Simplified Loader template:

1. Click on User Preferences in the Setup section of the Simplified Loader toolbar to open the User Setup panel

2. In the Connection Setup section of the User Preferences panel, select an Oracle Fusion environment from the Environment URL drop-down list and click Launch Connection Wizard button. This will start the connection wizard to identify the best connection method suited to connect to the selected environment.

3. To test connectivity, Connection Wizard will attempt to connect to the selected environment. The test is performed without a username and password, and therefore, it is likely that a pop-up message (screenshot below) will appear asking for a username and password. If this happens, it means that the Template received a success response from Fusion. Simply acknowledge the message by clicking the Cancel button.

4. When Connection Wizard finds an appropriate connection type, it displays one of the following messages. Click OK to complete the Connection Setup step.

Set Up BI Reports using Excel

Step performed using corresponding Excel template.

Simplified Loader templates use BI Reports to retrieve data from Oracle Fusion. BI Reports need to be set up once for each mobile app for each environment. Only users that have been allocated the BI Administrator role can complete the BI Report setup.

1. Navigate to Admin Panel

2. Under the BI Report section, select the environment and enter the Username and login password of the user with BI Administrator Role access.

3. Click the “Create the BI report in the selected environment” button to create BI reports. The following message will appear after the successful creation of BI Reports.

4. After receiving the confirmation message, the BI Administrator can review the reports in the /Custom/SL_Template folder in Oracle Fusion.

5. The BI Administrator can optionally set the SL_Template folder property to Hidden (as shown below). This will ensure that the Simplified Loader reports are not accessed by all users, as the user will not be executing the reports directly from BI.

Add Environments using Mobile App

This step is required when setting up a Mobile app using Oracle Fusion URL. Add the target Oracle Fusion environment to which you wish to connect using the Simplified Loader mobile app. Environment setup is a one-time configuration:

1. Navigate to the Settings page

2. Under the Environment setup section, enter the environment identifier in the Alias field and the environment URL in the URL field. Ensure to include https:// in the URL. The best source to obtain the environment URL is the Oracle Fusion login page.

3. Click the Add Environment button to save the environment Alias and URL. The following confirmation message will appear after the environment is successfully added.

4. More than one environment can be added if desired. To do so simply repeat steps 1 to 3 above.

Set Up BI Reports using Mobile App

This step is required when setting up a Mobile app using Oracle Fusion URL. Simplified Loader Mobile App use BI Reports to retrieve data from Oracle Fusion. BI Reports need to be set up once for each mobile app for each environment. Only users that have been allocated the BI Administrator role can complete the BI Report setup.

1. Navigate to Setting page

2. Under the Environment Setup section, click Setup BI Report button.

3. Select the environment and enter the Username and password of the user with BI Administrator Role access.

4. Click the “Create BI Report” button to create BI reports in the selected environment. The following message will appear after the successful creation of BI Reports.

Set Up Roles and Privileges

This step is required when setting up transactional mobile apps only. Skip this step if you are setting up the Dashboard app and go directly to Step 5.

To transact using mobile app, the users require specific Privileges to be assigned to them in Oracle Fusion. Privileges can be assigned using an existing role or a new role. Below are the steps to assign privilege using a new role.

1. Log in to Oracle Fusion with the user having access to the IT Security Manager role.

2. From Oracle Fusion’s SpringBoard. Select Tools and then the Security Console.

3. In the Roles page, click Create Role.

NOTE: You can add Privileges to a new or existing Role. Based on your organization’s security policies, either create a new Role or use an existing Role to add required privileges.

4. Enter details of the new Role and click Next.

5. In the Function Security Policies page, click Add Function Security Policy.

6. Search for the required privilege, highlight the record and click Add Privilege to Role.

NOTE: Refer to the Template or App page to get the list of required privileges.

7. Review all security Policies in the “Function Security Policies” page and click Next.

8. In the Data Security Policies page, click Next.

9. In the Role Hierarchy page, click Next.

10. Add users to the Role and click Next. Alternatively, Roles can be assigned to the users in the Users page found within the Security Console.

11. Search and add users

12. Review users and click Next

13. In the Summary and Impact Report page, click Save and Close.

14. From Navigator, select Scheduled Processes within the Tools section.

15. Execute the following Please wait for the first process to complete successfully before submitting the next process:

  1. Retrieve Latest LDAP Changes
  2. Import User and Role Application Security Data

Complete User Registration

The user registration for Simplified Loader is administered using Oracle Lookups functionality. To set up Lookup codes, the System Administrator within your organization needs to define the App specific Lookup Type in Oracle Fusion. Setting up Lookup Type is a two steps process:

  1. Get User Registration Lookup Type
  2. Complete Users registration

Get User Registration Lookup Type

To complete this step, you need Connection URL, Company Code, and Passcode.

1. Download app from Google Play or iOS App store.

2. Launch the app and navigate to the Settings screen

3. Scroll to Connection Setup section and enter Connection URL, Company Code and click Get Details.

4. Enter Passcode and click OK.

5. This will populate details in Environment Details section and App Details section

6. Get Lookup Type name populated in the App Details section

Complete Users Registration

Complete these steps in all the environments to which you wish to connect.

1. Log in to Oracle Fusion from your PC or laptop and navigate to Setup and Maintenance

2. Select “Search” from Tasks menu

3. Search Task “Manage Common Lookups”

4. Click the Plus (+) icon in the Search section to define a new Lookup

5. Enter the following details:

Lookup Type:{Value obtained from App Details section of mobile app}
Meaning:Simplified Loader - User registration for {App Name} mobile app
Description:Leave blank
Module:Common Lookups
Lookup Configuration Level:User
REST Access Secured:Secure

6. Save the record

7. Add user names, as lookup codes, of those users to which access to the Simplified Loader App is to be provided.

Lookup Code:Enter the user name Example: James@Abc.com
Display Sequence:Leave blank
Enabled:Ticked
Start Date:Start date from which the user has access. Start Date field can be left blank.
End Date:End date to which the user has access. End Date field can be left blank.
Meaning:Enter user name again here. NOTE: The Template performs user validation using the value in the Meaning field.
Description:Leave blank. This field is used to support custom validations.
Tag:Leave blank

8. Save the record

You are now ready to use the Mobile app!

After completing the above setup steps, the user can use the mobile app. You will find more information on how to use the app in the User Guide.