MRC query

[mukund_cs]

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 for the above receipt

Regards,

[oteixeira]

Hello.
Do you know the receipt number? If yes, query GL_JE_LINES with REFERENCE_4 = 'receipt number'
From LINES you can get HEADERS and, from there, BATCHES.

Hope this helps.
Octavio