Home » Applications » Oracle Fusion Apps & E-Business Suite » MRC query
MRC query [message #406588] Thu, 04 June 2009 14:42 Go to next message
Messages: 21
Registered: February 2007
Junior Member

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.

Re: MRC query [message #406606 is a reply to message #406588] Thu, 04 June 2009 22:53 Go to previous message
vamsi kasina
Messages: 2108
Registered: October 2003
Location: Hyderabad, India
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.

Previous Topic: Interfacing with Oracle iProcurement
Next Topic: API for employee assignment updation
Goto Forum:

Current Time: Mon Jul 24 14:04:36 CDT 2017

Total time taken to generate the page: 0.10488 seconds