Custom Time Attributes on Timecards are getting stored in random columns in HWM_TM_REP_ATRBS table
Timecards have the two custom time attributes. For all the time types, these custom time attributes are getting stored in ATTRIBUTE_VARCHAR1 and ATTRIBUTE_VARCHAR2 of HWM_TM_REP_ATRBS table correctly. But for couple of time types, these values are getting stored in ATTRIBUTE_VARCHAR12 and ATTRIBUTE_VARCHAR1.
Raised an SR with Oracle and got an answer that the manner in which this table is populated by the application can vary. If the manner varies everytime and the column selection is random, developing custom BI reports on this table is difficult. Does anyone have the same issue and have a resolution for this?