Downloading Processed Costs
The Costs Integrator has Multiple Download sources available, where information from different areas of Oracle can be downloaded into the same Integrator. See Download Sources for more information.
The two Download Sources available in the Costs Integrator are:
· Unprocessed Costs: download unprocessed transactions that have not been imported.
· Processed Costs: download project costs (processed transactions).
There are two ways to download the processed project costs from Oracle using the Costs Integrator. More information about downloading can be found here.
When you select either the ‘Download via Form’ or ‘Download via Sheet’ option, you will be prompted with a new window where you can select the download source to download the transactions from. Select the Download Source ‘Processed Costs’ to download processed transactions to the sheet.
Transaction Number can be used as a search criteria in both ‘Download via Form’ or ‘Download via Sheet’ options.
Cost Reversals and Transfers
During the lifecycle of a project, you may want to transfer costs from one Project Task to another and the Costs Integrator can help you carry this out by following the steps below. Note that the cost reversals and transfers carried out by the Costs Integrator will not have an audit trail associated to the original costs. We may be able to utilize the Oracle’s REST web service to do Reversals in the future. For now, this is one way of performing reversals and transfers using the Costs Integrator.
1. Download the Processed Costs that are to be reversed.
2. Copy the downloaded lines (Group A) and paste them below (Group B) so you have a copy of the original transactions before doing the reversal.
3. For costs under Group A, put a negative sign for Quantity, Raw Cost (if Costed), and move the values from the ‘Original Trans Ref’ column to the ‘Reversed Original Transaction Reference’ column.
4. For costs under Group B, change the Task Number to transfer the costs to another Project Task. In the example below, Task Number 3.1.03 is changed to Task Number 400 where costs are to be transferred. Clear the values from the ‘Original Trans Ref’ column so that new values can be created for the new transactions.
5. Enter ‘Create’ in the ‘Expenditure Items Upload Action’ column against rows for Group A (reversals) and Group B (transfers). You may also want to change the ‘Expenditure Batch’ names for both Group A and Group B for easier reference. The ‘Create’ action will create the unprocessed costs for the reversals of the original costs and transfers (costs with new Task Numbers).
6. Upload and Import the unprocessed costs in Group A and Group B. The upload will ignore the Transaction Numbers on the sheet.
7. Refresh the results on the sheet and check in Oracle to see that reversals have been created for the original costs and new costs are created with new Task Numbers.
Sections:
