Skip Headers

Oracle Financials for Europe User Guide
Release 12.1
Part Number E13421-04
Go to Table of Contents
Contents
Go to previous page
Previous
Go to next page
Next

Oracle General Ledger

Journal Allocation

Some countries require a greater level of detail for transaction reporting in certain accounts. To fulfill this requirement, Oracle General Ledger provides an allocation accounting structure that assigns required account segment values to one or more allocated accounts. The allocated accounts maintain parallel entries for transactions posted to General Ledger.

Depending on your needs, you can create either a one-to-one or one-to-many relationship between natural accounts and the allocation account structure. These two examples show an allocation accounting structure that illustrates these relationships.

These tables provide an example of a one-to-one relationship between the account journal line and the allocated journal line:

AP Invoice Distribution Line Account Segment Debit Credit
Line 1   100  
Line 2   150  
Accounting Entries Account Segment Debit Credit
Expense 6000 100  
Expense 6000 150  
     Liability 5000   250
Allocation Accounting Entries Account Segment Debit Credit
Allocation 920060 100  
Allocation 920160 150  
     Allocation Offset 906000   250

These tables provide an example of a one-to-many relationship between the account journal line and several allocated journal lines:

AP Invoice Distribution Line Account Segment Debit Credit
Line 1   100  
Accounting Entries Account Segment Debit Credit
Expense 6000 100  
     Liability     100
Allocation Accounting Entries Account Segment Debit Credit
Allocation 920060 25  
Allocation 920160 25  
Allocation 920170 40  
Allocation 920180 10  
     Allocation Offset 906000   100

Note that the allocation accounting structure includes a contra account (allocation offset) to balance out the allocation journal.

Oracle General Ledger provides this functionality to fulfill the allocation accounting requirement:

Setting Up General Ledger for Journal Allocation

This section describes the tasks required for journal allocation:

Additional setup tasks:

After you perform the setup procedures that you want, define rule sets for allocated journals. See Defining Allocated Journals for more information.

Defining Allocated Journals

Use the Define Journal Allocations window to define rule sets for allocated journals. You define allocated journal lines for all account values that require allocation entries.

You can define one rule set for each account type that requires journal allocation, or one rule set for all account types. When you choose an account type, Oracle General Ledger only displays the account ranges that refer to that account type.

The starting point for journal allocation is the cost center range. You define for each cost center, the account ranges to include in journal allocation and the destination allocation account values to use for each allocated journal line. Account ranges cannot overlap for the same cost center range; you cannot allocate the same account range twice for the same cost centers. If you do not use cost center ranges, define the account ranges to include in journal allocation and the destination allocation account values.

You also define the percentage amount that you want applied to each allocated journal line. For standard journal allocation, the total percentage amounts of all allocated journal lines must equal 100%. You can also create partial allocation entries that total less than 100% of the original accounting transaction, however, depending on your business requirements.

For each rule set that you create, choose the offset account at either the account level or the allocation level. Do not mix the level at which you define offset accounts within a rule set.

After you define your rule sets for journal allocation, run the Validate Allocation Rule Sets program to confirm the validity of the rule sets that you defined. See Validating Journal Allocations for more information.

After you validate your rule sets, run the Allocate Journals program to create allocated journals. See Creating Journal Allocations for more information.

Prerequisites

Before you can define allocated journals, you must:

