Customised OTL Self Service Timecard Saving Incorrect Values
Last updated on JULY 15, 2016
Applies to:Oracle Time and Labor - Version 12.1.3 and later
Information in this document applies to any platform.
Self Service timecard layout has been customized to add a field with a choice list. The list is populated via a custom value set and a view created called HXC_CUI_CUSTOM3_V which returns the values and ids.
- The layout has been modified as per the instructions to refer to this view and have set QUALIFIER_ATTRIBUTE27 = "Attribute12".
When using the Self Service screen, the list returns the expected values but when it is saved, the value vanishes.
In Hxc_Time_Attributes that the value being stored in Attribute12 is not the value returned by the view.
in a test instance, there are 3 values set up with the ids 1232023, 1232024 and 1232025.
When used in the screen, the values saved in the database are -5150515351480000000000000000, -5150515351490000000000000000 and -5150515351500000000000000000.
Using very similar functionality for a different department using a different value set and HXC_CUI_CUSTOM4_V (also pointing to Attribute12) and that works just fine.
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
- Timecard created and saved using the customized layout
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms