stkvar aborts with error 'ORA - 01405'

Getting below error while running the STKVAR batch

"stkvar_1~*~calc_av_cost~~-1405~ORA-01405: fetched column value is NULL~STORED FUNCTION CALL FAILED: function=STKLEDGR_SQL.TRAN_DATE_INSERT"

Hi,
I have created a Unit & Value Stock Count

After running all the stock count batches in RMS I am not able to get the data in the tran_data table. Here are the steps that I followed:

1. Create a stock count request in RMS User Interface

2. Run stkxpld (populates stake_sku_loc)

3. Run refeodinventory (refreshes item_loc_soh_eod)

4. Run stkupd, with pre and post (stake_sku_loc got updated, the snapshot columns)