Oracle Projects tracks detail transactions for project management and for financial accounting. Each transaction has many dates associated with it to handle the different types of processing and reporting required for these two purposes.
Note: The phrase financial accounting is used in this chapter to refer to enterprise accounting as opposed to project-oriented accounting.
You can report transactions based on:
When the work was incurred
When the work was accounted
The date the work was incurred is used for project and resource management control. The date the work was accounted for is for financial accounting control.
Oracle Projects also tracks dates when transactions were processed in the system for process flow audit.
For project and resource management control, Oracle Projects maintains the date the transaction was incurred and the expenditure period in which the transaction date falls.
These dates are defined as follows:
The expenditure item date is the date upon which work was incurred. This date falls between the start date and end date of an expenditure period. For example, if you submit an expense report that includes an expenditure item for air travel incurred on 15-MAR-96, the expenditure item date is 15-MAR-96.
The expenditure ending date is the end date of a weekly expenditure period. For example, if you submit a timecard for labor hours worked during the week of 20-MAR-96, the expenditure ending date is 20-MAR-96.
Note: The expenditure periods usually correspond to the expenditure entry cycle of timecard and expense report entry.
Oracle Projects supports weekly expenditure periods. You specify the day of the week for the Expenditure Cycle Start Day in the Implementation Options window.
For a description of how Oracle Projects derives accounting dates, see: Financial Periods and Date Processing.
Oracle Projects maintains the following dates to track process flow through the system.
The approved date applies only to customer invoices, and is the date on which the invoice was approved.
Oracle Projects sets this date when you approve an invoice in the Invoice Summary or Invoice windows.
The released date applies only to revenue and customer invoices, and is the date on which the transaction was approved.
Oracle Projects sets this date when you release an invoice in the Invoice Summary or Invoice windows.
For costs and revenue, the interface date is the date on which you generate accounting events for Oracle Subledger Accounting. Oracle Projects sets this date on the date that you run the generate accounting events process. Oracle Projects maintains the interface date for each cost distribution line and revenue distribution line.
For invoices, the interface date is the date on which you interface invoices to Oracle Receivables. Oracle Projects sets this date on the date that you run the interface process. Oracle Projects maintains the interface date for each invoice.
Other Sources
Expenditure Cycle Start Day, Oracle Projects Implementation Guide