There are two steps that need to be completed before data is available in Oracle Projects:
Step One– Upload the transaction(s) into the Transaction Interface Table.
When uploading the transactions, you can choose from the ribbon:
Multi Sheet– Use this option to upload all selected sheets in the open workbook. Note that this option can be blocked using a profile option in Oracle. For more details on this please refer to theProfile Optionssection in this document.
Single Sheet– Use this option to upload transactions from the current worksheet.
There are two upload options available:
Validate only– Validates the data only and does not upload it to the interface table.
Validate and Upload– Validates before uploading the data to the interface table.
Validation is ALWAYS performed on any values in the Header section and Employee Names, Batch Sources, Expenditure Types, and Non-Labor Resources, regardless of the ribbon setting.
Step Two– Import the data from the Transaction Interface Table into Oracle Projects. Once this step is completed successfully then you are able to view the transaction(s) in Oracle Projects.
The steps in this section are to upload the transaction/s into the Transaction Interface Table.
