The job docclose fails with INTERNAL STORED FUNCTION ERROR: function=APPT_DOC_CLOSE_SQL.CLOSE_TSF, e

Hi All,

We have faced a issue with docclose .It failed with the following error. docclose_1~20151008005702~close_tsf~WH~105~RET-0105: generic stored procedure error~INTERNAL STORED FUNCTION ERROR: function=APPT_DOC_CLOSE_SQL.CLOSE_TSF, error=CLOSE cursor C_WAREHOUSE in package TRANSFER_COST_SQL.RECALC_WAC.

 

Based on our analysis inorder to find the erroneous transfer.We set the commit max counter to 1 in and reran the job .It failed with the erroneous transfer which was taken from the following driving cursor

SELECT doc,

             doc_type,

             rowid

        FROM doc_close_queue

      WHERE doc_type = 'T'      

      ORDER BY doc;

On analysing the transfer we could see that the quantity received was not equal to the quantity for a pack item. On deleting that erroneous transfer the job completed successfully.What could be the possible reasons for the transfer to cause failure? Could the qty_expected<>qty_received be the possible cause for failure?