To define a rule set for allocated journals:

  1. Navigate to the Define Journal Allocations window.

  2. In the Rule Set field, enter a unique name for this set of journal allocation rules.

  3. In the Chart of Accounts field, enter the chart of accounts structure that you want to use. The default value is the responsibility chart of accounts name within your ledger.

  4. If you use an account type, enter the account type in the Account Type field, such as Asset or Expense, for this rule set.

  5. If you are going to use partial allocation, check the Allow Partial Allocation check box.

  6. If you use cost centers, navigate to the Cost Center Range region. Otherwise go to step 9.

  7. In the Low and High fields, enter the first cost center range to process.

  8. In the Description field, you can optionally enter a unique description for this allocated journal.

    If you import allocated journals into General Ledger after journal allocation and if you enter Yes in the Headers by Cost Center Range? parameter in the Allocate Journals program, Journal Import uses the description in this field as a prefix to the standard journal header created by the import process. This description appears in the journal header.

  9. Navigate to the Account Range region.

  10. In the Low and High fields, enter the account ranges to process. This field only returns values for the account type that you specify.

    Note: Account ranges cannot overlap for the same cost center ranges.

  11. In the Offset field, enter the offset account for these account ranges.

    If you enter the offset here, the Offset fields are disabled in the Allocations region.

  12. Navigate to the Allocations region.

  13. In the percentage (%) fields, enter the percentage amount to allocate to each destination account.

    The total of all percentages must equal 100, unless you checked the Allow Partial Allocation check box.

    Note: Partial allocation is enforced when you run the Allocate Journals program or the Validate Allocation Rule Sets program.

  14. In the Account fields, enter the destination account value or values for allocated journal lines.

  15. In the Offset field, enter the offset account for the allocated account values, if you did not enter the offset in the Account Range region.

  16. Save your work.

  17. Repeat steps 7 to 16 for each required cost center range for this rule set.

  18. Repeat steps 2 to 18 for each rule set that you want to create.

  19. Run the Journal Allocation - Rule Set Listing to review your rule sets.

    See Journal Allocation - Rule Set Listing for more information.

Validating Journal Allocations

Use the Validate Allocation Rule Sets program to verify the completeness of your journal allocation definitions before actually creating physical journal allocations.

Run the Validate Allocation Rule Sets program under any of the following circumstances:

The Validate Allocation Rule Sets program validates the rule set against posted journal lines and produces an exception report of invalid or missing rule set definitions.

After you validate your rule set definitions, you can create physical journal allocations. SeeCreating Journal Allocations for more information.

Use the Standard Request Submission windows to submit the Validate Allocation Rule Sets program.

Program Parameters

Rule Set

Enter the rule set that you want to use for journal allocation.

Period

Enter the accounting period that you want. The Validate Allocation Rule Sets program only processes posted journals within this period.

Currency

Enter the journal currency code.

Amount Type

Enter the amount type to assign to allocated journal entries:

Balance Type

Enter the journal balance type:

Budget Name/Encumbrance Type

Enter the budget name or encumbrance type, depending on whether you entered Budget or Encumbrance in the Balance Type field.

Balancing Segment Value

Enter the balancing segment value for allocated journal lines. The Validate Allocation Rule Sets program only processes journal lines containing this balancing segment value.

Destination Segment Method

Enter the segment method that you want to use for allocated journal line account code combinations. Choose one of the following:

Error Handling

Enter Warning (default) as the error handling method that you want to use to validate the rule set. The available options are:

Related Topics

Running Reports and Programs, Oracle Applications User Guide

Creating Journal Allocations

Use the Allocate Journals program to process posted accounting entries and create the new allocated journals. The Allocate Journals program creates allocated journals based on the rule sets that you defined in the Define Journal Allocations window.

The Allocate Journals program marks each journal line with a corresponding allocated journal line which prevents the program from reallocating the same journal lines in subsequent runs for the same period.

The Allocate Journals program loads the newly created allocated journals into the General Ledger Interface table. You can set the Allocate Journals program to run Journal Import after creating allocated journals. The Journal Import reads and validates the allocated journal entries, and creates new unposted journals in general ledger.

The Allocate Journals program produces an exception report of the journal lines without journal allocation rules or with invalid rule set definitions. Depending on your needs, you can set the Allocate Journals program to record errors and continue processing, to ignore any errors found, or to record errors and abort processing.

If you need to correct a rule set after you create the physical journal allocations, you can unallocate a previous journal allocation. You may also need to reverse or delete the imported journal. The Unallocate Journals program unmarks the journal lines marked by the Allocate Journals program. See Unallocating Journal Allocations for more information.

