Oracle Retail Knowledge Base

Initial setup - W_LANGUAGES_G

1 min read

Context

W_LANGUAGES_G lists the languages the warehouse supports for translatable data such as item and location descriptions. AIF_DATA generates translation lookup rows for every language in this table.

New environments are provisioned with a default US English row. On P&C, English is kept and German is added, so both languages coexist and descriptions are available in either.

Configuration

Connect through APEX, or navigate AI FOUNDATION CLOUD SERVICE > TOP LEFT MENU > Tasks > Control and Tactical Center > Manage Configurations > select the table W_LANGUAGES_G.

The two columns that matter for initial setup are:

  • LANGUAGE_CODE: the language being added, D for German.
  • SRC_LANGUAGE_CODE: the source language the translation derives from, US for the provisioned US English row.

Add German while leaving the default English row in place:

-- GERMAN, DERIVED FROM THE DEFAULT US ENGLISH ROW
insert into w_languages_g
	(LANGUAGE_CODE, SRC_LANGUAGE_CODE)
values
	('D', 'US');

Reference

Graph View

Backlinks