Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\global_mess_reports.htm
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=us-ascii" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <meta http-equiv="Content-Script-Type" content="text/javascript" /> <title>Translating Messages Used Internally by Oracle Application Express</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-14T16:11:32Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Translating Messages Used Internally by Oracle Application Express" /> <meta name="relnum" content="Release 3.2" /> <meta name="partnum" content="E11947-01" /> <link rel="copyright" href="dcommon/html/cpyr.htm" title="Copyright" type="text/html" /> <link rel="stylesheet" href="dcommon/css/blafdoc.css" title="Oracle BLAFDoc" type="text/css" /> <link rel="contents" href="toc.htm" title="Contents" type="text/html" /> <link rel="up" href="preface.htm" title="Home" type="text/html" /> <link rel="up" href="global.htm" title="Managing Application Global..." type="text/html" /> <link rel="up" href="global_messages.htm" title="Translating Messages" type="text/html" /> <link rel="up" href="global_mess_reports.htm" title="Translating Messages Used I..." type="text/html" /> <link rel="prev" href="global_mess_plsql.htm" title="Previous" type="text/html" /> <link rel="next" href="global_lovs.htm" title="Next" type="text/html" /> </head> <body> <p id="BREADCRUMBING"><a href="preface.htm" title="Home">Home</a> > <a href="global.htm" title="Managing Application Global...">Managing Application Global...</a> > <a href="global_messages.htm" title="Translating Messages">Translating Messages</a> > Translating Messages Used I...</p> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr valign="bottom"> <td align="left"></td> <td align="center"><a href="global_mess_plsql.htm"><img src="dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="global_lovs.htm"><img src="dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CHDJFHBD" name="CHDJFHBD"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1><a name="HTMDB25939" id="HTMDB25939"></a>Translating Messages <a id="sthref2378" name="sthref2378"></a><a id="sthref2379" name="sthref2379"></a><a id="sthref2380" name="sthref2380"></a><a id="sthref2381" name="sthref2381"></a><a id="sthref2382" name="sthref2382"></a>Used Internally by Oracle Application Express</h1> <p>Oracle Application Express is translated into German, Spanish, French, Italian, Japanese, Korean, Brazilian Portuguese, Simplified Chinese, and Traditional Chinese. If your application uses a language that is not among the ten languages into which Oracle Application Express is translated, you must translate messages displayed by the Application Express reporting engine.</p> <p>For example, if you develop a Russian application and want to include report messages, such as pagination, in Russian, you must translate the strings used in messages displayed in reports.</p> <p>To translate messages:</p> <ol> <li> <p>Navigate to the Translate Application page:</p> <ol> <li> <p>On the Workspace home page, click the <span class="bold">Application Builder</span> icon.</p> </li> <li> <p>Select an application.</p> </li> <li> <p>Click <span class="bold">Shared Components</span>.</p> </li> <li> <p>Under Globalization, click <span class="bold">Text Messages</span>.</p> </li> </ol> </li> <li> <p>On the Translate Messages page, click <span class="bold">Create</span>.</p> </li> <li> <p>On Identify Text Message, specify the following:</p> <ol> <li> <p>Name - Enter the name of each message that needs to be translated. See <a href="#CHDEDHBJ">Table: Internal Messages Requiring Translation</a>.</p> </li> <li> <p>Language - Select the language for which the message would be used.</p> </li> <li> <p>Text - Enter the text to be returned when the text message is called. If the English text message contains positional substitution values (for example, <code>%0</code>, <code>%1</code>), ensure that your defined message also contains the same named and number of positional substitution values.</p> </li> </ol> </li> <li> <p>Click <span class="bold">Create</span>.</p> </li> </ol> <p><a href="#CHDEDHBJ">Table: Internal Messages Requiring Translation</a> lists the internal messages that require translation.</p> <div class="tblformalwide"><a id="sthref2383" name="sthref2383"></a><a id="CHDEDHBJ" name="CHDEDHBJ"></a> <p class="titleintable">Internal Messages Requiring Translation</p> <table class="FormalWide" title="Internal Messages Requiring Translation" summary="This table lists internal messages requiring translation." dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <col width="40%" /> <col width="*" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t21">Message Name</th> <th align="left" valign="bottom" id="r1c2-t21">English Text</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t21" headers="r1c1-t21"> <p><code>FLOW.SINGLE_VALIDATION_ERROR</code></p> </td> <td align="left" headers="r2c1-t21 r1c2-t21"> <p>1 error has occurred</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t21" headers="r1c1-t21"> <p><code>FLOW.VALIDATION_ERROR</code></p> </td> <td align="left" headers="r3c1-t21 r1c2-t21"> <p>%0 errors have occurred</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t21" headers="r1c1-t21"> <p><code>INVALID_CREDENTIALS</code></p> </td> <td align="left" headers="r4c1-t21 r1c2-t21"> <p>Invalid Login Credentials</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r5c1-t21" headers="r1c1-t21"> <p><code>OUT_OF_RANGE</code></p> </td> <td align="left" headers="r5c1-t21 r1c2-t21"> <p>Invalid set of rows requested, the source data of the report has been modified</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r6c1-t21" headers="r1c1-t21"> <p><code>PAGINATION.NEXT</code></p> </td> <td align="left" headers="r6c1-t21 r1c2-t21"> <p>Next</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r7c1-t21" headers="r1c1-t21"> <p><code>PAGINATION.NEXT_SET</code></p> </td> <td align="left" headers="r7c1-t21 r1c2-t21"> <p>Next Set</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r8c1-t21" headers="r1c1-t21"> <p><code>PAGINATION.PREVIOUS</code></p> </td> <td align="left" headers="r8c1-t21 r1c2-t21"> <p>Previous</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r9c1-t21" headers="r1c1-t21"> <p><code>PAGINATION.PREVIOUS_SET</code></p> </td> <td align="left" headers="r9c1-t21 r1c2-t21"> <p>Previous Set</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r10c1-t21" headers="r1c1-t21"> <p><code>REPORT_TOTAL</code></p> </td> <td align="left" headers="r10c1-t21 r1c2-t21"> <p>report total</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r11c1-t21" headers="r1c1-t21"> <p><code>RESET</code></p> </td> <td align="left" headers="r11c1-t21 r1c2-t21"> <p>reset pagination</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r12c1-t21" headers="r1c1-t21"> <p><code>SINCE_DAYS_AGO</code></p> </td> <td align="left" headers="r12c1-t21 r1c2-t21"> <p>%0 days ago</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r13c1-t21" headers="r1c1-t21"> <p><code>SINCE_HOURS_AGO</code></p> </td> <td align="left" headers="r13c1-t21 r1c2-t21"> <p>%0 hours ago</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r14c1-t21" headers="r1c1-t21"> <p><code>SINCE_MINUTES_AGO</code></p> </td> <td align="left" headers="r14c1-t21 r1c2-t21"> <p>%0 minutes ago</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r15c1-t21" headers="r1c1-t21"> <p><code>SINCE_MONTHS_AGO</code></p> </td> <td align="left" headers="r15c1-t21 r1c2-t21"> <p>%0 months ago</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r16c1-t21" headers="r1c1-t21"> <p><code>SINCE_SECONDS_AGO</code></p> </td> <td align="left" headers="r16c1-t21 r1c2-t21"> <p>%0 seconds ago</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r17c1-t21" headers="r1c1-t21"> <p><code>SINCE_WEEKS_AGO</code></p> </td> <td align="left" headers="r17c1-t21 r1c2-t21"> <p>%0 weeks ago</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r18c1-t21" headers="r1c1-t21"> <p><code>SINCE_YEARS_AGO</code></p> </td> <td align="left" headers="r18c1-t21 r1c2-t21"> <p>%0 years ago</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r19c1-t21" headers="r1c1-t21"> <p><code>TOTAL</code></p> </td> <td align="left" headers="r19c1-t21 r1c2-t21"> <p>Total</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r20c1-t21" headers="r1c1-t21"> <p><code>WWV_FLOW_UTILITIES.CAL</code></p> </td> <td align="left" headers="r20c1-t21 r1c2-t21"> <p>Calendar</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r21c1-t21" headers="r1c1-t21"> <p><code>WWV_FLOW_UTILITIES.CLOSE</code></p> </td> <td align="left" headers="r21c1-t21 r1c2-t21"> <p>Close</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r22c1-t21" headers="r1c1-t21"> <p><code>WWV_FLOW_UTILITIES.OK</code></p> </td> <td align="left" headers="r22c1-t21 r1c2-t21"> <p>Ok</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r23c1-t21" headers="r1c1-t21"> <p><code>WWV_RENDER_REPORT3.FOUND_BUT_NOT_DISPLAYED</code></p> </td> <td align="left" headers="r23c1-t21 r1c2-t21"> <p>Minimum row requested: %0, rows found but not displayed: %1</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r24c1-t21" headers="r1c1-t21"> <p><code>WWV_RENDER_REPORT3.SORT_BY_THIS_COLUMN</code></p> </td> <td align="left" headers="r24c1-t21 r1c2-t21"> <p>Sort by this column</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r25c1-t21" headers="r1c1-t21"> <p><code>WWV_RENDER_REPORT3.X_Y_OF_MORE_THAN_Z</code></p> </td> <td align="left" headers="r25c1-t21 r1c2-t21"> <p>row(s) %0 - %1 of more than %2</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r26c1-t21" headers="r1c1-t21"> <p><code>WWV_RENDER_REPORT3.X_Y_OF_Z</code></p> </td> <td align="left" headers="r26c1-t21 r1c2-t21"> <p>row(s)%0 - %1 of %2</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r27c1-t21" headers="r1c1-t21"> <p><code>WWV_RENDER_REPORT3.X_Y_OF_Z_2</code></p> </td> <td align="left" headers="r27c1-t21 r1c2-t21"> <p>%0 - %1 of %2</p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformalwide" --> <p><a href="#BABEADAJ">Table: Interactive Report Messages Requiring Translation</a> lists the internal messages that require translation.</p> <div class="tblformalwide"><a id="sthref2384" name="sthref2384"></a><a id="BABEADAJ" name="BABEADAJ"></a> <p class="titleintable">Interactive Report Messages Requiring Translation</p> <table class="FormalWide" title="Interactive Report Messages Requiring Translation" summary="This table lists Interactive Report messages requiring translation." dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <col width="39%" /> <col width="*" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t22">Message Name</th> <th align="left" valign="bottom" id="r1c2-t22">English Text</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t22" headers="r1c1-t22"> <p><code>APEXIR_3D</code></p> </td> <td align="left" headers="r2c1-t22 r1c2-t22"> <p>3D</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t22" headers="r1c1-t22"> <p><code>APEXIR_ACTIONS_MENU</code></p> </td> <td align="left" headers="r3c1-t22 r1c2-t22"> <p>Actions Menu</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t22" headers="r1c1-t22"> <p><code>APEXIR_ADD</code></p> </td> <td align="left" headers="r4c1-t22 r1c2-t22"> <p>Add</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r5c1-t22" headers="r1c1-t22"> <p><code>APEXIR_AGGREGATE</code></p> </td> <td align="left" headers="r5c1-t22 r1c2-t22"> <p>Aggregate</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r6c1-t22" headers="r1c1-t22"> <p><code>APEXIR_AGGREGATE_DESCRIPTION</code></p> </td> <td align="left" headers="r6c1-t22 r1c2-t22"> <p>Aggregates are displayed after each control break and at the end of the report.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r7c1-t22" headers="r1c1-t22"> <p><code>APEXIR_AGGREGATION</code></p> </td> <td align="left" headers="r7c1-t22 r1c2-t22"> <p>Aggregation</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r8c1-t22" headers="r1c1-t22"> <p><code>APEXIR_AGG_AVG</code></p> </td> <td align="left" headers="r8c1-t22 r1c2-t22"> <p>Average</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r9c1-t22" headers="r1c1-t22"> <p><code>APEXIR_AGG_COUNT</code></p> </td> <td align="left" headers="r9c1-t22 r1c2-t22"> <p>Count</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r10c1-t22" headers="r1c1-t22"> <p><code>APEXIR_AGG_MAX</code></p> </td> <td align="left" headers="r10c1-t22 r1c2-t22"> <p>Maximum</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r11c1-t22" headers="r1c1-t22"> <p><code>APEXIR_AGG_MEDIAN</code></p> </td> <td align="left" headers="r11c1-t22 r1c2-t22"> <p>Median</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r12c1-t22" headers="r1c1-t22"> <p><code>APEXIR_AGG_MIN</code></p> </td> <td align="left" headers="r12c1-t22 r1c2-t22"> <p>Minimum</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r13c1-t22" headers="r1c1-t22"> <p><code>APEXIR_AGG_MODE</code></p> </td> <td align="left" headers="r13c1-t22 r1c2-t22"> <p>Mode</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r14c1-t22" headers="r1c1-t22"> <p><code>APEXIR_AGG_SUM</code></p> </td> <td align="left" headers="r14c1-t22 r1c2-t22"> <p>Sum</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r15c1-t22" headers="r1c1-t22"> <p><code>APEXIR_ALL</code></p> </td> <td align="left" headers="r15c1-t22 r1c2-t22"> <p>All</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r16c1-t22" headers="r1c1-t22"> <p><code>APEXIR_ALL_COLUMNS</code></p> </td> <td align="left" headers="r16c1-t22 r1c2-t22"> <p>All Columns</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r17c1-t22" headers="r1c1-t22"> <p><code>APEXIR_AND</code></p> </td> <td align="left" headers="r17c1-t22 r1c2-t22"> <p>and</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r18c1-t22" headers="r1c1-t22"> <p><code>APEXIR_APPLY</code></p> </td> <td align="left" headers="r18c1-t22 r1c2-t22"> <p>Apply</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r19c1-t22" headers="r1c1-t22"> <p><code>APEXIR_ASCENDING</code></p> </td> <td align="left" headers="r19c1-t22 r1c2-t22"> <p>Ascending</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r20c1-t22" headers="r1c1-t22"> <p><code>APEXIR_AS_OF</code></p> </td> <td align="left" headers="r20c1-t22 r1c2-t22"> <p>As of %0</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r21c1-t22" headers="r1c1-t22"> <p><code>APEXIR_BETWEEN</code></p> </td> <td align="left" headers="r21c1-t22 r1c2-t22"> <p>between</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r22c1-t22" headers="r1c1-t22"> <p><code>APEXIR_BGCOLOR</code></p> </td> <td align="left" headers="r22c1-t22 r1c2-t22"> <p>Background Color</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r23c1-t22" headers="r1c1-t22"> <p><code>APEXIR_BLUE</code></p> </td> <td align="left" headers="r23c1-t22 r1c2-t22"> <p>blue</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r24c1-t22" headers="r1c1-t22"> <p><code>APEXIR_BOTTOM</code></p> </td> <td align="left" headers="r24c1-t22 r1c2-t22"> <p>Bottom</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r25c1-t22" headers="r1c1-t22"> <p><code>APEXIR_CALENDAR</code></p> </td> <td align="left" headers="r25c1-t22 r1c2-t22"> <p>Calendar</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r26c1-t22" headers="r1c1-t22"> <p><code>APEXIR_CANCEL</code></p> </td> <td align="left" headers="r26c1-t22 r1c2-t22"> <p>Cancel</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r27c1-t22" headers="r1c1-t22"> <p><code>APEXIR_CATEGORY</code></p> </td> <td align="left" headers="r27c1-t22 r1c2-t22"> <p>Category</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r28c1-t22" headers="r1c1-t22"> <p><code>APEXIR_CELL</code></p> </td> <td align="left" headers="r28c1-t22 r1c2-t22"> <p>Cell</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r29c1-t22" headers="r1c1-t22"> <p><code>APEXIR_CHART</code></p> </td> <td align="left" headers="r29c1-t22 r1c2-t22"> <p>Chart</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r30c1-t22" headers="r1c1-t22"> <p><code>APEXIR_CHART_INITIALIZING</code></p> </td> <td align="left" headers="r30c1-t22 r1c2-t22"> <p>Initializing...</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r31c1-t22" headers="r1c1-t22"> <p><code>APEXIR_CHART_TYPE</code></p> </td> <td align="left" headers="r31c1-t22 r1c2-t22"> <p>Chart Type</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r32c1-t22" headers="r1c1-t22"> <p><code>APEXIR_CHOOSE_DOWNLOAD_FORMAT</code></p> </td> <td align="left" headers="r32c1-t22 r1c2-t22"> <p>Choose report download format</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r33c1-t22" headers="r1c1-t22"> <p><code>APEXIR_CLEAR</code></p> </td> <td align="left" headers="r33c1-t22 r1c2-t22"> <p>clear</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r34c1-t22" headers="r1c1-t22"> <p><code>APEXIR_COLUMN</code></p> </td> <td align="left" headers="r34c1-t22 r1c2-t22"> <p>Column</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r35c1-t22" headers="r1c1-t22"> <p><code>APEXIR_COLUMNS</code></p> </td> <td align="left" headers="r35c1-t22 r1c2-t22"> <p>Columns</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r36c1-t22" headers="r1c1-t22"> <p><code>APEXIR_COLUMN_HEADING</code></p> </td> <td align="left" headers="r36c1-t22 r1c2-t22"> <p>Column Heading</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r37c1-t22" headers="r1c1-t22"> <p><code>APEXIR_COLUMN_HEADING_MENU</code></p> </td> <td align="left" headers="r37c1-t22 r1c2-t22"> <p>Column Heading Menu</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r38c1-t22" headers="r1c1-t22"> <p><code>APEXIR_COLUMN_INFO</code></p> </td> <td align="left" headers="r38c1-t22 r1c2-t22"> <p>Column Information</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r39c1-t22" headers="r1c1-t22"> <p><code>APEXIR_COMPARISON_CONTAINS</code></p> </td> <td align="left" headers="r39c1-t22 r1c2-t22"> <p>contains</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r40c1-t22" headers="r1c1-t22"> <p><code>APEXIR_COMPARISON_DOESNOT_CONTAIN</code></p> </td> <td align="left" headers="r40c1-t22 r1c2-t22"> <p>does not contain</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r41c1-t22" headers="r1c1-t22"> <p><code>APEXIR_COMPARISON_IN</code></p> </td> <td align="left" headers="r41c1-t22 r1c2-t22"> <p>in</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r42c1-t22" headers="r1c1-t22"> <p><code>APEXIR_COMPARISON_ISNOT_IN_LAST</code></p> </td> <td align="left" headers="r42c1-t22 r1c2-t22"> <p>is not in the last</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r43c1-t22" headers="r1c1-t22"> <p><code>APEXIR_COMPARISON_ISNOT_IN_NEXT</code></p> </td> <td align="left" headers="r43c1-t22 r1c2-t22"> <p>is not in the next</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r44c1-t22" headers="r1c1-t22"> <p><code>APEXIR_COMPARISON_IS_IN_LAST</code></p> </td> <td align="left" headers="r44c1-t22 r1c2-t22"> <p>is in the last</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r45c1-t22" headers="r1c1-t22"> <p><code>APEXIR_COMPARISON_IS_IN_NEXT</code></p> </td> <td align="left" headers="r45c1-t22 r1c2-t22"> <p>is in the next</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r46c1-t22" headers="r1c1-t22"> <p><code>APEXIR_COMPARISON_IS_NOT_NULL</code></p> </td> <td align="left" headers="r46c1-t22 r1c2-t22"> <p>is not null</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r47c1-t22" headers="r1c1-t22"> <p><code>APEXIR_COMPARISON_IS_NULL</code></p> </td> <td align="left" headers="r47c1-t22 r1c2-t22"> <p>is null</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r48c1-t22" headers="r1c1-t22"> <p><code>APEXIR_COMPARISON_LIKE</code></p> </td> <td align="left" headers="r48c1-t22 r1c2-t22"> <p>like</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r49c1-t22" headers="r1c1-t22"> <p><code>APEXIR_COMPARISON_NOT_IN</code></p> </td> <td align="left" headers="r49c1-t22 r1c2-t22"> <p>not in</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r50c1-t22" headers="r1c1-t22"> <p><code>APEXIR_COMPARISON_NOT_LIKE</code></p> </td> <td align="left" headers="r50c1-t22 r1c2-t22"> <p>not like</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r51c1-t22" headers="r1c1-t22"> <p><code>APEXIR_COMPARISON_REGEXP_LIKE</code></p> </td> <td align="left" headers="r51c1-t22 r1c2-t22"> <p>matches regular expression</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r52c1-t22" headers="r1c1-t22"> <p><code>APEXIR_COMPUTATION</code></p> </td> <td align="left" headers="r52c1-t22 r1c2-t22"> <p>Computation</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r53c1-t22" headers="r1c1-t22"> <p><code>APEXIR_COMPUTATION_FOOTER</code></p> </td> <td align="left" headers="r53c1-t22 r1c2-t22"> <p>Create a computation using column aliases.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r54c1-t22" headers="r1c1-t22"> <p><code>APEXIR_COMPUTATION_FOOTER_E1</code></p> </td> <td align="left" headers="r54c1-t22 r1c2-t22"> <p>(B+C)*100</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r55c1-t22" headers="r1c1-t22"> <p><code>APEXIR_COMPUTATION_FOOTER_E2</code></p> </td> <td align="left" headers="r55c1-t22 r1c2-t22"> <p>INITCAP(B)||', '||INITCAP(C)</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r56c1-t22" headers="r1c1-t22"> <p><code>APEXIR_COMPUTATION_FOOTER_E3</code></p> </td> <td align="left" headers="r56c1-t22 r1c2-t22"> <p>CASE WHEN A = 10 THEN B + C ELSE B END</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r57c1-t22" headers="r1c1-t22"> <p><code>APEXIR_COMPUTE</code></p> </td> <td align="left" headers="r57c1-t22 r1c2-t22"> <p>Compute</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r58c1-t22" headers="r1c1-t22"> <p><code>APEXIR_CONTROL_BREAK</code></p> </td> <td align="left" headers="r58c1-t22 r1c2-t22"> <p>Control Break</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r59c1-t22" headers="r1c1-t22"> <p><code>APEXIR_CONTROL_BREAKS</code></p> </td> <td align="left" headers="r59c1-t22 r1c2-t22"> <p>Control Breaks</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r60c1-t22" headers="r1c1-t22"> <p><code>APEXIR_DATA_AS_OF</code></p> </td> <td align="left" headers="r60c1-t22 r1c2-t22"> <p>Report data as of %0 minutes ago.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r61c1-t22" headers="r1c1-t22"> <p><code>APEXIR_DATE</code></p> </td> <td align="left" headers="r61c1-t22 r1c2-t22"> <p>Date</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r62c1-t22" headers="r1c1-t22"> <p><code>APEXIR_DEFAULT</code></p> </td> <td align="left" headers="r62c1-t22 r1c2-t22"> <p>Default</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r63c1-t22" headers="r1c1-t22"> <p><code>APEXIR_DELETE</code></p> </td> <td align="left" headers="r63c1-t22 r1c2-t22"> <p>Delete</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r64c1-t22" headers="r1c1-t22"> <p><code>APEXIR_DELETE_CHECKED</code></p> </td> <td align="left" headers="r64c1-t22 r1c2-t22"> <p>Delete Checked</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r65c1-t22" headers="r1c1-t22"> <p><code>APEXIR_DELETE_CONFIRM</code></p> </td> <td align="left" headers="r65c1-t22 r1c2-t22"> <p>Would you like to delete these report settings?</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r66c1-t22" headers="r1c1-t22"> <p><code>APEXIR_DELETE_CONFIRM_JS_DIALOG</code></p> </td> <td align="left" headers="r66c1-t22 r1c2-t22"> <p>Would you like to perform this delete action?</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r67c1-t22" headers="r1c1-t22"> <p><code>APEXIR_DELETE_REPORT</code></p> </td> <td align="left" headers="r67c1-t22 r1c2-t22"> <p>Delete Report</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r68c1-t22" headers="r1c1-t22"> <p><code>APEXIR_DESCENDING</code></p> </td> <td align="left" headers="r68c1-t22 r1c2-t22"> <p>Descending</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r69c1-t22" headers="r1c1-t22"> <p><code>APEXIR_DESCRIPTION</code></p> </td> <td align="left" headers="r69c1-t22 r1c2-t22"> <p>Description</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r70c1-t22" headers="r1c1-t22"> <p><code>APEXIR_DETAIL_VIEW</code></p> </td> <td align="left" headers="r70c1-t22 r1c2-t22"> <p>Single Row View</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r71c1-t22" headers="r1c1-t22"> <p><code>APEXIR_DIRECTION</code></p> </td> <td align="left" headers="r71c1-t22 r1c2-t22"> <p>Direction</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r72c1-t22" headers="r1c1-t22"> <p><code>APEXIR_DISABLE</code></p> </td> <td align="left" headers="r72c1-t22 r1c2-t22"> <p>Disable</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r73c1-t22" headers="r1c1-t22"> <p><code>APEXIR_DISABLED</code></p> </td> <td align="left" headers="r73c1-t22 r1c2-t22"> <p>Disabled</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r74c1-t22" headers="r1c1-t22"> <p><code>APEXIR_DISPLAY</code></p> </td> <td align="left" headers="r74c1-t22 r1c2-t22"> <p>Display</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r75c1-t22" headers="r1c1-t22"> <p><code>APEXIR_DISPLAYED</code></p> </td> <td align="left" headers="r75c1-t22 r1c2-t22"> <p>Displayed</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r76c1-t22" headers="r1c1-t22"> <p><code>APEXIR_DISPLAYED_COLUMNS</code></p> </td> <td align="left" headers="r76c1-t22 r1c2-t22"> <p>Displayed Columns</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r77c1-t22" headers="r1c1-t22"> <p><code>APEXIR_DISPLAY_IN_REPORT</code></p> </td> <td align="left" headers="r77c1-t22 r1c2-t22"> <p>Display in Report</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r78c1-t22" headers="r1c1-t22"> <p><code>APEXIR_DOWN</code></p> </td> <td align="left" headers="r78c1-t22 r1c2-t22"> <p>Down</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r79c1-t22" headers="r1c1-t22"> <p><code>APEXIR_DOWNLOAD</code></p> </td> <td align="left" headers="r79c1-t22 r1c2-t22"> <p>Download</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r80c1-t22" headers="r1c1-t22"> <p><code>APEXIR_DO_NOT_AGGREGATE</code></p> </td> <td align="left" headers="r80c1-t22 r1c2-t22"> <p>- Do not aggregate -</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r81c1-t22" headers="r1c1-t22"> <p><code>APEXIR_DO_NOT_DISPLAY</code></p> </td> <td align="left" headers="r81c1-t22 r1c2-t22"> <p>Do Not Display</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r82c1-t22" headers="r1c1-t22"> <p><code>APEXIR_EDIT_CHART</code></p> </td> <td align="left" headers="r82c1-t22 r1c2-t22"> <p>Edit Chart Settings</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r83c1-t22" headers="r1c1-t22"> <p><code>APEXIR_EDIT_CHART2</code></p> </td> <td align="left" headers="r83c1-t22 r1c2-t22"> <p>Edit Chart</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r84c1-t22" headers="r1c1-t22"> <p><code>APEXIR_EDIT_FILTER</code></p> </td> <td align="left" headers="r84c1-t22 r1c2-t22"> <p>Edit Filter</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r85c1-t22" headers="r1c1-t22"> <p><code>APEXIR_EDIT_HIGHLIGHT</code></p> </td> <td align="left" headers="r85c1-t22 r1c2-t22"> <p>Edit Highlight</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r86c1-t22" headers="r1c1-t22"> <p><code>APEXIR_ENABLE</code></p> </td> <td align="left" headers="r86c1-t22 r1c2-t22"> <p>Enable</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r87c1-t22" headers="r1c1-t22"> <p><code>APEXIR_ENABLED</code></p> </td> <td align="left" headers="r87c1-t22 r1c2-t22"> <p>Enabled</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r88c1-t22" headers="r1c1-t22"> <p><code>APEXIR_ENABLE_DISABLE_ALT</code></p> </td> <td align="left" headers="r88c1-t22 r1c2-t22"> <p>Enable/Disable</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r89c1-t22" headers="r1c1-t22"> <p><code>APEXIR_ERROR</code></p> </td> <td align="left" headers="r89c1-t22 r1c2-t22"> <p>Error</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r90c1-t22" headers="r1c1-t22"> <p><code>APEXIR_EXAMPLES</code></p> </td> <td align="left" headers="r90c1-t22 r1c2-t22"> <p>Examples</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r91c1-t22" headers="r1c1-t22"> <p><code>APEXIR_EXAMPLES_WITH_COLON</code></p> </td> <td align="left" headers="r91c1-t22 r1c2-t22"> <p>Examples:</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r92c1-t22" headers="r1c1-t22"> <p><code>APEXIR_EXCLUDE_NULL</code></p> </td> <td align="left" headers="r92c1-t22 r1c2-t22"> <p>Exclude Null Values</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r93c1-t22" headers="r1c1-t22"> <p><code>APEXIR_EXPAND_COLLAPSE_ALT</code></p> </td> <td align="left" headers="r93c1-t22 r1c2-t22"> <p>Expand/Collapse</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r94c1-t22" headers="r1c1-t22"> <p><code>APEXIR_EXPRESSION</code></p> </td> <td align="left" headers="r94c1-t22 r1c2-t22"> <p>Expression</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r95c1-t22" headers="r1c1-t22"> <p><code>APEXIR_FILTER</code></p> </td> <td align="left" headers="r95c1-t22 r1c2-t22"> <p>Filter</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r96c1-t22" headers="r1c1-t22"> <p><code>APEXIR_FILTERS</code></p> </td> <td align="left" headers="r96c1-t22 r1c2-t22"> <p>Filters</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r97c1-t22" headers="r1c1-t22"> <p><code>APEXIR_FINDER_ALT</code></p> </td> <td align="left" headers="r97c1-t22 r1c2-t22"> <p>Select columns to search</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r98c1-t22" headers="r1c1-t22"> <p><code>APEXIR_FLASHBACK</code></p> </td> <td align="left" headers="r98c1-t22 r1c2-t22"> <p>Flashback</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r99c1-t22" headers="r1c1-t22"> <p><code>APEXIR_FLASHBACK_DESCRIPTION</code></p> </td> <td align="left" headers="r99c1-t22 r1c2-t22"> <p>A flashback query enables you to view the data as it existed at a previous point in time.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r100c1-t22" headers="r1c1-t22"> <p><code>APEXIR_FLASHBACK_ERROR_MSG</code></p> </td> <td align="left" headers="r100c1-t22 r1c2-t22"> <p>Unable to perform flashback request</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r101c1-t22" headers="r1c1-t22"> <p><code>APEXIR_FORMAT_MASK</code></p> </td> <td align="left" headers="r101c1-t22 r1c2-t22"> <p>Format Mask</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r102c1-t22" headers="r1c1-t22"> <p><code>APEXIR_FUNCTION</code></p> </td> <td align="left" headers="r102c1-t22 r1c2-t22"> <p>Function</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r103c1-t22" headers="r1c1-t22"> <p><code>APEXIR_FUNCTIONS</code></p> </td> <td align="left" headers="r103c1-t22 r1c2-t22"> <p>Functions</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r104c1-t22" headers="r1c1-t22"> <p><code>APEXIR_GO</code></p> </td> <td align="left" headers="r104c1-t22 r1c2-t22"> <p>Go</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r105c1-t22" headers="r1c1-t22"> <p><code>APEXIR_GREEN</code></p> </td> <td align="left" headers="r105c1-t22 r1c2-t22"> <p>green</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r106c1-t22" headers="r1c1-t22"> <p><code>APEXIR_HCOLUMN</code></p> </td> <td align="left" headers="r106c1-t22 r1c2-t22"> <p>Horizontal Column</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r107c1-t22" headers="r1c1-t22"> <p><code>APEXIR_HELP</code></p> </td> <td align="left" headers="r107c1-t22 r1c2-t22"> <p>Help</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r108c1-t22" headers="r1c1-t22"> <p><code>APEXIR_HELP_01</code></p> </td> <td align="left" headers="r108c1-t22 r1c2-t22"> <p>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> <p><p/></p> <p>An Interactive Report can be customized in three ways: the search bar, actions menu and column heading menu.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r109c1-t22" headers="r1c1-t22"> <p><code>APEXIR_HELP_ACTIONS_MENU</code></p> </td> <td align="left" headers="r109c1-t22 r1c2-t22"> <p>The actions menu is used to customize the display of your Interactive Report.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r110c1-t22" headers="r1c1-t22"> <p><code>APEXIR_HELP_AGGREGATE</code></p> </td> <td align="left" headers="r110c1-t22 r1c2-t22"> <p>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> <p><p/></p> <p><ul><li><b>Aggregation</b> allows you to select a previously defined aggregation to edit.</li></p> <p><li><b>Function</b> is the function to be performed (e.g. SUM, MIN).</li></p> <p><li><b>Column</b> is used to select the column to apply the mathematical function to. Only numeric columns will be displayed.</li></ul></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r111c1-t22" headers="r1c1-t22"> <p><code>APEXIR_HELP_AGGREGATE</code></p> </td> <td align="left" headers="r111c1-t22 r1c2-t22"> <p>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/></p> <p><p/></p> <p><ul><li><b>Aggregation</b> allows you to select a previously defined aggregation to edit.</li></p> <p><li><b>Function</b> is the function to be performed (e.g. SUM, MIN).</li></p> <p><li><b>Column</b> is used to select the column to apply the mathematical function to. Only numeric columns will be displayed.</li></ul></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r112c1-t22" headers="r1c1-t22"> <p><code>APEXIR_HELP_CHART</code></p> </td> <td align="left" headers="r112c1-t22 r1c2-t22"> <p>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> <p><p/></p> <p><ul><li><b>Chart Type</b> identifies the chart type to include. Select from horizontal bar, vertical bar, pie or line.</li></p> <p><li><b>Label</b> allows you to select the column to be used as the label.</li></p> <p><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></p> <p><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></p> <p><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></p> <p><li><b>Function</b> is an optional function to be performed on the column selected for Value.</li></ul></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r113c1-t22" headers="r1c1-t22"> <p><code>APEXIR_HELP_COLUMN_HEADING_MENU</code></p> </td> <td align="left" headers="r113c1-t22 r1c2-t22"> <p>Clicking on any column heading exposes a column heading menu.</p> <p><p/></p> <p><ul><li><b>Sort Ascending icon</b> sorts the report by the column in ascending order.</li></p> <p><li><b>Sort Descending icon</b> sorts the report by the column in descending order.</li></p> <p><li><b>Hide Column</b> hides the column.</li></p> <p><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></p> <p><li><b>Column Information</b> displays help text about the column, if available.</li></p> <p><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></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r114c1-t22" headers="r1c1-t22"> <p><code>APEXIR_HELP_COMPUTE</code></p> </td> <td align="left" headers="r114c1-t22 r1c2-t22"> <p>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> <p><p/></p> <p><ul><li><b>Computation</b> allows you to select a previously defined computation to edit.</li></p> <p><li><b>Column Heading</b> is the column heading for the new column.</li></p> <p><li><b>Format Mask</b> is an Oracle format mask to be applied against the column (e.g. S9999).</li></p> <p><li><b>Format Mask</b> is an Oracle format mask to be applied against the column (e.g. S9999).</li></p> <p><li><b>Computation</b> is the computation to be performed. Within the computation, columns are referenced using the aliases displayed.</li></p> <p></ul></p> <p><p/></p> <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> <p><p/></p> <p>An example computation to display Total Compensation is:</p> <p><p/></p> <p><pre>CASE WHEN A = 'SALES' THEN B + C ELSE B END</pre></p> <p>(where A is ORGANIZATION, B is SALARY and C is COMMISSION)</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r115c1-t22" headers="r1c1-t22"> <p><code>APEXIR_HELP_CONTROL_BREAK</code></p> </td> <td align="left" headers="r115c1-t22 r1c2-t22"> <p>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.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r116c1-t22" headers="r1c1-t22"> <p><code>APEXIR_HELP_DETAIL_VIEW</code></p> </td> <td align="left" headers="r116c1-t22 r1c2-t22"> <p>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.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r117c1-t22" headers="r1c1-t22"> <p><code>APEXIR_HELP_DOWNLOAD</code></p> </td> <td align="left" headers="r117c1-t22 r1c2-t22"> <p>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.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r118c1-t22" headers="r1c1-t22"> <p><code>APEXIR_HELP_FILTER</code></p> </td> <td align="left" headers="r118c1-t22 r1c2-t22"> <p>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 wild card (for example, STATE_NAME like A%).</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r119c1-t22" headers="r1c1-t22"> <p><code>APEXIR_HELP_FLASHBACK</code></p> </td> <td align="left" headers="r119c1-t22 r1c2-t22"> <p>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.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r120c1-t22" headers="r1c1-t22"> <p><code>APEXIR_HELP_HIGHLIGHT</code></p> </td> <td align="left" headers="r120c1-t22 r1c2-t22"> <p>Highlighting allows you to define a filter. The rows that meet the filter are highlighted using the characteristics associated with the filter.</p> <p><p/></p> <p><ul><li><b>Name</b> is used only for display.</li></p> <p><li><b>Sequence</b> identifies the sequence in which the rules will be evaluated.</li></p> <p><li><b>Enabled</b> identifies if the rule is enabled or disabled.</li></p> <p><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></p> <p><li><b>Background Color</b> is the new color for the background of the highlighted area.</li></p> <p><li><b>Text Color</b> is the new color for the text in the highlighted area.</li></p> <p><li><b>Highlight Condition</b> defines your filter condition.</li></ul></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r121c1-t22" headers="r1c1-t22"> <p><code>APEXIR_HELP_REPORT_SETTINGS</code></p> </td> <td align="left" headers="r121c1-t22 r1c2-t22"> <p>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> <p><p/></p> <p>For each report setting, you can:</p> <p><ul><li><b>Edit</b> by clicking the name.</li></p> <p><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></p> <p><li><b>Remove</b> by click the Remove icon. This permanently removes the setting.</li></ul></p> <p><p/></p> <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.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r122c1-t22" headers="r1c1-t22"> <p><code>APEXIR_HELP_RESET</code></p> </td> <td align="left" headers="r122c1-t22 r1c2-t22"> <p>Resets the report back to the default settings, removing any customizations that you have made.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r123c1-t22" headers="r1c1-t22"> <p><code>APEXIR_HELP_SAVE_REPORT</code></p> </td> <td align="left" headers="r123c1-t22 r1c2-t22"> <p>Saves the customized report for future use. You provide a name and an optional description.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r124c1-t22" headers="r1c1-t22"> <p><code>APEXIR_HELP_SEARCH_BAR</code></p> </td> <td align="left" headers="r124c1-t22 r1c2-t22"> <p>At the top of each report page is a search region. The region provides the following features:</p> <p><p/></p> <p><ul><li><b>Select columns icon</b> allows you to identify which column to search (or all).</li></p> <p><li><b>Text area</b> allows for case insensitive search criteria (no need for wild cards).</li></p> <p><li><b>Rows</b> selects the number of records to display per page.</li></p> <p><li><b>[Go] button</b> executes the search.</li></p> <p><li><b>Actions Menu icon</b> displays the actions menu (discussed next).</li></ul></p> <p><p/></p> <p>Please note that all features may not be available for each report.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r125c1-t22" headers="r1c1-t22"> <p><code>APEXIR_HELP_SELECT_COLUMNS</code></p> </td> <td align="left" headers="r125c1-t22 r1c2-t22"> <p>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>.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r126c1-t22" headers="r1c1-t22"> <p><code>APEXIR_HELP_SORT</code></p> </td> <td align="left" headers="r126c1-t22 r1c2-t22"> <p>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.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r127c1-t22" headers="r1c1-t22"> <p><code>APEXIR_HIDE_COLUMN</code></p> </td> <td align="left" headers="r127c1-t22 r1c2-t22"> <p>Hide Column</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r128c1-t22" headers="r1c1-t22"> <p><code>APEXIR_HIGHLIGHT</code></p> </td> <td align="left" headers="r128c1-t22 r1c2-t22"> <p>Highlight</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r129c1-t22" headers="r1c1-t22"> <p><code>APEXIR_HIGHLIGHTS</code></p> </td> <td align="left" headers="r129c1-t22 r1c2-t22"> <p>Highlights</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r130c1-t22" headers="r1c1-t22"> <p><code>APEXIR_HIGHLIGHT_CONDITION</code></p> </td> <td align="left" headers="r130c1-t22 r1c2-t22"> <p>Highlight Condition</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r131c1-t22" headers="r1c1-t22"> <p><code>APEXIR_HIGHLIGHT_TYPE</code></p> </td> <td align="left" headers="r131c1-t22 r1c2-t22"> <p>Highlight Type</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r132c1-t22" headers="r1c1-t22"> <p><code>APEXIR_HIGHLIGHT_WHEN</code></p> </td> <td align="left" headers="r132c1-t22 r1c2-t22"> <p>Highlight When</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r133c1-t22" headers="r1c1-t22"> <p><code>APEXIR_INTERACTIVE_REPORT_HELP</code></p> </td> <td align="left" headers="r133c1-t22 r1c2-t22"> <p>Interactive Report Help</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r134c1-t22" headers="r1c1-t22"> <p><code>APEXIR_INVALID</code></p> </td> <td align="left" headers="r134c1-t22 r1c2-t22"> <p>Invalid</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r135c1-t22" headers="r1c1-t22"> <p><code>APEXIR_INVALID_COMPUTATION</code></p> </td> <td align="left" headers="r135c1-t22 r1c2-t22"> <p>Invalid computation expression. %0</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r136c1-t22" headers="r1c1-t22"> <p><code>APEXIR_KEYPAD</code></p> </td> <td align="left" headers="r136c1-t22 r1c2-t22"> <p>Keypad</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r137c1-t22" headers="r1c1-t22"> <p><code>APEXIR_LABEL</code></p> </td> <td align="left" headers="r137c1-t22 r1c2-t22"> <p>Label</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r138c1-t22" headers="r1c1-t22"> <p><code>APEXIR_LABEL_AXIS_TITLE</code></p> </td> <td align="left" headers="r138c1-t22 r1c2-t22"> <p>Axis Title for Label</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r139c1-t22" headers="r1c1-t22"> <p><code>APEXIR_LAST_DAY</code></p> </td> <td align="left" headers="r139c1-t22 r1c2-t22"> <p>Last Day</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r140c1-t22" headers="r1c1-t22"> <p><code>APEXIR_LAST_HOUR</code></p> </td> <td align="left" headers="r140c1-t22 r1c2-t22"> <p>Last Hour</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r141c1-t22" headers="r1c1-t22"> <p><code>APEXIR_LAST_MONTH</code></p> </td> <td align="left" headers="r141c1-t22 r1c2-t22"> <p>Last Month</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r142c1-t22" headers="r1c1-t22"> <p><code>APEXIR_LAST_WEEK</code></p> </td> <td align="left" headers="r142c1-t22 r1c2-t22"> <p>Last Week</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r143c1-t22" headers="r1c1-t22"> <p><code>APEXIR_LAST_X_DAYS</code></p> </td> <td align="left" headers="r143c1-t22 r1c2-t22"> <p>Last %0 Days</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r144c1-t22" headers="r1c1-t22"> <p><code>APEXIR_LAST_X_HOURS</code></p> </td> <td align="left" headers="r144c1-t22 r1c2-t22"> <p>Last %0 Hours</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r145c1-t22" headers="r1c1-t22"> <p><code>APEXIR_LAST_X_YEARS</code></p> </td> <td align="left" headers="r145c1-t22 r1c2-t22"> <p>Last %0 Years</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r146c1-t22" headers="r1c1-t22"> <p><code>APEXIR_LAST_YEAR</code></p> </td> <td align="left" headers="r146c1-t22 r1c2-t22"> <p>Last Year</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r147c1-t22" headers="r1c1-t22"> <p><code>APEXIR_LINE</code></p> </td> <td align="left" headers="r147c1-t22 r1c2-t22"> <p>Line</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r148c1-t22" headers="r1c1-t22"> <p><code>APEXIR_MAX_QUERY_COST</code></p> </td> <td align="left" headers="r148c1-t22 r1c2-t22"> <p>The query is estimated to exceed the maximum allowed resources. Please modify your report settings and try again.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r149c1-t22" headers="r1c1-t22"> <p><code>APEXIR_MAX_ROW_CNT</code></p> </td> <td align="left" headers="r149c1-t22 r1c2-t22"> <p>This query returns more then %0 rows, please filter your data to ensure complete results.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r150c1-t22" headers="r1c1-t22"> <p><code>APEXIR_MIN_AGO</code></p> </td> <td align="left" headers="r150c1-t22 r1c2-t22"> <p>%0 minutes ago</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r151c1-t22" headers="r1c1-t22"> <p><code>APEXIR_MORE_DATA</code></p> </td> <td align="left" headers="r151c1-t22 r1c2-t22"> <p>More Data</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r152c1-t22" headers="r1c1-t22"> <p><code>APEXIR_MOVE</code></p> </td> <td align="left" headers="r152c1-t22 r1c2-t22"> <p>Move</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r153c1-t22" headers="r1c1-t22"> <p><code>APEXIR_MOVE_ALL</code></p> </td> <td align="left" headers="r153c1-t22 r1c2-t22"> <p>Move All</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r154c1-t22" headers="r1c1-t22"> <p><code>APEXIR_NAME</code></p> </td> <td align="left" headers="r154c1-t22 r1c2-t22"> <p>Name</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r155c1-t22" headers="r1c1-t22"> <p><code>APEXIR_NEW_AGGREGATION</code></p> </td> <td align="left" headers="r155c1-t22 r1c2-t22"> <p>New Aggregation</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r156c1-t22" headers="r1c1-t22"> <p><code>APEXIR_NEW_CATEGORY</code></p> </td> <td align="left" headers="r156c1-t22 r1c2-t22"> <p>- New Category -</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r157c1-t22" headers="r1c1-t22"> <p><code>APEXIR_NEW_COMPUTATION</code></p> </td> <td align="left" headers="r157c1-t22 r1c2-t22"> <p>New Computation</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r158c1-t22" headers="r1c1-t22"> <p><code>APEXIR_NEXT</code></p> </td> <td align="left" headers="r158c1-t22 r1c2-t22"> <p>&gt;</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r159c1-t22" headers="r1c1-t22"> <p><code>APEXIR_NEXT_DAY</code></p> </td> <td align="left" headers="r159c1-t22 r1c2-t22"> <p>Next Day</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r160c1-t22" headers="r1c1-t22"> <p><code>APEXIR_NEXT_HOUR</code></p> </td> <td align="left" headers="r160c1-t22 r1c2-t22"> <p>Next Hour</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r161c1-t22" headers="r1c1-t22"> <p><code>APEXIR_NEXT_MONTH</code></p> </td> <td align="left" headers="r161c1-t22 r1c2-t22"> <p>Next Month</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r162c1-t22" headers="r1c1-t22"> <p><code>APEXIR_NEXT_WEEK</code></p> </td> <td align="left" headers="r162c1-t22 r1c2-t22"> <p>Next Week</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r163c1-t22" headers="r1c1-t22"> <p><code>APEXIR_NEXT_X_DAYS</code></p> </td> <td align="left" headers="r163c1-t22 r1c2-t22"> <p>Next %0 Days</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r164c1-t22" headers="r1c1-t22"> <p><code>APEXIR_NEXT_X_HOURS</code></p> </td> <td align="left" headers="r164c1-t22 r1c2-t22"> <p>Next %0 Hours</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r165c1-t22" headers="r1c1-t22"> <p><code>APEXIR_NEXT_X_YEARS</code></p> </td> <td align="left" headers="r165c1-t22 r1c2-t22"> <p>Next %0 Years</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r166c1-t22" headers="r1c1-t22"> <p><code>APEXIR_NEXT_YEAR</code></p> </td> <td align="left" headers="r166c1-t22 r1c2-t22"> <p>Next Year</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r167c1-t22" headers="r1c1-t22"> <p><code>APEXIR_NO</code></p> </td> <td align="left" headers="r167c1-t22 r1c2-t22"> <p>No</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r168c1-t22" headers="r1c1-t22"> <p><code>APEXIR_NONE</code></p> </td> <td align="left" headers="r168c1-t22 r1c2-t22"> <p>- None -</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r169c1-t22" headers="r1c1-t22"> <p><code>APEXIR_NO_AGGREGATION_DEFINED</code></p> </td> <td align="left" headers="r169c1-t22 r1c2-t22"> <p>No aggregation defined.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r170c1-t22" headers="r1c1-t22"> <p><code>APEXIR_NO_COLUMN_INFO</code></p> </td> <td align="left" headers="r170c1-t22 r1c2-t22"> <p>No column information available.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r171c1-t22" headers="r1c1-t22"> <p><code>APEXIR_NO_COMPUTATION_DEFINED</code></p> </td> <td align="left" headers="r171c1-t22 r1c2-t22"> <p>No computation defined.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r172c1-t22" headers="r1c1-t22"> <p><code>APEXIR_NULLS_ALWAYS_FIRST</code></p> </td> <td align="left" headers="r172c1-t22 r1c2-t22"> <p>Nulls Always First</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r173c1-t22" headers="r1c1-t22"> <p><code>APEXIR_NULLS_ALWAYS_FIRST</code></p> </td> <td align="left" headers="r173c1-t22 r1c2-t22"> <p>Nulls Always First</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r174c1-t22" headers="r1c1-t22"> <p><code>APEXIR_NULLS_ALWAYS_LAST</code></p> </td> <td align="left" headers="r174c1-t22 r1c2-t22"> <p>Nulls Always Last</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r175c1-t22" headers="r1c1-t22"> <p><code>APEXIR_NULL_SORTING</code></p> </td> <td align="left" headers="r175c1-t22 r1c2-t22"> <p>Null Sorting</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r176c1-t22" headers="r1c1-t22"> <p><code>APEXIR_NUMERIC_FLASHBACK_TIME</code></p> </td> <td align="left" headers="r176c1-t22 r1c2-t22"> <p>Flashback time must be numeric.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r177c1-t22" headers="r1c1-t22"> <p><code>APEXIR_NUMERIC_SEQUENCE</code></p> </td> <td align="left" headers="r177c1-t22 r1c2-t22"> <p>Sequence must be numeric.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r178c1-t22" headers="r1c1-t22"> <p><code>APEXIR_OPERATOR</code></p> </td> <td align="left" headers="r178c1-t22 r1c2-t22"> <p>Operator</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r179c1-t22" headers="r1c1-t22"> <p><code>APEXIR_ORANGE</code></p> </td> <td align="left" headers="r179c1-t22 r1c2-t22"> <p>orange</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r180c1-t22" headers="r1c1-t22"> <p><code>APEXIR_OTHER</code></p> </td> <td align="left" headers="r180c1-t22 r1c2-t22"> <p>Other</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r181c1-t22" headers="r1c1-t22"> <p><code>APEXIR_PIE</code></p> </td> <td align="left" headers="r181c1-t22 r1c2-t22"> <p>Pie</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r182c1-t22" headers="r1c1-t22"> <p><code>APEXIR_PREVIOUS</code></p> </td> <td align="left" headers="r182c1-t22 r1c2-t22"> <p>&lt;</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r183c1-t22" headers="r1c1-t22"> <p><code>APEXIR_PUBLIC</code></p> </td> <td align="left" headers="r183c1-t22 r1c2-t22"> <p>Public</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r184c1-t22" headers="r1c1-t22"> <p><code>APEXIR_RED</code></p> </td> <td align="left" headers="r184c1-t22 r1c2-t22"> <p>red</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r185c1-t22" headers="r1c1-t22"> <p><code>APEXIR_REMOVE</code></p> </td> <td align="left" headers="r185c1-t22 r1c2-t22"> <p>Remove</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r186c1-t22" headers="r1c1-t22"> <p><code>APEXIR_REMOVE_AGGREGATE</code></p> </td> <td align="left" headers="r186c1-t22 r1c2-t22"> <p>Remove Aggregate</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r187c1-t22" headers="r1c1-t22"> <p><code>APEXIR_REMOVE_ALL</code></p> </td> <td align="left" headers="r187c1-t22 r1c2-t22"> <p>Remove All</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r188c1-t22" headers="r1c1-t22"> <p><code>APEXIR_REMOVE_CONTROL_BREAK</code></p> </td> <td align="left" headers="r188c1-t22 r1c2-t22"> <p>Remove Control Break</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r189c1-t22" headers="r1c1-t22"> <p><code>APEXIR_REMOVE_FILTER</code></p> </td> <td align="left" headers="r189c1-t22 r1c2-t22"> <p>Remove Filter</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r190c1-t22" headers="r1c1-t22"> <p><code>APEXIR_REMOVE_FLASHBACK</code></p> </td> <td align="left" headers="r190c1-t22 r1c2-t22"> <p>Remove Flashback</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r191c1-t22" headers="r1c1-t22"> <p><code>APEXIR_REMOVE_HIGHLIGHT</code></p> </td> <td align="left" headers="r191c1-t22 r1c2-t22"> <p>Remove Highlight</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r192c1-t22" headers="r1c1-t22"> <p><code>APEXIR_RENAME_REPORT</code></p> </td> <td align="left" headers="r192c1-t22 r1c2-t22"> <p>Rename Report</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r193c1-t22" headers="r1c1-t22"> <p><code>APEXIR_REPORT</code></p> </td> <td align="left" headers="r193c1-t22 r1c2-t22"> <p>Report</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r194c1-t22" headers="r1c1-t22"> <p><code>APEXIR_REPORT_SETTINGS</code></p> </td> <td align="left" headers="r194c1-t22 r1c2-t22"> <p>Report Settings</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r195c1-t22" headers="r1c1-t22"> <p><code>APEXIR_REPORT_VIEW</code></p> </td> <td align="left" headers="r195c1-t22 r1c2-t22"> <p>&lt; Report View</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r196c1-t22" headers="r1c1-t22"> <p><code>APEXIR_RESET</code></p> </td> <td align="left" headers="r196c1-t22 r1c2-t22"> <p>Reset</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r197c1-t22" headers="r1c1-t22"> <p><code>APEXIR_RESET_CONFIRM</code></p> </td> <td align="left" headers="r197c1-t22 r1c2-t22"> <p>Restore report to the default settings.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r198c1-t22" headers="r1c1-t22"> <p><code>APEXIR_ROW</code></p> </td> <td align="left" headers="r198c1-t22 r1c2-t22"> <p>Row</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r199c1-t22" headers="r1c1-t22"> <p><code>APEXIR_ROWS</code></p> </td> <td align="left" headers="r199c1-t22 r1c2-t22"> <p>Rows</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r200c1-t22" headers="r1c1-t22"> <p><code>APEXIR_ROW_OF</code></p> </td> <td align="left" headers="r200c1-t22 r1c2-t22"> <p>Row %0 of %1</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r201c1-t22" headers="r1c1-t22"> <p><code>APEXIR_ROW_ORDER</code></p> </td> <td align="left" headers="r201c1-t22 r1c2-t22"> <p>Row Order</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r202c1-t22" headers="r1c1-t22"> <p><code>APEXIR_ROW_TEXT_CONTAINS</code></p> </td> <td align="left" headers="r202c1-t22 r1c2-t22"> <p>Row text contains</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r203c1-t22" headers="r1c1-t22"> <p><code>APEXIR_SAVE</code></p> </td> <td align="left" headers="r203c1-t22 r1c2-t22"> <p>Save</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r204c1-t22" headers="r1c1-t22"> <p><code>APEXIR_SAVED_REPORT</code></p> </td> <td align="left" headers="r204c1-t22 r1c2-t22"> <p>Saved Report</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r205c1-t22" headers="r1c1-t22"> <p><code>APEXIR_SAVED_REPORT_MSG</code></p> </td> <td align="left" headers="r205c1-t22 r1c2-t22"> <p>Saved Report = "%0"</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r206c1-t22" headers="r1c1-t22"> <p><code>APEXIR_SAVE_AS_DEFAULT</code></p> </td> <td align="left" headers="r206c1-t22 r1c2-t22"> <p>Save as Default</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r207c1-t22" headers="r1c1-t22"> <p><code>APEXIR_SAVE_DEFAULT_CONFIRM</code></p> </td> <td align="left" headers="r207c1-t22 r1c2-t22"> <p>The current report settings will be used as the default for all users.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r208c1-t22" headers="r1c1-t22"> <p><code>APEXIR_SAVE_REPORT</code></p> </td> <td align="left" headers="r208c1-t22 r1c2-t22"> <p>Save Report</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r209c1-t22" headers="r1c1-t22"> <p><code>APEXIR_SEARCH_BAR</code></p> </td> <td align="left" headers="r209c1-t22 r1c2-t22"> <p>Search Bar</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r210c1-t22" headers="r1c1-t22"> <p><code>APEXIR_SELECT_CATEGORY</code></p> </td> <td align="left" headers="r210c1-t22 r1c2-t22"> <p>- Select Category -</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r211c1-t22" headers="r1c1-t22"> <p><code>APEXIR_SELECT_COLUMN</code></p> </td> <td align="left" headers="r211c1-t22 r1c2-t22"> <p>- Select Column -</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r212c1-t22" headers="r1c1-t22"> <p><code>APEXIR_SELECT_COLUMNS</code></p> </td> <td align="left" headers="r212c1-t22 r1c2-t22"> <p>Select Columns</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r213c1-t22" headers="r1c1-t22"> <p><code>APEXIR_SELECT_COLUMNS_FOOTER</code></p> </td> <td align="left" headers="r213c1-t22 r1c2-t22"> <p>Computed columns are prefixed with **.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r214c1-t22" headers="r1c1-t22"> <p><code>APEXIR_SELECT_FUNCTION</code></p> </td> <td align="left" headers="r214c1-t22 r1c2-t22"> <p>- Select Function -</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r215c1-t22" headers="r1c1-t22"> <p><code>APEXIR_SELECT_VALUE</code></p> </td> <td align="left" headers="r215c1-t22 r1c2-t22"> <p>Select Value</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r216c1-t22" headers="r1c1-t22"> <p><code>APEXIR_SEQUENCE</code></p> </td> <td align="left" headers="r216c1-t22 r1c2-t22"> <p>Sequence</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r217c1-t22" headers="r1c1-t22"> <p><code>APEXIR_SORT</code></p> </td> <td align="left" headers="r217c1-t22 r1c2-t22"> <p>Sort</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r218c1-t22" headers="r1c1-t22"> <p><code>APEXIR_SORT_ASCENDING</code></p> </td> <td align="left" headers="r218c1-t22 r1c2-t22"> <p>Sort Ascending</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r219c1-t22" headers="r1c1-t22"> <p><code>APEXIR_SORT_DESCENDING</code></p> </td> <td align="left" headers="r219c1-t22 r1c2-t22"> <p>Sort Descending</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r220c1-t22" headers="r1c1-t22"> <p><code>APEXIR_SPACE_AS_IN_ONE_EMPTY_STRING</code></p> </td> <td align="left" headers="r220c1-t22 r1c2-t22"> <p>space</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r221c1-t22" headers="r1c1-t22"> <p><code>APEXIR_STATUS</code></p> </td> <td align="left" headers="r221c1-t22 r1c2-t22"> <p>Status</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r222c1-t22" headers="r1c1-t22"> <p><code>APEXIR_TEXT_COLOR</code></p> </td> <td align="left" headers="r222c1-t22 r1c2-t22"> <p>Text Color</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r223c1-t22" headers="r1c1-t22"> <p><code>APEXIR_TIME_DAYS</code></p> </td> <td align="left" headers="r223c1-t22 r1c2-t22"> <p>days</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r224c1-t22" headers="r1c1-t22"> <p><code>APEXIR_TIME_HOURS</code></p> </td> <td align="left" headers="r224c1-t22 r1c2-t22"> <p>hours</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r225c1-t22" headers="r1c1-t22"> <p><code>APEXIR_TIME_MINS</code></p> </td> <td align="left" headers="r225c1-t22 r1c2-t22"> <p>minutes</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r226c1-t22" headers="r1c1-t22"> <p><code>APEXIR_TIME_MONTHS</code></p> </td> <td align="left" headers="r226c1-t22 r1c2-t22"> <p>months</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r227c1-t22" headers="r1c1-t22"> <p><code>APEXIR_TIME_WEEKS</code></p> </td> <td align="left" headers="r227c1-t22 r1c2-t22"> <p>weeks</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r228c1-t22" headers="r1c1-t22"> <p><code>APEXIR_TIME_YEARS</code></p> </td> <td align="left" headers="r228c1-t22 r1c2-t22"> <p>years</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r229c1-t22" headers="r1c1-t22"> <p><code>APEXIR_TOP</code></p> </td> <td align="left" headers="r229c1-t22 r1c2-t22"> <p>Top</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r230c1-t22" headers="r1c1-t22"> <p><code>APEXIR_UNAUTHORIZED</code></p> </td> <td align="left" headers="r230c1-t22 r1c2-t22"> <p>Unauthorized</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r231c1-t22" headers="r1c1-t22"> <p><code>APEXIR_UNIQUE_COLUMN_HEADING</code></p> </td> <td align="left" headers="r231c1-t22 r1c2-t22"> <p>Column Heading must be unique.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r232c1-t22" headers="r1c1-t22"> <p><code>APEXIR_UNIQUE_HIGHLIGHT_NAME</code></p> </td> <td align="left" headers="r232c1-t22 r1c2-t22"> <p>Highlight Name must be unique.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r233c1-t22" headers="r1c1-t22"> <p><code>APEXIR_UNSUPPORTED_DATA_TYPE</code></p> </td> <td align="left" headers="r233c1-t22 r1c2-t22"> <p>unsupported data type</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r234c1-t22" headers="r1c1-t22"> <p><code>APEXIR_UP</code></p> </td> <td align="left" headers="r234c1-t22 r1c2-t22"> <p>Up</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r235c1-t22" headers="r1c1-t22"> <p><code>APEXIR_VALID_COLOR</code></p> </td> <td align="left" headers="r235c1-t22 r1c2-t22"> <p>Please enter a valid color.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r236c1-t22" headers="r1c1-t22"> <p><code>APEXIR_VALID_FORMAT_MASK</code></p> </td> <td align="left" headers="r236c1-t22 r1c2-t22"> <p>Please enter a valid format mask.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r237c1-t22" headers="r1c1-t22"> <p><code>APEXIR_VALUE</code></p> </td> <td align="left" headers="r237c1-t22 r1c2-t22"> <p>Value</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r238c1-t22" headers="r1c1-t22"> <p><code>APEXIR_VALUE_AXIS_TITLE</code></p> </td> <td align="left" headers="r238c1-t22 r1c2-t22"> <p>Axis Title for Value</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r239c1-t22" headers="r1c1-t22"> <p><code>APEXIR_VALUE_REQUIRED</code></p> </td> <td align="left" headers="r239c1-t22 r1c2-t22"> <p>Value Required</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r240c1-t22" headers="r1c1-t22"> <p><code>APEXIR_VCOLUMN</code></p> </td> <td align="left" headers="r240c1-t22 r1c2-t22"> <p>Vertical Column</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r241c1-t22" headers="r1c1-t22"> <p><code>APEXIR_VIEW_CHART</code></p> </td> <td align="left" headers="r241c1-t22 r1c2-t22"> <p>View Chart</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r242c1-t22" headers="r1c1-t22"> <p><code>APEXIR_VIEW_REPORT</code></p> </td> <td align="left" headers="r242c1-t22 r1c2-t22"> <p>View Report</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r243c1-t22" headers="r1c1-t22"> <p><code>APEXIR_WORKING_REPORT</code></p> </td> <td align="left" headers="r243c1-t22 r1c2-t22"> <p>Working Report</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r244c1-t22" headers="r1c1-t22"> <p><code>APEXIR_YELLOW</code></p> </td> <td align="left" headers="r244c1-t22 r1c2-t22"> <p>yellow</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r245c1-t22" headers="r1c1-t22"> <p><code>APEXIR_YES</code></p> </td> <td align="left" headers="r245c1-t22 r1c2-t22"> <p>Yes</p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformalwide" --></div> <!-- class="sect2" --> <!-- class="sect1" --> <!-- Start Footer --> <div class="footer"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr> <td align="left"><span class="copyrightlogo">Copyright © 2003, 2009, Oracle and/or its affiliates. All rights reserved.</span><br /> <a href="dcommon/html/cpyr.htm"><span class="copyrightlogo">Legal Notices</span></a></td> <td align="center"><a href="global_mess_plsql.htm"><img src="dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="global_lovs.htm"><img src="dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </div> <!-- class="footer" --> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de