Allocated journals must conform to other General Ledger settings and rules, such as cross-validation rules. Oracle General Ledger does not validate all journal rules when you run the Allocate Journals program, but instead during the Journal Import process. If the allocated journals violate any other journal rules, you need to find and correct the source of the error. See Correcting Journal Allocations for more information.

You can run the Journal Allocation - Rule Set Listing to print a record of the current rule sets used to create allocated journals. See Journal Allocation - Rule Set Listing for more information.

You can run the Allocate Journals program by choosing Run Allocate Journals from the Special menu in the Define Journal Allocations window, or as a standard request submission.

Prerequisites

Before you can create allocated journals, you must:

Program Parameters

Enter these parameters to specify the desired program options:

Rule Set

Enter the rule set that you want to use for journal allocation.

Period

Enter an open or future accounting period. The Allocate Journals program only processes posted journals within this period.

Currency

Enter the journal currency code.

Amount Type

Enter the amount type to assign to allocated journal entries:

Balance Type

Enter the journal balance type:

Budget Name/Encumbrance Type

Enter the budget name or encumbrance type, depending on whether you entered Budget or Encumbrance in the Balance Type field.

Balancing Segment Value

Enter the balancing segment value for allocated journal lines. The Allocate Journals program only processes journal lines with this balancing segment value.

Destination Ledger Name

Enter the ledger that you want to use to create allocated journals.

Destination Period

Enter an open period for allocated journals. You can enter the same open period that the allocated journal was created from, or any open period or future available period before or after.

Destination Source

Enter the journal source that you want to assign to allocated journals.

Destination Journal Category

Enter the journal category that you want to use for allocated journals. The Allocate Journals program assigns this journal category to each allocated journal.

Destination Segment Method

Enter the segment method that you want to use for allocated journal line account code combinations. Choose one of the following:

Headers by Cost Center Range?

Enter Yes if you want to create journal headers per cost center range.

Note: If you entered a cost center range description in the Description field in the Define Journal Allocations window, the description is included in each journal header. Enter No to create the same journal header for all ranges.

Abort on Missing Rule

Enter the error handling method to use to validate the rule set:

Run Journal Import?

Enter Yes to run Journal Import after the Allocate Journals program creates physical journal allocations. Enter No to create physical journal allocations without running Journal Import.

Enter values in the following parameters if you entered Yes in the Run Journal Import? field.

Destination Summary Level

Enter the summary level that you want to use for Journal Import:

Import Descriptive Flexfields?

Choose whether to import descriptive flexfields along with your journal information.

Note: You can only use this option if you entered Detail in the Destination Summary Level field.

Choose one of the following:

Post Errors to Suspense Account

If you entered Yes in the Run Journal Import? Field, enter Yes or No to specify whether Journal Import should post erroneous journals to a suspense account.

Note: You can only enter Yes if your destination ledger allows suspense posting.

Related Topics

Running Reports and Programs, Oracle Applications User Guide

Correcting Journal Allocations

After you run Journal Import for your allocated journals, you may find that Journal Import rejected data from journal allocation processing. In some cases, the allocated journals may violate the Oracle General Ledger cross-validation rules due to an error in the journal allocation rule set, or the cross-validation rules themselves may be in error.

To correct journal allocations, use one of these procedures:

See Unallocating Journal Allocations for information about unallocating a journal allocation.

Related Topics

Importing Journals, Oracle General Ledger User Guide

Unallocating Journal Allocations

Use the Unallocate Journals program to unallocate a journal allocation. The Unallocate Journals program unmarks the journal lines used to create the allocated journal to include journal lines in a subsequent run of the Allocate Journals program.

Note: After you run the Unallocate Journals program, run the Delete Journal Import program to delete allocated journal lines that are already loaded into the General Ledger interface tables.

You need to reverse a journal allocation if the Allocate Journals program produces several errors during processing. The Allocate Journals program exception report provides details of all unallocated journal lines and invalid rule definitions.

