Deleting Journal Import Data
If you have many Journal Import errors for a specific journal entry source and group ID, you can delete all erroneous data for the source and group ID from the journal import table, GL_INTERFACE. You can then repopulate the import table with corrected data and rerun Journal Import.
If you reserved funds for any transaction in a feeder system, you cannot delete the incorrect data. Instead, you must correct each Journal Import error using the Correct Journal Import Data window.
Prerequisite
Review your Journal Import Execution Report and note the Request ID and Group ID of the Journal Import process that encountered invalid import data
To delete journal import data from the import table:
1. Navigate to the Delete Journal Import Data window.
2. Identify the data you want to delete from the General Ledger import table by entering a journal entry Source for which you have imported data.
3. Enter the Request ID corresponding to the Journal Import run.
4. Enter a Group ID to delete all Journal Import data that corresponds to the specified source and group ID.
Leave the Group ID blank to delete all Journal Import data that corresponds to the specified source, but has no corresponding Group ID.
5. Choose Delete to submit a concurrent process to delete your incorrect Journal Import data.
See Also
Integrating General Ledger Using Journal Import
Defining Journal Sources
Importing Journals
Correcting Journal Import Data
Journal Import Execution Report
