11i: R12: Payment Transaction is Shown as Reconciled in AP But Unreconciled in CE (Doc ID 344956.1)

Last updated on JANUARY 14, 2016

Applies to:

Oracle Cash Management - Version 12.0.0 and later
Information in this document applies to any platform.
Accounts Payable (AP)
Cash Management (CE)
Payment

Symptoms

Payments show as Reconciled in AP (Example, payments 106362 and 100015 show as reconciled) however, in Cash Management both show as not reconciled.  Users are unable to  UNCLEAR or UNRECONCILE the payment in Cash Management.

Review of the data shows:

APLIST:

Data and the checks are reconciled/cleared. The payment clearing accounting is created correctly. The checks have the correct status = RECONCILED.

 

STMT_INFO_ALL_SQL:

Check number 100015/Check Id 68584 was manually cleared in Cash Management by user_id = 1459 on 23-NOV-2005 10:18.
Check number 106362/Check Id 42373 was manually cleared in Cash Management by user_id = 14383 on 30-SEP-2005 08:30.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms