Accounting Process Fatal Error

[asimsandhu2000]

We are facing a Fatal error during accounting process, there are some specific invoices which are not being posted.

[ramu.parepalli]

Can you plz give us the Log file desciption of the Fatal Error.

[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>

[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

[asimsandhu2000]

The ver is:11.5.7 and we didn't made any change from backend.

[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

[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

[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