The transaction exception details reports list all transactions that have not been fully processed. You can use this report to identify corrections that you need to make before you attempt to close a period in Oracle Projects. You can run the following two transaction exception details reports:
EXC: Transaction Exception Details by PA Period: The report is sorted by PA period. Within each PA period, the report is sorted by exception category (see the list of report parameters below) and exception reason. For each group of transactions under an exception reason, the report lists the total amount and total number of items.
EXC: Transaction Exception Details by GL Period: The report is sorted by GL period. Within each GL period, the report is sorted by exception category (see the list of report parameters below) and exception reason. For each group of transactions under an exception reason, the report lists the total amount and total number of items.
Costing and cross charge exceptions are shown in functional and transaction currencies. Revenue exceptions are shown in the project currency.
The table below shows the information that is listed for transactions in each exception category:
| Exception Category | Information Listed for Each Transaction |
|---|---|
| Accounts Payable Invoice Exceptions | invoice number, invoice date, supplier number, supplier, line number, posted (yes or no), project, task, expenditure type, and amount |
| Costing Exceptions | supplier or employee, project, task, expenditure type, expenditure item date, expenditure batch name, quantity, unit, functional amount, transaction currency, and transaction amount |
| Cross Charge Exceptions | receiver operating unit, project, task, employee, supplier, non-labor resource organization, expenditure organization, date, type |
| Project Manufacturing/Inventory Exceptions | organization, originating table, transaction identifier, project, and task |
| Receipt Accrual Exceptions | receipt number, date, supplier number, supplier name, PO number, line number, shipment number, distribution number, project, task expenditure type, and amount |
| Revenue Exceptions | project, draft revenue number, and project amount |
| Uncosted Transactions | project, task, expenditure batch, supplier or employee, expenditure type, expenditure item date or accrual date, currency, and amount |
From PA Period...To PA Period. This parameter is only for the EXC: Transaction Exception Details by PA Period report. Enter a range of PA periods for which you want the report to print exceptions. These parameters are required. You must specify valid PA periods.
From GL Period...To GL Period. This parameter is only for the EXC: Transaction Exception Details by GL Period report. Enter a range of GL periods for which you want the report to print exceptions. These parameters are required. You must specify valid GL periods.
Exception Category. If you want the report to print just one category of exceptions, you can select an exception category. If you leave this parameter blank, the report includes all categories. The categories are:
Accounts Payable Invoice Exceptions. Includes supplier invoices that have not been interfaced from Oracle Payables to Oracle Projects.
Costing Exceptions. Includes cost distribution lines for which Oracle Projects has not successfully generated an accounting event.
Cross Charge Exceptions. Includes cross charge distribution lines for which Oracle Projects has not successfully generated an accounting event.
Project Manufacturing/Inventory Exceptions. Includes costs that have not been interfaced from Oracle Project Manufacturing and Oracle Inventory to Oracle Projects.
Receipt Accrual Exceptions. Includes receipt accruals that have not been interfaced from Oracle Purchasing to Oracle Projects.
Revenue Exceptions. Includes revenue distribution lines for which Oracle Projects has not successfully generated an accounting event.
Uncosted Transactions. Includes expenditure items that have not been cost distributed in Oracle Projects.
Exception Reason. If you selected an exception category, you can also select an exception reason. The list of values displays exception reasons that are valid for the category you chose. If you leave this parameter blank, the report includes all exception reasons.
Show Transaction Exceptions Across Operating Units. This parameter is only for the EXC: Transaction Exception Details by PA Period report. Select Yes if you want the report to display transaction exceptions across operating units. This parameter is required.