Endeca V5: OPM: Quality Information Dashboard Tool Tip Date Is Not Language Specific (Doc ID 2029137.1)

Last updated on JULY 17, 2017

Applies to:

Oracle Process Manufacturing Product Development - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

In 12.1.3 Instance, In Endeca Extensions' implementation for GMD
A page level tip is shown to indicate the time/date at which the previous data load got completed at the left/top corner.

The following query is being used to identify the last-successful execution date:

SELECT Max(etl_run_end_date)
FROM fnd_eid_etl_audits FEEA
WHERE FEEA.eid_instance_id = &instance_id
AND FEEA. etl_run_status = 'S'
AND FEEA.EID_DATA_STORE_NAME='gmd-quality';

Need to add one more condition to pick the etl_run_end_date as language
specific.
AND etl_run_lang = UserEnv('LANG'

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