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.

In order to begin the setup process, the following are required – all of which will have been provided to you at the time of purchase of the mobile app:

1. The Simplified Loader Excel template corresponding to the mobile app (NOTE: Excel templates are only used for the first-time setup)

2. Connection URL, 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.

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.

Step 2. 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.

Step 3. Set Up BI Reports

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.

Step 4. Set Up Roles and Privileges

This step is required when setting up “SL PO Receipts” mobile app 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

Step 5. 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:
Display Sequence:Leave blank
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.