This chapter covers the following topics:
Use the Event Details window to enter and review events for a project or top task. Examples of events include an invoice reduction, a performance bonus, revenue write-off, or adjusting revenue. You can also change the bill hold status of an event using these windows.
For transactions that involve foreign currencies, all amounts displayed in the Event windows are shown in the event transaction currency.
Events can be entered in any currency when multi-currency is enabled for the associated project. The currency in which the event is entered or created is called the event transaction currency. Oracle Projects uses the currency conversion attributes stored for each event to convert revenue and invoice amounts for manually entered and automatically created events from the event transaction currency to the project functional, project currency, and the funding currency.
The following table describes the conversion currency attribute fields for the project functional currency and the project currency:
| Field | Comments |
|---|---|
| Currency Code | Currency code of the project functional currency or the project currency |
| Rate Type | Required field. List of values is restricted to the rate types defined in Oracle General Ledger Exchange rate type used to determine the conversion rate from the event transaction currency to the project functional and project currency Default value is derived from the project setup |
| Rate Date | Exchange rate date used to determine the conversion from event transaction currency to the project functional currency and the project currency Default value is derived from the project setup if the exchange rate type defined for the project is Fixed Date Can be updated if the rate date type defined for the project is Fixed Date |
| Rate | Rate used to convert from the event transaction currency to the project functional currency or the project currency Display only field if the Exchange Rate Type is not User. Can be entered if the Exchange Rate Type is User Required if the Exchange Rate Type is User |
| Revenue Date | Exchange rate date used during the revenue generation process to convert from the event transaction currency to the project functional currency and the project currency |
| Revenue Rate | Exchange rate used during the revenue generation process to convert from the event transaction currency to the project functional currency and the project currency |
| Revenue Amount | Revenue amount in project functional currency or the project currency that is calculated during the revenue generation process by applying the project functional currency conversion attributes and the project currency currency conversion attributes respectively. |
| Bill Date | Exchange rate date used during the invoice generation process to convert from the event transaction currency to the project functional currency and the project currency |
| Bill Rate | Exchange rate used during the invoice generation process to convert from the event transaction currency to the project functional currency and the project currency |
| Bill Amount | Bill amount in project functional currency and the project currency that is calculated during the invoice generation process by applying the project functional currency conversion attributes and the project currency conversion attributes, respectively. |
The following table explains the conversion currency attributes for the funding currency:
| Field | Comments |
|---|---|
| Rate Type | Exchange rate type used to determine the exchange rate from the event transaction currency to the funding currency Default value is derived from the project setup List of values is restricted to the exchange rate types defined in Oracle General Ledger |
| Rate Date | Exchange rate date used to determine the exchange rate from the event transaction currency to the funding currency Default value is the Exchange Rate Date defined for the project if the Funding Rate Date Type defined for the project is Fixed Date Can be entered if the Funding Rate Date type for the project is Fixed |
| Rate | Rate used to convert from the event transaction currency to the funding currency Display only field if the Exchange Rate Type is not User. Can be entered if the Exchange Rate Type is User Required if the Exchange Rate Type is User |
You can enter adjusting revenue events when you enable the Adjusting Revenue check box in the Event Details window.
Note: You can enable the Adjusting Revenue check box only for manual event types.
Entering adjusting revenue events allows you to adjust revenue for a project without reopening the project accounting period. Adjusting revenue amounts do not have an effect on invoicing. Therefore, you cannot enter a value in the Bill Amount field for these events.
After you make the adjustments and regenerate revenue in Oracle Projects, submit the process PRC: Generate Revenue Accounting Events. Next, submit the process PRC: Create Accounting. You can select Revenue for the Process Category parameter when you run the Create Accounting process to include only revenue accounting events. When you run the Create Accounting process in final mode, you can optionally transfer the final accounting to Oracle General Ledger.
Note: The revenue generation process assigns sequential revenue numbers to the draft revenue as it is generated. When adjusting events are entered for a project, a gap in numbering can occur when revenue is deleted and regenerated.
When Enhanced Period Processing is enabled, both the PA Date and GL Date for adjusting revenue are determined based on the Accrue Through Date you enter when you submit the revenue generation process. The PA Date and the GL Date are always equal to the Accrue Through Date, even when the accounting periods that include the Accrue Through Date have a closed status in Oracle Projects. The accounting period in General Ledger must have an open status.
When Enhanced Period Processing is not enabled, the PA date for the draft revenue is determined based on the Accrue Through Date, and the GL Date is based on the PA Date. The PA Date is the ending date of the open or closed PA period that includes the Accrue Through Date. The GL Date is the ending date of the GL period that includes the PA Date. The accounting period in General Ledger must have an open status.
For information on determining PA and GL date for non-adjusting revenue events, see: Date Processing in Oracle Projects, Oracle Projects Fundamentals.
The rules for determining PA and GL dates are shown in the following example.
The PA Periods in this example are shown in the following table:
| Period | Start Date | End Date |
|---|---|---|
| Jan-W3-02 | 14-Jan-2002 | 20-Jan-2002 |
| Jan-W4-02 | 21-Jan-2002 | 27-Jan-2002 |
| Jan-W5-02 | 28-Jan-2002 | 03-Feb-2002 |
The GL Periods in this example are shown in the following table:
| Period | Start Date | End Date |
|---|---|---|
| Jan-02 | 01-Jan-2002 | 31-Jan-2002 |
| Feb-02 | 01-Feb-2002 | 28-Feb-2002 |
An adjusting revenue event for $100.00 and a non-adjusting revenue event for $150.00 are entered. Both have an Event Date of 20-Jan-2002. The Accrue Through Date is 25-Jan-2002 for both events.
Case 1: Enhanced Period Processing is not Enabled
The table below illustrates the PA Date and the GL Date determined by the system for adjusting revenue when Enhanced Period Processing is not enabled and the PA Period (Jan-W4-02) that includes the Accrue Through Date is open.
| Event | Accrue Through Date | PA Date | GL Date |
|---|---|---|---|
| Adjusting Revenue | 25-Jan-2002 | 27-Jan-2002 | 31-Jan-2002 |
| Non-Adjusting Revenue | 25-Jan-2002 | 27-Jan-2002 | 31-Jan-2002 |
The table below illustrates the PA Date and the GL Date determined by the system for adjusting revenue when Enhanced Period Processing is not enabled and the PA Period (Jan-W4-02) that includes the Accrue Through Date is closed.
| Event | Accrue Through Date | PA Date | GL Date |
|---|---|---|---|
| Adjusting Revenue | 25-Jan-2002 | 27-Jan-2002 | 31-Jan-2002 |
| Non-Adjusting Revenue | 25-Jan-2002 | 03-Feb-2002 | 28-Feb-2002 |
Case 2: Enhanced Period Processing is Enabled
The table below illustrates the PA Date and the GL Date determined by the system for adjusting revenue when Enhanced Period Processing is enabled. The PA Period (Jan-W4-02) that includes the Accrue Through Date and the GL Period (Jan-02) that includes the Accrue Through Date are both open.
| Event | Accrue Through Date | PA Date | GL Date |
|---|---|---|---|
| Adjusting Revenue | 25-Jan-2002 | 25-Jan-2002 | 25-Jan-2002 |
| Non-Adjusting Revenue | 25-Jan-2002 | 25-Jan-2002 | 25-Jan-2002 |
The following table illustrates the PA Date and the GL Date determined by the system for adjusting revenue when Enhanced Period Processing is enabled. The PA Period (Jan-W4-02) that includes the Accrue Through Date and the GL Period (Jan-02) that includes the Accrue Through Date are both closed.
| Event | Accrue Through Date | PA Date | GL Date |
|---|---|---|---|
| Adjusting Revenue | 25-Jan-2002 | 25-Jan-2002 | 25-Jan-2002 |
| Non-Adjusting Revenue | 25-Jan-2002 | 28-Jan-2002 | 01-Feb-2002 |
There are two Event Window modes:
Project. The Project mode Event Windows allow you to enter and view events for a single project only. You must enter a project number or name in the Find Project Events window before you can execute the query. If project security has been implemented, you can only select projects that you are allowed to see.
All. The All mode Event Windows allow you to enter and view events across projects for the selected operating unit. You are not required to enter a project number or name in the Find Events window. You can structure your query to retrieve information across projects for the selected operating unit.
The mode in which you access the Event Window is determined by your user responsibility, as set up by your System Administrator. Under the Project Billing Super User and Project Costing Super User responsibilities, which are supplied by Oracle Projects, you have access to both modes.
To Review or Enter Events
Navigate to the Find Events window (Billing > Events).
To view or enter events in summary format, enter your search criteria and choose Find. See Events Summary Window Reference.
To enter a new event in the Event Details window, choose New. See Event Details Window.
From the Events Summary window, choose:
Revenue to view event revenue distribution lines information.
Totals to view the total bill amount and total revenue amount for the events displayed based on your search criteria.
Note: The total bill amount and the total revenue amount are displayed only if all the events queried are in the same currency.
Open to view all of the event information for a single event in one window. See: Event Details Window.
Related Topics
Generate Revenue Accounting Events, Oracle Projects Fundamentals
Create Accounting, Oracle Projects Fundamentals
Generate Draft Revenue, Oracle Projects Fundamentals
Event Types, Oracle Projects Implementation Guide
Events Summary Window Reference
Event Revenue Distribution Lines Window
Function Security for Event Windows, Oracle Projects Implementation Guide
Integration with Oracle Project Contracts
The Events Summary window uses folder technology, allowing you to customize the window to display the fields you want to view. Some of the information displayed in this window is shown in the following table:
| Item | Description |
|---|---|
| Project Number | The number of the project for the event |
| Project Name | The name of the project |
| Task Number | The number of the top task for the event |
| Task Name | The name of the top task |
| Agreement Number | The number of the agreement under which the event will be billed |
| Product Source | The name of the external system from which the event was imported |
| Event Reference | The name of the event in the external system from which the event was imported |
| Event Number | The number of the event |
| Event Type | The event type |
| Event Classification | The event classification of the event type |
| Date | The date the event is eligible for processing |
| Currency | The currency of the event |
| Bill Amt | The bill amount if the event affects billing for this project/task |
| Revenue Amt | The revenue amount if this event affects revenue accrual. The amount for write-off revenue may not exceed this project's unbilled receivables amount. |
| Description | The event description. Except for events having a classification of Write-Off, this description appears on the invoice line billing this event. |
| Organization | The organization name for the event. You assign organizations to events to credit project revenue to different organizations. You can also use events in AutoAccounting to account for revenue at the expenditure organization level. |
| Bill Hold Flag | The bill hold flag for this event. The options are: No - Do not hold from billing. Once - Hold from the next billing only. Yes - Hold from future billing indefinitely. You cannot hold billing on revenue write-offs. The Bill Hold Flag is only enabled for events that can be billed. You can update this flag from the Event Summary Window. |
| Billed | Flag that indicates whether this event has been billed |
| Revenue Hold Flag | The revenue hold flag for this event. The options are: No - Do not hold from revenue accrual. Yes - Hold from future revenue accrual indefinitely. This flag is applicable only for the Realized Gains and Realized Losses events created by the Revaluate Funding process. The Revenue Hold Flag for the realized gains is set to Yes if the corresponding revaluation adjustment funding does not have a baseline, and set to No when the revaluation adjustment funding has a baseline. |
Use the Event Details window to enter, modify, or review all of the information for a single event on one screen.
To enter events
Navigate to the Event Details window.
Enter the details of the project, task, and event.
Note: Event number must be greater then zero, and cannot be changed once the event is billed or revenue generated.
Optionally enter the agreement number of the agreement on which the event will be billed.
Enter the organization of the event.
Enter a description for the event.
In the currency field, enter any currency defined in Oracle General Ledger.
Click on the Currency button to review or override the currency conversion attributes defined for the project. See: Entering Events in Any Currency.
Check the Adjusting Revenue check box if you are entering an event to adjust revenue amount. See: Adjusting Revenue Amounts.
Note: After an event has been processed for revenue or invoicing, you cannot change the event transaction currency or the currency conversion attributes.
For field descriptions in the Event Details window, see: Events Summary Window Reference.
The Event Revenue Distribution Lines window displays information about the revenue distribution lines for an event.
The following information is displayed for the selected event:
Project Functional Amount - displays amount in project functional currency
Revenue Transaction Amount - displays amount in project functional currency if you selected the Project Functional Currency Only option for the revenue transaction currency on your project, or displays amount in invoice transaction currency if you selected the Project Functional Currency and Invoice Transaction Currency option for the revenue transaction currency
Default Account and Description
Draft Revenue Number and Line
PA Date and Period
GL Date and Period