My Oracle Support Banner

DRM-GL Integration: Start Date / End Date Format Mismatch (Doc ID 1553525.1)

Last updated on AUGUST 19, 2021

Applies to:

Hyperion Data Relationship Management - Version and later
Generic (Platform Independent)


When you run concurrent job program "Load Segment values and Hierarchies" from GL, DRM imports dates incorrectly.

For example, if the Start Date and End date in GL is '05 Jan 1951', DRM shows 01/05/1951, meaning 1 May 1951. With a date like 13/05/2013, which is invalid if interpreted as mm/dd/yyyy, the export fails and you get the error:

"DRM-23081: Export was unable to run due to the following error: String was not recognized as a valid DateTime. Couldn't store '5/13/2013' in START_DATE_ACTIVE Column. Expected type is DateTime."


You patched EBS R12.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.