Simplified Loader Templates work independently of any plugin. Users don’t need to install the ADFdi or any other plugin to use the Simplified Loader Templates.

Simplified Loader templates support SSO login and non-SSO (local Oracle Fusion user) login. When using SSO login, users receive a browser window where they enter their SSO login credentials.

The "Error 401--Unauthorized" page is displayed after the SSO validation process successfully validates the user. Oracle Fusion displays this page. After successful user validation, it seems contradictory to show the "Error 401--Unauthorized" page.

The expected Simplified Loader Excel functionality is "Error 401--Unauthorized" page should close within seconds.

Starting in 2025, the 'Sample - DataSheet' has been removed from the main Excel template. It is now available as a separate Excel file on the Support Portal.
If you don't see it under the Published Documents section, please contact the Support Team using the Support Portal.

Simplified Loader Templates can be used in either TRIAL mode or FULL mode. TRIAL mode allows connection to DEV or TEST environments only. After purchasing the Template, the user gets access to the LIVE environment.

Simplified Loader templates send and receive data from Oracle Fusion. If Oracle Fusion takes more time to process the request sent from the template, then Excel temporarily shows a ‘Not Responding’ status. Once the template receives a response from Oracle Fusion, it will recover from the ‘Not Responding’ state and complete the operation.

PROBLEM: Users encounter runtime error 1004 when downloading data to Simplified Loader Excel templates. Complete error message:

Error 1004:

Microsoft Excel can't insert new cells because it would push non-empty cells off the end of the worksheet. These non-empty cells might appear empty but have blank values, some formatting, or a formula. Delete enough rows or columns to make room for what you want to insert and then try again.

CONTEXT: When downloading data, Simplified Loader inserts new rows into the DataSheet to accommodate the downloaded transactions. However, if the last row of the Excel sheet is already populated, contains formatting, or includes a formula, Excel cannot insert additional rows, as doing so would result in the loss of details in the last row. In such cases, Excel generates error 1004 and halts the operation.

SOLUTION: To resolve this error, delete the unused rows at the bottom of the sheet. Simplified Loader recommends the following methods for deleting unused rows:

1. Select the entire row, right-click, and choose Delete

2. Select the entire row and use the Clear All option. (Navigation: Home > Editing section)

PROBLEM: Clicking the SSO Login button displays a page with the message: 'Navigation to the webpage was canceled'.

CONTEXT: This error occurs because Oracle Fusion applications use the TLS 1.2 internet protocol. The issue arises when TLS 1.2 is disabled on the user's machine.

SOLUTION:

1. Go to the Control Panel and search for Internet Options.

2. In the Internet Properties window, navigate to the Advanced tab.

3. Enable the checkbox for TLS 1.2 and click OK.

4. Try logging in again using Simplified Loader.

To fix this error, follow the instructions under the topic 'Resolving the error: Navigation to the webpage was canceled.'