Use the Define Journal Allocations window to modify the rule set, then run the Validate Allocation Rule Sets program or the Allocate Journals program again.

You can also use the Journal Allocation - Rule Set Listing to review your rule sets before running the Allocate Journals program. See Journal Allocation - Rule Set Listing for more information.

Use the Standard Request Submission windows to submit the Unallocate Journals program.

Program Parameters

Concurrent Request ID

Enter the concurrent request ID of the last run of the Allocate Journals program. The concurrent request ID is part of your destination journal batch name.

Related Topics

Running Reports and Programs, Oracle Applications User Guide

Importing Journals, Oracle General Ledger User Guide

Journal Allocation - Rule Set Listing

Use the Journal Allocation - Rule Set Listing to review your rule sets for journal allocation. The Journal Allocation - Rule Set Listing prints a listing, for each rule set, of the natural accounts and their destination allocated journal accounts and offsets.

After you review your rule sets, you can use the Define Journal Allocations window to correct any rule set errors.

Use the Standard Request Submission windows to submit the Journal Allocation - Rule Set Listing.

Report Parameters

Rule Set Name

Enter the name of the rule set that you want to print for the report.

Related Topics

Running Reports and Programs, Oracle Applications User Guide

Year End Closing Journals

Many organizations follow specific procedures to generate special journal entries to close and open fiscal years. These closing entries apply to both the income statement and balance sheet. At fiscal year end, all accounts must be closed to get the economic result and balances. The E-Business Suite provides a program that closes the account by putting the debit sum in the credit and vice versa.

For some countries, fiscal requirements dictate that the accounts must be closed through the difference between Total Debit and Total Credit. In these countries, all year end process journals created require considering the resulting net amount between credit and debit amounts.

The Net Amount is the difference between total credit and total debit when the total credit is greater, or the difference between the total debit and the total credit when the total debit is greater.

To meet the Net Amount requirements for Year End Closing Journals, select the Net Closing Balance Journal checkbox in Accounting Setup Manager.

Net Closing Balance Journal

During setup in the Accounting Setup Manager, when you select the Net Closing Balance Journal checkbox in the Ledger Options page, net balance closing entries will be generated by the Close Process: Create Income Statement Closing Journals and Close Process: Create Balance Sheet Closing concurrent programs for Profit and Loss accounts and for Balance accounts. The entries are calculated as the difference between total debit and total credit, and vice versa.

The default option for this checkbox is unchecked. When the Net Closing Balance Journal checkbox remains unchecked, the Close Process: Create Balance Sheet Closing and Close Process: Create Income Statement Closing Journals concurrent programs will calculate closing journals in the standard accumulated balance method. Accumulated balance closing journal entries will be generated for Profit and Loss balance accounts, having both credit and debit amounts in the balances. The entries are calculated as the reciprocal of total debit in the credit side, and total credit in the debit side.

Prerequisites

Before selecting the Net Closing Balance Journal checkbox, the following tasks must be completed:

Related Topics

General Ledger Setup Steps, Oracle General Ledger Implementation Guide.

Running Reports and Programs, Oracle Applications User Guide.

Reports

General Ledger Journal Entry Report

Use the General Ledger Journal Entry report to retrieve all information required by the transactional reports. The transactional reports only require journal entry information and do not require account balance information. The journal entry information is used in all and comprises fields belonging to journal entry line, journal entry header, and journal batch information.

A journal entry represents a transaction in general ledger. It is an annotation of an event and is recorded by indicating the amount of the event and what it was used for. What it was used for is represented by an Account. Each Account has a meaning, which allows identifying what has been done; for example, an item was purchased, or sold, or returned. Additional information on a journal entry better allows describing and controlling the transaction (event).

The report uses the General Ledger Journal Entry Report XML Publisher template. The template is essentially the same as the report, but with changes like group by’s (Legal Entity, Effective Date, Batch, and Journal), Brought/Carried Forward and Page Total and Daily Brought/Carried Forward. The Journal Entry Data Extract program is used for information retrieval purposes.

