SAP Knowledge Base Article - Preview

3807523 - IBP: RTI - Error when inserting master data: A database error occured. The error message in the database was: "invalid DATE, TIME or TIMESTAMP value: Error while parsing '0' in format

Symptom

During master data integration, it fails due to errors:

"Error when inserting master data: A database error occured. The error message in the database was: "invalid DATE, TIME or TIMESTAMP value: Error while parsing '0' in format 'YYYYMMDDHH24MISS.FF7' as DATE/TIME at "to_time".

Error when inserting master data: A database error occured. The error message in the database was: "invalid DATE, TIME or TIMESTAMP value: Error while parsing '0' in format 'YYYYMMDDHH24MISS.FF7' as DATE/TIME at "to_timestamp".


Read more...

Environment

  • SAP Integrated Business Planning (SCM-IBP)
  • SAP ERP
  • SAP S/4 On Premise

Product

SAP ERP all versions ; SAP Integrated Business Planning all versions ; SAP S/4HANA all versions

Keywords

IBP, RTI, real-time, integration, custom field, timestamp, master data, BAdI, custom code, populated, filled, empty, blank, wrong, format, invalid, date, time, to_time, to_timestamp, Error when inserting master data, A database error occurred, The error message in the database was, invalid DATE, TIME or TIMESTAMP value, Error while parsing '0' in format, Error while parsing 0 in format, 'YYYYMMDDHH24MISS.FF7', DATE/TIME,  YYYYMMDDHH24MISS.FF7 , KBA , SCM-IBP-INT-RTI-PDS , Production Data Structure , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.