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.
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.
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
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.
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:
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:
There are no predefined journal entry sources available for Generic Interface. Users can define journal sources as required.
To define journal sources:
In General Ledger, navigate to the Journal Sources window as follows:
Setup - Journal - Sources
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.
Feeder Book Mapping Window
To map book IDs from the feeder system to the ledger:
Navigate to the Feeder Book Mapping window as follows:
OPSF(I) Generic Interface - Setup - Book Mapping
In the Feeder Book ID field, enter the feeder book identifier as defined in the feeder system.
In the Ledger Name field, enter the ledger to map to the ledger in the feeder system.
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 |
Feeder Period Mappings Window
To map periods from the feeder system to General Ledger periods:
Navigate to the Feeder Period Mappings window as follows:
OPSF(I) Generic Interface - Setup - Period Mapping
In the Ledger Name field, enter the name of the ledger to map the feeder system periods.
In the Source Name field, enter the name of the feeder system that supplies transactions for this journal.
In the Source Period Name field, enter the period name as it appears in the feeder system.
In the General Ledger Period Name field, enter the General Ledger period name that corresponds to this period in the feeder system.
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 |
Feeder System Descriptors Window
To define system descriptors:
Navigate to the Feeder System Descriptors window as follows:
OPSF(I) Generic Interface - Setup - Feeder Descriptors
In the Source Name field, enter the name of the feeder system that supplies transactions for this journal.
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.
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
Enter the transaction descriptor names used by the feeder system.
Transaction descriptors correspond to General Ledger field names.
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 |