Running Load Files

After you ensure load files load the correct data, run the load files in the proper order (see Required Data Load File Run Order) in a production environment. Use this syntax to run data load files:

OutlineLoad /A:<application> /U:<username> /I:<.csv file>/D:<dimension> /L:<.log file> /N [/S:<server>] [/M] [/C]/X:<exception file>

  To run load files:

  1. From a command prompt, enter CD x:\oracle\middleware\user_projects\epmsystem1\Planning\planning1 or {EPM_ORACLE_INSTANCE}/Planning/planning1/OutlineLoad.cmd.

  2. Run a command:

    • Windows:

      • To load dimensional metadata:

        OutlineLoad /A:PO /U:jtadmin /I:<directory>\employee.csv/D:Employee /L:c:/employee_load.log /N/S:localhost /M/X:c:/employee_load.exc

      • To load Smart List data:/A:<application> /U:<user name> /I:<directory>/<.csv file> /DS:HSP_SMARTLISTS /L:/<directory>/<.LOG file> /N [/S:<server>] [/M] /X:/<directory>/<.EXC file>

      For example, C:\Oracle\Middleware\user_projects\epmsystem1\Planning\planning1>OutlineLoad /A:psbapp /U:admin /M /I:c:\psb_salgradedetails.csv /D:"Budget Item"

    • UNIX: {EPM_ORACLE_INSTANCE}/Planning/planning1/OutlineLoad.sh /A:<appName> /U:<adminUser> /M /I:<filename.csv> /DS:HSP_SMARTLISTS /L:outlineload.log /X:outlineload.exc

  3. Review the LOG file to confirm that the file ran correctly.

  4. Open the application to ensure that the correct metadata loaded.

  5. Select Administration, then Manage Applications, and then Refresh Database to write the metadata to the Plan 1, 2, or 3, and the HCP plan type.