Incorrect French Translation On The Manager’s Timecard Status Dashboard

(Doc ID 2041619.1)

Last updated on OCTOBER 11, 2017

Applies to:

Oracle Time and Labor - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

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”.


Cause

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