Day End can't complete - Internal error. Cannot read OESHCD (7852...)

[vbdbcoder]

I am having a problem with my customer.

Day End does not run due to shipment records are missing. - per initial investigation. The error message was "Description: Internal error. Cannot read OESHCD (7852 OEPOSTI1.C)."

I have identified one suspicious transactions: Order # "00007047" with Shipment # "SH00062416" and Invoice # "IN188841". Shipment # "SH00062416" has no details, while its invoice has the details.

I ran Rvspy and it stopped at:

[247c] PO0335: PODEPR [13:09:31.94].Unload
[247c] 9903 <==[13:09:31.95;t=182661;ovh=159841] {**ERROR**}


How to add transactions back to shipment detail table? or is it a solution to add records to shipment table? or should I remove the invoice and shipment header, and re-create the shipment and invoice?

Thanks

 

[Jay Converse]

Old problem,

http://www.tek-tips.com/viewthread.cfm?qid=1549910

 

[vbdbcoder]

Thanks for the prompt reply.

Your solution is to populate OESHCD with records from OESHID for the identified SHIUNIQ.

I don't have Shipment Detail records in OESHID for the SHIUNIQ identified (1548095). should I populate OESHID using SQL script first?

Thanks

 

[Jay Converse]

Sure, that might work, but I've never tried it. My clients never get this error.

 

[vbdbcoder]

Here is how we fixed it....

Somehow that specific Order keeps giving me grief. It creates the OE Invoice without an OE shipment, or with an OE shipment without Shipment details.

We updated OEORDH.COMPLETE = 4 and OEORDH.COMPDATE = 20111125 to mark the Order to be completed.

Then we updated OEINVH.INVSTAT = 2 and OEINVH.COMPDATE = 20111125 to mark the Invoice to be completed.

Then Day End runs with no error.

After Day End, Of course, we manually updated the Qty fields on the Order to be shipped (fields updated QTYORDERED, QTYBACKORDER,....) to make the order look it was shipped.

We manually add an AR invoice to AR batch for the $ amount of the order, since Day End skipped that invoice...

Still, can't figure out why an invoice was created without a shipment. But Day End runs now.