プライマリ・コンテンツに移動
Oracle® Application Expressアプリケーション・ビルダー・ユーザーズ・ガイド
リリース5.0
E64891-02
  目次へ移動
目次
索引へ移動
索引

前
 
次
 

21.4 メッセージの翻訳

この項では、Oracle Application Expressアプリケーションでメッセージをいつどのように翻訳するかについて説明します。

21.4.1 メッセージの翻訳について

アプリケーションが次に当てはまる場合、メッセージを翻訳する必要があることがあります。

  • PL/SQLリージョンまたはPL/SQLプロセスが含まれる場合、あるいはPL/SQLパッケージ、プロシージャ、またはファンクションをコールする場合。この場合、生成されたHTMLを翻訳する必要があることがあります。

  • Oracle Application Expressが翻訳されている10言語以外の言語を使用する場合。この場合、レポートに使用されているメッセージを翻訳する必要があることがあります。

21.4.2 PL/SQLプロシージャで使用されるメッセージの翻訳

この項では、PL/SQLプロシージャで使用されるメッセージの翻訳方法について説明します。


関連項目:

『Oracle Application Express APIリファレンス』APEX_LANGに関する項

21.4.2.1 PL/SQLプロシージャで使用されるメッセージの翻訳について

アプリケーションにPL/SQLリージョンまたはPL/SQLプロセスが含まれる場合、あるいはアプリケーションがPL/SQLパッケージ、プロシージャ、またはファンクションをコールする場合は、生成されるHTMLを翻訳する必要がある場合があります。最初に、翻訳可能なメッセージ・ページで、各メッセージを定義します。次に、APEX_LANG.MESSAGE APIを使用して、PL/SQLストアド・プロシージャ、ファンクション、トリガーまたはパッケージ化されたプロシージャおよびファンクションのメッセージを翻訳します。

21.4.2.2 翻訳メッセージの定義

翻訳可能なメッセージ・ページで、翻訳可能なメッセージを作成します。

新しい翻訳メッセージを定義するには、次のステップを実行します。

  1. アプリケーションの翻訳ページにナビゲートします。

    1. 「ワークスペース」ホームページで、「アプリケーション・ビルダー」アイコンをクリックします。

    2. アプリケーションを選択します。

    3. 「共有コンポーネント」をクリックします。

    4. 「グローバリゼーション」の下で「テキスト・メッセージ」をクリックします。

  2. メッセージの翻訳ページで、「テキスト・メッセージの作成」をクリックします。

  3. テキスト・メッセージを指定ページで、次のステップを実行します。

    1. 名前: メッセージを識別するための名前を入力します。

    2. 言語: メッセージが使用される言語を選択します。

    3. JavaScriptで使用: メッセージがJavaScriptコードのAPEX.LANG APIコールで使用されている場合、「はい」を選択します。

    4. テキスト: テキスト・メッセージがコールされたときに戻されるテキストを入力します。

      たとえば、メッセージGREETING_MSGを次のように英語で定義できます。

      Good morning %0
      

      また、メッセージGREETING_MSGを次のようにドイツ語で定義できます。

      Guten Tag %0
      
  4. 「テキスト・メッセージの作成」をクリックします。

21.4.3 Oracle Application Expressにより内部使用されるメッセージの翻訳

Oracle Application Expressはドイツ語、スペイン語、フランス語、イタリア語、日本語、韓国語、ポルトガル語(ブラジル)、簡体字中国語、および繁体字中国語に翻訳されています。これらの翻訳された10言語以外の言語をアプリケーションで使用する場合は、Application Expressレポート・エンジンによって表示されるメッセージを翻訳する必要があります。

たとえば、ロシア語のアプリケーションを開発してロシア語のレポート・メッセージ(ページ区切りなど)を使用する場合は、レポートに表示されるメッセージで使用される文字列を翻訳する必要があります。

21.4.3.1 テキスト・メッセージの作成

翻訳メッセージを作成するには、次のステップを実行します。

  1. アプリケーションの翻訳ページにナビゲートします。

    1. 「ワークスペース」ホームページで、「アプリケーション・ビルダー」アイコンをクリックします。

    2. アプリケーションを選択します。

    3. 「共有コンポーネント」をクリックします。

    4. 「グローバリゼーション」の下で「テキスト・メッセージ」をクリックします。

  2. メッセージの翻訳ページで、「テキスト・メッセージの作成」をクリックします。

  3. 「テキスト・メッセージを指定」で、次のように指定します。

    1. 名前: 翻訳する必要のある各メッセージの名前を入力します。「翻訳が必要な内部メッセージ」および「翻訳が必要な対話モード・レポートのメッセージ」を参照してください。

    2. 言語: メッセージが使用される言語を選択します。

    3. テキスト: テキスト・メッセージがコールされたときに戻されるテキストを入力します。英語のテキスト・メッセージに定位置の置換値(%0%1など)が含まれている場合、ユーザー定義のメッセージにも同じ名前と数字の定位置の置換値を含めてください。

  4. 「テキスト・メッセージの作成」をクリックします。

21.4.3.2 テキスト・メッセージの編集

テキスト・メッセージを編集するには、次のステップを実行します。

  1. アプリケーションの翻訳ページにナビゲートします。

    1. 「ワークスペース」ホームページで、「アプリケーション・ビルダー」アイコンをクリックします。

    2. アプリケーションを選択します。

    3. 「共有コンポーネント」をクリックします。

    4. 「グローバリゼーション」の下で「テキスト・メッセージ」をクリックします。

  2. テキスト・メッセージの編集で、次のステップを実行します。

    1. メッセージ名をクリックします。

    2. 適切な編集を加えます。

      英語のテキスト・メッセージに定位置の置換値(%0%1など)が含まれている場合、ユーザー定義のメッセージにも同じ名前と数字の定位置の置換値を含めてください。

    3. 「変更の適用」をクリックします。

  3. グリッド編集ページにアクセスするには、次のステップを実行します。

    1. 「グリッド編集」をクリックします。

      グリッド編集ページが表示されます。

    2. 適切な編集を加えます。

      英語のテキスト・メッセージに定位置の置換値(%0%1など)が含まれている場合、ユーザー定義のメッセージにも同じ名前と数字の定位置の置換値を含めてください。

    3. 「変更の適用」をクリックします。


    ヒント:

    グリッド編集ページから新しいメッセージを追加するには、ページの下部にある「テキスト・メッセージの追加」をクリックします。

