Error on table MSC_ST_MEASURE_DATA, column TIM_LVL_MEMBER_VALUE. ORA-01841:(full) year must not be 0 — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!