Page 1 of 1
Accounting Process Fatal Error
Posted: Wed Jan 09, 2008 1:48 am
by asimsandhu2000
We are facing a Fatal error during accounting process, there are some specific invoices which are not being posted.
Posted: Thu Jan 10, 2008 10:04 am
by ramu.parepalli
Can you plz give us the Log file desciption of the Fatal Error.
Posted: Fri Jan 11, 2008 12:58 am
by asimsandhu2000
Dear ,
PFA.....
<b>Named as Accounting Process Log.zip</b>
[img]/images/icon_zip.gif[/img] <b>Attachment:</b>
Accounting_Process_Log.zip <i>( 1143bytes )</i>
Posted: Fri Jan 11, 2008 1:07 am
by admin
Hi,
Please let us know the version of your application and also if any change made from backend? Also let us know this is production instance or test? If it is production then I will recommend you to create an SR with metalink. Thanks
Posted: Fri Jan 11, 2008 2:18 am
by asimsandhu2000
The ver is:11.5.7 and we didn't made any change from backend.
Posted: Sat Jan 12, 2008 6:06 am
by seneeraj
[quote]We are facing a Fatal error during accounting process, there are some specific invoices which are not being posted.
<i><div align="right">Originally posted by asimsandhu2000
Posted: Mon Jan 14, 2008 3:41 pm
by ramu.parepalli
Hi,
Is there any particular reason for Transferring the entries in Summarize by Accounting Period.
Transfer to GL Interface :Summarize by Accounting Period
Please to run Transfer to GL with Parameter Summarize in Detail.
Plz forward the log file after submitting this request.
Regards,
Ram
Posted: Wed Jan 23, 2008 1:22 am
by asimsandhu2000
Dear All,
We've solved the problem by doing as
1. Balance the Accounting entries in ap_ae_lines_all for the invoice bearing the error
2. Set Event_status_code = ?ACCOUNTED? in AP_ACCOUNTING_EVENTS_ALL for the related accounting event.
3. Set Accounting_error_code =null in ap_ae_headers_all for the related invoice.
Exact SQL Statements are as below
update ap_ae_headers_all set accounting_error_code = null where ae_header_id like '****XX';
update AP_ACCOUNTING_EVENTS_ALL set EVENT_STATUS_CODE = 'ACCOUNTED' where accounting_event_id in (select accounting_event_id from ap_ae_headers_all where ae_header_id like '****XX')
4. Run payables Transfer To GL.
I think this is problem with this release in later releases the issue has been resolved.
Thanks for your cooperation...
Regards,
Asim Ikram