Skip Headers

Oracle Public Sector Financials (International) Implementation Guide
Release 12.1
Part Number E13417-04
Go to Table of Contents
Contents
Go to previous page
Previous
Go to next page
Next

Generic Interface Setup

Definition

The Generic Interface setup windows are used to identify and map a relationship between an external system, such as a payroll system, and corresponding elements in the General Ledger system.

This chapter describes the journal source and feeder book windows only.

Overview

The following Oracle Public Sector Financials (International) and Oracle General Ledger windows are described:

The setup windows identify external sources for data and ensure journal lines are imported correctly into the appropriate journals and period in the correct ledger.

A profile option can be set at site, application, responsibility, or user level to control access to secure feeder system data.

The layout of feeder system data files must conform to the file specification. The following table shows how field names in the feeder system data file relate to General Ledger items.

Mapping Feeder System Data File Fields to General Ledger
Feeder System Data File Element Record Type Feeder System Data File Element Field Name Maps to General Ledger Item In Window ...
FH, file header Feeder Book ID Ledger ID Feeder Book Mapping
FH, file header Source Period Name General Ledger period name Feeder Period Mappings
JH, journal header Category Name Journal entry category Define Journal Categories
TL, transaction line Feeder System Descriptors Detail fields in corresponding General Ledger area Feeder System Descriptors

Related Topics

3. Specify Site-Level and Application-Level Profile Options Procedure.

Defining Journal Categories, Oracle General Ledger User's Guide

Prerequisites

Accounting periods must be defined in the General Ledger. Journal categories must be defined in the General Ledger.

To define accounting periods and journal categories see Setting Up, Oracle General Ledger User's Guide.

If using Generic Interface, the source must be defined as Import References and set to Yes.

Generic Interface Setup Steps

The Generic Interface functionality is based on the standard General Ledger journal interface. Generic Interface enhances the file loading, data manipulation, and inquiry steps in the import process. Setting up Generic Interface consists of the following procedures:

Set Profile Options

Generic Interface provides one profile option - Generic Interface: View Secure Sources - that controls access to secure source feeder system detail transactions.

For information on setting profile options, see the following:

Define Additional Journal Entry Sources

This step is recommended.

There are no predefined journal entry sources available for Generic Interface. Users can define journal sources as required.

To define journal sources:

  1. In General Ledger, navigate to the Journal Sources window as follows:

    Setup - Journal - Sources

  2. Define journal entry sources to uniquely identify journals imported using the generic interface.

    For information on defining journal sources, see Defining Journal Sources, Oracle General Ledger User's Guide.

Note: Users must select the Import Journal References check box for each journal source to be used.

Define Map Feeder Books

This step is required.

Feeder Book Mapping Window

the picture is described in the document text

To map book IDs from the feeder system to the ledger:

  1. Navigate to the Feeder Book Mapping window as follows:

    OPSF(I) Generic Interface - Setup - Book Mapping

  2. In the Feeder Book ID field, enter the feeder book identifier as defined in the feeder system.

  3. In the Ledger Name field, enter the ledger to map to the ledger in the feeder system.

Feeder Book Mapping Window Description

Feeder Book Mapping Window Description
Field Name Description
Feeder Book Id Feeder book identifier as defined in feeder system
Ledger Name Ledger name to be mapped to feeder book specified by Feeder Book Id

Define Map Feeder Periods

This step is required.

Feeder Period Mappings Window

the picture is described in the document text

To map periods from the feeder system to General Ledger periods:

  1. Navigate to the Feeder Period Mappings window as follows:

    OPSF(I) Generic Interface - Setup - Period Mapping

  2. In the Ledger Name field, enter the name of the ledger to map the feeder system periods.

  3. In the Source Name field, enter the name of the feeder system that supplies transactions for this journal.

  4. In the Source Period Name field, enter the period name as it appears in the feeder system.

  5. In the General Ledger Period Name field, enter the General Ledger period name that corresponds to this period in the feeder system.

Feeder Period Mappings Window Description

Feeder Period Mappings Window Description
Field Name Description
Ledger Name Corresponding ledger to map feeder system periods
Source Name Feeder system journal source name
Description Feeder system journal source description
Source Period Name Feeder system period name
General Ledger Period Name Corresponding General Ledger period name

Define Feeder System Descriptors

This step is required.

Feeder System Descriptors Window

the picture is described in the document text

To define system descriptors:

  1. Navigate to the Feeder System Descriptors window as follows:

    OPSF(I) Generic Interface - Setup - Feeder Descriptors

  2. In the Source Name field, enter the name of the feeder system that supplies transactions for this journal.

  3. If some users are not allowed access to transaction details imported from this feeder system, select Secure Source.

    This option is available only if the Generic Interface: View Secure Sources profile option is set to No.

    For information on setting profile options, see 3. Specify Site-Level and Application-Level Profile Options Procedure.

  4. In the Date Picture field, enter the format used by the feeder system for displaying dates. Typical values are as follows:

  5. Enter the transaction descriptor names used by the feeder system.

    Transaction descriptors correspond to General Ledger field names.

Feeder System Descriptors Window Description

Feeder System Descriptors Window Description
Field Name Description
Source Name Feeder system source name
Description Feeder system source description
Secure Source Restricts access to journal source feeder information
Date Picture Feeder system date format
Descriptor Transaction descriptors