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
Navigate to the Submit Request window.
Choose to run a Single Request.
Select Program - Delete Journal Import Data. Provide the following parameters:
Source: 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.
Request ID: Enter the Request ID corresponding to the Journal Import run.
Group ID: 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.
Submit your request.
Note: You must have read and write access to the ledger or read and write access to all of the import data's balancing segment values or management segment values to delete the journal import data.
Note: Do not delete subledger data from the GL_INTERFACE table. If you do, your subledger and General Ledger will not reconcile. Instead, correct the data in your subledger, repopulate the GL_INTERFACE table and rerun journal import.