Use the Standard Request Submission windows to submit the General Ledger Journal Entry report. First choose the General Ledger Journal Entry report and after entering the report parameters, chose the XML publisher template you want to run in the Options window.

Prerequisites

Before submitting the General Ledger Journal Entry Report, you must post the subledger journals to the general ledger to ensure that all the report information appears correctly. Otherwise, certain report column values may not be available.

Additional Prerequisites for Poland

Complete the following:

Report Parameters

Posting Status

Select the applicable posting status. The valid values are Error Status, Posted Journals, and Unposted Journals.

Page Number Format

Select the applicable page number format. The valid values are Page: n and Page: n of m. Default value is Page: n of m.

General Ledger Journal and Balance Report

Use the General Ledger Journal and Balance report to retrieve all information required by the reports that require transactions, for example journal entries, and account balances. An account balance represents the total currency amount of an account in a given period of time. This report enables you to identify how much was spent on purchases and how much was sold.

The report uses the General Ledger Journal and Balance Report and General Ledger Journal and Balance Report by Balancing Segment XML Publisher templates. These templates are essentially the same as the report, but with changes like group by’s (Legal Entity, Period, Natural Account Segment, Account, and Batch.) and Brought/Carried Forward and Page Total. The General Ledger Journal and Balance Report by Balancing Segment template has group by balancing segment as well. The report uses the General Ledger Journal and Balance Data Extract program for information retrieval purposes.

Use the Standard Request Submission windows to submit the General Ledger Journal and Balance reports. First choose the General Ledger Journal and Balance report and after entering the report parameters, chose the XML publisher template you want to run in the Options window.

Prerequisites

Before submitting the General Ledger Journal and Balance reports, you must complete the following:

Report Parameters

Ledger Currency

Enter the primary currency and translated currencies. The default value is primary currency of the ledger selected.

Currency Type

Select the applicable type of currency. The default value is Total.

Entered Currency

Displays the list of valid currencies when Currency Type is Entered, defaults to STAT when Currency Type is Statistical and defaults to N/A when Currency Type is Total. The default value is N/A

Balance Type

Select the applicable type of balance. The default is Actual (A).

Budget or Encumbrance Name

It is required if the balance type is B or E. The default value is N/A.

Account Level

Enter the number for degree reporting. The valid values are null and 1 through 10. Null means only detail rows will be printed. 1 through 10 means relevant number of parent total rows and detail rows will be printed.

Top Level Parent Account

Indicate the hierarchy that you want to work with. This is required if the account level is not null.

Page Number Format

Select the applicable page number format. The valid values are Page: n and Page: n of m. The default value is Page: n of m.

General Ledger Trial Balance Report

Use the General Ledger Trial Balance report to retrieve all information required by the following reports and the flat file:

The General Ledger Trial Balance report shows accounting activity in the form of account balances. Below is a brief description of some of the information in the reports:

The General Ledger Trial Balance report uses the following XML Publisher templates:

The templates are essentially the same as the report, but with changes like group by’s (Legal Entity, Balancing Segment, Account Segment, and Account or Account Level Segment Value) and Brought/Carried Forward and Page Total. The report uses the General Ledger Trial Balance Report Data Extract program for information retrieval purposes.

Use the Standard Request Submission windows to submit the General Ledger Trial Balance report. First choose the General Ledger Trial Balance Report and after entering the report parameters, chose the XML publisher template you want to run in the Options window.

Prerequisites

Before submitting the General Ledger Trial Balance report, you must complete these tasks:

Prerequisites for Turkey

Complete the following account hierarchy setup to provide balances at summary levels:

Report Parameters

Ledger Currency

Select the primary currency and translated currencies. The default value is functional currency of the ledger selected.

Currency Type

Select the applicable type of currency. The default value is Total.

Entered Currency

Displays the list of valid currencies when Currency Type is Entered, defaults to STAT when Currency Type is Statistical and defaults to N/A when Currency Type is Total. The default value is N/A.

Period To

Enter a period later than Period From, but in the same fiscal year.

Account Level

Enter the number for degree reporting. The valid values are null and 1 through 10. Null means only detail rows will be printed. 1 through 10 means relevant number of parent total rows and detail rows will be printed.

Top Level Parent Account

Indicates the hierarchy that you want to work with. This is required if the account level is not null.

Account Class

Select the applicable account class. The default value is All.

Account Delimiter

Select the applicable account delimiter. This is used for Greek Trial Balance reporting.

Zero Beginning of Year Balance

Select Yes to have zero balance for debit and credit. Select No to get the year begin balance of the year. The default value is No.

Trial Balance Type

Select the applicable trial balance type. This is used for Portugal reporting only.

Page Number Format

Select the applicable page number format. The valid values are Page: n and Page: n of m. The default value is Page: n of m.

Portuguese General Ledger Trial Balance Reports

Use the Portuguese General Ledger Trial Balance reports to meet legal, statutory, and internal management reporting requirements in Portugal. There are five separate reports with a standard layout; however, each report has different parameters. The reports display the current period, up to the end of the previous period, year-to-date, and current balance.

The Portuguese General Ledger Trial Balance reports print a single line of data for each natural account. The reports are sorted by natural account, in ascending order, for the segments that you specify. The report layout is 180 characters wide. The account balances are returned in functional currency only.

If you do not want the natural accounts reported as parent accounts, then you must define the accounts and make them non-posting accounts. The following table shows account values and their descriptions:

Account Value Description (with proper account descriptions)
11 Total for degree 2 range 11x
111 Total for degree 3 range 111x
112 Total for degree 3 range 112x
1111 Detailed Account 1111
1112 Detailed Account 1112
1121 Detailed Account 1121
1122 Detailed Account 1122

Note: Balances for account 11 are the addition of accounts 1111, 1112, 1121, and 1122. Balances for account 111 are for accounts 1111 and 1112. Balances for account 112 are for accounts 1121 and 1122.

Report Types

Portuguese General Ledger Detail Trial Balance Report

The degree that you select determines the level of summary information that appears for the account codes, period, and balancing segments that you select.

Portuguese General Ledger Summary Trial Balance Report

The Portuguese General Ledger Summary Trial Balance report displays selected accounts at Degree 1, such as the summary level. The report displays only two-digit accounts and aggregates all associated balances up to this degree level.

Portuguese General Ledger Results Trial Balance Report

The Portuguese General Ledger Results Trial Balance report displays accounting balances for classes 6, 7, and 8 accounts (excluding account 88 - Year Net Result) for Degree 1 through Degree 7. These classes are associated with trading accounts. The Portuguese General Ledger Results Trial Balance report displays information on the trading position for the balancing segment that you select.

Portuguese General Ledger Begin Year Trial Balance Report

The Portuguese General Ledger Begin Year Trial Balance report excludes classes 6, 7, and 8 (apart from account 88 - Year Net Result), which are associated with the company's trading accounts. At the beginning of the year, only balance sheet accounts are displayed.

Portuguese General Ledger End Year Trial Balance Report

The Portuguese General Ledger End Year Trial Balance report is run after the Results Calculation because it represents the final year end trial balance for all accounts except for classes 6 and 7, which are set to zero at the end of the fiscal year.

Prerequisites

Before running the Portuguese General Ledger Trial Balance reports, you must:

Greece

Define Parent Account Structure

Greek law currently requires that you use a statutory account class hierarchy for your chart of accounts. This hierarchy is called a parent account structure. Companies must report on both summarized account balances and account activity for one or more account class levels in the parent account structure.

Greek law requires that at a minimum the first two account levels of the account class hierarchy are parent in most cases, or precision, levels with a fixed digit width. The first level has a fixed width of two digits. The second level has a fixed width of four digits: the first two digits of the second level replicate the first parent level values. A parent defined at the third level has a fixed width of six digits: the first four digits replicate the second parent level values plus two additional digits.

