Accounting and Project Accounting Periods Close Exceptions Reports

This topic provides an overview of the Accounting and Project Accounting Periods Close Exceptions reports.

Overview

You can review the unprocessed transactions and other conditions that prevent accounting or project accounting periods from being closed by using the Accounting and Project Accounting Periods Close Exceptions reports. Multiple reports are grouped under the Accounting and Project Accounting Periods Close Exceptions reports as listed below.

  • Close Accounting Period Execution Report

  • Close Pending Accounting Period Execution Report

  • Close Project Accounting Period Execution Report

  • Close Pending Project Accounting Period Execution Report

  • Accounting Period Close Exceptions Report

  • Project Accounting Period Close Exceptions Report

Key Insights

These reports answer the following business questions:

  • What must be done before I can close the periods?

  • Are there any issues which will prevent me from closing the periods?

  • Which unprocessed transactions can prevent the periods from being closed?

Frequently Asked Questions

The following table lists the frequently asked questions about these reports.

FAQ

Answer

How do I find these reports?

  • Reports and Analytics - Shared Folders - Projects - Project Cost - Accounting

  • Cost Work Area - Tasks - Reporting

  • Revenue Work Area - Tasks - Reports

How do I generate these reports?

Using the following processes:

  • Close Accounting Period

  • Close Project Accounting Period

  • Accounting Period Close Exceptions Report

  • Project Accounting Period Close Exceptions Report

Who uses these reports?

  • Grants Accountant

  • Project Accountant

When do I use these reports?

When you need to close accounting or project accounting periods.

What can I do with these reports?

You can:

  • Confirm that the status of the accounting period has been updated to close or close pending.

  • Confirm that the status of the project accounting period has been updated to close or close pending.

  • Identify unprocessed cost transactions, unaccounted cost transactions, and transactions which exist in account payables but haven't been imported into project costing that prevent accounting and project accounting periods from being closed.

What type of reports are these?

Oracle Analytics Publisher

Process Parameters for the Reports

The following table lists the parameters you must provide for the various processes that generate these reports.

Report

Process

Process Parameters

Values

Close Accounting Period Execution Report

Close Accounting Period

  • *Ledger

  • *Processing Action

  • *Period

  • Report Style

  • Ledger name from list of values

  • Accounting period close

  • Accounting period for the ledger from list of values

  • Detail

    Summary

Close Pending Accounting Period Execution Report

Close Accounting Period

  • *Ledger

  • *Processing Action

  • *Period

  • Report Style

  • Ledger name from list of values

  • Accounting period close pending

  • Accounting period for the ledger from list of values

  • Detail

    Summary

Close Project Accounting Period Execution Report

Close Project Accounting Period

  • *Ledger

  • *Processing Action

  • *Period

  • Report Style

  • Ledger name from list of values

  • Project accounting period close

  • Project accounting period for the ledger from list of values

  • Detail

    Summary

Close Pending Project Accounting Period Execution Report

Close Project Accounting Period

  • *Ledger

  • *Processing Action

  • *Period

  • Report Style

  • Ledger name from list of values

  • Project accounting period close pending

  • Project accounting period for the ledger from list of values

  • Detail

    Summary

Accounting Period Close Exceptions Report

Accounting Period Close Exceptions Report

  • *Ledger

  • *Period

  • Report Style

  • Transaction Category

  • Ledger name from list of values

  • Accounting period for the ledger from list of values

  • Detail

    Summary

  • Cross-charge transactions

    Expenditure transactions

    Inventory transactions

    Receipt accrual transactions

    Revenue transactions

    Supplier invoice transactions

Project Accounting Period Close Exceptions Report

Project Accounting Period Close Exceptions Report

  • *Business Unit

  • *Period

  • Report Style

  • Transaction Category

  • Business unit name from list of values

  • Project accounting period for the business unit from list of values

  • Detail

    Summary

  • Cross-charge transactions

    Expenditure transactions

    Inventory transactions

    Receipt accrual transactions

    Revenue transactions

    Supplier invoice transactions

The following processes always trigger the Validate Pending Inventory and Receipt Transactions process:

  • Close Accounting Period

  • Close Project Accounting Period

The following processes for inventory or receipt accrual transactions always trigger the Validate Pending Inventory and Receipt Transactions process:

  • Accounting Period Close Exceptions Report

  • Project Accounting Period Close Exceptions Report

The following processes have the processing mode set to Update:

  • Close Accounting Period

  • Close Project Accounting Period

The following processes have the processing mode set to Review:

  • Accounting Period Close Exceptions Report

  • Project Accounting Period Close Exceptions Report