Home » Applications » Oracle Fusion Apps & E-Business Suite » autoreconciliation problem (r12)
autoreconciliation problem [message #409755] Tue, 23 June 2009 20:39 Go to next message
bananaman
Messages: 71
Registered: March 2009
Member
Hi! I'm having trouble in using the autoreconciliation in R12 Cash Management. Why is it that everytime I run the program "AutoReconciliation", I always get the message "Program Ran Successfully, No Error Found." from AutoReconciliation Execution Report but the target bank statement status remains "Unreconciled"?
Re: autoreconciliation problem [message #409825 is a reply to message #409755] Wed, 24 June 2009 03:37 Go to previous messageGo to next message
tgs100
Messages: 66
Registered: July 2005
Location: Chennai, India
Member
I too got this message when there are no unreconciled payable/receivable transactions for the bank account. First ensure that there are unreconciled payments/receipts for the bank account.

If you want to reconcile receipts, then the receipt status should be "Remitted".

In the case of Payables, check the payable options and make sure that clearing is enabled for the OU.


Cheers,
Saravanan
Re: autoreconciliation problem [message #409855 is a reply to message #409825] Wed, 24 June 2009 04:39 Go to previous messageGo to next message
bananaman
Messages: 71
Registered: March 2009
Member
Hi! I already checked my receipt class for that bank that I used. In the Clearance method, I chose 'By Matching' so that this will require the reconciliation in cash management. Even if the state of the receipt is 'Remitted', I still got the same result. I also tried to reconcile other bank statements with no matching receipt but the execution report did not raised any error and still prompted "Program Ran Successfully, No Error Found." on the execution report. Any other suggestion to fix this?
Re: autoreconciliation problem [message #409870 is a reply to message #409855] Wed, 24 June 2009 05:09 Go to previous messageGo to next message
tgs100
Messages: 66
Registered: July 2005
Location: Chennai, India
Member
Did you upload the bank statement or entered it manually.

Have you done transaction code setup in CM? Have you attached the transaction codes in the bank statement lines?

Cheers,
Sara
Re: autoreconciliation problem [message #409872 is a reply to message #409870] Wed, 24 June 2009 05:14 Go to previous messageGo to next message
bananaman
Messages: 71
Registered: March 2009
Member
I just entered the bank statement manually. I have set up the transaction codes. My question is how do you attach the transaction code to the bank statement lines? Thanks for the reply by the way.
Re: autoreconciliation problem [message #409874 is a reply to message #409755] Wed, 24 June 2009 05:35 Go to previous messageGo to next message
tgs100
Messages: 66
Registered: July 2005
Location: Chennai, India
Member
While entering the bank statement lines, there is field called "Code" after the transaction type.

Cheers,
Sara
Re: autoreconciliation problem [message #410021 is a reply to message #409874] Wed, 24 June 2009 20:20 Go to previous messageGo to next message
bananaman
Messages: 71
Registered: March 2009
Member
Ok. I got it. It is now working. I usually run the AutoReconciliation program in 11i without entering the code in the statement line and it works properly that's why I assumed this would be just the same in R12. Thanks a lot!
Re: autoreconciliation problem [message #410038 is a reply to message #410021] Wed, 24 June 2009 23:05 Go to previous messageGo to next message
tgs100
Messages: 66
Registered: July 2005
Location: Chennai, India
Member
I doubt that auto reconciliation works in R11 without transaction codes.

As per my understanding, even in R11, transaction code is mandatory in bank statement.

Cheers,
Sara
Re: autoreconciliation problem [message #410072 is a reply to message #410038] Thu, 25 June 2009 01:15 Go to previous message
bananaman
Messages: 71
Registered: March 2009
Member
It works, even if you don't link the bank transaction code you created to the bank statement line. The field "Code" in Bank Statement Line window is not a required field. That is what I usually do when running the AutoReconciliation program. But I always provide the receipt number in the "Number" field.
Previous Topic: AR auto invoice interface
Next Topic: subledger journals tranfer to GL
Goto Forum:
  


Current Time: Sun Jun 23 14:15:35 CDT 2024