21.4.3.3 翻訳が必要な内部メッセージ

表 21-2に、翻訳が必要な内部メッセージを示します。

表 21-2 翻訳が必要な内部メッセージ

メッセージ名 英語のテキスト

APEX.AUTHENTICATION.LOGIN_THROTTLE.COUNTER

Please wait <span id="apex_login_throttle_sec">%0</span> seconds to login again.

APEX.AUTHENTICATION.LOGIN_THROTTLE.ERROR

The login attempt has been blocked.

APEX.DATA_HAS_CHANGED

Current version of data in database has changed since user initiated update process. current checksum = "%0" application checksum = "%1".

APEX.DATEPICKER.ICON_TEXT

Popup Calendar: %0

APEX.DATEPICKER_VALUE_GREATER_MAX_DATE

#LABEL# is greater than specified maximum date %0.

APEX.DATEPICKER_VALUE_INVALID

#LABEL# does not match format %0.

APEX.DATEPICKER_VALUE_LESS_MIN_DATE

#LABEL# is less than specified minimum date %0.

APEX.DATEPICKER_VALUE_NOT_BETWEEN_MIN_MAX

#LABEL# is not between the valid range of %0 and %1.

APEX.DATEPICKER_VALUE_NOT_IN_YEAR_RANGE

#LABEL# is not within valid year range of %0 and %1.

APEX.FILE_BROWSE.DOWNLOAD_LINK_TEXT

Download

APEX.GO_TO_ERROR

Go to error

APEX.ITEM_TYPE.SLIDER.VALUE_NOT_BETWEEN_MIN_MAX

#LABEL# is not between the valid range of %0 and %1.

APEX.ITEM_TYPE.SLIDER.VALUE_NOT_MULTIPLE_OF_STEP

#LABEL# is not a multiple of %0.

APEX.ITEM_TYPE.YES_NO.INVALID_VALUE

#LABEL# must match to the values %0 and %1.

APEX.ITEM_TYPE.YES_NO.NO_LABEL

No

APEX.ITEM_TYPE.YES_NO.YES_LABEL

Yes

APEX.NUMBER_FIELD.VALUE_GREATER_MAX_VALUE

#LABEL# is greater than specified maximum %0.

APEX.NUMBER_FIELD.VALUE_INVALID

#LABEL# must be Numeric.

APEX.NUMBER_FIELD.VALUE_INVALID2

#LABEL# does not match number format %0 (For example, %1).

APEX.NUMBER_FIELD.VALUE_LESS_MIN_VALUE

#LABEL# is less than specified minimum %0.

APEX.NUMBER_FIELD.VALUE_NOT_BETWEEN_MIN_MAX

#LABEL# is not between the valid range of %0 and %1.

APEX.PAGE_ITEM_IS_REQUIRED

#LABEL# must have some value.

APEX.POPUP_LOV.ICON_TEXT

Popup List of Values: %0.

APEX.REGION.JQM_LIST_VIEW.SEARCH

Search

APEX.REGION.JQM_LIST_VIEW.LOAD_MORE

Load more

FLOW.SINGLE_VALIDATION_ERROR

1 error has occurred.

FLOW.VALIDATION_ERROR

%0 errors have occurred.

INVALID_CREDENTIALS

Invalid Login Credentials .

OUT_OF_RANGE

Invalid set of rows requested, the source data of the report has been modified.

PAGINATION.NEXT

Next

PAGINATION.NEXT_SET

Next Set

PAGINATION.PREVIOUS

Previous

PAGINATION.PREVIOUS_SET

Previous Set

REPORT_TOTAL

report total

RESET

reset pagination

SINCE_DAYS_AGO

%0 days ago

SINCE_DAYS_FROM_NOW

%0 days from now

SINCE_HOURS_AGO

%0 hours ago

SINCE_HOURS_FROM_NOW

%0 hours from now

SINCE_MINUTES_AGO

%0 minutes ago

SINCE_MINUTES_FROM_NOW

%0 minutes from now

SINCE_MONTHS_AGO

%0 months ago

SINCE_MONTHS_FROM_NOW

%0 months from now

SINCE_NOW

Now

SINCE_SECONDS_AGO

%0 seconds ago

SINCE_SECONDS_FROM_NOW

%0 seconds from now

SINCE_WEEKS_AGO

%0 weeks ago

SINCE_WEEKS_FROM_NOW

%0 weeks from now

SINCE_YEARS_AGO

%0 years ago

SINCE_YEARS_FROM_NOW

%0 years from now

TOTAL

Total

WWV_FLOW_UTILITIES.CAL

Calendar

WWV_FLOW_UTILITIES.CLOSE

Close

WWV_FLOW_UTILITIES.OK

Ok

WWV_RENDER_REPORT3.FOUND_BUT_NOT_DISPLAYED

Minimum row requested: %0, rows found but not displayed: %1

WWV_RENDER_REPORT3.SORT_BY_THIS_COLUMN

Sort by this column.

WWV_RENDER_REPORT3.UNSAVED_DATA

This form contains unsaved changes.Press Ok to proceed without saving your changes.

WWV_RENDER_REPORT3.X_Y_OF_MORE_THAN_Z

row(s) %0 - %1 of more than %2

WWV_RENDER_REPORT3.X_Y_OF_Z

row(s)%0 - %1 of %2

WWV_RENDER_REPORT3.X_Y_OF_Z_2

%0 - %1 of %2


21.4.3.4 翻訳が必要な対話モード・レポートのメッセージ

表 21-3に、翻訳が必要な対話モード・レポート・メッセージを示します。

表 21-3 翻訳が必要な対話モード・レポート・メッセージ

メッセージ名 英語のテキスト

4150_COLUMN_NUMBER

Column %0

APEXIR_3D

3D

APEXIR_ACTIONS

Actions

APEXIR_ACTIONS_MENU

Actions Menu

APEXIR_ADD

Add

APEXIR_ADD_FUNCTION

Add Function

APEXIR_ADD_GROUP_BY_COLUMN

Add Group By Column

APEXIR_ADD_PIVOT_COLUMN

Add Pivot Column

APEXIR_ADD_ROW_COLUMN

Add Row Column

APEXIR_ADD_SUBSCRIPTION

Add Subscription

APEXIR_AGG_AVG

Average

APEXIR_AGG_COUNT

Count

APEXIR_AGG_MAX

Maximum

APEXIR_AGG_MEDIAN

Median

APEXIR_AGG_MIN

Minimum

APEXIR_AGG_MODE

Mode

APEXIR_AGG_SUM

Sum

APEXIR_AGGREGATE

Aggregate

APEXIR_AGGREGATE_DESCRIPTION

Aggregates are displayed after each control break and at the end of the report.

APEXIR_AGGREGATION

Aggregation

APEXIR_ALL

All

APEXIR_ALL_COLUMNS

All Columns

APEXIR_ALL_ROWS

All Rows

APEXIR_ALTERNATIVE

Alternative

APEXIR_ALTERNATIVE_DEFAULT_NAME

Alternative Default: %0

APEXIR_AND

and

APEXIR_APPLY

Apply

APEXIR_AS_OF

As of %0

APEXIR_ASCENDING

Ascending

APEXIR_AVERAGE_X

Average %0

APEXIR_BETWEEN

between

APEXIR_BGCOLOR

Background Color

APEXIR_BLUE

blue

APEXIR_BOTTOM

Bottom

APEXIR_CALENDAR

Calendar

APEXIR_CANCEL

Cancel

APEXIR_CATEGORY

Category

APEXIR_CELL

Cell

APEXIR_CHART

Chart

APEXIR_CHART_INITIALIZING

Initializing...

APEXIR_CHART_LABEL_NOT_NULL

Chart label must be specified

APEXIR_CHART_MAX_ROW_CNT

The maximum row count for a chart query limits the number of rows in the base query, not the number of rows displayed.Your base query exceeds the maximum row count of %0.Please apply a filter to reduce the number of records in your base query.

APEXIR_CHART_TYPE

Chart Type

APEXIR_CHECK_ALL

Check All

APEXIR_CHOOSE_DOWNLOAD_FORMAT

Choose report download format

APEXIR_CLEAR

clear

APEXIR_COLUMN

Column

APEXIR_COLUMN_FILTER

Filter...

APEXIR_COLUMN_HEADING

Column Heading

APEXIR_COLUMN_HEADING_MENU

Column Heading Menu

APEXIR_COLUMN_INFO

Column Information

APEXIR_COLUMN_N

Column %0

APEXIR_COLUMNS

Columns

APEXIR_COMPARISON_CONTAINS

contains

APEXIR_COMPARISON_DOESNOT_CONTAIN

does not contain

APEXIR_COMPARISON_IN

in

APEXIR_COMPARISON_IS_IN_LAST

is in the last

APEXIR_COMPARISON_IS_IN_NEXT

is in the next

APEXIR_COMPARISON_IS_NOT_NULL

is not null

APEXIR_COMPARISON_IS_NULL

is null

APEXIR_COMPARISON_ISNOT_IN_LAST

is not in the last

APEXIR_COMPARISON_ISNOT_IN_NEXT

is not in the next

APEXIR_COMPARISON_LIKE

like

APEXIR_COMPARISON_NOT_IN

not in

APEXIR_COMPARISON_NOT_LIKE

not like

APEXIR_COMPARISON_REGEXP_LIKE

matches regular expression

APEXIR_COMPUTATION

Computation

APEXIR_COMPUTATION_EXPRESSION

Computation Expression

APEXIR_COMPUTATION_FOOTER

Create a computation using column aliases.

APEXIR_COMPUTATION_FOOTER_E1

(B+C)*100

APEXIR_COMPUTATION_FOOTER_E2

INITCAP(B)||', '||INITCAP(C)

APEXIR_COMPUTATION_FOOTER_E3

CASE WHEN A = 10 THEN B + C ELSE B END

APEXIR_COMPUTE

Compute

APEXIR_CONTROL_BREAK

Control Break

APEXIR_CONTROL_BREAK_COLUMNS

Control Break Columns

APEXIR_CONTROL_BREAKS

Control Breaks

APEXIR_COUNT_DISTINCT

Count Distinct

APEXIR_COUNT_DISTINCT_X

Count Distinct

APEXIR_COUNT_X

Count %0

APEXIR_DAILY

Daily

APEXIR_DATA_AS_OF

Report data as of %0 minutes ago.

APEXIR_DATE

Date

APEXIR_DAY

Day

APEXIR_DEFAULT

Default

APEXIR_DEFAULT_REPORT_TYPE

Default Report Type

APEXIR_DELETE

Delete

APEXIR_DELETE_CHECKED

Delete Checked

APEXIR_DELETE_CONFIRM

Would you like to delete these report settings?

APEXIR_DELETE_CONFIRM_JS_DIALOG

Would you like to perform this delete action?

APEXIR_DELETE_DEFAULT_REPORT

