Register a Source System

In this procedure you register a source system into Oracle Accounting Hub.

In Oracle Accounting Hub, download the setup template:

  1. On the Setup and Maintenance work area, click the Implementation Projects button.

  2. Search for the FAH implementation project.

  3. Expand the task list: Define Accounting Entry Configuration for Rapid Implementation.

  4. Select the task: Create Subledger Application Setups in Spreadsheet.

  5. Click Go to Task.

  6. Select the Download Setup Template button.

  7. Click Save As and save the file on your local drive.

In Microsoft Excel, populate the setup template:

  1. Open the downloaded template from your local drive.

  2. Review the instructions tab for instructions on completing the template.

  3. Enter your data into the spreadsheet worksheets:

    1. Click the Source System worksheet and enter data in these fields.

      • Source System Name

      • Source System Short Name

      • Source System Transaction Name

      • Source System Transaction Short Name

    2. Click the Transaction Information worksheet and enter data in these fields:

      • Source Name

      • Source Short Name

      • Source Type

      • Source Journal Display

    3. Click the Line Information worksheet and enter data in these fields:

      • Source Name

      • Source Short Name

      • Source Type

      • Source Chart of Accounts Value

In Microsoft Excel, validate the setup template and generate a .zip file:

  1. Click the Source System worksheet.

  2. Click Validate.

  3. Click OK on the confirmation message. The .zip file was created and saved in the same local folder as the downloaded file.

In Oracle Accounting Hub, upload the .zip file.

  1. Navigate to the task: Create Subledger Application Setups in Spreadsheet.

  2. Click Go to Task.

  3. Click the Upload Setup File button.

  4. Click Browse.

  5. Browse your local drive for the .zip file you created.

  6. Select the file.

  7. Click Open.

  8. Click Import. Wait until the process completes.

  9. Click OK.

  10. Click Done.

In Oracle Accounting Hub, review your new subledger application.

  1. Navigate to the task: Manage Subledger Application.

  2. Click Go to Task.

  3. In the Select Scope window:

    • Select the Manage Subledger Application option.

    • In the Subledger Application Setup drop-down list, select Select and Add.

    • Click Apply and Go to Task.

    • Search for the subledger name, as defined in the Source System Name field in the spreadsheet.

    • Select the subledger.

    • Click Save and Close.

  4. Preview the registered source system on the Manage Subledger Application page.

    • Expand Event Model components.

    • Click Cancel.

  5. Preview the generated sources:

    • Select the Manage Source task.

    • View the sources.

    • Click Cancel.

  6. Preview the assigned accounting attributes:

    • Select the Manage Accounting Attributes task.

    • View the accounting attributes.

    • Click Cancel.