Localize Custom Report Data

About this task

To localize the custom report data in your system:

Procedure

  1. Create a localized view by performing an outer join on the report-specific view and the YFS_LOCALIZED_STRINGS table.
    Note: Localization of Item Descriptions is done differently. Item Descriptions are localized by performing an outer join on the report-specific view and the YFS_LANGUAGE_DESCRIPTION table.
  2. Take the report data from the localized views created in the previous step.
  3. In the report, create a mandatory filter on the locale code to fetch data specific to the user’s locale. If the data is fetched from multiple localized views, the locale code should be added as a filter for each view.