3 Setting Profile Values

Oracle Applications includes a set of profiles whose settings affect the way your application looks and behaves. You must have the System Administrator responsibility to set profile values at the site level.

For further information, see the Oracle E-Business Suite System Administrator's Guide - Maintenance at http://download.oracle.com/docs/cd/B53825_08/current/acrobat/121samg.pdf.

This chapter contains the following topics:

• How to Log In to Oracle Applications Profile Forms
  This is the login procedure for Oracle Applications Profile Forms
• Setting Native Client Encoding
  The value for this profile determines the encoding used when uploading and downloading files from the client.
• Using Character Semantics for Work Area Table Installation
  If your data includes multibyte unicode characters, your data may sometimes not fit into character columns in the Oracle Life Sciences Data Hub Table instances you create because you are using byte semantics (which is the default behavior).
• Gathering Work Area Schema Statistics
  You can set a profile to gather statistics on user-defined tables in a Work Area during the post-processing phase of job executions writing to tables.
• Default Tablespace for Work Area Schema Objects
  By default, Oracle LSH internal application tables and user-defined Work Area tables are controlled using internal profile values. To avoid performance and functional issues, do not change the values of the profile.
• Setting the Default Value for: Force Output Validation Status to Development
  Oracle Life Sciences Data Hub Program definitions have an attribute that determines how all outputs of all instances of that Program definition receive their initial validation status. You can set the default value in a profile.
• Setting the Maximum Number of Nested Domains
  In Oracle Life Sciences Data Hub you define Library Domains to contain object definitions, Application Areas and, if you allow Domain nesting, other Domains.
• Adding the Direct SQL Option to SAS Libraries
  his profile allows you to add the SAS option DIRECT_SQL=NOWHERE to your SAS libraries.
• Allowing User Preferences for SAS Clients
  This profile allows you to set the default User Preference for SAS client across your site and stores individual users' preferences.
• Set Default SAS Number Format
  The default value in Oracle Life Sciences Data Hub for SAS number format is 8, which does not support precision.
• Set Processing Type for OC Data Extract Incremental Adapter
  This profile allows you to set the default processing type for the incremental Oracle Clinical data extract adapter, which uses incremental-mode processing and is therefore faster than the regular OC data extract adapter, which uses full-mode processing. You can specify transactional processing with or without audit.
• Turn debugging on or off
  Enable or disable the recording of debugging statements for database processes.
• Setting Password Requirements
  A password expiration utility is available if the System Administrator requires that all users convert to case sensitive passwords upon the next login.
• Oracle LSH: BIP Endpoint
  This profile stores the namespace value of Oracle BI Publisher webservices:
• Attachment File Upload Restriction Default
  This profile allows more file types to be uploaded than are allowed under E-Business Suite recommended security settings.