What's new in Customer Journeys?

Connect and learn more! ×
Custom Time Attributes on Timecards are getting stored in random columns in HWM_TM_REP_ATRBS table — 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

Custom Time Attributes on Timecards are getting stored in random columns in HWM_TM_REP_ATRBS table

Received Response
15
Views
1
Comments

Summary:

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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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