Delete Default Report

APEXIR_DELETE_REPORT

Delete Report

APEXIR_DESCENDING

Descending

APEXIR_DESCRIPTION

説明

APEXIR_DETAIL_VIEW

Single Row View

APEXIR_DIRECTION

Direction

APEXIR_DISABLE

Disable

APEXIR_DISABLED

Disabled

APEXIR_DISPLAY

Display

APEXIR_DISPLAY_IN_REPORT

Display in Report

APEXIR_DISPLAYED

Displayed

APEXIR_DISPLAYED_COLUMNS

Displayed Columns

APEXIR_DO_NOT_AGGREGATE

- Do not aggregate -

APEXIR_DO_NOT_DISPLAY

Do Not Display

APEXIR_DOWN

Down

APEXIR_DOWNLOAD

Download

APEXIR_DUPLICATE_PIVOT_COLUMN

Duplicate pivot column.Pivot column list must be unique.

APEXIR_EDIT

Edit

APEXIR_EDIT_ALTERNATIVE_DEFAULT

Edit Alternative Default

APEXIR_EDIT_CHART

Edit Chart Settings

APEXIR_EDIT_CHART2

Edit Chart

APEXIR_EDIT_FILTER

Edit Filter

APEXIR_EDIT_GROUP_BY

Edit Group By

APEXIR_EDIT_HIGHLIGHT

Edit Highlight

APEXIR_EDIT_PIVOT

Edit Pivot

APEXIR_EMAIL

Email

APEXIR_EMAIL_ADDRESS

Email Address

APEXIR_EMAIL_BCC

Bcc

APEXIR_EMAIL_BODY

Body

APEXIR_EMAIL_CC

Cc

APEXIR_EMAIL_FREQUENCY

Frequency

APEXIR_EMAIL_NOT_CONFIGURED

Email has not been configured for this application.Please contact your administrator.

APEXIR_EMAIL_REQUIRED

Email Address must be specified.

APEXIR_EMAIL_SEE_ATTACHED

See attached.

APEXIR_EMAIL_SUBJECT

Subject

APEXIR_EMAIL_SUBJECT_REQUIRED

Email Subject must be specified.

APEXIR_EMAIL_TO

To

APEXIR_ENABLE

Enable

APEXIR_ENABLE_DISABLE_ALT

Enable/Disable

APEXIR_ENABLED

Enabled

APEXIR_ERROR

Error

APEXIR_EXAMPLES

Examples

APEXIR_EXAMPLES_WITH_COLON

Examples:

APEXIR_EXCLUDE_NULL

Exclude Null Values

APEXIR_EXPAND_COLLAPSE_ALT

Expand/Collapse

APEXIR_EXPRESSION

Expression

APEXIR_FILTER

Filter

APEXIR_FILTER_EXPRESSION

Filter Expression

APEXIR_FILTER_TYPE

Filter Type

APEXIR_FILTERS

Filters

APEXIR_FINDER_ALT

Select columns to search.

APEXIR_FLASHBACK

Flashback

APEXIR_FLASHBACK_DESCRIPTION

A flashback query enables you to view the data as it existed at a previous point in time.

APEXIR_FLASHBACK_ERROR_MSG

Unable to perform flashback request.

APEXIR_FORMAT

Format

APEXIR_FORMAT_MASK

Format Mask

APEXIR_FUNCTION

Function

APEXIR_FUNCTION_N

Function %0

APEXIR_FUNCTIONS

Functions

APEXIR_FUNCTIONS_OPERATORS

Functions / Operators

APEXIR_GO

Go

APEXIR_GREEN

green

APEXIR_GROUP_BY

Group By

APEXIR_GROUP_BY_COL_NOT_NULL

Group by column must be specified

APEXIR_GROUP_BY_COLUMN

Group By Column

APEXIR_GROUP_BY_MAX_ROW_CNT

The maximum row count for a Group By query limits the number of rows in the base query, not the number of rows displayed.Your base query exceeds the maximum row count of %0.Please apply a filter to reduce the number of records in your base query.

APEXIR_GROUP_BY_SORT

Group By Sort

APEXIR_GROUP_BY_SORT_ORDER

Group By Sort Order

APEXIR_HCOLUMN

Horizontal Column

APEXIR_HELP

Help

APEXIR_HELP_01

An Interactive Report displays a predetermined set of columns.The report may be further customized with an initial filter clause, a default sort order, control breaks, highlighting, computations, aggregates and a chart.Each Interactive Report can then be further customized and the results can be viewed, or downloaded, and the report definition can be stored for later use.

<p/>

An Interactive Report can be customized in three ways: the search bar, actions menu and column heading menu.

APEXIR_HELP_ACTIONS_MENU

The actions menu is used to customize the display of your Interactive Report.

APEXIR_HELP_AGGREGATE

Aggregates are mathematical computations performed against a column.Aggregates are displayed after each control break and at the end of the report within the column they are defined.

<p/>

<ul><li><b>Aggregation</b> allows you to select a previously defined aggregation to edit.</li>

<li><b>Function</b> is the function to be performed (e.g. SUM, MIN).</li>

<li><b>Column</b> is used to select the column to apply the mathematical function to.Only numeric columns will be displayed.</li></ul>

APEXIR_HELP_CHART

You can include one chart per Interactive Report.Once defined, you can switch between the chart and report views using links below the search bar.

<p/>

<ul><li><b>Chart Type</b> identifies the chart type to include.Select from horizontal bar, vertical bar, pie or line.</li>

<li><b>Label</b> allows you to select the column to be used as the label.</li>

<li><b>Axis Title for Label</b> is the title that will display on the axis associated with the column selected for Label.This is not available for pie chart.</li>

<li><b>Value</b> allows you to select the column to be used as the value.If your function is a COUNT, a Value does not need to be selected.</li>

<li><b>Axis Title for Value</b> is the title that will display on the axis associated with the column selected for Value.This is not available for pie chart.</li>

<li><b>Function</b> is an optional function to be performed on the column selected for Value.</li></ul>

APEXIR_HELP_COLUMN_HEADING_MENU

Clicking on any column heading exposes a column heading menu.

<p/>

<ul><li><b>Sort Ascending icon</b> sorts the report by the column in ascending order.</li>

<li><b>Sort Descending icon</b> sorts the report by the column in descending order.</li>

<li><b>Hide Column</b> hides the column.</li>

<li><b>Break Column</b> creates a break group on the column.This pulls the column out of the report as a master record.</li>

<li><b>Column Information</b> displays help text about the column, if available.</li>

<li><b>Text Area</b> is used to enter case insensitive search criteria (no need for wild cards).Entering a value will reduce the list of values at the bottom of the menu.You can then select a value from the bottom and the selected value will be created as a filter using '=' (e.g. column = 'ABC').Alternatively, you can click the flashlight icon and the entered value will be created as a filter with the 'LIKE' modifier (e.g. column LIKE '%ABC%').<li><b>List of Unique Values</b> contains the first 500 unique values that meet your filters.If the column is a date, a list of date ranges is displayed instead.If you select a value, a filter will be created using '=' (e.g. column = 'ABC').</li></ul>

APEXIR_HELP_COMPUTE

Computations allow you to add computed columns to your report.These can be mathematical computations (e.g. NBR_HOURS/24) or standard Oracle functions applied to existing columns (some have been displayed for example, others, like TO_DATE, can also be used).

<p/>

<ul><li><b>Computation</b> allows you to select a previously defined computation to edit.</li>

<li><b>Column Heading</b> is the column heading for the new column.</li>

<li><b>Format Mask</b> is an Oracle format mask to be applied against the column (e.g. S9999).</li>

<li><b>Format Mask</b> is an Oracle format mask to be applied against the column (e.g. S9999).</li>

<li><b>Computation</b> is the computation to be performed.Within the computation, columns are referenced using the aliases displayed.</li>

</ul>

<p/>

Below computation, the columns in your query are displayed with their associated alias.Clicking on the column name or alias will write them into the Computation.Next to Columns is a Keypad.These are simply shortcuts of commonly used keys.On the far right are Functions.

<p/>

An example computation to display Total Compensation is:

<p/>

<pre>CASE WHEN A = 'SALES' THEN B + C ELSE B END</pre>

(where A is ORGANIZATION, B is SALARY and C is COMMISSION)

APEXIR_HELP_CONTROL_BREAK

Used to create a break group on one or several columns.This pulls the columns out of the Interactive Report and displays them as a master record.

APEXIR_HELP_DETAIL_VIEW

To view the details of a single row at a time, click the single row view icon on the row you want to view.If available, the single row view will always be the first column.Depending on the customization of the Interactive Report, the single row view may be the standard view or a custom page that may allow update.

APEXIR_HELP_DOWNLOAD

Allows the current result set to be downloaded.The download formats will differ depending upon your installation and report definition but may include CSV, XLS, PDF, or RTF.

APEXIR_HELP_FILTER

Used to add or modify the where clause on the query.You first select a column (it does not need to be one that is displayed), select from a list of standard Oracle operators (=, !=, not in, between), and enter an expression to compare against.The expression is case sensitive and you can use % as a wildcard (for example, STATE_NAME like A%).

APEXIR_HELP_FLASHBACK

Performs a flashback query to allow you to view the data as it existed at a previous point in time.The default amount of time that you can flashback is 3 hours (or 180 minutes) but the actual amount will differ per database.

APEXIR_HELP_FORMAT

<p>Format enable you to customize the display of the report.Format contains the following submenu:</p> <ul><li>Sort</li> <li>Control Break</li> <li>Highlight</li> <li>Compute</li> <li>Aggregate</li> <li>Chart</li> <li>Group By</li> <li>Pivot</li> </ul>

APEXIR_HELP_GROUP_BY

You can define one Group By view per saved report.Once defined, you can switch between the group by and report views using view icons on the Search bar.To create a Group By view, you select: <p></p><ul> <li>the columns on which to group</li> <li>the columns to aggregate along with the function to be performed (average, sum, count, etc.)</li> </ul>

APEXIR_HELP_HIGHLIGHT

Highlighting allows you to define a filter.The rows that meet the filter are highlighted using the characteristics associated with the filter.

<p/>

<ul><li><b>Name</b> is used only for display.</li>

<li><b>Sequence</b> identifies the sequence in which the rules will be evaluated.</li>

<li><b>Enabled</b> identifies if the rule is enabled or disabled.</li>

<li><b>Highlight Type</b> identifies whether the Row or Cell should be highlighted.If Cell is selected, the column referenced in the Highlight Condition is highlighted.</li>

<li><b>Background Color</b> is the new color for the background of the highlighted area.</li>

<li><b>Text Color</b> is the new color for the text in the highlighted area.</li>

<li><b>Highlight Condition</b> defines your filter condition.</li></ul>

APEXIR_HELP_PIVOT

You can define one Pivot view per saved report.Once defined, you can switch between the pivot and report views using view icons on the Search bar.To create a Pivot view, you select: <p></p> <ul> <li>the columns on which to pivot</li> <li>the columns to display as rows</li> <li>the columns to aggregate along with the function to be performed (average, sum, count, etc.)</li> </ul>

APEXIR_HELP_REPORT_SETTINGS

If you have customized your Interactive Report, the report settings will be displayed below the Search Bar and above the report.If you have saved customized reports, they will be shown as tabs.You can access your alternate views by clicking the tabs.Below the tabs are the report settings for the current report.This area can be collapsed and expanded using the icon on the left.

<p/>

For each report setting, you can:

<ul><li><b>Edit</b> by clicking the name.</li>

<li><b>Disable/Enable</b> by unchecking or checking the Enable/Disable check box.This is used to temporarily turn off and on the setting.</li>

<li><b>Remove</b> by click the Remove icon.This permanently removes the setting.</li></ul>

<p/>

If you have created a chart, you can toggle between the report and chart using the Report View and Chart View links shown on the right.If you are viewing the chart, you can also use the Edit Chart link to edit the chart settings.

APEXIR_HELP_RESET

Resets the report back to the default settings, removing any customizations that you have made.

APEXIR_HELP_ROWS_PER_PAGE

Sets the number of records to display per page.

APEXIR_HELP_SAVE_REPORT

Saves the customized report for future use.You provide a name and optional description and can make the report accessible to the public (that is, all users who can access the primary default report).4つのタイプの対話モード・レポートを保存できます。

  • Primary Default (Developer Only).プライマリ・デフォルトは、最初に表示されるレポートです。プライマリ・デフォルト・レポートは、名前を変更することも、削除することもできません。

  • Alternative Report (Developer Only).開発者は、複数のレポート・レイアウトを作成できます。代替レポートの保存、名前の変更または削除ができるのは開発者のみです。

  • Public Report (End user).作成者であるエンド・ユーザーによって保存、名前変更、削除できます。他のユーザーは、別のレポートとしてレイアウトを表示および保存できます。

  • Private Report (End user).レポートを作成したエンド・ユーザーのみが表示、保存、名前の変更または削除を実行できます。

If you save customized reports, a Reports selector displays in the Search bar to the left of the Rows selector (if this feature is enabled).

APEXIR_HELP_SEARCH_BAR

At the top of each report page is a search region.The region provides the following features:

<p/>

<ul><li><b>Select columns icon</b> allows you to identify which column to search (or all).</li>

<li><b>Text area</b> allows for case insensitive search criteria (no need for wild cards).</li>

<li><b>Rows</b> selects the number of records to display per page.</li>

<li><b>[Go] button</b> executes the search.</li>

<li><b>Actions Menu icon</b> displays the actions menu (discussed next).</li></ul>

<p/>

Please note that all features may not be available for each report.

APEXIR_HELP_SEARCH_BAR_ACTIONS_MENU

<li><b>Actions Menu</b> enables you to customize a report.See the sections that follow.</li>

APEXIR_HELP_SEARCH_BAR_FINDER

<li><b>Select columns icon</b> enables you to identify which column to search (or all).</li>

APEXIR_HELP_SEARCH_BAR_REPORTS

<li><b>Reports</b> displays alternate default and saved private or public reports.</li>

APEXIR_HELP_SEARCH_BAR_ROWS

<li><b>Rows</b> sets the number of records to display per page.</li>

APEXIR_HELP_SEARCH_BAR_TEXTBOX

<li><b>Text area</b> enables you to enter case insensitive search criteria (wild card characters are implied).</li> <li><b>Go button</b> executes the search.Hitting the enter key will also execute the search when the cursor is in the search text area.</li>

APEXIR_HELP_SEARCH_BAR_VIEW

<li><b>View Icons</b> switches between the icon, report, detail, chart, group by, and pivot views of the report if they are defined.</li>

APEXIR_HELP_SELECT_COLUMNS

Used to modify the columns displayed.The columns on the right are displayed.The columns on the left are hidden.You can reorder the displayed columns using the arrows on the far right.Computed columns are prefixed with <b>**</b>.

APEXIR_HELP_SORT

Used to change the column(s) to sort on and whether to sort ascending or descending.You can also specify how to handle nulls (use the default setting, always display them last or always display them first).The resulting sorting is displayed to the right of column headings in the report.

APEXIR_HELP_SUBSCRIPTION

When you add a subscription, you provide an email address (or multiple email addresses, separated by commas), email subject, frequency, and start and end dates.The resulting emails include an HTML version of the interactive report containing the current data using the report setting that were present when the subscription was added.

APEXIR_HIDE_COLUMN

Hide Column

APEXIR_HIGHLIGHT

Highlight

APEXIR_HIGHLIGHT_CONDITION

Highlight Condition

APEXIR_HIGHLIGHT_TYPE

Highlight Type

APEXIR_HIGHLIGHT_WHEN

Highlight When

APEXIR_HIGHLIGHTS

Highlights

APEXIR_INACTIVE_SETTING

1 inactive setting

APEXIR_INACTIVE_SETTINGS

%0 inactive settings

APEXIR_INTERACTIVE_REPORT_HELP

Interactive Report Help

APEXIR_INVALID

Invalid

APEXIR_INVALID_COMPUTATION

Invalid computation expression. %0

APEXIR_INVALID_END_DATE

The end date must be greater than the start date.

APEXIR_INVALID_END_DATE

The end date must be greater than the start date.

APEXIR_INVALID_FILTER

Invalid filter expression. %0

APEXIR_INVALID_FILTER_QUERY

Invalid filter query

APEXIR_INVALID_SETTING

1 invalid setting

APEXIR_INVALID_SETTINGS

%0 invalid settings

APEXIR_IS_IN_THE_LAST

%0 is in the last %1

APEXIR_IS_IN_THE_NEXT

%0 is in the next %1

APEXIR_IS_NOT_IN_THE_LAST

%0 is not in the last %1

APEXIR_IS_NOT_IN_THE_NEXT

%0 is not in the next %1

APEXIR_KEYPAD

Keypad

APEXIR_LABEL

Label

APEXIR_LABEL_AXIS_TITLE

Axis Title for Label

APEXIR_LABEL_PREFIX

Label Prefix

APEXIR_LAST_DAY

Last Day

APEXIR_LAST_HOUR

Last Hour

APEXIR_LAST_MONTH

Last Month

APEXIR_LAST_WEEK

Last Week

APEXIR_LAST_X_DAYS

Last %0 Days

APEXIR_LAST_X_HOURS

Last %0 Hours

APEXIR_LAST_X_YEARS

Last %0 Years

APEXIR_LAST_YEAR

Last Year

APEXIR_LINE

Line

APEXIR_MAX_QUERY_COST

The query is estimated to exceed the maximum allowed resources.Please modify your report settings and try again.

APEXIR_MAX_ROW_CNT

This query returns more then %0 rows, please filter your data to ensure complete results.

APEXIR_MAX_X

Maximum %0

APEXIR_MEDIAN_X

Median %0

APEXIR_MIN_AGO

%0 minutes ago

APEXIR_MIN_X

Minimum %0

APEXIR_MONTH

Month

APEXIR_MONTHLY

Monthly

APEXIR_MORE_DATA

More Data

APEXIR_MOVE

Move

APEXIR_MOVE_ALL

Move All

APEXIR_NAME

Name

APEXIR_NEW_AGGREGATION

New Aggregation

APEXIR_NEW_CATEGORY

- New Category -

APEXIR_NEW_COMPUTATION

New Computation

APEXIR_NEXT

&gt;

APEXIR_NEXT_DAY

Next Day

APEXIR_NEXT_HOUR

Next Hour

APEXIR_NEXT_MONTH

Next Month

APEXIR_NEXT_WEEK

Next Week

APEXIR_NEXT_X_DAYS

Next %0 Days

APEXIR_NEXT_X_HOURS

Next %0 Hours

APEXIR_NEXT_X_YEARS

Next %0 Years

APEXIR_NEXT_YEAR

Next Year

APEXIR_NO

No

APEXIR_NO_AGGREGATION_DEFINED

No aggregation defined.

APEXIR_NO_COLUMN_INFO

No column information available.

APEXIR_NO_COMPUTATION_DEFINED

No computation defined.

APEXIR_NO_END_DATE

- No End Date -

APEXIR_NONE

- None -

APEXIR_NOT_VALID_EMAIL

Not a valid email address.

APEXIR_NULL_SORTING

Null Sorting

APEXIR_NULLS_ALWAYS_FIRST

Nulls Always First

APEXIR_NULLS_ALWAYS_LAST

Nulls Always Last

APEXIR_NUMERIC_FLASHBACK_TIME

Flashback time must be numeric.

APEXIR_NUMERIC_SEQUENCE

Sequence must be numeric.

APEXIR_OPERATOR

Operator

APEXIR_ORANGE

orange

APEXIR_OTHER

Other

APEXIR_PERCENT_OF_TOTAL_COUNT_X

Percent of Total Count %0 (%)

APEXIR_PERCENT_OF_TOTAL_SUM_X

Percent of Total Sum %0 (%)

APEXIR_PERCENT_TOTAL_COUNT

Percent of Total Count

APEXIR_PERCENT_TOTAL_SUM

Percent of Total Sum

APEXIR_PIE

Pie

APEXIR_PIVOT

Add Pivot Column

APEXIR_PIVOT_AGG_NOT_NULL

Aggregate must be specified.

APEXIR_PIVOT_AGG_NOT_ON_ROW_COL

You cannot aggregate on a column selected to as row column.

APEXIR_PIVOT_COLUMN_N

Pivot Column %0

APEXIR_PIVOT_COLUMN_NOT_NULL

Pivot column must be specified.

APEXIR_PIVOT_COLUMNS

Pivot Columns

APEXIR_PIVOT_MAX_ROW_CNT

The maximum row count for a Pivot query limits the number of rows in the base query, not the number of rows displayed.Your base query exceeds the maximum row count of %0.Please apply a filter to reduce the number of records in your base query.

APEXIR_PIVOT_SORT

Pivot Sort

APEXIR_PREVIOUS

&lt;

APEXIR_PRIMARY

Primary

APEXIR_PRIMARY_REPORT

Primary Report

APEXIR_PRIVATE

Private

APEXIR_PUBLIC

Public

APEXIR_RED

red

APEXIR_REMOVE

Remove

APEXIR_REMOVE_AGGREGATE

Remove Aggregate

APEXIR_REMOVE_ALL

Remove All

APEXIR_REMOVE_CHART

Remove Chart

APEXIR_REMOVE_CONTROL_BREAK

Remove Control Break

APEXIR_REMOVE_FILTER

Remove Filter

APEXIR_REMOVE_FLASHBACK

Remove Flashback

APEXIR_REMOVE_GROUP_BY

Remove Group By

APEXIR_REMOVE_HIGHLIGHT

Remove Highlight

APEXIR_REMOVE_PIVOT

Remove Pivot

APEXIR_RENAME_DEFAULT_REPORT

Rename Default Report

APEXIR_RENAME_REPORT

Rename Report

APEXIR_REPORT

Report

APEXIR_REPORT_ALIAS_DOES_NOT_EXIST

Saved Interactive report with alias %0 does not exist.

APEXIR_REPORT_DISPLAY_COLUMN_LIMIT_REACHED

The number of display columns in the report reached the limit.Please click Select Columns under Actions menu to minimize the report display column list.

APEXIR_REPORT_DOES_NOT_EXIST

Report does not exist.

APEXIR_REPORT_ID_DOES_NOT_EXIST

Saved Interactive Report ID %0 does not exist.

APEXIR_REPORT_SETTINGS

Report Settings

APEXIR_REPORT_VIEW

&lt; Report View

APEXIR_REPORTS

Reports

APEXIR_RESET

Reset

APEXIR_RESET_CONFIRM

Restore report to the default settings.

APEXIR_ROW

Row

APEXIR_ROW_COL_DIFF_FROM_PIVOT_COL

Row column must be different from the pivot column.

APEXIR_ROW_COLUMN_N

Row Column %0

