| MRC query [message #406588] |
Thu, 04 June 2009 14:42  |
mukundsahare
Messages: 21
Registered: February 2007
|
Junior Member |
|
|
Hi,
We had a receipt with data corruption, during monthend close. This prevented the May period from closing. The issue was that one line from the receipt (5K amount) was not hitting the MRC SOB. We worked with Oracle to get it fixed.below is the fix
update ar_mc_receivable_apps
set gl_posted_date = to_date('28-MAY-2009','dd-mon-yyyy'),
posting_control_id = 1337217
where receivable_application_id = 36353213
and cash_receipt_id = 773110
and set_of_books_id = 12042.
After the fix was applied, the AR-GL transfer was run and it created a journal in the reporting SOB for the receipt in question.
Do any one have the query to get the GL Batch and MRC batch information.
Regards,
|
|
|
|
| Re: MRC query [message #406606 is a reply to message #406588] |
Thu, 04 June 2009 22:53  |
 |
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
|
Senior Member |
|
|
Are you sure that it has created a journal after AR-GL Transfer?
After updating the posting_control_id to a value (<> -3), I don't think AR-GL Transfer will pick that up.
You can work with Oracle again to get a clarification on this.
As you are talking about AR-GL Transfer and I don't think Oracle is supporting 11, I assume you are on 11i.
By
Vamsi
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
