After running the Import Unprocessed Project Costs, the Refresh functionality can be used to update the status of the Pending Unprocessed Transactions on the sheet. To use the Refresh functionality in the Costs Integrator, follow the instructions below:
1. Create the unprocessed project costs using the Costs Integrator as per the instructions in the section Create Unprocessed Project Costs. The Unprocessed Costs will be in the Pending status until the Import is submitted.
2. Submit the Import process by logging into the Oracle Cloud environment:
3. Click on the Refresh icon from the toolbar to see the import results of the Expenditure Items on the sheet. The Batch Status column must show ‘Pending’ in order for the Refresh to work. It is imperative that the Transaction Reference ID column has values for the Integrator to reference back to Oracle to retrieve the results of the Oracle Import Costs process.
4. Once the Refresh has finished running, the Integrator will change the status of the transactions from ‘Pending’ to either ‘Error’ or ‘Accepted’. The transactions that have the status of ‘Error’ have been rejected by the Import process and the error message will display the errors that need to be corrected. Transactions that have the status of ‘Accepted’ have been successfully imported by the Import process.