Every child value in the chart of accounts must have a parent to appear in a summarized report. This parent must also have a parent, and so on, up to the highest parent level. The highest parent level must have a two-digit width.

The first (highest) level in the parent account structure is called a class; the second level is called a sub-class; the third level is called a group.

This table is an example of an account structure with child at the third level:

Value Parent Level Regulated Precision
60 Yes First Yes Class
6000 Yes Second Yes Sub-class
6000234 No Third No Group

This table is an example of an account structure with parent at the third level:

Value Parent Level Regulated Precision
62 Yes First Yes Class
6200 Yes Second Yes Sub-class
620002 Yes Third No Group
620202234 No Fourth No No

Using the Parent Account Structure for Statutory Reporting

You must have a fixed parent account structure over the precision levels that are used for summarized reporting to fulfill statutory reporting requirements. Statutory reporting's summarized precision feature lets you report on accounts at the first, second, and third levels.

To provide a summarized report with the three levels, however, you cannot mix parent and child values at the third level in your chart of accounts because summarized statutory reporting cannot distinguish child values at the third level from parent values also defined at the third level.

You should set up a three-level parent account structure to make full use of the summarized statutory reporting functionality.

Related Topics

Defining Your Account Structure, Oracle General Ledger Implementation Guide

Parent and Child Values and Rollup Groups, Oracle General Ledger Implementation Guide

Accounting Cutoff Rules

The following cutoff rules apply to postings in Oracle General Ledger:

Use the JEGR: Default Cutoff Days profile option to set the default number of cutoff days. The system uses this default when no cutoff rule is defined.

Posting Entries

You must post all journals within the designated cutoff rule period. Oracle General Ledger invalidates journals that are not posted within the cutoff period, and the entire journal batch fails the posting process.

Oracle General Ledger automatically enforces the cutoff rules when you post a journal batch. Use the Journal Posting Execution report to review journal entries that failed due to cutoff rule violations.

To correct journals that violate cutoff rules:

  1. Change the journal header effective date to within the cutoff rule period.

  2. Save your changes.

  3. Resubmit the journal batch for posting.

Analytical Accounts

Run the allocate journal process to create your analytical accounting entries at the end of each period, after you:

Analytical accounting journals can remain open until the end of the following fiscal period, which is the end of the following month. You should, however, complete journals within 15 days because Oracle Financials defines rule periods as a set number of days, and the number of days in a rule period is not consistent from month to month.

Adjustment Period Journals

You can update unposted adjustment period journal entries for up to four months before posting. Adjustment periods overlap the beginning and end period for the fiscal year. Journal entries made to these adjustment periods are usually dated January 1 or December 31.

Related Topics

Posting Journal Batches, Oracle General Ledger User Guide

Norwegian Government EDI Reporting (GEI)

Use the Norwegian Government EDI reporting (GEI) functionality to electronically report accounting data from government departments to the central state accounting budget controlled by the Ministry of Finance (FIN). The GEI functionality enables you to:

Setting Up Norwegian Government EDI Reporting (GEI)

To electronically report accounting data using the GEI functionality, you must complete the following tasks:

Related Topics

General Ledger Setup Steps, Oracle General Ledger Implementation Guide

Requesting the S-Report

The routine for creating and sending a S-Report consists of the following steps:

S-Report Proposal

To check or reconcile the accounting figures, you can request a Preliminary S-Report before you create the file to be sent to the Ministry of Finance. The preliminary report coincides with the final S-Report, but unlike the final report it is possible to select open periods as parameters. If the Preliminary S-Report is ok, then you must temporarily close the accounting period in Oracle General Ledger, and request the final S-Report.

Generate the S-Report using the Norwegian GEI S-Report concurrent program in the Submit Request window.

Report Parameters

Final Report?

Enter Yes if this is the final S-Report and No if it is the proposal.

Period

Enter the period for which you are reporting.

Income

