How can I reverse processed project costs?

Before you attempt to reverse a processed project cost, you must ensure that the project cost's eligible for reversal.

Eligibility Criteria for Project Cost Reversal

To be eligible for reversal, a processed project cost:
  • Must not be a net-zero item
  • Must not be a converted item. Converted items enable you to load upgrade data and prohibit further actions on such project costs.
  • Must not be a summarized burden transaction cost
  • Must not be a Labor Distribution cost
  • Must have Allow reversal enabled at the document entry level (For predefined transaction sources, such as Account Payables and Supply Chain Management, this option's disabled; therefore, you cannot reverse project costs coming in from predefined transaction sources.)
  • Must not have pending, pending approval, or rejected adjustments
  • Must have a project status that allows project cost adjustments

Performing Project Cost Reversal Using the Manage Unprocessed Costs Page

Note:
  • Before you create a reversing project cost, you must ensure that the project cost that you want to reverse is eligible for reversal. See the Eligibility Criteria for Project Cost Reversal section for more information.
  • The attributes that you use to create the reversing expenditure batch must precisely match the attributes of the project cost that you want to reverse. See the Reversal Attributes that Must Match Original Transaction Details section for more information.

To reverse a project cost using the Projects Costing user interface:

  1. In the Projects > Costs > Manage Unprocessed Costs page, click Create.
  2. Enter and confirm the required values in the Create Transaction modal. Ensure that the values you choose in the Source, Business Unit, Document, and Document Entry fields match corresponding values in the transaction that you want to reverse.
  3. In the General Details > Cost Collection Details section of the Create Transaction page that appears, enter the Project Number, Task Number, Expenditure Item Date, Expenditure Type, and Expenditure Organization details. Again, these details must match corresponding values in the transaction that you want to reverse.
  4. In the Usage Details section, enter the quantity and cost details associated with the project cost. This must be the exact opposite of the quantity and cost in the project cost that you want to reverse. For example, if the quantity in the project cost that needs reversal is 10, the quantity in the reversing project cost must be -10.
  5. Enter the Nonlabor Resource and Nonlabor Resource Organization details. These details must also match corresponding values in the transaction that you want to reverse.
  6. Enter an Original Transaction Reference value. This must be a unique value.
  7. In the Additional Details tab, enter the original transaction reference of the project cost that you want to reverse in the Reversed Original Transaction Reference field.
  8. Leave the Unmatched Negative Transaction check box deselected to tell the application that the details that you provided in this expenditure batch must match an existing project cost.
  9. Click Save and Close to submit the expenditure batch. If the project cost details that you provided match an existing project cost, and if that project cost is eligible for reversal, the expenditure batch appears in the list of unprocessed project costs.
  10. Click Import Costs, and click Yes in the warning message that appears, to trigger the import.
  11. Click the Refresh button in the Process Monitor section of the Project Costing landing page to view the status of your project cost reversal. After the import succeeds, the status of the process ID associated with the import job changes to Succeeded.
After the import succeeds, you can view a report associated with the process by clicking the View Output icon adjacent to the process ID.

Performing Project Cost Reversal Using FBDI

Note:
  • Before you create a reversing project cost, you must ensure that the project cost that you want to reverse is eligible for reversal. See the Eligibility Criteria for Project Cost Reversal section for more information.
  • The attributes that you use to create the reversing expenditure batch must precisely match the attributes of the project cost that you want to reverse. See the Reversal Attributes that Must Match Original Transaction Details section for more information.

To reverse a project cost using FBDI, you must choose the FBDI spreadsheet meant for the transaction source associated with the project cost that you want to reverse. Follow the instructions provided in the downloaded spreadsheet to complete the import.

For additional details on importing project costs, see Import Costs Process in the Using Project Costing guide.

Reversal Attributes that Must Match Original Transaction Details

Here's a table listing out the reversal attributes that must match the corresponding attributes of the original transaction, for the reversal to succeed:

Project Cost Reversal Attributes that Must Match the Original Project Cost

Attribute Description
Expenditure Item Date Date on which the project cost was recorded.
Expenditure Type A classification of cost that's assigned to the transaction.
Project Details of the project associated with the project cost that you want to reverse. Examples: Project Name, Project Number.
Task Details of the task associated with the project cost that you want to reverse. Examples: Task Name, Task Number.
Transaction Source Details of the transaction source of the reversing transaction. Example: Transaction Source Name.
Document Details of the document associated with the project cost that you want to reverse. Example: Document Name.
Document Entry Details of the document entry associated with the project cost that you want to reverse. Example: Document Entry Name.
Person Details of the person associated with the project cost that you want to reverse. Example: Person Name.
Expenditure Organization Details of the expenditure organization associated with the project cost that you want to reverse. Example: Expenditure Organization Name.
Non Labor Resource Organization Details of the non-labor resource organization associated with the project cost that you want to reverse. Example: Non Labor Resource Organization Name.
Non Labor Resource Details of the non-labor resource associated with the project cost that you want to reverse. Example: Non Labor Resource Name.
Net Zero Item Indicates that the project cost has either been reversed or is reversing another project cost, resulting in a sum of zero for the two costs together. For the transaction being reversed, the net zero value must be False.
Reversed Original Transaction Reference The original transaction reference of the existing project cost that the current unprocessed cost, usually negative, is reversing.
Expenditure Business Unit Name Name of the expenditure business unit to which the project cost is charged.
Transaction Currency The currency in which the project cost is incurred.

Importing Person-Related Project Cost Transaction Reversals

You can create a matched reversal for an existing person-related transaction, regardless of the person’s current Oracle Fusion Cloud Human Capital Management status, such as Terminated, Suspended, or Canceled.

You can use either the Unprocessed Project Costs REST API or one of the Import Project Cost FBDI templates to use Person ID to create reversals for persons with canceled work relationships.

Importing Person-Related Project Cost Transaction Reversals: Considerations

  • When using the Unprocessed Project Costs REST API to create a reversal, you don't need to specify any assignment-related attributes in the request, because assignment information from the original transaction will be copied to the reversing transaction. If you do specify the person’s assignment in the request, use Assignment ID. If you use Assignment Name or Assignment Number, errors will be returned for persons without active HCM assignments.
  • When using one of the Import Cost FBDI templates to create a reversal of a person-related transaction, you don't need to specify any assignment-related attributes in the file, as the assignment information from the original transaction will be copied to the reversing transaction if successfully imported. If you do populate any of the assignment-related columns in the template, these values will be ignored during import processing.
  • When using the Unprocessed Project Costs REST API to create a reversal for persons with canceled or terminated work relationships, identify the person using Person ID in the request. If you use Person Name or Person Number instead of Person ID, then errors will be returned.