Auto-reconcilitation Missing matching criteria

This forum is to discuss different features/issues of Oracle Financials modules ( GL - General Ledger, AP - Accounts Payable, AR - Accounts Receivable, FA - Fixed Assets & CM - Cash Management ).
Post Reply
AIMAM
Posts: 139
Joined: Thu May 17, 2007 6:04 am
Location: Egypt

Auto-reconcilitation Missing matching criteria

Post by AIMAM »

Hi,

In oracle apps 11i , manual reconcilation for bank statements is done by the user. On the attempt to try Autoreconciliation program the statement lines had the error"Missing matching criteria " in the AutoReconciliation Execution Report.

I have found in the cash mangement user manual the following:

The statement line needs at least one of the following criteria to
match, and all are missing: 1) transaction number; 2) invoice
number and agent name; 3) invoice number and agent bank
account.

But I do not know how to do any of the 3 points above because the bank statement lines entered either manually or uploaded through the interface consist of the following information only:

POST DATE, VALUE DATE , DR AMOUNT , CR AMOUNT,and BANK TRANSACTION CODE

What do we have to do to use the auto-reconciliation program?
oteixeira
Posts: 451
Joined: Wed Aug 27, 2008 12:34 pm
Location: Portugal

Post by oteixeira »

Hello.
We successfully use Auto-reconciliation. The bank statement data consists exactly on the same data as yours, what we do is to add the transaction number before uploading it to the system.

Octavio
AIMAM
Posts: 139
Joined: Thu May 17, 2007 6:04 am
Location: Egypt

Post by AIMAM »

can you please specify what do you mean exactly by transaction number?

Should it be matched to a specific information in the application?

Thank you for your help...
oteixeira
Posts: 451
Joined: Wed Aug 27, 2008 12:34 pm
Location: Portugal

Post by oteixeira »

Hello.

For AR and AP, the system stores the transaction numbers in 2 views:
CE_222_TRANSACTIONS_V
CE_200_TRANSACTIONS_V

Octavio
oracleapps1983
Posts: 256
Joined: Thu Aug 07, 2008 3:48 am
Location: USA

Post by oracleapps1983 »

Hi Aimam

Transaction number either Check numbers of internal Bank or Third parties Bank Check Number.

Matching will be done based on Transaction numbers.

Regards
Oracleapps1983
oracleapps1983
Posts: 256
Joined: Thu Aug 07, 2008 3:48 am
Location: USA

Post by oracleapps1983 »

Hi Aimam

Transaction number either Check numbers of internal Bank or Third parties Bank Check Number.

Matching will be done based on Transaction numbers.

Regards
Oracleapps1983
oracleapps1983
Posts: 256
Joined: Thu Aug 07, 2008 3:48 am
Location: USA

Post by oracleapps1983 »

Hi Aimam

Transaction number either Check numbers of internal Bank or Third parties Bank Check Number.

Matching will be done based on Transaction numbers.

Regards
Oracleapps1983
oracleapps1983
Posts: 256
Joined: Thu Aug 07, 2008 3:48 am
Location: USA

Post by oracleapps1983 »

Hi Aimam

Transaction number either Check numbers of internal Bank or Third parties Bank Check Number.

Matching will be done based on Transaction numbers.

Regards
Oracleapps1983
oracleapps1983
Posts: 256
Joined: Thu Aug 07, 2008 3:48 am
Location: USA

Post by oracleapps1983 »

Hi Aimam

Transaction number either Check numbers of internal Bank or Third parties Bank Check Number.

Matching will be done based on Transaction numbers.

Regards
Oracleapps1983
oracleapps1983
Posts: 256
Joined: Thu Aug 07, 2008 3:48 am
Location: USA

Post by oracleapps1983 »

Hi Aimam

Transaction number either Check numbers of internal Bank or Third parties Bank Check Number.

Matching will be done based on Transaction numbers.

Regards
Oracleapps1983
oracleapps1983
Posts: 256
Joined: Thu Aug 07, 2008 3:48 am
Location: USA

Post by oracleapps1983 »

Hi Aimam

Transaction number either Check numbers of internal Bank or Third parties Bank Check Number.

Matching will be done based on Transaction numbers.

Regards
Oracleapps1983
oracleapps1983
Posts: 256
Joined: Thu Aug 07, 2008 3:48 am
Location: USA

Post by oracleapps1983 »

Hi Aimam

Transaction number either Check numbers of internal Bank or Third parties Bank Check Number.

Matching will be done based on Transaction numbers.

Regards
Oracleapps1983
anjan.614
Posts: 21
Joined: Tue Sep 09, 2008 8:50 am
Location: India

Post by anjan.614 »

Hi,

We are getting problem when we are doing auto reconciliation. we are unable to do the auto reconciliation for an perticular bank. can you please help me what we have to(Set up) check before conclude the problem.

Regards,
Anjan
Post Reply

Who is online

Users browsing this forum: No registered users and 21 guests