This appendix covers the following topics:
Use the following procedure to set any profile option.
Before making Oracle Forms settings, ensure that all Oracle Applications server processes are up and running. In particular, if you stopped concurrent managers before applying Oracle Applications patchsets, restart them now by changing to $COMMON_TOP/admin/scripts, and executing adcmctl.sh <APPS user name/APPS password> start.
Log into Oracle applications using the Personal Home Page login, or the Single Sign-On login if implemented.
System Administrator
From the Navigator, navigate to Profile > System.
The Find System Profile Values window opens.
Check the level(s) at which you want to set the profile option. The available levels are listed below:
Site: If you select this level, the profile will apply to the entire site. Individual profiles with a different value designated at any other level will take precedence.
Application: If you select this level, choose the application from the Application LOV for which you want to set the profile option.
Responsibility: If you select this level, choose the responsibility from the Responsibility LOV for which you want to set the profile option.
User: If you select this level, choose the user from the User LOV for whom you want to set the profile option.
In the Profile field, enter the profile name, such as IES: Architecture Type, or a wildcard search criterion such as IES%.
Click Find.
The System Profile Values form opens with the results of your search.
Verify or set the profile option(s) at the levels that you selected.
You must know the APPLICATION_ID value for Oracle Scripting and the RESPONSIBILITY_ID value for the Survey Administrator responsibility before you can set the required Oracle CRM Technology Foundation (JTT) profile options for users with these responsibilities.
Note: The APPLICATION_ID value for the seeded Scripting User (or Scripting Agent) responsibility is 519. The RESPONSIBILITY_ID value for Survey Administrator is 21685. However, in some scenarios, the responsibility identification may differ, based on environmental factors.
Use the following procedure to find the APPLICATION_ID value and RESPONSIBILITY_ID value of a responsibility.
None
Log into Oracle applications using the Personal Home Page login, or the Single Sign-On login if implemented.
System Administrator
From the Navigator, navigate to Security > Responsibility > Define.
The Responsibilities form opens.
Choose View > Find. Search for the responsibility, highlight it, and click OK in the search window.
The Responsibilities form is populated with the record for the responsibility that you chose.
With your cursor in any field of the record, choose Help > Diagnostics > Examine.
The Examine Field and Variable Values window opens.
In the Examine Field and Variable Values window, choose APPLICATION_ID from the Field LOV.
The Value field in the Examine Field and Variable Values window is populated with the value of APPLICATION_ID.
In the Examine Field and Variable Values window, choose RESPONSIBILITY_ID from the Field LOV.
The Value field in the Examine Field and Variable Values window is populated with the value of RESPONSIBILITY_ID.
This section summarizes the Oracle CRM Technology Foundation (JTT) profile options that you need to set when implementing Oracle Scripting. Most of these are set at the site level.
Listed in the table below are the system profile name, a description of the function or purpose of the profile setting, recommended level settings, and a sample value.
Note: See FindingResponsibilityIDValues if you need to find the APPLICATION_ID and RESPONSIBILITY_ID values for a responsibility.
| Profile Option Name | Description | Recommended Level Setting | Value |
|---|---|---|---|
| JTF_PROFILE_DEFAULT_APPLICATION | Default application ID (519=Oracle Scripting) | Site | 519 |
| JTF_PROFILE_DEFAULT_BLANK_ROWS | Number of blank rows on HTML forms (can be set to any integer > 0) | Site | 3 |
| JTF_PROFILE_DEFAULT_CSS | Default Oracle CRM Technology Foundation Cascading Style Sheet | Site | jtfucss.css |
| JTF_PROFILE_DEFAULT_CURRENCY | Default currency. Enter the currency code in all uppercase letters. | Site | USD |
| JTF_PROFILE_DEFAULT_NUM_ROWS | Number of default rows (records) displayed on HTML summary tables (can be set to any integer > 0) | Site | 10 |
| JTF_PROFILE_DEFAULT_RESPONSIBILITY (application level only) | Default responsibility ID (21685=Survey Administrator) | Application | 21685 |
This section summarizes the current Oracle Scripting (IES) profile options that you need to set when implementing the Scripting Engine and the Survey components of Oracle Scripting. Set the profile options in this section at the site level.
Listed in the table below are the system profile name, any seeded lookup values, a description of the function or purpose of the profile setting, and recommended settings.
| Profile Option Name | Category | Lookup Values | Description | Recommended Setting |
|---|---|---|---|---|
| IES : Architecture Type | Architecture | Apache Mid Tier/Servlet Architecture Three Tier Mode Caching Architecture |
Determines mode of Oracle Scripting operations.
|
Apache Mid Tier/Servlet Architecture |
| IES : Debug Mode | Debug | Debug off Debug on |
Controls display at runtime of client-side informational and error messages for Scripting Engine operations. When enabled, these messages are displayed in a Java-based Debug console that appears (in a separate window) when a script is executed in the Scripting Engine agent interface. Server-side message logs are controlled by FND profiles. See Information, Error and Debug Logging Profile Options for more information. |
Generally set to Debug off unless troubleshooting specific issues. When troubleshooting specific issues, enable at the Responsibility or User level for best results. |
| IES : Display Suspend Button on Script Frame | Runtime UI Settings | False True |
When set to True, the Scripting Engine agent interface displays a Suspend button on the bottom of the script frame. This button is hidden if the profile is set to False (or remains null). When this button is clicked by an agent during script runtime, the current script interaction is suspended. (Requires Suspendable global script property option to be enabled.) | False unless using Oracle Scripting in standalone mode |
| IES : Dropdowns Display Default Null Choice in HTML UI | HTML UI Dropdown options | True False |
By default, Oracle Scripting displays a text string "- select one - " at runtime for questions with a data type of drop-down list. Although "- select one -" appears in the list, this is a null value. Business rules for a drop-down list require the user to select one value for this question, resulting in a blackboard value other than null for each such question. Setting this profile to False suppresses the null value with the "- select one - " one string in the Scripting Engine Web interface. For Web browsers only, the first answer choice in the list will appear as the selected value, unless another answer choice has been designated as a default answer. | Set to False to prevent " - select one -" string from displaying for scripts displaying in HTML UI. Leave null or set to True to ensure this string remains in both interfaces. When null or set to True, user action will be required at runtime to select an option from the list, as a null value is not acceptable for the drop-down list question UI type. |
| IES : Initial Script Frame Size | Runtime UI Settings | 1280 X 1024 800 X 600 Maximized 1024 X 768 |
Controls the initial size of the Scripting Engine window frame, in pixels, in the Forms/Java agent user interface. | Prior to the introduction of this profile option, the initial size of the Oracle Scripting window in the agent interface was 800 X 600 pixels by default. Change as required to accommodate various monitor resolutions. |
| IES : Scripting Panel Display Mode | Runtime UI Settings | Display Multiple Panels at a time in Scripting window Display Single Panel at a time in Scripting window |
Determines in Scripting Engine Java agent interface whether a single panel is visible upon script execution or whether multiple panels are displayed with active panel having focus. | At the discretion of the implementing enterprise. |
| IES: Survey Resources Caching | Survey Resources | On Off |
Determines whether survey resources for OAF surveys are cached at runtime. If no value is set, caching occurs by default (same behavior as setting to On). | Set to Off to avoid caching. Set to On or leave null to cache survey resources for OAF surveys. |
| IES: Proxy Server Name | Connectivity | None | Name of Proxy server (required if proxy server used for Scripting Engine agent interface only). | Syntax: http://<servername>.<domain>:<Apache Web server port>/<servlet_zone> |
| IES: Proxy Server Port | Connectivity | None | Port of Proxy server (required if proxy server used for Scripting Engine agent interface only). | N/A |
This section summarizes the system profile options that affect the logging of server-side informational, error, and debug messages in the Oracle Applications Logging Framework for OAF technology stack applications.
Client-side message logs are controlled by the IES : Debug Mode profile. See Current IES Profile Options for more information.
Listed in the table below are the system profile name, any seeded lookup values, the level available for setting the system profile, a description of the function or purpose of the profile setting, and recommended settings.
| Profile Option Name | Lookup Values | Level | Description | Recommended Setting |
|---|---|---|---|---|
| FND: Diagnostics | Yes No |
Site Application Responsibility User |
Causes a Diagnostics link to appear in the HTML UI when set to Yes. This provides access to the log messages captured using the Oracle Applications Logging Framework. | Generally set to No unless specific user has need to access server logs. Generally recommended only for administrators or trusted users. For this reason, recommended to set at User level. |
| FND: Debug Log Enabled | Yes No |
Site Application Responsibility User |
Controls display at runtime of informational and error messages for Scripting Engine operations when set to Yes. These messages are logged to the Oracle Applications Logging Framework server logs. | Generally set to No unless troubleshooting specific issues. Recommended to set at User level to avoid heavy system load. |
| FND: Debug Log Filename | Null | Site Application Responsibility User |
When defined, saves log messages (at the level determined by the FND: Debug Log Level profile setting) in a text file. Leave this value null to record log messages to database log files. | Generally, do not provide a filename unless directed to do so by Oracle Support Services for specific problem remediation. File size can quickly grow to an unmanageable size that may cause performance issues. |
| FND: Debug Log Level | Statement Procedure Event Exception Error Unexpected |
Site Application Responsibility User |
Controls the level and degree of log messages captured, decreasing the amount of information by the order listed (Statement level logging captures the most information; Unexpected captures the fewest messages). | Generally, set this profile option to Error at the Application level for application Scripting to capture error-level message logs. For diagnosing specific errors, set this profile to Statement at the User level for the Oracle Applications user account experiencing problems. Use in combination with FND: Debug Log Module for specific problem diagnosis. |
| FND: Debug Log Module | None | Site Application Responsibility User |
Determines the module for which messages are logged. | Generally, set to ies% at the Site level to log messages coming from all IES (Oracle Scripting) Java classes. To diagnose specific problems, set at the user level with more specific criteria. For example, to debug issues with the Scripting Engine, set to ies.engine%. This value is not case-sensitive. Ensure the % is included, to capture all messages included in the designated class. |
| Guest User Password or GUEST_USER_PWD | None | Site | Determines the Oracle Applications user account and password considered as the applications-level guest user. | Only required when logging for guest user must be enabled. Generally set to GUEST/<password>. |
This section summarizes additional profile options that you need to set when implementing the Scripting Engine and the Survey components of Oracle Scripting. Set the profile options in this section at the site level.
Listed in the table below are the system profile name, any seeded lookup values, the level available for setting the system profile, a description of the function or purpose of the profile setting, and recommended settings.
| Profile Option Name | Lookup Values | Level | Description | Recommended Setting |
|---|---|---|---|---|
| Apps Servlet Agent | None | Site Application |
Identifies servlet zone of Apache Web server JServ used for Scripting Engine agent interface only. May be set at site level if one Apache server listener used. If different settings required for multiple applications, set at application level. |
Syntax: http://<server name>.<domain>:<Apache Web server port>/<servlet_zone> |
| ICX: Language | None | Site | Establishes default language for the Internet Cartridge Exchange (ICX) settings for Web-based transactions | As appropriate |
| FND: Migrated To JRAD | No Yes |
Application | Enables searches in the Survey Administration console. | Yes |