Correcting Errors and Reloading
Correcting Rejected Data
If you have an Error status in any of the status columns, you need to read the appropriate 'Message' column value and investigate and correct the data. The error messages relate to data on the same row in the relevant section.
To correct the information either key directly into the worksheet, or open the Journal Header and Lines Form to select from existing lists of values.
Note that errors reported back from the Journal Import process will only display the General Ledger error message code. To view the meaning of the error open the concurrent request 'Output' file and all error messages can be located at the bottom of the report.
Once the data has been corrected you can choose to either upload one row, selected range of rows or the entire worksheet.
Journals that already have an Upload Status of Accepted will not be processed again.
Continuing the previous example, after correcting the data and re-running the ‘Validate and Upload’ option and submitting the Journal Import will show all records are successfully transferred into Oracle General Ledger.
Updating Journals and Lines in the Interface Table
If for any reason you want to update values in journals loaded into the interface this will need to be done using the standard General Ledger 'Journals Correct' form. The Wizard does not have an interface table update option.
You can however delete your data from the interface and upload it again. Using this option removes your data from the interface table data but leaves it in the worksheet allowing for quick and easy uploading again.
Delete Journal and Line Data from the Interface Table
The journal and all lines will be deleted from the interface by highlighting the required journal on your worksheet.
Click the 'Delete from Interface' button on the ribbon.
The Line Status will be updated to Deleted once the record has been removed from the interface table.
You can now change the Wizard data and reload the journal.
Refer to section:
