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:

• System Profile Values window

• Journal Categories window

• Feeder Book Mapping window

• Feeder Period Mappings window

• Feeder System Descriptors window

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

• Define Additional Journal Entry Sources

• Define Map Feeder Books

• Define Map Feeder Periods

• Define Feeder System Descriptors

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:

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

• Setting Profile Options.

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

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

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

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:

   • DD/MON/YYYY, the Oracle Public Sector Financials (International) standard date format

   • DDMMYYYY

   • DD/MM/YYYY

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