Loading Member Lists

When you load member list files, the system waits for other tasks such as consolidation, data entry or other load processes to finish before proceeding to load the files. Oracle recommends that you load member lists during periods of light activity across the server cluster instead of, for example, during a long-running consolidation. You can check the Running Tasks page to see which consolidations or data loads, for example, are in progress.

After you load a member list file into an application, users using that application are notified that the system has changed and that they must log off from the application and log back on.

Web Procedure

Note:

Oracle recommends that you add Financial Management to the exceptions for your Web pop-up blocker. When you perform some Financial Management tasks on the Web such as loading data, a status window pops up showing the task status. If you have a pop-up blocker enabled on your computer, the status window is not displayed.

  To load member lists:

  1. Open the application.

  2. In the Browser View, expand Tasks and select Load Tasks.

  3. Select Load Member Lists.

  4. For Member Lists File , enter the file name to load, or click Browse to find the file.

    Note:

    By default, member list files use the LST file extension. The load process accepts other file extensions such as TXT or CSV, however, Oracle recommends that you use the LST file extension.

  5. Optional: Click Scan to verify that the file format is correct.

  6. Click Load.

    Note:

    If an invalid member list is loaded, Web users may not be able to access the data grid. If the following error message is displayed, you may need to correct the member list and load the file:

    ”Type Mismatch /hfm/Data/ExploreData.asp. Error Number 13. Error Source: Microsoft VBScript runtime error.”