2 Generating GL File

The GL File is generated from OHC GL Accounting program and the file format may varies depending on the value defined in Parameter group “General Ledger”,”GL Accounting Type”. A Custom Accounting format using customize script is available if you require more information in the GL transfer file. Contact Oracle Customer Support for more information.

Generic GL Accounting

  1. Login to GLAccounting program.

  2. Select Generate File from GL Transfer option.

  3. At the Account Interface Transfer screen, the revenue of the current cruise is shown.

  4. At the Revenue section, select the cruise from the Cruise drop-down menu.

    Figure 2-1 Accounting Interface Transfer


    This figure shows the Accounting Interface Transfer window.

  5. Click the Process button to generate the GL file.

  6. Once the file generation completes, the system prompts a confirmation message and the saved file path is shown at the bottom left of the screen. Click OK to close the File Creation window and exit. This also dim the Process button.

  7. To regenerate the file, check the Include postings already transferred to enable the Process button, and then repeat step 3 and 4.

Custom GL Accounting

The Custom GL Accounting feature is enabled by setting the value field in parameter “General Ledger”,”GL Accounting Type” to “CUSTOM”. This setting changes the function within the GL Accounting Interface, and add a Configurator option to the interface.

  1. Log in to GL Accounting program and select Configurator from the option.

  2. At the configuration screen, enter the Name, Output, Directory, File Name Prefix, Source View and Data View Type.

    Figure 2-2 Custom GL Accounting Data Export


    This figure shows the Custom GL Accounting, Data View Type.

    • The Source View refers to the custom view provided, depending on the customer requirement.

    • The File Name Prefix have to be different for the next record. Otherwise, the system prompts a ‘Unique Constraint for PGE_I2’ error.

    • The File Name Formatter (SQL) uses a SQL query to generate the file name.

    • The Data View Type defines the view for each export type, either by day, month or cruise. For example,

      • Cruise Only View: GL Export by Cruise only.

      • Month View: GL Export by Month within the cruise.

      • Day View: GL Export by Day within the cruise.

  3. When generating the GL file from Generate GL File window, the output file format appearing in the Cruise Only View Output File section is based on the chosen selection - by Cruise, Month or Day.

    Figure 2-3 Accounting Interface Transfer Data View Type


    This figure shows the output file type according to the selected Data View Type option.

  4. Click the Preview button to expand the view of records included in the file. The column prefix with “F_” denotes for output purpose only, and the column prefix with “D_” denotes for display purpose only.

  5. Click the Process button to generate the GL file. The Process button remains enabled even after the file generation completes. This is to allow the generation of the next type of export file.