When attempting to XOG in custom object getting an error cannot insert NULL into ("NIKU"."ODF_MAPPINGS"."MAPPING_CODE")

Products

• Clarity PPM On Premise

Issue/Introduction

After susseccfully XOG out a custom object we are getting an error attempting to XOG into another environment.

ORA-01400: cannot insert NULL into ("NIKU"."ODF_MAPPINGS"."MAPPING_CODE")

Environment

Release : 16.0.3

Cause

Saw mapping missing and looked like as below in the XOG output file:

<mapping mappingCode="" typeCode="" value=""/>

Resolution

There were couple of attributes that had missing display mapping and after adding in Studio issue was resolved.