Correcting Bank Statement Interface Errors
If any records in a statement fail validation, the Bank Statement Import program does not import the statement, and assign it an Error status. You can review validation errors from the Bank Statement Interface window, or by running the AutoReconciliation Execution Report.
Interface errors may occur for a variety of reasons. The following is a list of the most common causes of bank statement interface errors:
- Incorrect Cash Management setup information, such as bank transaction codes, currencies, or bank account information.
Solution: Update the Cash Management setup information and rerun the Bank Statement Import program.
- Errors in the bank's transmission file.
Solution: Obtain a corrected transmission file from your bank, or update the statement using the Bank Statement Interface window.
- Problem in the SQL*Loader control file.
Solution: Modify the SQL*Loader file and rerun the Bank Statement Import program.
In some cases you may need to modify the information in the bank statement interface tables before you can import the bank statement. You can modify this information using the Bank Statement Interface window. You can update all bank statement and line information including any optional descriptive flexfield content.
To correct the bank statement interface header information:
2. Query the Statement you want to correct.
3. Edit the bank statement header information as necessary, including the Control Balances.
5. Run the Bank Statement Import program to import the corrected bank statement information from the interface tables.
Additional Information: You can submit the Bank Statement Import program directly from the Bank Statement Interface window. Choose AutoReconciliation from the Oracle Application's Special menu.
To correct the bank statement interface lines:
1. Navigate to the Bank Statement Interface window.
2. Query the Statement you want to correct.
4. Edit the bank statement transaction information. You can edit the Line Number, transaction Code, transaction Number, and Date.
5. Choose Amounts from the alternative region poplist to edit the transaction Amount, bank Charges, and Original Amount.
Additional Information: The poplist appears on the right side of the window, directly under the Date field. The default value is Amounts.
6. Choose Exchange from the alternative region poplist to edit exchange rate information, including Currency code, exchange rate Type, Date, and exchange Rate.
7. Choose Reference from the alternative region poplist to edit the Agent (customer or supplier), Invoice number, and Agent Bank Account associated with each line.
8. Choose Description from the poplist to edit the Effective Date and Description for each line.
10. Run the Bank Statement Import program to import the corrected bank statement information from the interface tables.
See Also
Loading Bank Statement Open Interface
Importing Bank Statements
About Bank Statement Validation
Reviewing Bank Statement Interface Errors
Reconciling Bank Statements Automatically
Archiving and Purging Imported Bank Statements