Enter the sum from the account in the Norwegian Bank - revenue - Refer to Bank Statement. You must enter the balances representing assets for the company without the '-' or '+' prefix, and the balances representing liabilities for the company with a '-' (minus) prefix.

Expenses

Enter the sum from the account in the Norwegian Bank - expenses - Refer to Bank Statement. You must enter the balances representing liabilities for the company without the '-' or '+' prefix, and the balances representing assets for the company with a '-' (minus) prefix.

Filename and Path

Enter the filename and path for which the generated flat file should be written to. This is only needed for the final S-Report.

Final S-Report

If the Preliminary S-Report is ok, then close the accounting period temporarily, and request the final S-Report, by running the Norwegian GEI S-Report, but this time with Yes for the Final Report? parameter. For this report, you can not select a period that has not been temporarily closed. Running the report in the final mode also creates a flat file in the specified output directory provided by the Filename and Path parameter. You send this file to the Ministry of Finance.

Sending the S-Report to Ministry of Finance

There are different ways of sending the file from the company to the Ministry of Finance. The most common is a third party program that checks, at constant intervals, the specified output directory (Filename and Path parameter) for requests that are waiting to be sent. The third party program then translates the flat file into EDIFACT standard and transfers it to the Ministry of Finance, which then prepares a receipt after checking the received S-Report. Some companies use the Ministry of Finance’s Web application to post the flat file as is.

Receiving the Receipt from Ministry of Finance

The Ministry of Finance returns a receipt regardless of whether the S-report is rejected or approved, assuming the file does not contain syntax errors. The receipt is also referred to as a APERAK-control message. The receipt has one of the three status codes:

The Ministry of Finance uses the last code when, for example, the reconciliation variance (or discrepancy) between the General Ledger figures and the Bank Statement figures is so small that the Ministry of Finance chooses to process the S-Report manually instead of rejecting it.

Requesting the A-Report

Use the A-Report to request reconciliation information from the State Central Accounts department, containing accumulated accounting figures that the company has reported to the Ministry of Finance. After checking this reconciliation information, against the GL figures, close the reporting period. The routine for requesting and receiving the A-Report from the Ministry of Finance is as follows:

Requesting the A-Report

Use the Norwegian GEI Request A-Report concurrent program in the Submit Request window to request for the A-Report.

Sending the Request to Ministry of Finance

There are different ways of sending the file from the company to the Ministry of Finance. The most common is a third party program that checks, at constant intervals, the specified output directory (Filename and Path parameter) for requests that are waiting to be sent. The third party program then translates the flat file into EDIFACT standard and transfers it to the Ministry of Finance. Some companies use the Ministry of Finance’s Web application to post the flat file as is. The Ministry of Finance then prepares a receipt after checking the received S-Report, based on the following:

Receiving the A-Report from Ministry of Finance

If the request was approved, then the Ministry of Finance will return an A-Report. After you receive the transferred file on the unix-machine, you must run the following programs:

Checking and Closing a Period

After receiving the A-Report, check it against the accumulated figures in the accounting system, for example a statement of account. If the figures are in agreement, then you must close the accounting period permanently using the Open and Close Periods window in Oracle General Ledger. If the figures in the A-Report do not agree with the statement of account, then you must correct them after reopening the reporting period. You must repeat the A-Report routine as described previously.

Norwegian Government EDI Reporting Errors

No Return from Ministry of Finance

Receiving Control Messages

The Ministry of Finance always returns a control message when receiving an A-Report request or a S-Report. The message only implies if the shipment is accepted or rejected. You must check the control message if you do not receive the requested A-Report, or in case of a S-Report - an APERAK-message that the Ministry of Finance has received the S-Report. This can be the result of technical errors during sending and the request or report must be sent again. To enable the Ministry of Finance to send control messages, you must ensure that the EDI-translation program is setup correctly, such that the request for control messages is sent automatically. The control message is read directly from the unix-machine. There are three codes on the control message:

No Data in S-Report

If the S-Report is empty, it is because the view used to retrieve data does not contain any data. The reason for this can be: