Error on table MSC_ST_MEASURE_DATA, column TIM_LVL_MEMBER_VALUE. ORA-01841:(full) year must not be 0
Summary:
We wanted to load the item shipment history to a new custom measure. So, we have created a new measure by dupliating the Shipments History: Shipped Item by Requested Date measure. We are trying to load the same data that we have loaded previously to the seeded shipment history measure.
But we are getting the error as Year must not be 0. While preparing the measures.csv file we are changing the TIM_LVL_MEMBER_VALUE column data to the standard date format YYYY/MM/DD and uploading. Still the records are rejecting due to this error.
If we change the measure to seeded one i.e Shipments History: Shipped Item by Requested Date in the same file and load then its successful.