APEXIR_ROW_COLUMN_NOT_NULL

Row column must be specified.

APEXIR_ROW_COLUMNS

Row Columns

APEXIR_ROW_FILTER

Row Filter

APEXIR_ROW_OF

Row %0 of %1

APEXIR_ROW_ORDER

Row Order

APEXIR_ROW_TEXT_CONTAINS

Row text contains

APEXIR_ROWS

Rows

APEXIR_ROWS_PER_PAGE

Rows Per Page

APEXIR_RPT_DISP_COL_EXCEED

The number of display columns in the report reached the limit.Please click Select Columns under Actions menu to minimize the report display column list.

APEXIR_SAVE

Save

APEXIR_SAVE_AS_DEFAULT

Save as Default

APEXIR_SAVE_DEFAULT_CONFIRM

The current report settings are used as the default for all users.

APEXIR_SAVE_DEFAULT_REPORT

Save Default Report

APEXIR_SAVE_REPORT

Save Report

APEXIR_SAVE_REPORT_DEFAULT

Save Report *

APEXIR_SAVED_REPORT

Saved Report

APEXIR_SAVED_REPORT_MSG

Saved Report = "%0"

APEXIR_SEARCH

Search

APEXIR_SEARCH_BAR

Search Bar

APEXIR_SEARCH_COLUMN

Search: %0

APEXIR_SEARCH_REPORT

Search Report

APEXIR_SELECT_CATEGORY

- Select Category -

APEXIR_SELECT_COLUMN

- Select Column -

APEXIR_SELECT_COLUMNS

Select Columns

APEXIR_SELECT_COLUMNS_FOOTER

Computed columns are prefixed with **.

APEXIR_SELECT_FUNCTION

- Select Function -

APEXIR_SELECT_GROUP_BY_COLUMN

- Select Group By Column -

APEXIR_SELECT_PIVOT_COLUMN

- Select Pivot Column -

APEXIR_SELECT_ROW

Select Row

APEXIR_SELECT_ROW_COLUM

- Select Row Column -

APEXIR_SELECT_SORT_COLUMN

- Select Sort Column -

APEXIR_SELECT_VALUE

Select Value

APEXIR_SELECTED_COLUMNS

Selected Columns

APEXIR_SEND

Send

APEXIR_SEQUENCE

Sequence

APEXIR_SORT

Sort

APEXIR_SORT_ASCENDING

Sort Ascending

APEXIR_SORT_COLUMN

Sort Column

APEXIR_SORT_DESCENDING

Sort Descending

APEXIR_SORT_ORDER

Sort Order

APEXIR_SPACE_AS_IN_ONE_EMPTY_STRING

space

APEXIR_STATUS

Status

APEXIR_SUBSCRIPTION

Subscription

APEXIR_SUBSCRIPTION_ENDING

Ending

APEXIR_SUBSCRIPTION_STARTING_FROM

Starting From

APEXIR_SUBSCRIPTION_STARTING_FROM

Starting From

APEXIR_SUM_X

Sum %0

APEXIR_TABLE_SUMMARY

Region = %0, Report = %1, View = %2, Displayed Rows Start = %3, Displayed Rows End = %4, Total Rows = %5

APEXIR_TEXT_COLOR

Text Color

APEXIR_TIME_DAYS

days

APEXIR_TIME_HOURS

hours

APEXIR_TIME_MINS

minutes

APEXIR_TIME_MONTHS

months

APEXIR_TIME_WEEKS

weeks

APEXIR_TIME_YEARS

years

APEXIR_TOGGLE

Toggle

APEXIR_TOP

Top

APEXIR_UNAUTHORIZED

Unauthorized

APEXIR_UNGROUPED_COLUMN

Ungrouped Column

APEXIR_UNIQUE_COLUMN_HEADING

Column Heading must be unique.

APEXIR_UNIQUE_HIGHLIGHT_NAME

Highlight Name must be unique.

APEXIR_UNSUPPORTED_DATA_TYPE

unsupported data type

APEXIR_UP

Up

APEXIR_VALID_COLOR

Please enter a valid color.

APEXIR_VALID_FORMAT_MASK

Please enter a valid format mask.

APEXIR_VALUE

Value

APEXIR_VALUE_AXIS_TITLE

Axis Title for Value

APEXIR_VALUE_REQUIRED

Value Required

APEXIR_VCOLUMN

Vertical Column

APEXIR_VIEW_CHART

View Chart

APEXIR_VIEW_DETAIL

View Detail

APEXIR_VIEW_GROUP_BY

View Group By

APEXIR_VIEW_ICONS

View Icons

APEXIR_VIEW_PIVOT

View Pivot

APEXIR_VIEW_REPORT

View Report

APEXIR_WEEK

Week

APEXIR_WEEKLY

Weekly

APEXIR_WORKING_REPORT

Working Report

APEXIR_X_DAYS

%0 days

APEXIR_X_HOURS

%0 hours

APEXIR_X_MINS

%0 minutes

APEXIR_X_MONTHS

%0 months

APEXIR_X_WEEKS

%0 weeks

APEXIR_X_YEARS

%0 years

APEXIR_YEAR

Year

APEXIR_YELLOW

yellow

APEXIR_YES

Yes

IR_AS_DEFAULT_REPORT_SETTING

As Default Report Settings

IR_AS_NAMED_REPORT

As Named Report

IR_STAR

Only displayed for developers

LAYOUT.T_CONDITION_EXPR2

Expression 2

OUT_OF_RANGE

Invalid set of rows requested, the source data of the report has been modified.

REPORT

Report

REPORTING_PERIOD

Reporting Period

RESET

Reset Pagination

SAVED_REPORTS.PRIMARY.DEFAULT

Primary Default

WWV_RENDER_REPORT3.X_Y_OF_Z_2

%0 - %1 of %2