R12: CE: R12 Autoreconciliation Gives Check Digits Error (Doc ID 1596192.1)

Last updated on APRIL 19, 2019

Applies to:

Symptoms

Bank Account is Configured with Check Digits.

Flat File From Bank Does not include check digits.

If Customer uses the List of Values in the Interface Table to Populate the
Check Digits, then runs Import and Autoreconciliation.
Then no error message.


If Customer does not use the List of Values in the Interface Table to
Populate the Check Digits, then runs Import and Autoreconciliation.
Then error message appears correctly -

The check digits on the statement do not match the  check digits on the bank account.
Ensure that the  statement has the same check digits as the bank  account,
or that check digits are not used on either the bank account or the statement.


HOWEVER - This is the Problem.

If Customer does not use the List of Values in the Interface Table to
Populate the Check Digits, then runs Import or Import and Autoreconciliation
to populate the statement tables CE_STATEMENT_HEADERS and CE_STATEMENT_LINES
Then uses the list of values in the Bank Statement Header to populate the
check digits
Then runs the Autoreconciliation, the Reconciliation works however the Error
Message is still shown on the Exceptions report.


The check digits on the statement do not match the
check digits on the bank account. Ensure that the
statement has the same check digits as the bank
account, or that check digits are not used on either
the bank account or the statement.

This is clearly incorrect. How can the check digits not match when they have
been populated on the statement header using the List of Values.
And if it is an Error, why does the Autoreconciliation still work ?

STEPS.
1.
Create Bank Account, with Check Digits and a Payment Document for that
account.
2.
Create Payables Invoice and Pay it using the Account and Document in Step 1.
3.
Create a Payment Transaction Cod for the Bank Account.
4.
Create a Statement for the Account in the Interface Form, Delete the check
Digits.
5.
Run Bank Statement Import and Autoreconciliation. Error Message - CORRECT
Behavior.
6.
Open the Bank Statement. Populate the Check Digits using the List of Values
on the Statement Header.
7.
Run Autoreconciliation.
Reconciliation completes, but error message is still shown in the exceptions
report.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.