Running the Export GL Company Cost Centers Process

Run this process if you are converting your existing setup to use automatic cost center creation.

Note: You can only use the export functionality if you have the full version of Oracle HRMS installed.

The process is run for your current business group and writes information about GL company cost center combinations for companies that you have previously defined for your business group to a tab delimited file. It creates a record in the file for each unique company cost center combination that has been defined in GL.

To identify the company and cost center segments, the process looks to see which segments have had certain qualifiers applied. The company segment is identified by the Balancing Segment qualifier, and the cost center is identified by the Cost Center Segment qualifier.

Note: You need to ensure that your Financials implementation team has set both of these qualifiers for the GL account combinations that are being mapped to organizations in HR.

The process only includes company and cost center combinations that have not already been linked to an organization.

Run the Export GL Company Cost Centers process in the Submit requests window. You can only have one version of this process running at any one time.

arrow icon   To run the Export GL Company Cost Centers process:

  1. Select Export GL Company Cost Centers in the Name field.

  2. Select the chart of accounts for which you want to run the process.

  3. Choose the Submit button to run the process.

    The process produces two files and puts them in the directory defined by the HR: Data Exchange Directory profile option. The files produced are:

What Next?

You can use a spreadsheet or text editor to amend the GLCC_business group name_business group id.txt file to map company and cost center combinations to existing organizations in HRMS. To do this, replace the suggested organization name with the exact name of the existing organization in the organization_name column. Do not make any amendments to any other columns.

Note: If you are using Microsoft Excel to edit the tab delimited file you must make sure the settings are correct when importing the file using the Text Import wizard. Select Tab as the delimiter and ensure that each column that contains IDs or Dates is given a Column Data Format of Text. This is to ensure that numbers that begin with zeros are imported correctly and that dates are imported with the correct format. The columns you need to set are: