Incorrect French Translation On The Manager’s Timecard Status Dashboard (Doc ID 2041619.1)
Last updated on SEPTEMBER 04, 2015
Oracle Time and Labor - Version 12.1.3 and later Information in this document applies to any platform.
On : 12.1 RUP7 version, Dashboards
Incorrect French Translation on the timecard status dashboard function
Steps to Reproduce: The issue can be reproduced at will with the following steps:
1. Go to Manager Self Service->Timecard Status Dashboard 2. Go to About this page 3. Check for TcdSummaryTotalsVO 4. We can see 'Summary Totals' is hardcoded
SELECT 'Summary Totals' ColumnName, sum(not_enetered), sum(working), sum(error), sum(submitted), sum(rejected), sum(approved), sum(total) FROM hxc_tcd_status_count where user_id = fnd_global.login_id
5. Check for TcdSummaryGraphVO 6. The name of the column is Hardcoded “TimecardCount” and no translation is provided.
SELECT hxc.meaning "TimecardStatus" ,count (approval_status) "TimecardCount" FROM hxc_tcd_timecards hxc WHERE hxc.user_id = fnd_global.login_id GROUP BY meaning UNION SELECT meaning ,0 FROM fnd_lookup_values fdk WHERE fdk.meaning NOT IN ( SELECT DISTINCT meaning FROM hxc_tcd_timecards WHERE user_id = fnd_global.login_id ) AND language = userenv ('LANG') AND view_application_id = 3 AND lookup_type = 'HXC_APPROVAL_STATUS' AND fdk.lookup_code IN ('NOTENTERED','WORKING','ERROR' ,'SUBMITTED','REJECTED','APPROVED')
7. In TcDashboardSummaryCO,the territory that is passed in parameter is hardcoded to “00”.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a Million Knowledge Articles and hundreds of Community platforms