Use the Expenditure Items window to review a project's expenditure items. You can see the amount and type of expenditure items charged to a project, the date an expenditure item occurred, accrued revenue, and other information. You can also drill down to Oracle Payables to view the Invoice Overview form. You can use the View Accounting option from the Tools menu to review the accounting entries for expenditure items.
Navigate to the Find Project Expenditure Items or Find Expenditure Items window. See: Oracle Projects Navigation Paths.
Your ability to navigate to either window (by selecting Project or All) depends on your user responsibility.
If you select Project, you can view expenditure items for a single project. If your system uses project security, you can select only projects that you are allowed to see. You can view expenditure items for a project that are specific to the current operating unit, as well as those expenditure items that are charged across operating units. You can enter search criteria to determine whether Oracle Projects queries expenditure items specific to the current operating unit, expenditure items charged across operating units, or both.
If you select All, you can view expenditure items across projects, and can structure your query to retrieve information across projects. No project security is enforced. Oracle Projects shows only the expenditure items that correspond to the current operating unit. If a project has expenditure items that are charged across operating units, then you are not able to view these expenditure items using the Find Expenditure Items window. In this case, you must use the Find Project Expenditure Items window to view these expenditure items.
In the Find Expenditure Items window, enter your search criteria. See: Expenditure Items Windows Reference.
Choose Find if you want to execute the search, or choose Mass Adjust if you want to process mass adjustment of expenditures. See: Mass Adjustment of Expenditures.
From the Expenditure Items window, choose:
Run Request to create Project Streamline Requests to process adjustments. You can select multiple processes to run for your project. The requests will run in the correct order. See: Adjusting Expenditure Items.
Totals to view the totals for the expenditure items returned based on your search criteria.
Note: This window does not display events. If your project uses event-based or cost-to-cost revenue accrual or invoice generation, use the Events window to view the total project revenue and bill amounts.
Item Details to select a window for reviewing the details of this expenditure item. The Inquiry Options window will be displayed, from which you can choose one of the following options:
Choose Cost Distribution Lines to view individual transactions and the default debit and credit GL accounts for each expenditure item that Oracle Projects derived using AutoAccounting. You can also view other information about the cost distribution lines, such as PA and GL period, accounting event generation status, and the rejection reason if the generation of the accounting event was not successful.
Note: The Cost Distribution Lines window does not display the credit account for supplier invoice expenditure items interfaced from Oracle Payables.
Choose Revenue Distribution Lines to view the revenue transactions generated for a specific expenditure item. The window displays the default revenue account that Oracle Projects derived using AutoAccounting. You can also see the GL and PA posting period for the revenue, accounting event generation status, and the rejection reason if the generation of the accounting event was not successful.
Choose AP Invoice to drill down to the Invoice Overview window in Oracle Payables. If the invoice is matched to a purchase order, then you can drill down to the purchase order from the Invoice Workbench. This option is enabled for expenditure items whose expenditure type class is either Supplier Invoices or Expense Reports.
Chose PO Receipt to drill down to the Receipt Transaction Summary window in Oracle Purchasing. You can also drill down to the related purchase order from the Receipt Transaction Summary window. This option is enabled for expenditure items for receipt accrual transactions in Oracle Purchasing.
Choose Purchase Order Details to drill down to the purchase order details for contingent worker labor costs. This option is enabled for expenditure items for contingent worker labor costs that are associated with a purchase order.
Choose Service Request Details to display the Service Request Details page in Oracle TeleService. The Service Request Details page contains information regarding the service request and the associated cost details. This option is enabled for transactions that are imported from Oracle TeleService.
Attention: If you define your own detailed accounting rules in Oracle Subledger Accounting, then Oracle Subledger Accounting overwrites default accounts, or individual segments of accounts, that Oracle Projects derives using AutoAccounting. In this case, the default accounts displayed on the Cost Distribution Lines and Revenue Distribution Lines windows may not be the same as final accounts that Oracle Subledger Accounting transfers to Oracle General Ledger. To view the final subledger accounting, see: Viewing Accounting Lines.
You can use the Item Details option to review accounting event generation statuses for cost distribution lines and revenue distribution lines. The following table describes accounting event generation statuses.
Accounting Event Generation Statuses
| Status | Detailed Status | Transfer Status Code | Description |
|---|---|---|---|
| Transferred | Transferred to Oracle Accounts Payable | T | For historical (prior to Release 12) cost distribution lines only. Indicates that the cost distribution line is for a supplier cost adjustment that is successfully interfaced to Oracle Payables. |
| Received | Accounted transaction received | V | For cost distribution lines. Indicates that the transaction was accounted in another application, such as Oracle Payables or Oracle Purchasing. |
| Generated | No transfer required | G | For historical (prior to Release 12) cost distribution lines only. Indicates that transfer to another application is not required. For example, for a revenue distribution line when the Interface Revenue to GL Implementation Option is disabled. |
| Generated | No accounting events required | G | For cost and revenue distribution lines. Indicates that accounting event generation is not required. For example, for a revenue distribution line when the Interface Revenue to GL Implementation Option is not enabled. Also, for a Net Zero cost distribution lines that does not require accounting events. |
| Accepted | Accepted in Oracle General Ledger | A | For historical (prior to Release 12) cost distribution lines only. Indicates that the transfer to Oracle General Ledger for the line was successful. |
| Accepted | Events generated in Oracle Subledger Accounting | A | For cost and revenue distribution lines. Indicates that the generate accounting events process successfully generated an accounting event for the line. |
| Accepted | Draft Accounted in Oracle Subledger Accounting | A | For cost and revenue distribution lines. Indicates that the create accounting process successfully created accounting for the accounting event in draft mode. |
| Accepted | Final Accounted in Oracle Subledger Accounting | A | For cost and revenue distribution lines. Indicates that the create accounting process successfully created accounting for the accounting event in final mode. |
| Accepted | Accounting event in error in Oracle Subledger Accounting | For cost and revenue distribution lines. Indicates that generate accounting events process successfully generated an accounting event for the line, but the create accounting process ended in error when it attempted to create accounting for the accounting event. | |
| Accepted | Accepted | A | For cost distribution lines. Indicates that the Interface Costs to GL Oracle Projects implementation option is not enabled, and you have run the process PRC: Generate Cost Accounting Events. |
| Pending | Pending accounting event generation | P | For cost and revenue distribution lines. Indicates that a cost distribution line or a revenue distribution line is ready for the generation of accounting events. |
| Rejected | Rejected during transfer to Oracle Accounts Payable | R | For historical (prior to Release 12) cost distribution lines only. Indicates that the cost distribution line is for a supplier cost adjustment and the transfer to Oracle Payables for the line was not successful. |
| Rejected | Rejected during transfer to Oracle General Ledger | R | For historical (prior to Release 12) cost and revenue distribution lines only. Indicates the transfer to Oracle General Ledger for the line was not successful. |
| Rejected | AutoAccounting could not derive the credit account | R | For cost and revenue distribution lines. Indicates that the generate accounting events process was unable to derive a default credit account. |
| Rejected | Accounting events could not be generated | R | For cost and revenue distribution lines. Indicates that the generate accounting events process was unable to generate an accounting event for the line. |
Note: You can view rejection reasons for expenditure items from the Expenditure Items window. From the Folder menu, choose Show Field and select either Cost Distr. Rejection or Revenue Distr. Rejection.