Oracle Security Rules

Mar 7, 2020 | HR, Oracle

Security Overview

Defining which records and information users can access is fundamental to HRMS security.

As part of your implementation plan, you identify who will use Oracle HRMS, what information they require, and how they use it. You can control a user’s access to database elements such as records, fields, forms, and functions, and you can also control a user’s access to other user records and data.Applications

See: ResponsibilitiesSecurity and Business GroupsSee: Defining Preferences with User Profile Options, Oracle Applications User’s Guide

Profile Options Summary

The table below indicates whether users of the system can view or update the profile option, and at which System Administrator levels (either user, responsibility, application, or site) the profile options can be updated. These System Administrator levels are included in the table as Site, App, Resp, and User.

For the User column, Yes indicates that you can update the profile, View Only indicates that you can view the profile but you cannot update it, and No indicates that you can neither view nor update the profile.

A “Required” profile option requires you to provide a value. Otherwise the profile option already provides a default value, so you only need to change it if you do not want to accept the default.

For details of profile options applicable to all Oracle Applications, see: Profile Options in Oracle Applications Object Library, Oracle Applications Developer’s Guide

Profile OptionAdmin UpdateLevelsUserRequiredDefault Value
Apply Assessment Competencies to PersonSiteNoNoNo
AME:InstalledAppYesNoNA
AuditTrail:ActivateAppSiteNoNoNo
BEN:BEN HOURLY ANNUALIZATION FACTORSiteAppRespYesNo2080
BEN:Benefits Preferred CurrencySiteAppRespUser       YesNoNA
BEN: Carry Forward CertificationSiteAppRespUser       NoNoNo
BEN: Check Enrollment LimitsSiteNoNoNo
BEN:Compensation ManagerSiteAppRespUser       YesNoNA
BEN:Comp Objects Display Name BasisSiteAppNoNoSession
BEN: Cross Business Group for Plan Design CopySiteAppRespYesNoYes
BEN: CWB Approval ModeSiteNoNoSubmission at any time
BEN: CWB Allocation as Percent of Eligible Salary Decimals    
BEN: CWB Budget as Percent of Eligible Salary Decimals    
BEN: CWB Budget Rows DisplayedSiteAppRespUser          
BEN: CWB Download Expire SecondsSiteAppRespUser       YesNo60
BEN:CWB Display Currency TypeSiteAppRespUser       YesNoCorporate Currency
BEN: CWB Encrypt/Decrypt KeySiteAppRespUser       NoNoNA
BEN: CWB Estimated Market PriceSiteAppRespUser       YesNoNA
BEN: CWB History Type DisplaySiteAppRespYesNoBasic Stock History
BEN: CWB Home Plans DisplayedSiteAppRespUser       YesNoNA
BEN: CWB Layout Lock TimeSiteAppRespUser       YesNo10
BEN: CWB Maximum Number of LayoutsSiteAppRespUser       YesNo10
BEN: CWB Plan Context for ReportingSiteYesNoPlan
BEN: CWB Spreadsheet VersionSiteAppRespUser          
BEN:CWB Summary LevelSiteAppRespUser       YesNoNA
BEN:CWB Table PopulationSiteAppRespUser       YesNo 
BEN: CWB Valid Grade FilteringSiteAppRespUser       YesNoYes
BEN: CWB Validate Performance/Assignment Changes OnlineSiteAppRespUser       YesNoNo
BEN: CWB Wizard Compratio RangeSiteAppRespUser       YesNo5
BEN: CWB Wizard Years Worked RangeSiteAppRespUser       YesNo1
BEN: CWB Worksheet Rows DisplayedSiteAppRespUser          
BEN:Designation No ChangeSiteAppRespYesNoNo
BEN:Eligible Profile RuleSiteAppRespYesNoAND
BEN: Enable Absence Plans FunctionalitySiteAppRespYesNoNo
BEN:Enable Quartile in Grade Life EventSiteAppRespYesNoYes
BEN:Imputed Income Post Tax DeductionSiteAppRespUser       YesNoNo
BEN:Max Extract Line SizeSiteAppRespUser       YesNo10000
BEN:VAPRO RuleSiteAppRespYesNoAND
DateTrack:Date SecuritySiteAppRespUser       Viewonly       NoNA
DateTrack:Delete ModeNot in use 
DateTrack:EnabledNote: This profile option applies to Full HR only.AppViewonly       NoYes
DateTrack:Login Date (YYYY/MM/DD)SiteAppRespUser       Viewonly       NANA
DateTrack:Override ModeNot in use 
DateTrack:ReminderSiteAppRespUser       YesNoNo
DateTrack:Update ModeNot in use 
Disable Self-Service PersonalSiteAppRespUser       YesNoNo
Display MessagesSiteAppRespUser       Yes  
Enable Security GroupsSiteAppNoYesSecurity groups are not enabled
Flexfields:Open Descr WindowSiteAppRespUser       YesYesYes
Flexfields:Open Key WindowSiteAppRespUser       YesYesYes
Help Localization CodeRespUserYesYes, by HRMSThe Responsibility is associated with the Global set of help files rather than a localized or verticalized set.
HR: Absence Duration Auto OverwriteSiteRespNoNoNo
HR: Absence Start DateSiteAppRespUser       NoNoThe start date of the Absence being recorded on the Absence form
HR: Absence View LayoutSiteAppRespUser       YesNoFORM or TABLE
HR: Access Non-Current Employee DataSiteRespNoNoNo
HR: Accrual Plan Element Set Displayed to UserSiteAppRespUser       YesNoNull
HR:Action Parameter Group NameSiteAppRespUser       Yes  
HR: Actions – Validation       SiteAppRespUser       YesNoValidate all Functions
HR:Allow Approver Updates to Self Service ActionsSiteNoNoNo
HR:Allow Concurrent Self Service ActionsSiteNoNoNo
HR:Allow Concurrent Self Service ActionsSiteNoNoNo
HR:Allow Concurrent Self Service ActionsSiteNoNo 
HR:Allow Functions Access During Hrglobal RunView onlyViewonly       NoNo
HR:Allow Online W-2 Viewing as of (MM/DD)       SiteAppRespUser       Yes  
HR:Allow Processing of Ineligible Self Service ActionsSiteNoNoNo
HR:Allow Use of Eligibility for Self Service ActionsSiteNoNoNo
HR: Applicant Assignment Cleanup Run ModeSiteNoNoIn Patch Process
HR: Applications View LayoutSiteAppRespUser       Viewonly       NoFORM or TABLE
HR: Appraisal Template LovSiteAppRespUser       YesNoNo
HR: Appraisee Can Add ParticipantsSiteAppRespUser       NoNoYes
HR: Assignment IDInternal use only. 
HR: Authoria Integration EnabledSiteAppRespUser       YesYes (if linking to Authoria HR)No
HR: Authoria UK URLSiteNoYes (if linking to Authoria HR) 
HR: Authoria US URLSiteNoYes (if linking to Authoria HR) 
HR: Auto Apply Collective Agreement EntitlementsSiteAppRespYesYesNo
HR: Auto Evaluate Collective Agreement EntitlementsSiteAppRespNoYesNo
HR: Automatically synchronize single GL company cost centers with HRSiteYesYesNo
HR: Base Salary RequiredSiteNoNoNull
HR: BIS Job Hierarchy – Job Grouping Level 1SiteNoNoNull
HR: BIS Job Hierarchy – Job Grouping Level 2SiteNoNoNull
HR: BIS Reporting HierarchyObsolete. 
HR:Blank Effective Date       SiteAppRespUser       YesNoNo
HR:Business GroupSiteRespViewonly       YesDefault Setup Business Group at Site level.
HR: Cancel ApplicationSiteAppRespViewonly       NoDefault is Null. This is interpreted by the system as No.
HR: Check Entitlement CacheSiteAppRespNoYesYes
HR: Collective Agreement LoggingSiteAppRespUser       YesYesLow
HR:Contingent Worker Manager Actions MenuSiteAppRespUser       YesYesContingent Worker Manager Actions Menu
HR:Contingent Worker Personal Actions MenuSiteAppRespUser       YesYesContingent Worker Personal Actions Menu
HR: Copy period details for budgetSiteAppRespUser       YesNoDefault is No.
HR:Cross Business GroupSite AppRespViewonly       NADefault is No.
HR: Cross BG Duplicate Person CheckSiteAppRespNoNoYes
HR: CWK in Head Count ReportsSiteAppRespUser       YesNoYes
HR: Data Exchange DirectorySiteAppRespViewonly       No 
HR: Data Migrator Business Group Lockout       SiteNoNANA
HR:Data Pump Action Parameter GroupSiteAppRespUser       YesNoNull
HR: Date FromInternal use only. 
HR:Default Assignment CostingSiteAppRespUser       YesNo.
HR:Default Check/Cheque Number MethodSiteAppRespUser       YesNoNull
HR: Default Correspondence LanguageSiteAppRespUser       YesNoNo default.
HR: Default Full Name FormatSiteAppRespUser       Viewonly       NoSurname Prefix Initials Prefix (Partner) Surname (Partner)
HR: Default NationalitySiteAppRespUser       YesNoNA
HR: Defer Update After ApprovalSiteAppRespUser       YesYesYes
HR: Disable Ethnicity TabSiteAppRespUser       Viewonly       NoEnabled
HR: Disallow Template ReferenceSiteAppRespUser       Yes  
HR: Display All Candidate OffersObsolete. 
HR:Display CompetenciesSiteApprespYes  
HR:Display Brief Person NameSiteNoNoNo
HR:Display Person NameSiteAppRespUser       YesNoBrief Name
HR:Display Person SearchSiteAppRespUser       YesNoYes
HR: Display Position HierarchySiteNoNoNo
HR:Employee Directory Global MenuSiteNoNoEmployee Directory Global Menu
HR: Employment View LayoutSiteAppRespUser       YesNoFORM or TABLE
HR:Enable Bank Branch ValidationSiteAppRespUser       YesNoNull
HR: Enable Initiator to Delete a Pending-Approval TransactionSiteAppRespUser       YesNoNo
HR:Enable Security for Batch Element EntrySiteAppRespUser       YesYes
HR: Enable DTW4 defaulting Note: This profile option is US legislation specific profile related to tax rules and works with Full HR only.SiteViewonly       NoYes
HR:Enable Multiple Assignments in SSHRSiteAppRespUser       YesNoNo
HR:Enforce Costing Mandatory Segment Check at Data EntrySiteAppRespUser       Yes Default is Null. This is interpreted by the application as No.
HR:Execute Legislative Check Formula within RunSiteAppRespUser       YesNoNA
HR: Expand Role of Contingent WorkerSiteYesYesDefault is Null. This is interpreted by the application as No.
HR: Extension AgentSiteUserNoNo 
HR: Extension Agent Client Timeout YesNoNA
HR: Extension Agent EnabledSiteNoYes (if using Info online)No
HR: FastFormula Debug LevelSiteAppRespUser       YesNANA
HR: Free text school name allowed in Self ServiceSiteAppRespUser       YesNoNull
HR:French HRMS check mandatory payroll assignment attributes existSiteAppRespUser       Yes Yes
HR: FTE Factor    
HR: GL Cost Center Org ClassificationsSiteViewonly       Yes (if you want to use Auto Orgs to synchronize GL cost centers with HR)None
HR: GL Cost Center Synchronization Options       SiteViewonly       No – This profile option is obsolete.NA
HR: GL Organization Name FormatSiteViewonly       Yes (if you want to use Auto Orgs to synchronize GL cost centers with HR)NA
HR:Global Competence Flex StructureSiteViewonly       Yes (if you want to create global competencies)       NA
HR:Grade Key Flex-Identify 1st SegmentSiteAppRespYesNoNA
HR:Grade Key Flex-Identify 2nd SegmentSiteAppRespYesNoNA
HR:HR/Payroll Representative SourceSiteViewonly       NoNo default
HR:Hide Work Phone on Person Obsolete. 
HR:IE P35 Reporting YearSiteYesYesNA
HR: Info Online: Open in New Window NoNo 
HR: Info Online: RIA PasswordSiteAppRespUser       Yes  
HR: Info Online: RIA UsernameSiteAppRespUser       Yes  
HR: Info Online Toolbar IconNANANo 
HR: Info Online: Use Field ContextSiteAppRespUser       Yes  
HR: Informal Name FormatSiteNoNoNA
HR:Job Key Flex-Identify 1st SegmentSiteAppRespYesNoNA
HR:Job Key Flex-Identify 2nd SegmentSiteAppRespYesNoNA
HR: Job LevelSiteAppRespNoNoNA
HR: KI Framework VersionSiteAppRespUser       YesYesDefault is Null. This is interpreted by the system as Version 1.
HR: KI Maximum Topics and IntegrationsSiteAppRespUser       YesNoDefault is Null. This is interpreted by the system as Version 3.
HR: Class Name to Fetch KI DataSiteNoYes (if linking to Enwisen)Default is Null.
HR: KI Providers EnabledSiteRespUserYesNoDefault is No.
HR: KI User Options EnabledSiteRespUserYesNoDefault is No.
HR: KI Topics EnabledSiteRespUserYesNoDefault is Null. This is interpreted by the application as Yes.
HR: Enwisen Login URLSiteNoYes (if linking to Enwisen)Default is Null.
HR: Local or Global Name FormatSiteAppRespUser       YesNoLocal Format
HR: Localization in SSHRValid for SSHR 3.4 only. 
HR: Location IDInternal use only. 
HR: Local NationalityNo default value exists, and the system administrator can set the value at any level.
HR:Manage Self Service Actions When Future-Dated Changes ExistSiteNoNoStop with an Error
HR:Manager Actions MenuSiteAppRespUser       YesYesManager Actions Menu
HR: Manager Appraisals MenuSiteAppRespUser       YesNoManager Appraisals Menu
HR: Mask CharactersSiteAppRespUser       No  
HR: Metalink Integration ApplicationSiteAppRespUser       YesNoHuman Resource Management Systems
HR: Metalink Integration EnabledSiteAppRespUser       YesNoYes
HR:Monitor Balance RetrievalSiteAppRespUser       YesNo 
HR:NI Unique Error or WarningSiteRespNoNoNA
HR:National Identifier ValidationSiteAppRespUser       NoNoError on Fail
HR:Non-Updateable Element SetSiteAppRespUser       YesNoNA
HR: Number SeparatorSiteNoNoNA
HR:OAB New Benefits ModelSiteAppRespUser       YesNoNA
HR: Offers – Hiring Manager InitiationObsolete 
HR:Online Tax Forms Update MethodSiteUserViewonly       NoAll
HR: Organization IDInternal use only. 
HR: Override Grade DefaultsSiteAppRespUser       YesNoDefaults to Yes
HR:Payroll Payments Self-Service Enable Multiple AssignmentsSiteAppRespUser       YesNoNo
HR:Payroll Payments Self-Service Payment FunctionSiteAppRespUser       YesNo 
HR:Payroll Payments Self-Service Payments List ModeSiteAppRespUser       YesNoNull
HR:Performance View LayoutSiteAppRespUser       YesNoFORM or TABLE
HR: Person IDInternal use only. 
HR:Personal Actions MenuSiteAppRespUser       YesYesPersonal Actions Menu
HR:Personal Info Check PendingObsolete. 
HR: PL NI Unique Error or WarningSiteAppRespUser       YesYesWarn
HR:Position Key Flex-Identify 1st SegmentSiteAppRespYesNoNA
HR: Position Default Options for SSHRSiteAppRespUser       YesYesDefault with User Decision
HR:Position Key Flex-Identify 2nd SegmentSiteAppRespYesNoNA
HR:Propagate Data ChangesSiteYesNoDefault is Null. This is interpreted by the application as No.
HR:Purge Element Entry PermissionSiteAppRespUser       Viewonly       NANA
HR:Query Only ModeSiteAppRespUser       Viewonly       NoNA
HR: Refresh Self Service Actions with Data from Intervening ActionsNoNoNoNo
HR: Restrict Letter by Vacancy or EventSiteViewonly       NoDefault is Null
HR:Restrict Transactions across Legislations for SSHRSiteRespNoNoNo
HR: RIA Integration EnabledSiteAppRespUser       YesNoYes
HR:Run BENMNGLE When Processing a Self Service ActionSiteNoNoNo
HR:Salary View LayoutSiteAppRespUser       YesNoFORM or TABLE
HR: Save and Stay in Appraisals PageSiteUserYesNoYes
HR: Schedule Based Absence CalculationSiteRespNo  
HR: Security ProfileSiteRespNoYesDefault view-all security profile at Site level
HR: Security Performance EnhancerResponsibilityNoNoNo
HR: Self Service HR LicensedSiteNoNoDefaults to No
HR:Self Service Hire and Placement Default ValuesSiteAppRespUser       No Yes
HR:Self-Service Save for LaterSiteNoNoYes
HR: Servlet TimeoutSiteAppRespUser       YesNoDefault is Null. This is interpreted by the system as 40 (seconds).
HR: SM Employee Find Work Opp MenuRespNoYesHR_SM_EMP_PERSONAL_FUNCTIONS  
HR: SM Manager Find Person MenuRespNoYesHR_SM_MANAGER_FUNCTIONS
HR: SM Manager Find Work Opp MenuRespNoYesHR_SM_PERSONAL_FUNCTIONS
HR:SubrogationSiteAppRespUser       YesNoNo
HR: Supervisor Hierarchy UsageSiteYesNo 
HR:TCA Unmerge OptionsSiteNoNoIn Patch Process
HR:Training View LayoutSiteAppRespUser       YesNoFORM or TABLE
HR: US Address Line LengthSiteAppRespUser       YesYesNA
HR: Use Fast Formula Based PTO AccrualsSiteNoYesNo
HR:Use Global Applicant NumberingSiteViewonly       YesNo
HR:Use Global Contingent Worker NumberingSiteViewonly       YesNo
HR:Use Global Employee NumberingSiteViewonly       YesNo
HR:Use Grade DefaultsSiteAppRespUser       Viewonly        Defaults to Yes
HR:Use Standard AttachmentsSiteAppRespUser       NoYesYes at Site Level, No at Seeded Responsibility Level
HR:User TypeAppRespViewonly       YesNA
HR: Use Title in Person’s full nameSiteNoNAYes
HR: Verification External NodeSiteRespNoYesNo default value
HR: View Payslip From Date for WEB (MM/DD/YYYY)SiteAppRespUser       YesYes01/01/1997
HR:View Unpublished Employee 360 Self AppraisalSiteAppRespYesNoDefault value is Null
HR: Views Layer SizeSiteAppRespUser       YesYes300 pixels
HR:Webapps Tips Test ModeUserYesNoNo
HR: Web Proxy Host No  
HR: Web Proxy Port No  
HR: Worker Appraisals MenuSiteAppRespUser       NoYesEmployee Appraisals Menu
HR: ZA Nature of Person Mandatory at Person LevelSiteAppRespUser       YesNo 
HRI: Collect Manager SnapshotsSiteNoYesYes
HRI: Collect Open Enrollment in ProgressSiteNoYesNo
HRI:DBI Chief HR Officer Named UserSiteNoYesNo
HRI:DBI Force Foundation HR ProcessesSiteNoYesNo
HRI:DBI Link to Transaction SystemSiteNoYesDisable Link
HRI:Enable Benefits Collections and Event QueueSiteNoYesYes
HRI:Enable Captured Events ArchiveSiteNoYesNo
HRI:Enable Detailed LoggingSiteNoYesNo
HRI: Manager Snapshot ThresholdSiteNoYes2500
HRI:Multithreading Chunk SizeSiteNoYes200
HRI:Number of Threads to LaunchSiteNoYes8
HRI:Period of Service / Placement Date Start SourceSiteNoYesStart Date
HRI:Populate Assignment Events QueueSiteNoYesYes
HRI:Populate Supervisor Hierarchy Events QueueSiteNoYesYes
HRI:Populate Supervisor Status History Events QueueSiteNoYesYes
HRI: Workforce in Period Calculation MethodSiteNoNoNull
HZ: Protect HR Person InformationSiteNoNoNo
Limit By Persons OrganizationSiteAppRespUser       YesNoNo
OAB: Enable Self-Service Benefits Trace YesNoNull
OAB:Self Registered User ResponsibilitySiteAppRespUser       YesNoSelf Registered Employee Default responsibility
OAB:User to Organization LinkSiteAppRespUser       YesNoNull
OAB:User to Payroll LinkSiteAppRespUser       YesNoNull
PAY: Enable Workflow for Assignment CostingSiteAppRespUser       View onlyNoNull. A system administrator can set the value at any level.
PAY: Display Reset Years in PayrollSiteAppRespUser       YesNoNo
PAY: Generate Periods for Tax YearSiteAppRespUser       Yes  
PAY:Statement of Earnings User CategorySiteRespUserYes  
PER:Automatic SaveSiteYes  
PER:NavigationSiteYes  
Personalize Self-Service DefnSiteAppRespUser       YesNoNo
PO: Services Procurement EnabledSiteViewonly       NoNo
Performance Management Source TypeSiteNoYes (if you enable automatic update of competency profiles)NA
Workforce Measurement TypeSiteNoYes

Profile Options

Apply Assessment Competencies to Person

Controls whether HRMS updates an appraisee’s competency profile automatically when an appraisal is complete. Set this option to Yes to enable automatic update of competency profiles.

AME:Installed

Determines whether Oracle Approvals Management (AME) is installed. Integrating applications such as Internet Expenses or iProcurement use this profile option to indicate if AME is installed.

AuditTrail:Activate

Determines whether the AuditTrail functionality is enabled or disabled.

When you enter or update data in your forms, you change the database tables underlying the forms you see and use. AuditTrail tracks which rows in a database table were updated at what time and which user was logged in using the form(s).

You can turn AuditTrail on or off (Yes or No). The default setting is No. You must set this option to Yes before you can audit any Oracle Applications table.

BEN:BEN HOURLY ANNUALIZATION FACTOR

Determines how to convert an hourly rate to an annual rate, and vice versa, if you want to use the Hourly activity reference period for Compensation Workbench plans. The default value is 2080 hours (8 hours * 5 days * 52 weeks).

BEN: Carry Forward Certification

Determines if benefits administrators can carry forward interim and suspended coverage created due to coverage restrictions configured for a life event when subsequent life events do not have coverage restrictions.

BEN:Benefits Preferred Currency

Controls the preferred currency in which a manager views and enters budget and worksheet distributions for the Compensation Workbench. Actual amounts are paid in the currency of the Compensation Workbench plan, not the preferred currency.

BEN: Check Enrollment Limits

Determines if the application should execute the check for minimum and maximum Plan Type in Program when an event is processed and the person cannot make elections.

BEN:Compensation Manager

Gives access to features in the Compensation Workbench that are available only to Compensation Managers.

BEN:Comp Objects Display Name Basis

Determines whether the compensation object names displayed in various application windows (both in the professional and self-service user interfaces) are based on the user’s session date or the life event occurred on date.

BEN: Cross Business Group for Plan Design Copy

Controls whether a user can copy plan design data between business groups using the Plan Design Copy function. The default value for the profile option is ‘Y.’ If you set the value to ‘N,’ the user will only be able to export a plan design or copy the plan design within the business group attached to their responsibility.

Ben: CWB Approval Mode

Controls CWB Approval behavior. If you set the value to ‘Y,’ then the CWB Approval Mode enables you to enforce the submission and approval of all lower-level manager worksheets before higher-level managers may submit their worksheets for approval. The default approval mode allows the submission of a worksheet by a higher-level manager at any time regardless of the status of the lower-level manager worksheets.

BEN: CWB Allocation as Percent of Eligible Salary Decimals

Determines if the application displays decimals for percent of eligible salary based on allocated amounts.

BEN: CWB Budget as Percent of Eligible Salary Decimals

Determines if the application displays budgets as percent of eligible salary

BEN: CWB Budget Rows Displayed

Controls the number of rows available for display on budgetsheets, for example, if you set the profile option to 10, then managers and compensation administrators can choose to display between 1 and 10 rows on their budgetsheets.

Note: This profile option is available only in Oracle Applications Release 12

BEN: CWB Download Expire Seconds

Specifies the length in seconds available to download worksheets. The default value is 60 seconds. Increase this value if you have problems downloading large worksheets.

BEN:CWB Display Currency Type

Determines the last selected currency in Compensation Workbench for each manager. The application displays this value the next time managers log into CWB.

BEN: CWB Encrypt/Decrypt Key

Determines the key the application uses to decrypt security key information for downloaded Compensation Workbench worksheets. You can modify this key to any characters, however you must not change the key between a download and an upload.

BEN: CWB Estimated Market Price

This profile controls the estimate market price that the application uses to calculate the walk-away value of stock option grants. This is the default value of the market price that displays on the Extended Stock Option History page and Employee Stock Option History Report. Managers can override the value in CWB, which is retained for the session. However, the value defaults to the profile value upon re-login or session loss.

BEN: CWB History Type Display

Set this profile option to Extended Stock Option History for use with the Employee Stock Options Total Position Report. If you load stock history from a third party administrator into Oracle HRMS, you can use the Grant Detail Report Style of the Total Position Report to view details about grants held by individual employees.

BEN: CWB Home Plans Displayed

This determines how many plans the application displays on the home page before table navigation links display. The recommended value is 5 or more.

BEN: CWB Layout Lock Time

BEN: CWB Maximum Number of Layouts

BEN: CWB Plan Context for Reporting

Determines the Plan Name and Period that the application uses to obtain the Manager Hierarchy and Employee Information for the Reports available from the CWB Home Page. If you do not specify a Plan Name and Period, then the application uses the latest plan for which the manager is a participant. The Employee Stock Option History, and Employee Compensation History use this profile option.

BEN: CWB Spreadsheet Version

Controls the versions of MS Excel available for download of spreadsheets from CWB.

Note: This profile option is available only in Oracle Applications Release 12.

BEN:CWB Summary Level

Determines the last viewed display of the worksheet summary for each manager. The application displays this value during the next session. By default, this is set to Direct Employees.

BEN:CWB Table Population

Determines the last selected population filter on the worksheet. The application displays this value during the next session. By default, this is set to Direct Employees.

BEN: CWB Valid Grade Filtering

Determines if the application validates grades. If you set this profile to Yes (default), then the application displays only valid grades for a proposed job/position within the business group. If you set this profile to No, then the application displays all grades for the business group.

BEN: CWB Validate Performance/Assignment Changes Online

Determines if the application validates assignment changes online. If you set the profile option to Yes, then you enable assignment API edits for the worksheet and the application enforces the integrity between jobs, positions, and grades. If you set this profile option to No (default), then API edits are not online and the Compensation Workbench Post Process validates all assignment changes.

BEN: CWB Wizard Compratio Range

Determines the incremental range that displays on all pages using comparatio criteria. For example if you use 5, then the application displays comparatios in 5% ranges. The Allocation Wizard criteria option, the Employee Stock Option History report, the Employee Compensation History report, and the Summary By Directs report use this profile option. The default value is 5.

BEN: CWB Wizard Years Worked Range

Determines the incremental range that displays on all pages using Years Worked criteria. For example if you use 5, then the application displays the Years Worked in 5 Year Ranges. The Allocation Wizard  criteria option, the Employee Stock Option History report, Employee Compensation History report, and the Summary By Directs report use this profile option. The default value is 1.

BEN: CWB Worksheet Rows Displayed

Controls the number of rows available for display on worksheets, for example, if you set the profile option to 10, then managers and compensation administrators can choose to display between 1 and 10 rows on their worksheets.

Note: This profile option is available only in Oracle Applications Release 12.

BEN: Designation No Change

Determines the contents of the Dependent Eligibility Audit log. If you set the profile option to No (the default value), the audit log returns information only for dependents with eligibility changes. If you set it to Yes, the audit log returns all dependents, even if they have no eligibility change.

BEN:Eligible Profile Rule

Controls how FastFormula rules are evaluated in an eligibility profile. The default value is AND. This means that a participant must satisfy all the rules you attach to an eligibility profile. If you set the profile option to OR, the participant need only satisfy one of the rules.

BEN:Enable Absence Plans Functionality

Displays the Enroll Absences button on the Absence Detail window. If you set this profile option to Yes for the users or responsibilities who will enter absences for absence benefit plans, they can run the Participation Process to process the absence life events.

BEN:Enable Quartile in Grade Life Event

Detemines whether the system triggers the Quartile in Grade Life Event when a change in a person’s grade, salary basis, or salary moves them into a new quartile in grade. If you set this profile option to Yes, these conditions trigger the Quartile in Grade life event. If you set this profile option to No, the system never creates a Quartile in Grade potential life event.

BEN:Imputed Income Post Tax Deduction

Controls whether after-tax employee contributions are deducted from the imputed income total for a benefits plan subject to imputed income. If you set this profile set to N (the default value) the application assumes that the employer pays 100% of the given benefit.

BEN:Max Extract Line Size

Sets the maximum length of a record generated by the Extract Write Process for compensation and benefits system extracts.

BEN:VAPRO Rule

Controls how FastFormula rules are evaluated in a variable rate profile (VAPRO). The default value is AND. This means that a participant must satisfy all the rules you attach to a variable rate profile. If you set the profile option to OR, the participant need only satisfy one of the rules.

DateTrack:Date Security

Controls the way users can change their effective date:

  • All (users can change to any date)
  • Past (users can change to dates in the past only)
  • Present (users cannot change their effective date)
  • Future (users can change to dates in the future only)

The meaning of Past and Future here is with respect to the user’s login date, which is usually today’s date, but may be set to another value by the DateTrack:Login Date profile option.

See: How DateTrack Works, Oracle HRMS Implementation Guide

DateTrack:Enabled

Controls whether the DateTrack functionality is enabled. Set to Yes at the Application level for Oracle HRMS.

Important: This profile option applies to Full HR only. If you are installing Shared HR, the profile option value must be set to No.

See: How DateTrack Works, Oracle HRMS Implementation Guide

DateTrack:Login Date (YYYY/MM/DD)

Defines the log-in date for a user. Normally a user logs onto the system with an effective date of today’s date. Use this profile option to change a user’s default date to another date. This profile option works in conjunction with DateTrack:Date Security. For example, if a user has DateTrack:Date Security set to Future and DateTrack:Login Date set to 1900/01/01, they can change their effective date to any date after January 1 1900, but not before.

DateTrack:Reminder

Determines whether the Decision window appears when you open a window in which you can enter, update, or delete datetracked information. Notice that the Decision window never appears on windows where you can query datetracked information but not update it. There are three possible values:

  • Always (the window always appears)
  • Never (the window never appears)
  • Not Today (the window appears only if the effective date is not the system date)

Disable Self-Service Personalizations

Controls whether personalizations created for self-service functions using the Personalization Framework are applied. If the profile option is Yes, no personalizations are applied and only the original definition of each self-service page is displayed.

This profile option is used in SSHR.

Enable Security Groups

Controls whether you use multiple security groups. There are three possible values for the profile:

  • No – If using standard security
  • Y – If using multiple security groups
  • Hosted – Reserved for use by VPD Hosting implementations

Change the profile option to Yes at application level only if your enterprise is implementing a Security Groups Enabled system (multiple security groups). If you change the profile option to Yes, you must run the Enable Multiple Security Groups process. See Security Models.

Important: Once you have changed to Security Groups Enabled Security you cannot revert to the Standard Security model.

Note: Non-HRMS applications do not support multiple security groups in Release 11i.

Flexfields:Open Descr Window

Determines whether a descriptive flexfield window automatically opens when you navigate to the corresponding field.

Set the profile option to Yes if you want the flexfield to pop open automatically. If you set this option to No, you can open the flexfield by choosing Edit Field from the Edit menu or pressing CTRL+L.

Flexfields:Open Key Window

Determines whether a key flexfield window automatically opens when you navigate to the corresponding field.

Set the profile value to Yes if you want the flexfield to pop open automatically. If you set this option to No, you can open the flexfield by choosing Edit Field from the Edit menu or pressing CTRL+L.

Help Localization Code

Controls which set of help files are linked to each responsibility. If you accept the default value, then the set of help files for Global HRMS will be associated with the responsibility. However, if you want to specify a legislative or vertical variant of HRMS, then you must set the Help Localization Code as shown in the following table:

Help Localization Code     Localization       
AEUAE
AUAustralia
BEBelgium
CACanada
CNChina
DEGermany
DKDenmark
ESSpain
FDUS Federal
FIFinland
FRFrance
HKHong Kong
HUHungary
IEIreland
INIndia
ITItaly
JPJapan
KRKorea
KWKuwait
MXMexico
NLNetherlands
NONorway
NZNew Zealand  
PLPoland
RURussia
SASaudi Arabia  
SGSingapore
SESweden
UKUK
USUS
ZASouth Africa

Note: These entries must be in upper case.

HR: Absence Duration Auto Overwrite

Controls whether the absence duration formula automatically recalculates the duration of an absence when the date or time of the absence is changed. Set the profile option to Yes if you have created an absence duration formula (or one is supplied by your localization team) and you want absence durations to be recalculated automatically.

See: Absence Recording, Oracle HRMS Compensation and Benefits Management Guide

HR: Absence View Layout

Controls whether a manager sees the Detail Summary View in a Form or Tabular Format.

This profile option is used in SSHR.

HR: Access Non-Current Employee Data

Controls the display of records of ex-employees and future dated employees. Set the profile option value to Yes to enable HR users to view data of ex-employees and future dated employees if you are using user-based security.

Note: This profile option does not apply to security profiles based on the supervisor hierarchy. You can use this profile option if your security profiles are based on user-based organization security, or user-based position security, or user-based custom security. For information on user-based security, see: Security Profiles

HR: Accrual Plan Element Set Displayed to User

Enables the display of accrual balances in the SSHR Leave of Absence page, when you attach the required element set to this profile at the appropriate levels.

See: Viewing Accrual Balances in SSHR, Oracle SSHR Deploy Self-Service Capability Guide

HR:Action Parameter Group Name

Identifies the set of action parameter values for all payroll processes supported by the Action Parameter group. You use action parameter values to control the process run, for example, to enable parallel processing, to control the number of API batch calls, and to specify the number of errors allowed before the process run fails.

See: Maintaining Parameters and Parameter Groups for Payroll Processes, Oracle HRMS Implementation Guide

HR: Actions – Validation

Controls the point at which the application runs validation checks for Pending workflow transactions within SSHR. The validation can be carried out using one of the following options:

  • All actions are validated
  • Only the preselected action is validated. The other actions are validated after selection.
  • All actions are validated after selection.

This profile option is used in SSHR.

HR:Allow Approver Updates to Self Service Actions

Controls whether an approver can make updates to self-service actions. The self-service actions functionality uses Oracle Approvals Management (AME) to determine the list of approvers for the action. If you set this profile option to No, the approver can approve or reject the action or return the action to a previous approver on the chain after receiving the workflow notification. If you set this profile option to Yes, the approver can also update the action, for example, change the effective date.

See: Approving a Self-Service Action, Oracle SSHR Deploy Self-Service Capability Guide

This profile option is used in SSHR.

HR:Allow Concurrent Self Service Actions

Controls whether Oracle SSHR can process multiple actions on a selected person at the same time. If you set this profile option to No, the Pending column is displayed on the Actions page. This indicates to the user whether pending transactions are present. The user can then review the pending transaction. If you set the profile option to Yes, you allow multiple simultaneous self-service actions. This means that the Pending column is not displayed, and users can perform actions against all assignments. On final approval, each action takes effect on its own effective date, superseding any actions with a previous effective date.

See: Managing Conflicting Actions, Oracle SSHR Deploy Self-Service Capability Guide

This profile option is used in SSHR.

HR: Allow change Hire beyond Payroll actions

Enables payroll users to move the hire date beyond payroll actions. Along with this profile option, you must set the AMEND_HIRE_WITH_PAYACT legislation rule value to Y to enable this functionality. For more information on how to use the profile option and set the legislation rule, refer to note IDs 822228.1 and 1160327.1 on My Oracle Support.

HR:Allow Functions Access During Hrglobal Run

Set this profile option to Yes to enable access to HRMS responsibilities during an hrglobal run.

HR:Allow Online W-2 Viewing as of MM/DD

Enables your employees to view and download their online W-2 statements as PDF files. You specify the month and day from when the employees can view the W-2 statements for the current year.

See: Tax Information Form (W-2) (US), Oracle SSHR Deploy Self-Service Capability Guide

This profile option is used in SSHR.

HR:Allow Processing of Ineligible Self Service Actions

Controls whether self-service users, usually managers, can process ineligible self-service actions. If you set the profile option to Yes, users can process actions for which a selected person is not eligible. They may wish to do this if the action will become eligible by its effective date.

Note: This option depends on also enabling the profile option HR:Allow Use of Eligibility for Self Service Actions in order to display ineligible actions in the first instance.

See: HR:Allow Use of Eligibility for Self Service Actions

See: Set Up Eligibility Processing, Oracle SSHR Deploy Self-Service Capability Guide

This profile option is used in SSHR.

HR:Allow Use of Eligibility for Self Service Actions

Controls whether the Eligibility column is displayed on the Actions page for self-service actions. If you set this profile option to Yes, both eligible and ineligible actions are displayed on the Actions page along with the Eligibility column. The Eligibility column distinguishes between eligible and ineligible actions.

If you set this profile option to No, the Actions page only displays eligible actions and the Eligibility column is not displayed.

Note: Managers will not be able to process ineligible actions unless the profile option HR:Allow Processing of Ineligible Self Service Actions is also set to Yes.

See: HR:Allow Processing of Ineligible Self Service Actions

See: Set Up Eligibility Processing, Oracle SSHR Deploy Self-Service Capability Guide

This profile option is used in SSHR.

HR: Applicant Assignment Cleanup Run Mode

Controls how the HR Applicant Assignment Cleanup script (delivered in PER Family Pack J) is run.

See: Guide to the HR Applicant Assignment Cleanup Process (available on My Oracle Support Note ID 295319.1)

HR:Applications View Layout

Enables a manager to see the Detail Summary View in a Form or Tabular Format.

This User Profile Option is used in SSHR.

HR: Appraisal Template LOV

Controls whether the Appraisal Template field in V3.4 of the SSHR Appraisals function is available as a list of values (LOV) or a poplist. Set this profile option to Yes to display the field as an LOV or set it to No to display the field as a poplist.

This profile option is used in SSHR 3.4.

HR: Appraisee Can Add Participants

Controls whether appraisees can add participants to their appraisals. If yu set this profile option to Yes (the default value), appraisees can add participants. If you set this profile option to No, appraisees cannot add participants.

See: Appraisals (Self-Service), Oracle SSHR Deploy Self-Service Capability Guide

HR: Auto Apply Collective Agreement Entitlements

Controls whether values calculated for a collective agreement during the entitlement evaluation process are applied automatically to an employee. For each entitlement item, the most beneficial value that the employee is entitled to is applied. Instances where the application cannot automatically establish the most beneficial value are noted in the log file and you can manually make a selection using the Collective Agreement Entitlements window.

See: Collective Agreement Administration, Oracle HRMS Enterprise and Workforce Management Guide

HR: Auto Evaluate Collective Agreement Entitlements

Controls whether the entitlement evaluation process is run automatically when an employee is first placed on a collective agreement.

See: Collective Agreement Administration, Oracle HRMS Enterprise and Workforce Management Guide

HR:Automatically Synchronize Single GL Company Cost Centers with HR

Controls whether the Synchronize Single GL Company Cost Centers with HR concurrent program runs automatically following the creation of a new GL account code combination. You use this profile option if you have set the HR: Generate Organizations from GL profile so that organizations are automatically created in HR based on GL cost centers.

See: Implementing Automatic Company Cost Center Creation, Oracle HRMS Enterprise and Workforce Management Guide

HR: Base Salary Required

Controls whether the Description and Salary fields are mandatory if a person’s assignment has a salary basis assigned but no pay proposal. If you set this profile option to Yes, the fields are mandatory. The user must enter values for these fields.

HR: BIS Job Hierarchy – Job Grouping Level 1

Defines the value set that represents the first level job grouping in the Job Hierarchy. Ensure that the value set you select is associated with a Job Key Flexfield structure, otherwise the Job Hierarchy will not use it.

See: Structuring the Job Hierarchy, Oracle HRMS Deploy Strategic Reporting (HRMSi)

HR: BIS Job Hierarchy – Job Grouping Level 2

Defines the value set that represents the second level job grouping in the Job Hierarchy. Ensure that the value set you select is associated with a Job Key Flexfield structure, otherwise the Job Hierarchy will not use it.

See: Structuring the Job Hierarchy, Oracle HRMS Deploy Strategic Reporting (HRMSi)

HR:Blank Effective Date

Controls the default value of the effective date field on the Effective Date page that appears at the start of a self-service action. When you set this profile to Yes, the effective date field is blank. When you set it to No, the page displays the default date.

The default date can differ, depending on:

  • Future-dated changes for the person whose record you are updating
  • The value of the profile HR:Manage Self Service actions when future-dated changes exist

The default date is usually the system date. The default date is the effective date of the future change if (1) you do not enable managing actions and (2) future-dated changes exist.

HR:Business Group

This profile option determines the business group linked to a responsibility. The Setup Business Group is defaulted at Site level.

If you use Standard HRMS security this option is automatically set up when you enter the HR: Security Profile profile option, except in cases where you are using a global security profile (that is, a security profile that does not specify a business group). In this case, you must specifically set up this option for each responsibility.

If you use Security Groups Enabled security, this option is not user-configurable. The business group is determined when you create a security profile assignment using the Assign Security Profile window.

HR: Cancel Application

This profile option enables you to delete an applicant’s record that has been entered in error. The default value is set to Null, this is interpreted as No and the function will not work.

HR: Check Entitlement Cache

This profile option is supplied primarily for Oracle Development or Third Party Suppliers to use. It currently has no impact on delivered functionality.

This profile option enables you to control whether the entitlement evaluation process first looks to see if a value for a particular entitlement exists in the cache before re-evaluating.

HR: Collective Agreement Logging

This profile option enables you to control whether the log file generated during the entitlement evaluation or entitlement population processes shows high or low detail. This profile only affects the processed that run from the Entitlement Results window, The log generated when you run the Collective Agreement Entitlement Evaluation process from the Submit Requests window always displays high detail and is not affected by this profile option.

HR:Contingent Worker Manager Actions Menu

Controls which Manager Actions menu SSHR displays for managers who are also contingent workers. If you create a custom Manager Actions menu for contingent workers, you must change this profile option to point to your custom menu.

See: Actions, Oracle SSHR Deploy Self-Service Capability Guide

HR:Contingent Worker Personal Actions Menu

Controls which Personal Actions menu SSHR displays for users who are also contingent workers. If you create a custom Personal Actions menu for contingent workers, you must change this profile option to point to your custom menu.

See: Actions, Oracle SSHR Deploy Self-Service Capability Guide

HR: Copy Period Details for Budget

You use this user profile option for HRMS budgets. When you set the profile option to Yes, the application copies all budget details (budget periods, budget sets, and funding sources) to a new budget worksheet when the worksheet is a copy of an existing budget version.

HR:Cross Business Group

Controls whether users of some HRMS windows can see certain information for more than one business group.

For example, when defining contacts, you can see contacts in one business group, even if they have been created in another. Similarly, when nominating a supervisor for a person, you can select a supervisor from another business group.

In addition, if you set this option to Yes, it:

  • Enables users to select benchmark jobs from other business groups
  • Checks for the uniqueness of job names across all business groups and issues a warning if you attempt to enter a non-unique name
  • Enforces that there can only be one master job group
  • Enables users to create global competencies and rating scales
  • Controls whether users can select people from other business groups in the following fields in HRMS windows:
    • Absence: authorizing person, replacement person
    • Applicant Assignment: recruiter, supervisor, referred by
    • Assignment: supervisor
    • Organization Manager Relationship: manager – also controls whether organizations from other business groups are available.
    • Events: event participants, internal contact person
    • Employee review: reviewers
    • Requisitions and Vacancies: requisition raised by, recruiter
    • Recruitment Activity: authorized by, internal contact
    • Termination: accepted by

This profile option also controls the filtering of HRMS secure views. If you set this profile option to Yes, secure views display data across all business groups. If you set this profile option to No, the views filter data by the business group of the current security profile.

Note: If you have built custom code that references HRMS secure views, the setting of the HR: Cross  Business Group profile option may affect the functionality of your code.

Set to Yes if users need to see this information across all business groups. Set to No if users only work with the information defined for one business group. The default is No.

HR: Cross BG Duplicate Person Check

Controls the duplicate person check functionality across multiple business groups in Oracle HRMS and Oracle SSHR. Set to Yes to enable the duplicate person check functionality across business groups. Oracle HRMS uses the global name format to search for duplicate person records across business groups.

Note: To use the HR: Cross BG Duplicate Person Check profile option, you must also enable the HR:Cross Business Group profile option.

For information about the global name format (Global List Name), see: Person-Name Formats, Oracle HRMS Workforce Sourcing, Deployment, and Talent Management Guide

The following table explains the searches that Oracle HRMS performs when you set up the HR: Cross BG Duplicate Person Check and HR:Cross Business Group profile options.

Value set for HR:Cross Business GroupValue set for HR: Cross BG Duplicate Person CheckRecords that Oracle HRMS searches to identify duplicate person records
NoNoHR tables in a business group. The application uses the last name, first name, date of birth, or national identifier values to search in HR tables.
NoYesHR tables in a business group. The application uses the last name, first name, date of birth, or national identifier values to search in HR tables.
YesYesHR tables in all business groups and TCA (Trading Community Architecture) tables. The application uses the global name format to search in HR tables.
YesNoThe application does not search for duplicate person records either across multiple business groups or in a single business group.

HR: CWK in Head Count Reports

Determines whether contingent workers are included in head-count reports. The default value is Yes. Set this option to No to exclude contingent workers from head-count reports.

HR: Data Exchange Directory

This profile option is used by Data Uploader and other areas of the system which need to read or import files. Set this profile to the full path for a directory accessible to the Oracle database. Files stored in this directory can then be accessed by Oracle HRMS.

HR: Data Migrator Business Group Lockout

This profile option is for a future release.

HR:Data Pump Action Parameter Group

Data pump may now be configured using action parameter groups instead of the default action parameters. This configuration enables data pump configuration to be separate to that of payroll processes that share action parameters (e.g. the THREADS action parameter) with Data Pump. You can use the HR:Data Pump Action Parameter Group profile option to specify the default action parameter group to use for Data Pump action parameters. HRMS also provides an extra concurrent program parameter to enable the action parameter group to be changed for the Data Pump run.

The default value for this profile option is Null and it is treated as Null in the code (the default action parameter group).

HR:Default Assignment Costing

Set this profile option to Yes to enable default costing for position assignments. For position control budgets, the default value is the proportional value for the budget. You can write a FastFormula to override the budget value with other costing segments and proportions.

HR:Default Check/Cheque Number Method

Use this profile option to set the automatic check/cheque number process. You can set this profile with the Organization Payment Level value to enable automatic check/cheque numbering. This profile option is for US and Canadian Payroll only.

HR: Default Correspondence Language

Specifies a default language for the Correspondence Language field.

This profile option is for users of the Italian legislation only.

HR: Default Full Name Format

Controls the default value for the full name format.

This profile option is for users of the Dutch legislation only.

HR: Default Nationality

Defines the default nationality for a user. When a new person is entered in the People window, the nationality entered here is automatically displayed in the Nationality field.

HR: Defer Update After Approval

Defers save of SSHR transactions after the final approval. The transaction is saved automatically when the Workflow Background Proces runs.

This applies to Self Service.

HR: Disable Ethnicity Tab

Enables you to disable the ethnicity tab in the People window.

This profile option is for users of the Dutch legislation only.

HR:Display Competencies

Controls the display of competencies in an Advanced Search. It is used to control the display of skill categories in:

  • Apply for a Job
  • Enroll in a Class

This User Profile Option is used in SSHR.

HR:Display Brief Person Name

By default this profile option is set to Brief Name, which means that on the Enter Process pages, employee names are displayed in brief format. If you prefer to see the full employee name, set this profile option to Full Name.

HR: Display Position Hierarchy

If set to Yes position hierarchy will be used in the HGrid on the Enter Process page in SSHR. By default the HGrid uses supervisor hierarchy.

HR:Employee Directory Global Menu

Enables you to specify a menu to provide global buttons in addition to the standard Self Service Global Menu buttons if a user accesses the Employee Directory anonymously. You can specify any menu with the menu type Global Menu.

See: The Employee Directory Module, Oracle SSHR Deploy Self-Service Capability Guide

HR: Employment View Layout

Enables a manager to see the Detail Summary View in a Form or Tabular Format.

This User Profile Option is used in SSHR.

HR:Enable Bank Branch Validation

Set this profile option to Yes to turn the Sort Code validation on and off. Sort Code will only appear for territories, for example GB, where branch code validation is supported. You disable the validation if you don’t set this profile option or set it to N.

Note: Note: As this profile option is a global profile option, you should take care in a multi-territory Oracle HRMS implementation not to set it on with too wide a scope.

HR: Enable DTW4 defaulting

This profile option is for use by US and Canadian customers who use Vertex geocodes data to validate US and Canadian addresses. It enables or disables the defaulting of DTW4 employee tax data when an employee primary address or work address is changed. For example, set this option to No to prevent DTW4 data from being defaulted when an employee address is changed to an overseas address.

The default is Yes. This option can be set at site level only.

Important: This profile option is US legislation specific profile related to tax rules and works with Full HR only. If you are installing Shared HR, the profile option must be set to No.

HR: Enable Multiple Assignments in SSHR

Controls whether a manager can view and update multiple assignments for an employee in SSHR. If you set the profile option to Yes, all the assignments of a person are displayed on the Hierarchy page. If you set the profile option to No, only primary assignments are displayed.

See: People in Hierarchy, My List, and Search Pages, Oracle SSHR Deploy Self-Service Capability Guide

This profile option is used in SSHR.

HR: Enable Initiator to Delete a Pending-Approval Transaction

Determines whether managers or workers can delete any transactions that they have initiated before approval in Oracle SSHR. If you set this profile option to Yes, then the initiator of the transaction can view the transaction in the list of Pending-Approval action items or in the All Actions Awaiting Your Attention table, and use the Delete icon to remove that transaction. The default value is No.

For information about the delete transactions pending approval functionality, see: Self-Service Functionality, Oracle Self-Service Human Resources Deploy Self-Service Capability Guide

HR: Enable Security for Batch Element Entry

Enables you to prevent unauthorized viewing and updating of batch lines for a confidential assignment by setting the profile option to Yes.

HR: Enforce Costing Mandatory Segment Check at Data Entry

Set this profile option to Yes to specify that users must enter a value for a mandatory costing segment at each costing level where it is qualified.

HR: Execute Legislative Check Formula within Run

Determines whether the legislation-specific check is performed during a payroll run.

HR: Expand Role of Contingent Worker

Determines whether you can select contingent workers to perform many of the roles fulfilled by employees. For example, if you set this option to Yes, you can select a contingent worker to be a supervisor in the Assignment window and an authorizer in the Absence window.

You can select a contingent worker to fulfill the following roles:

  • Supervisor
  • Recruiter
  • Interviewer
  • Cost center manager
  • Reviewer
  • Event attendee
  • Termination authority
  • Manager
  • Preparer
  • Requester
  • Approver
  • Buyer

HR: Extension Agent

If you are using Info Online to allow users to access to information provider web sites from a button on the Oracle toolbar, use this profile option to launch dynamic content via a web server different from the one specified by the Applications Servlet Agent.

HR: Extension Agent Client Timeout

If you are using Info Online to allow users to access information provider web sites from a button on the Oracle toolbar, this profile sets the maximum time in seconds that the system waits to contact the web server mediating the connection to Authoria HR.

You should not set this value unless asked to do so by Support.

HR: Extension Agent Enabled

If you are using Info Online to allow users to access information provider web sites from a button on the Oracle toolbar, this profile option controls whether or not the feature is enabled for a user or group of users. Set to Yes to enable the feature and display the Info Online button on the Oracle toolbar. Set to No to disable the feature and hide the button.

This is similar to the way that Applications Help Web Agent acts as an override to the default.

HR: FastFormula Debug Level

Enables debugging information to be output from the FastFormula compiler and execution engine.

HR: Free text school name allowed in Self Service

If this profile option is set to No, the user will not be able to enter text freely for the school name. Instead their entry will be restricted to a list of values. If the profile option is set to Yes they can enter free text, or choose from the list of values.

HR:French HRMS check mandatory payroll assignment attributes exist

Determines whether to perform the mandatory checks for establishment, contract, and employee category attribution on payroll assignments when your business group is French.

HR: FTE Factor

Determines the FTE (Full Time Equivalent) factor that the application uses to calculate full-time annual pay. You can set the option to:

  • Budget Full Time Equivalent – if you select this, then the application determines the FTE based on the information in the FTE factor unit in the Budgets region of the Person Assignment window.
  • Budget Percent of Full Time – if you select this, then the application determines the FTE based on the information in the Head Count factor unit in the Budgets region of the Person Assignment window.
  • No Conversion – if you select this, then the application uses an FTE factor of 1 so that no conversion occurs. This is the default value.
  • Normal Hours/Business Group Working Hours – if you select this, then the application determines the FTE based on the information in the Working Hours fields in the Standard Conditions region of the Person Assignment window. To calculate FTE, the application divides the person’s working hours by the business group’s working hours.

HR: GL Cost Center Org Classifications

This profile option defines which organization classifications are created when you synchronize your GL cost centers with your organizations in HRMS. It has the following settings:

  • None
  • Company Cost Centers
  • HR Organizations and Company Cost Centers

HR: GL Cost Center Synchronization Options

This profile option is obsolete.

HR: GL Organization Name Format

This profile option enables you to define the name format for organizations created automatically in HRMS based on a GL cost center.

HR:Global Competence Flex Structure

Defines the competence key flexfield structure for use when creating global competencies. If you do not set this option, then you cannot create global competencies.

HR:Grade Key Flex-Identify 1st and 2nd Segments

These options are used to control which two segments of the key flexfields appear in Person Search.

This profile option is used in SSHR.

HR: HR/Payroll Representative Source

SSHR offers three methods for determining an organization’s default payroll representative:

  • From Payroll (Further Payroll Information).
  • From GRE (Organization Information).
  • From custom (PL/SQL) code.

This profile option is used in SSHR.

HR:IE P35 Reporting Year

Determines the tax year for which you want to report the P35. If you do not set this option, you cannot report P35.

HR: Info Online: Open in New Window

If you are using Info Online to allow users to access information provider web sites from a button on the Oracle HRMS toolbar, this profile option controls whether the results are displayed in a separate browser window each time the user follows a link. Set to Yes to open a new window for each link followed; set to No to use the same window for each link.

HR: Info Online: RIA Password

If you are using Info Online to allow users to access the third party information product RIA from a button on the Oracle toolbar, this profile option controls the single sign-on capability between Oracle and RIA. Enter a valid password at user level.

Note: If you change your password on PCP then you must also update this user profile option.

HR: Info Online: RIA Username

If you are using Info Online to allow users to access the third party information product RIA from a button on the Oracle toolbar, this profile option controls the single sign-on capability between Oracle and RIA. Enter a valid username at user level.

HR: Info Online Toolbar Icon

If you are using Info Online to allow users to access information provider web sites from a button on the Oracle toolbar, you can optionally use this profile option to identify an alternative icon for the Info Online toolbar button.

The image file should be in GIF format with the following attributes:

  • Size: 18×18 pixels
  • Transparent background colour RGB:192,192,192 (grey)
  • 216 colour depth

Place the file in the virtual directory (relative to the web server used to start forms):

/OA_JAVA/oracle/apps/media

In most installations this would be the directory:

$JAVA_TOP/oracle/apps/media.

HR: Info Online: Use Field Context

If you are using Info Online to allow users to access information provider web sites from a button on the Oracle toolbar, this profile option narrows the search using predefined contexts associated with your current field and window.

Set to Yes to use the predefined contexts to narrow the search; set to No to display a list of all predefined options that are available from the selected window.

HR:Informal Name Format

Use this profile option to define the way a person’s name appears in your workflow notifications. If you do not set the HR: Informal Name Format profile option, the application uses the default name structure.

Use the following values:

  • $FI – First Name
  • $MI – Middle Name
  • $LA – Last Name
  • $PR – Prefix
  • $SU – Suffix
  • $TI – Title
  • $FU – Full Name
  • $KN – Known As
  • $IF – Initial First
  • $IM – Initial Middle

HR:Job Key Flex-Identify 1st and 2nd Segments

These options are used to control which two segments of the key flexfields appear in Person Search.

This profile option is used in SSHR.

HR: Job Level

The job level options are used to determine the seniority of a person’s job. You can set a default for the job level at Site, Application and Responsibility level.

HR: KI Framework Version

If you are using Info Online to allow users to access information provider web sites, use this profile to set the version of Knowledge Integrator Framework.

HR: KI Maximum Topics and Integrations

If you are using Info Online to allow users to access information provider web sites, use this profile to set the maximum number of topics or providers to display in the Content Container before the More link appears.

HR: Enwisen Login URL

Defines the URL of Enwisen web site, a third-party information provider that end users can access from Oracle iRecruitment, Oracle Performance Management, Oracle SSHR, and Oracle Time and Labor pages.

See: Info Online Links to Information Provider Web Sites

HR: KI Providers Enabled

If you are using Info Online to allow users to access information provider web sites, then this profile option controls the Providers region in the Info Online content container. Set to Yes to display the Providers region.

See: Info Online Content Container

HR: KI Topics Enabled

If you are using Info Online to allow users to access information provider web sites, then this profile option controls the Topics region in the Info Online content container. Set to Yes to display the Topics  region.

See: Info Online Content Container

HR: KI User Options Enabled

If you are using Info Online to allow users to access information provider web sites, then this profile option controls the User Options region in the Info Online content container. Set to Yes to display the User Options region.

See: Info Online Content Container

HR: Class Name to Fetch KI Data

Use this profile option to implement additional security when accessing Enwisen, a third-party information provider. The value for this profile option must be a fully qualified name of a Java class that implements Oracle’s predefined Java interface: oracle.apps.per.ki.kiserver.KIDataFetcher. The Java class contains the method to retrieve login values when end users access Enwisen from Oracle HRMS product pages.

See: Configuring Links between HRMS Products and Enwisen

HR:Local Nationality

Use this profile to set a value for nationality. This profile option is for users of the Saudi Arabia Payroll only.

The system administrator sets this option at any level of standard Security hierarchy type – Site, Application, Responsibility, and User.

The system administrator must enter a nationality code, available in the user defined-lookup_type, NATIONALITY. You cannot run the payroll until you set this profile option. If you attempt to run payroll before setting this option, the application will display an error message.

HR: Localization in SSHR

Identifies the localization for SSHR. This profile option is only valid for SSHR releases prior to SSHR 4.0.

HR: Local or Global Name Format

Determines whether the user sees person names in local or global formats. The value Local Format enables users to display names in a character set appropriate to their legislation. The value Global Format enables users in multinational enterprises, which generally use multiple character sets, to display person names in a single (typically, Western) character set. This option applies to the supplied Display Name and List Name formats, to edited versions of those formats, and to user-defined format masks.

HR: Make National Identifier Optional

Enables recording employee information without entering the SOFI Number in the Person window, the People Management Templates, and the Self-Service page. To make entering the BSN/SOFI Number optional, set this option to Yes. To make it a mandatory field, set this option to No.

HR:Manage Self Service Actions When Future-Dated Changes Exist

Controls potential data conflicts if future-dated changes exist for self-service actions. If you have set the profile option HR:Allow Concurrent Self Service Actions to Yes, this profile option allows you to determine how SSHR processes the actions.

The default value for the profile option is Stop with an Error. This forces the user to choose an effective date subsequent to any future-dated change.

If you change the profile option to Allow Approval (Notify HR Rep), you allow the user to select a date prior to any future-dated changes. After final approval, the transaction is forwarded to an HR Representative for review and manual entry into the database.

Important: If you are setting this profile option to Allow Approval, and you have enabled HR:Allow  Approver Updates to Self Service Actions, Oracle recommends that you also enable HR:Refresh Self Service Actions with Data from Intervening Actions.

See: Managing Conflicting Actions, Oracle SSHR Deploy Self-Service Capability Guide

This profile option is used in SSHR.

HR:Manager Actions Menu

Controls which actions menu is displayed for managers within SSHR. If you create a custom Manager Actions menu, you must change this profile option to point to your custom menu.

See: Actions, Oracle SSHR Deploy Self-Service Capability Guide

This profile option is used in SSHR.

HR: Manager Appraisals Menu

Controls the types of appraisal a manager can initiate (for example, Standard, 360 degree) from the Appraisals home page.

HR: Mask Characters

Use this profile option to set the number of characters or digits to display in numbers such as bank account or credit card numbers. Enter a positive number of digits to display from the back (for example, xxxx345) or a negative number of digits to display from the front (for example, 123xxxx).

HR: Metalink Integration Application

Use this profile option to select the first MetaLink page that appears when you choose the Info Online toolbar button in an HRMS window. You can select a page for a specific application (for example, Human Resources or Payroll), or you can add your own choice of pages to the list using the HR MetaLink Application lookup.

HR: Metalink Integration Enabled

Set this profile option to Yes to enable links from Oracle HRMS windows to MetaLink via the Info Online toolbar button. Set to No to disable the links.

HR:Monitor Balance Retrieval

This profile enables the Monitor Balance Retrieval Debug Tool, which allows you identify database items associated with the values held in the latest balance tables, in order to reference them in the formula called by the payroll run. Set to Yes to enable monitoring, or No to disable monitoring.

HR: NI Unique Error or Warning

Enables you to change the default warning to an error message.

If you want to warn users that the national identifier they have entered already exists, leave the default as warning. If you want to prevent a user entering the same national identifier more than once, you can change the message to an error. This stops the user entering the same national identifier.

HR: National Identifier Validation

Enables you to define the validation that is used for a national identifier. There are three possible values:

  • Error on Fail (default value). If a user enters an invalid national identifier, an error message is displayed and the user cannot save the national identifier until they have entered it in the correct format.
  • Warning on Fail. If a user enters an invalid national identifier, a warning is displayed, but the user can save the national identifier.
  • No Validation. A user can enter and save the national identifier in any format. No validation is performed and no message is displayed.

HR:Non-Updateable Element Set

Select a customization element set to define the element entry values that are view-only on the Element Entries window. Typically you use this user profile option to prevent updates to elements that are maintained using legislation-specific windows.

HR: Number Separator

Enables you to format integer, money and number values that are consistent with the ICX number format set at the Self-Service page. This profile has a value of either Yes or No. You can set it at the site level to ensure a consistent format across the application. The profile settings determine the group separator, decimal separator, and format of values. These settings will affect number formats on windows such as Element Entry, Element Description, Batch Element Entry, and User Tables.

HR: Online Tax Forms Update Method

Controls how SSHR processes multiple person assignments when dealing with tax information. SSHR supports multiple person assignments and keeps tax information for each assignment; however, since a person can file only one withholding form you must select one of the following options:

  • Primary. Only the tax information for the primary assignment is updated when a user changes tax information using the Online Tax Form.
  • All (default value). The tax information for all assignments is updated when a user changes tax information.
  • None. Users cannot update tax information using the Online Tax Form. The update functionality is disabled.

See: Tax Withholdings Form (W-4) (US), Oracle SSHR Deploy Self-Service Capability Guide

This profile option is used in SSHR.

HR: OAB New Benefits Model

Enables you to set up whether you are using the new benefits model, that is, Standard or Advanced Benefits. Enter Yes, if you are using the new benefits model. Enter No, if you are using the compensation and benefit models from previous releases.

HR: Override Grade Defaults

Controls whether the end user can override the default grade values when updating organization, position, or job information. If the profile option is set to No, the user can only select grade values from the defined list of values.

See: Assignment, Oracle SSHR Deploy Self-Service Capability Guide

This profile option is used in SSHR.

HR:Payroll Payments Self-Service Enable Multiple Assignments

This profile option is used by Payroll Payments Self-Service version 4. If it is set to No, employees can only specify payroll payments for their primary payroll assignment. If set to Yes, employees can specify payroll payments for additional payroll assignments. The default is No.

This profile option is used in SSHR.

HR:Payroll Payments Self-Service Payment Function

This profile option determines the defaults for the Organizational Payment Method (OPM). It operates differently depending on whether you have applied a foreign payment method enhancement.

Before Applying a Foreign Payment Method Enhancement:

  • Null Value. If the profile value is null, then each of the allowed payment categories takes the default from the first valid payment method in the cursor for that payment method.
  • Valid Function Name. If you supply a valid function name, then the organizational payment method is dynamically determined for each payment category. The returned OPM id becomes the default payment method.

After Applying a Foreign Payment Method Enhancement:

  • ALL. If the profile value is ALL, then there is no single default organizational payment method. Instead, all available payment methods are returned in a list of values so that the employee can select from them.
  • Null Value. If the profile value is null, then each of the allowed payment categories takes the default from the first valid payment method in the cursor for that payment method.
  • Valid Function Name. If you supply a valid function name, then the organizational payment method is dynamically determined for each payment category. The returned OPM id becomes the default payment method.

HR:Payroll Payments Self-Service Payments List Mode

If you set this profile option to Like, you can select the organization payment method name on the basis of it being like an entry in the payments list configuration attribute instead of an exact match. The setting of Like also enables you to perform an exact match. The default of this profile option is null, which performs an exact match.

HR: Performance View Layout

Enables a manager to see the Detail Summary View in a Form or Tabular Format.

This profile option is used in SSHR.

HR:Personal Actions Menu

Controls which actions menu is displayed for users within SSHR. If you create a custom Personal Actions menu, you must change this profile option to point to your custom menu.

This profile option is used in SSHR.

HR: PL NI Unique Error or Warning

Controls whether HRMS generates an error or a warning for duplicate PESEL values at the legal-employer level. Valid values are Error, Warn, and None. Set to None if no validation is required.

See: HR: NI Unique Error or Warning

HR: Position Default Options for SSHR

These options control whether or not the application displays default information based on the position you select for an assignment. You can set one of four values:

  • Default with No Warning
  • Default with User Decision
  • Default with Warning
  • No Defaulting

HR:Position Key Flex-Identify 1st and 2nd Segments

These options are used to control which two segments of the key flexfields appear in Person Search.

This profile option is used in SSHR.

HR: Propagate Data Changes

Controls the synchronization of person records for an individual in multiple business groups.

To propagate changes made to a person record in one business group to records for the same person in all business groups, set this profile option to Yes.

Note: You can propagate changes to only those business groups your security profile allows you to update.

HR:Purge Element Entry Permission

Controls whether users can purge element entries (irrespective of whether those entries have been processed by a payroll run). It does not affect a user’s ability to perform datetracked deletions or updates. The possible values are:

  • All (the user can purge all element entries)
  • Information (the user can purge only informational (non-payment) element entries)
  • None (the user cannot purge any element entries)

Note: If you have installed a third party payroll interface, you cannot purge any element entries attached to the interface. If you are using a setting of All or Information, an error message to this effect appears when you attempt to purge an element entry.

HR:Query Only Mode

Set to Yes to restrict access to view-only for all HR and Payroll forms on a menu.

You can set this profile for individual responsibilities or users, or at the site or application level.

If you want to give query-only access to some forms and full access to other forms, set the HR:Query Only Mode profile to No and use the parameter QUERY_ONLY=YES at form function level to restrict access to individual forms.

Note: You can set the parameter QUERY_ONLY=YES for a form function that also launches a task flow. In this case, specify two parameters in the Form Function window:

QUERY_ONLY=YES

WORKFLOW_NAME=”task flow name

The entire task flow will be query-only, not just the first form.

See: Restricting Access to Query-Only Mode.

HR:Refresh Self Service Actions with Data from Intervening Actions

This profile allows you to control the effect of concurrent actions. If this profile is set to Yes, when a pending change is approved which affects the current transaction the application will display a warning message listing changed attributes and the data will be refreshed. If it is set to No, the default, the application will display a warning message and the transaction will fail.

Oracle recommends that this profile option is set to Yes if HR: Allow Approver Updates to Self Service Actions is also set to Yes.

Note: Oracle recommends that you enable this option if you have set the system profile HR:Manage Self Service Actions When Future-Dated Changes Exist to Allow Approval (Notify HR Rep). Otherwise you should disable this option.

HR: Restrict Letter by Vacancy or Event

This profile serves both HR and OTA letter requests. It enables you to generate separate letter requests for each event (OTA) and for each vacancy (HR).

If you set the profile to Yes, it displays the Vacancy Name field on the Request Letter window. Choosing a value in this field restricts the letter generation to applicants associated with the vacancy you choose in the Vacancy Name field.

HR:Restrict Transactions across Legislations in SSHR

If the HR:Cross Business Group profile is set to Yes, this profile can prevent SSHR managers from carrying out transactions on employees (within their supervisor hierarchy) who are from different legislations.

HR: RIA Integration Enabled

Set this profile option to Yes to enable links from Oracle HRMS windows to the web pages of third party information provider RIA via the ‘Info Online’ toolbar button. Set to No to disable the links.

HR:Run BENMNGLE When Processing a Self Service Action

In order to ensure that the list of eligible actions and sub-actions is up to date, you must periodically run the Participation Batch Process (Run Benefits Manage Life Events Process) for that individual. This can be set to run automatically every time a manager initiates an action by setting the profile option, HR:Run BENMNGLE When Processing a Self Service Action, to Yes.

HR: Salary View Layout

Enables a manager to see the Detail Summary View in a Form or Tabular Format.

This User Profile Option is used in SSHR.

HR: Save and Stay in Appraisals Page

Controls what happens when the user clicks Save as Draft in an SSHR Appraisals page. When this option is set to Yes, which is the default value, the user remains in the current page and can continue to edit the appraisal. When this option is set to No, the Appraisals home page appears.

HR: Schedule Based Absence Calculation

Set this profile option to Yes at the site level if you want the application to take into account the schedules and calendar events information from the worker’s primary assignment to calculate the actual duration of an absence. The default is No. If you leave the default value for this profile, and have already created a basic formula for absence duration, the application calculates the absence duration on the basis of the absence start and end dates, without using the schedules and calendar events information.

HR: Security Profile

Restricts access to the organization, positions and payrolls defined in the security profile. This option is predefined at Site Level with the view-all security profile created for the Setup Business Group.

If you use Standard HRMS security you must set up the HR: Security Profile profile option for each responsibility.

If you use Security Groups Enabled security you must not set up the HR: Security Profile profile option. This is set up automatically when you assign security profiles using the Assign Security Profile window. You must only change the HR: Security Profile option by assigning a different security profile to a responsibility using the Assign Security Profile window.

HR: Security Performance Enhancer

Set this profile if you want to use the security performance enhancement feature. When you select Pick Performance Table(Assignment) as the value, the Oracle HRMS security mechanism retrieves information from the PER_ALL_ASSIGNMENTS_F_PERF performance table instead of the PER_ALL_ASSIGNMENTS_F base table when the person security evaluation happens and display of data is faster. You can set this profile option at the Responsibility level only.

See: Setting Up the Security Performance Enhancement Feature

Important: Before you set the profile option, you must run the Synchronize Security Performance Tables process. For more information, see: Running the Synchronize Security Performance Tables Process

HR: Self Service HR Licensed

Controls whether Self-Service HRMS (SSHR) is available. If the customer has obtained a license for SSHR, they must set this profile option to Yes at the site level.

This profile option is used in SSHR.

HR:Self Service New Hire Default Values

Specifies whether values for the new person record should be defaulted or not.

For the New Hire function, if the profile is set to Yes, then the following values are defaulted based on the primary assignment, as of the system date, of the person logged in:

  • Organization
  • GRE (if US)
  • Payroll
  • Salary Basis

The supervisor for the new person defaults to the person logged in. For both New Hire and Applicant Hire, this profile also controls which person type is defaulted.

  • If the profile is set to No and there is only one person type available, then this person type is defaulted. If there is more than one available then the field remains blank and you can select a value. 
  • If the profile is set to Yes and there is only one person type available, then this person type is defaulted. If there is more than one available, then the field displays the person type set as the default for the system person type of Employee.

This profile is used in SSHR.

HR:Self-Service Save for Later

This profile options allows the Save for Later button to be displayed on all transaction pages in Self Service. Set it to No to disable this feature.

HR: Servlet Timeout

If you are using Info Online to allow users to access information provider web sites, use this profile to set the maximum time in seconds that the system waits for a response from the web server mediating the connection to the integration partner.

HR: SM Employee Find Work Opp Menu

Controls suitability-matching functions for finding a work opportunity available to employees using the Employee Self-Service responsibility.

HR: SM Manager Find Person Menu

Controls suitability-matching functions available to managers using the HR Professional or Manager Self-Service responsibility for finding a person for a work opportunity.

HR: SM Manager Find Work Opp Menu

Controls suitability-matching functions available to managers using the HR Professional or Manager Self-Service responsibility for finding a work opportunity for a person.

HR: Subrogation

Use this profile option to set a value for subrogation. This profile option is for users of the French legislation only.

HR: Supervisor Hierarchy Usage

If you are using supervisor hierarchies for security within your organization, you use this profile option to specify whether the supervisor hierarchy is person-based or assignment-based.

HR: Training View Layout

Enables a manager to see the Detail Summary View in a Form or Tabular Format.

This profile option is used in SSHR.

HR:TCA Unmerge Options

The Trading Community Architecture (TCA) Unmerge function, which removes the records of people who are only contacts from the TCA party tables, is delivered in patch 3625452 and is part of the November 2003 Family Pack (PER Family Pack G). The TCA Unmerge function uses the TCA purge parties process, which checks references to party IDs throughout the E-Business Suite. This process can take a long time to complete. Patch 3621712 provides you with an alternative approach to the TCA Unmerge process. If you apply patch 3621712 prior to installing PER Family Pack G you can use this profile option to control how the unmerge process is run. Select one of the following options:

  • Pre Stage Process If you select this option, then the TCA Unmerge process does not run during auto patch. Instead, you can log in as a System Administrator and submit the concurrent program Unmerge Contacts from TCA (HR TCA process) at a convenient time.
  • In Patch Process If you select this option (which is the default option), then the HRMS component of the unmerge process is run during auto patch. A concurrent program is then submitted automatically during the auto patch process to run the TCA component of the process.
  • Deferred Process If you select this option, then a concurrent program is submitted automatically during the auto patch process to run both the HRMS and TCA components of the process.

HR: US Address Line Length

This profile option, which specifies the maximum length of an address line, affects U.S. addresses only; it has no effect in other legislations. Oracle HRMS displays a warning message when you view or enter address lines longer than the value you specify here. The value of this profile option overrides any maximum address line length specified in the Personal Address Information descriptive flexfield for the current local U.S. address style.

HR: Use Fast Formula Based PTO Accruals

This user profile option is disabled.

HR: Use Global Applicant Numbering

Enables the global sequence for applicant-number generation. This sequence is shared among all business groups.

To set this profile option, you run the process “Change automatic person number generation to global sequencing”. You cannot set this option in the System Profile Values window.

HR: Use Global Contingent Worker Numbering

Enables the global sequence for contingent-worker-number generation. This sequence is shared among all business groups.

To set this profile option, you run the process “Change automatic person number generation to global sequencing”. You cannot set this option in the System Profile Values window.

HR: Use Global Employee Numbering

Enables the global sequence for employee-number generation. This sequence is shared among all business groups.

To set this profile option, you run the process “Change automatic person number generation to global sequencing”. You cannot set this option in the System Profile Values window.

HR:Use Grade Defaults

This profile option allows you to restrict the list of values for the grade to include only those values permitted by the parent organization, job, or position.

This Profile Option is used in SSHR.

HR:Use Standard Attachments

Disables the facility to attach short text comments to records. Enables the attachment of multiple items of various types including OLE objects, Web pages, images, and word processed documents.

HR:User Type

Limits field access on windows shared between Oracle Human Resources and Oracle Payroll. If you do not use Oracle Payroll, it must be set to HR User for all responsibilities.

Note: You must set this profile option at responsibility level.

If you do use Oracle Payroll, you can give each responsibility one of the following user types, depending on the work role of the holders of the responsibility:

  • HR User
  • HR with Payroll User
  • Payroll User

The windows that are dependent on the setting of this profile option are as follows:

FormProfile SettingBehavior
Define Element Classification (PAYWSDEC)HR UserYou cannot create secondary element classifications.
Define Element Type (PAYWSDET)HR UserSome payroll fields are not available.
Define Payroll (PAYWSDPG)HR UserThe Statutory Information field is not visible. Note: Statutory Information is not available at payroll level for all localizations, for example, it is not available for the UK.
Element Entries (PAYWSMEE)HR UserThe Processing Priority field in the Element Entry Values window is not available.
Define Assignment Status (PERWSDAS)HR UserYou cannot use the Payroll Status as a query criterion in Enter Query mode.
Define Benefit Contributions (PERWSEBC)Payroll User       You cannot change the coverage type or contribution amounts for an existing benefit contributions record.You cannot create benefit contribution records.
SSP/SMP (SSPWSENT) (UK Only)HR UserYou must enter the average earnings amount for your employee before you can calculate their entitlement to statutory payments.
SSP/SMP (SSPWSENT) (UK Only)Payroll User or HR with Payroll User       You can derive the average earnings automatically.
Employee Assignment (PERWSEMA)HR UserPayroll field is display only.
Employee Address and Define Location (US Federal Only)HR UserThe default address style is United States (International).
Employee Address and Define Location (US Federal Only)Payroll User or HR with Payroll User       The default address style is United States.
Define Element Type (US Federal Only)HR UserThe application uses the predefined Federal element names.
Define Element Type (US Federal Only)HR with Payroll User       The application uses the element names you define for the Federal elements.
Terminate (US Federal Only)HR with Payroll User       You can update the Final Process Date.

HR: Use Title in Person’s full name

Enables you to remove title from a person’s full name so that it does not appear in person search lists, such as the Find window on the Person window.

This user profile option is only effective when you insert new records or update existing records. To remove title from existing records without updating them you should run the Remove Title from Person’s Full Name concurrent process.

HR: Verification External Node

Defines the URL for the external node for the Employment Verification function. The node redirects the access request from outside the security firewall to the HTML page containing the released employment information.

This profile option is used in SSHR.

HR: View Payslip From Date for WEB

Limits the number of pay periods an employee can view.

This profile option is used in SSHR.

HR: Views Layer Size

Enables you to set the width of the Employee Name and Employee Number floating layer to the longest name and number you have.

This profile option is used in SSHR.

HR:View Unpublished Employee 360 Degree Self Appraisal

Enables a manager to view employees’ unpublished 360 Degree appraisals. (This option does not affect self appraisals.) Set this option to Yes to view employees’ unpublished 360 Degree appraisals. The default value is Null.

HR:Webapps Tips Test Mode

Forces all tip icons in SSHR to be displayed whether tip text is defined or not.

This User Profile Option is used in SSHR.

HR: Web Proxy Host

This option is used as part of the Knowledge Management which allows the Proxy Host to be used when accessing an external site.

HR: Web Proxy Port

This option is used as part of the Knowledge Management which allows the Proxy Port to be used when accessing an external site.

HR: Worker Appraisals Menu

Controls the types of appraisal a worker can initiate. The default value is Employee Appraisals Menu. 

HR: ZA Nature of Person Mandatory at Person Level

Set this profile option to Yes to make the Nature of Person mandatory at the Person level. This ensures the application validates the Nature of Person during data entry. If you set this profile option to No, then Nature of Person is optional at the person level, and the application performs validations only when you run the Tax Year End Validation report. You must run the Generic Upgrade Mechanism process using the South Africa: Populate Nature of Person at the Person Level parameter to display the Nature of Person details at the person level for existing employees.

HRI: Collect Manager Snapshots

If you turn this profile option on, the DBI for HRMS collection process collects an additional summary layer for managers who have more staff than a specified number reporting to them. The default value is No. Use in conjunction with HRI: Manager Snapshot Threshold.

HRI: Collect Open Enrollment in Progress

Determines the enrollment data that DBI for HRMS collects. Set this profile option to Yes to collect data for the current open enrollment period. To collect historic data of enrollments along with the open enrollment data, set the profile option to No.

HRI:DBI Chief HR Officer Named User

Enables users of the Chief HR officer responsibility to access the Chief HR Officer dashboards effectively as the CEO of the enterprise.

Note: You must have successfully run an Initial Load before you set this profile option.

Select the name of the user from the profile option list. The list of managers shown for the profile is only those at level 1 (the top of the hierarchy). To turn this profile off, set the profile option value to No.

Note: This new profile option only affects the Chief HR Officer responsibility.

HRI:DBI Force Foundation HR Processes

Determines whether the HRI Collection Programs run in Foundation HR mode (on a Full HR Installation). The Foundation HR mode only collects data as of the system date; it does not maintain historical data. If you are an HRI DBI customer, you must set this profile option to No.

Non-DBI for HRMS customers, who do not require any more than the basic data collected in a Foundation HR implementation, can set the HRI:DBI Force Foundation HR Processes profile option to Yes. This setting reduces the amount of data collected and improves load times.

HRI:DBI Link to Transaction System

Enables users of DBI for HRMS to drill from detail reports to employee records in the HR Self Service Employee Directory.

Set this profile option to HR Employee Directory to turn this feature on. The default value is Disable Link.

HRI:Enable Benefits Collections and Event Queue

Enables managers to view the life event statuses for participants in the open enrollment period. Set this profile option to display the life event statuses in the DBI for HRMS Enrollment Process Status report.

HRI:Enable Captured Events Archive

Controls the archive mode for the events capture process in DBI for HRMS. Set this option to Yes to archive all events that trigger incremental processing.

HRI:Enable Detailed Logging

Enables you to include a debug message in the concurrent manager log to troubleshoot errors during the HRI data collection process. Set the HRI:Enable Detailed Logging profile option to Yes. The default is No.

Caution: Only set this profile option to Yes if you encounter an error. Debugging the collection process impacts the collection timings.

HRI: Manager Snapshot Threshold

Determines the minimum number of staff required to enable snapshot collection for a manager. The default is 2500. Use this profile in conjunction with HRI: Collect Manager Snapshots.

HRI:Multithreading Chunk Size

Determines the number of objects processed at one time during the DBI for HRMS collection phase. The default value is 200. You can change this to a value between 1 and 16000. However, you should avoid processing a large numbers of objects, as the default value is the result of benchmark tests. If you receive the error “Oracle exception: cannot extend rollback segment” during the collection process, then reduce the value for this profile option.

HRI:Number of Threads to Launch

Determines the number of threads, or sub-processes, that run in parallel on multi-processor machines. If you have already installed PYUGEN on your system, then set this profile option to equal the THREADS parameter defined for PYUGEN. The default value for this parameter is 8.

Caution: Your Applications System Administrator must define the concurrent manager to allow the required number of sub-processes to run in parallel.

HRI:Period of Service / Placement Date Start Source

Determines how DBI for HRMS calculates the employee’s periods of service. The default value is Start Date. With this setting, DBI for HRMS calculates periods of service from the beginning of employees’ current period of service.

To calculate the employee’s period of service from the beginning of their first period of service, change the value to Adjusted Service Date.

Caution: HRMS also uses the Adjusted Service Date to calculate benefits. You must therefore consider the effect on benefits if you use this feature.

HRI:Populate Assignment Events Queue

Determines whether the events collection process in DBI for HRMS populates the incremental update queue for the assignment events collection process. If you never run the assignment events process, set this profile option to No to reduce the load times of other processes. If you are a DBI for HRMS customer, you must set this profile option to Yes.

HRI:Populate Supervisor Hierarchy Events Queue

Determines whether the events collection process in DBI for HRMS populates the incremental update queue for the supervisor hierarchy collection process. If you never run the supervisor hierarchy process, set this profile option to No to reduce the load times of other processes. If you are a DBI for HRMS customer, you must set this profile option to Yes.

HRI:Populate Supervisor Status History Events Queue

Determines whether the events collection process in DBI for HRMS populates the incremental update queue for the supervisor status history collection process. If you never run the supervisor status history process, set this profile option to No to reduce the load times of other processes. If you are a DBI for HRMS customer, you must set this profile option to Yes.

HRI: Workforce in Period Calculation Method

Determines the calculation that DBI reports use in averaging values over a period, for example, workforce turnover or average employee absence. Select from:

  • Workforce End: headcount at the end date of the reporting period.
  • Workforce Start + End Average: average of the headcount at the start date and the headcount at the end date of the reporting period.

The default is null, which means that the calculation will use the headcount at the end date of the reporting period

HZ: Protect HR Person Information

Controls the synchronization of common data between Oracle HRMS and Oracle Student System (OSS). By default (when this option is set to No) data synchronization is enabled.

Limit by Persons Organization

Set this profile option to Y to limit the Compensation Objects selected by the Participation Process to only those linked to the employee’s organization.

OAB:Self Registered User Responsibility

Identifies the responsibility to be granted to new users who successfully self-register in SSHR using the New User Registration processes. This profile option is seeded at site level with the seeded responsibility Self Registered Employee Default Responsibility. You can set this profile at responsibility level if you have created several responsibilities for different groups of users to use after initial registration.

This profile option is used in SSHR.

OAB:Enable Self-Service Benefits Trace

This profile option enables to you to generate a PYUPIP trace file for a particular Self-Service Benefits user that you select. Use this profile option to debug Self-Service Benefits election problems.

This profile option is used in SSHR.

OAB:User to Organization Link

In the self-service New User Registration processes, links the responsibility you give to new users to register on SSHR with the organization to which they belong.

This profile option is used in SSHR.

OAB:User to Payroll Link

In the self-service New User Registration processes, provides a default employee payroll linked to the responsibility you give to new users to register on SSHR.

This profile option is used in SSHR.

PAY: Enable Workflow for Assignment Costing

Enables the user to toggle between the two processes of using with or without the workflow option. If the profile is set to Yes, the application saves the data on approval. If the rule is set to No, the application saves the data immediately. The default is No.

PAY: Generate Periods for Tax Year

Since the lunar month has only 28 days, the yearly start date of a period would be always less than the legislation specific start date. This profile option enables you to reset the generated payroll period start date back to the legislation start date. You should set the profile option to Yes to display Reset Years in the Payroll window. The default value is No.

PAY:Statement of Earnings User Category

You use this profile when setting up a global statement of earnings to be viewed online. It enables you to select user category when setting up the global statement of earnings.

PER:Automatic Save

You use this profile when setting up iRecruitment. Set the profile option to Y to enable an automatic Save For Later operation when users navigate to a new web page.

PER:Navigation

You use this profile when setting up iRecruitment. Set the profile option to Y if you want the application to validate data on the current web page when users navigate to a new page (Next or Previous).

Personalize Self-Service Defn

This profile option enables or disables the global Personalize link and Personalize Region link that appear on self-service functions from SSHR 4.0 and above.

This profile option is used in SSHR.

PO: Services Procurement Enabled

Controls the availability of purchase-order information from Oracle Services Procurement to Oracle HRMS. If you use Oracle Services Procurement to provide purchase order information for contingent worker assignments, you must set this profile option to Yes.

Performance Management Source Type

Enables you to select a default value from the “PROFICIENCY_SOURCE” (Source of Proficiency Rating) user lookup. HRMS uses this value when updating a person’s competency profile automatically after an appraisal.

Note: This profile option was previously known as Talent Management Source Type.

Workforce Measurement Type

Determines how DBI for HRMS measures the size of your workforce. The application currently only supports the value of Headcount.

Menus, Functions, and Responsibilities

Responsibilities

You can control users’ access to human resources information by record, window and function.

The responsibility is your primary means of defining security. To define what a user can access you link a user, responsibility and Business Group to a security profile. Other important components of the responsibility are the menu structures, task flows and information types. These also help you limit the employee records a user can access.

Users can sign on to the system only through the responsibilities you give them. So their responsibilities control what they can see and do in the system.

Responsibility

A responsibility is linked to a security profile and composed of:

  • A menu structure
  • A request group for reporting users (optional)
  • Extra information types available to the user

Responsibilities are also linked to business groups. However, depending on which security model you use, you link responsibilities differently.

  • Standard HRMS Security
    You can only link one business group to one responsibility using Standard HRMS security. You must set up different responsibilities for each business group. 
  • Security Groups Enabled Security
    You can enable more than one business group for a single responsibility. However, you still only view records for one business group at a time.

Each model enables you to set up multiple responsibilities. You can assign multiple responsibilities to users who need to:

  • Access applicant, employee, and contingent worker records from two or more security profiles.
  • Use more than one menu structure to view or make changes to the records they can access.
  • Access records for more than one business group if you use Standard HRMS security. For example, an enterprise with international operations may have a US-Based business group and a UK-Based business group. A few of your employees might need to access both.

The Oracle HRMS responsibilities available globally include:

  • HR Manager: to access HR features only
  • HRMS Manager: to access HR and Payroll features
  • Super HRMS Manager: to access HR, Payroll, and Advanced Benefits features

Note: You can access standard benefits features using the HR manager or HRMS manager responsibilities. Only use Super HRMS Manager if you have licensed Oracle Advanced Benefits.

Access Control Through Responsibility

The following key components help control user access to Oracle HRMS:

  • Security profiles determine the organizations, positions and payrolls whose applicant, employee and contingent worker records responsibility holders can access. 
  • Business Groups determine the set of records a user can access. Using Security Groups Enabled security you can enable one responsibility for many business groups. Using Standard HRMS security you must set up a new responsibility for each business group.
  • Menu structures and functions control:
    • The particular windows and functions a responsibility holder can access
      When you create a responsibility, you assign a menu structure to the responsibility. You can assign either a delivered menu or a custom menu. If required, you can restrict access to particular functions or menus using function or menu exclusions.
      See: Overview of Menus and Function Security, Oracle Applications Developer’s Guide
      See: How Function Security Works, Oracle Applications Developer’s Guide
      Warning: If you exclude a function from a responsibility, a user with the responsibility can no longer access the function from any menu assigned to the responsibility. However, the function may still be attached to a task flow. If this is the case, the user will be able to access the excluded function when working through the task flow sequence. To avoid this situation, you may need to modify your task flows to remove the function. 
      See: Task Flow
    • Whether he or she can perform data entry, change or deletion on these windows
      You can produce configured versions of some windows. Each configured version enables access to a subset of certain types of information, such as person types, special information types, or elements. You define additional menu functions to call configured windows or task flows, and then you add these functions to a menu structure, which is linked to a responsibility.
  • Request groups determine the group of processes and reports a responsibility holder can initiate. A request group is an optional component of a responsibility. If holders of a responsibility should not initiate any reports or processes, you do not include a request group in the responsibility.
  • Extra Information types are an optional component of a responsibility. By defining which extra information types are included in a responsibility, you effectively create a configured version of a window for users who are assigned the responsibility.

Important: If you do not associate any extra information types with a responsibility, a person assigned to this responsibility will not have access to any extra information types in the product.

For each responsibility, you must also define the user profile option HR:User Type.

Responsibility Ownership

If you are using Self-Service Human Resources (SSHR) you can use the Responsibility Ownership functionality to administer and control access to responsibilities by assigning an owner relationship. You can use the Responsibility Ownership functionality in SSHR to display a hierarchy of functions and menus attached to the responsibility and also display information on users of the responsibility. If appropriate, you can revoke access to a responsibility using the self-service interface.

See: Responsibility Ownership, Oracle SSHR Deploy Self-Service Capability Guide

Menu Structure

Users access standard windows, configured windows, and the first window in a task flow through the menu structure displayed in the Navigator window. Each responsibility includes a menu structure to restrict the windows users can access, and what they can do on these windows.

A function is a part of an application’s functionality that is registered under a unique name for the purpose of assigning it to, or excluding it from, a responsibility. There are two types of functions: form functions, and non-form functions. For clarity, we refer to a form function as a form, and a non-form function as a subfunction, even though both are just instances of functions in the database.

Using Function Security system administrators can further restrict access to individual menu options. You can include:

  • Standard windows, displayed in edit or view-only mode
  • Configured windows, on which you have restricted the range of data that can be displayed
  • The first window in task flows that link a number of windows that are used in sequence to complete a task

By defining menus with function security for groups of users, you can:

  • Limit the range of information users can access for the applicant and employee records available to them
  • Improve users’ efficiency in using the system by reducing menu choices
  • Restrict users to query-only access to some or all windows

Each responsibility you define must be linked to a root menu. The root menu lists the menu options when the Navigator window first opens.

The Default Menu Structure

The AutoInstall program creates a default menu structure for your HRMS product. This menu structure enables you to access all of the windows for your system. Normally, only a system administrator has access to the full default menu structure.

The supplied menus give you access to all of the available submenus. However, a number of predefined functions are not enabled on these menus. If your localization requires these menus, you need to add them for the responsibilities that should have access to these functions.

  • HR View Medical
    This causes the Medical Information tabbed region to display in the People window.
  • HR View Background
    This causes the Background Information tabbed region to display in the People window.
  • HR View Benefits
    This causes the Benefits tabbed region to display in the People window.
  • HR View Rehire
    This causes the Rehire Information tabbed region to display in the People window.
  • Salary Administration: Approve
    This enables the user to approve salary proposals in the Salary Administration window and the Salary Management folder.
  • HR View Projects Information
    This causes the Projects Information tabbed region to display in the Assignment window. You must have Oracle Projects installed to display this region.

Caution: Oracle HRMS with DateTrack and task flows does not fully support multiple active windows. When you define a new menu for use with Oracle HRMS the top menu must include the following function as a separate menu option:

Disable Multiform

See: Disabling Multiple Windows

Request Groups

When you build a responsibility for employees who must initiate reports or processes, you can attach a request group to the responsibility. The request group lists a group of processes and reports its holders can run. Holders of responsibilities with no request groups cannot run any processes or reports.

The group Reports and Processes gives access to all predefined reports and processes.

Structuring Menus

Using function security and the Menus window, you can use the default menu for any number of responsibilities and restrict access to the default menu options. You can also define any number of new functions and menus to restrict the access of other users. To view the hierarchy of menus you have defined, you can run the Menu Structures report.

Caution: You should not modify the default functions and menus supplied with the system. On upgrade, these defaults will be overwritten.

If you want to add window configuration options or task flows you should define your own menus.

The supplied menus give you access to all of the available submenus. However, a number of predefined functions are not enabled on these menus. You need to add them for the responsibilities that should have access to these functions.

Structuring Menus

  1. Start by drawing it out on paper. This helps you to decide the best structure and the best prompts and descriptions. 
  2. Decide how to structure your menus. Menus can be structured in different ways:
    • Following a Sequence of Tasks.
      For example:
      1. Define a Requisition and Vacancy
      2. Define a Recruitment Activity
      3. Enter Applicant Information
    • By Type:
      For example, all inquiry windows grouped together. If you structure the menu by type, the grouping is important but the sequence is not.
  3. Work from the lowest level of sub-menu to the highest and define the root menu as the last step in the sequence.
  4. Define as many submenus as you require under each menu option. We recommend that you restrict the number of menu levels to three because a menu structure with more levels is cumbersome to use. 

Defining Menus

Use the Menus window to add predefined functions to a menu.

Caution: Oracle HRMS with DateTrack and task flows does not fully support multiple active windows. When you define a new menu for use with Oracle HRMS the top menu must include the following function as a separate menu option:

Disable Multiform

See: Disabling Multiple Windows

A number of predefined functions are not provided on the supplied menus. You can add them to your own menus. See: Menu Structure for a list of these functions.

To define a menu

  1. Query the menu onto which to add the function.
  2. Add a new line and select the function. 
    For example, select Salary Administration: Approve to enable users to approve salary proposals.
  3. Save your changes.
    See: Menus Window, Oracle Applications System Administrator’s Guide if you need further information about using the Menus window.

Disabling Multiple Windows

In most Oracle Applications, you can open multiple windows from the Navigator window without closing the window you already have open. HRMS, however, does not support Multiform functionality.

Important: You must disable this feature on menu structures that accesses Oracle HRMS windows.

To disable the Multiple Open Window feature

  1. Add a Function type menu entry to the top-level menu referenced by your new responsibility.
  2. Select the function whose User Function Name and Function Name are:
    • Navigator: Disable Multiform
    • FND_FNDSCSGN_DISABLE_MULTIFORM
  3. Save your changes.

Defining Menu Functions

Use the Form Functions window to define your menu functions.

Function Security helps you to control the menu options you make available to each responsibility. When you define a responsibility you can restrict the submenus or functions for that responsibility using exclusion rules.

See: How Function Security Works, Oracle Applications Developer’s Guide

Define Menu Functions

  1. Define your menu function using the Form Functions window.
    See: Form Functions Window, Oracle Applications Developer’s Guide
  2. When you have created your custom functions, add them to a menu.
    See: Menus Window, Oracle Applications System Administrator’s Guide
    Caution: You should not modify the default functions and menus supplied with the system. On upgrade, these defaults will be overwritten. 
    If you want to add window configuration options or task flows you should define your own menus.

Restricting Access to Query-Only Mode

To restrict access to query-only mode for an individual form

  1. In the Form Functions window, select the form and specify the parameter QUERY_ONLY=YES. If you want to specify other parameters for this form function, separate them with a space.
  2. Enter a user function name to identify your new function, and save it.
  3. In the Menus window, select your new function instead of the supplied form function.

Using Parameters for HRMS Form Functions

To use parameters in Form Functions

For certain options you must define menu functions that include a parameter in the Parameters field of the Form Functions window, as follows:

  • If the menu entry calls a configured form, use the following parameter:
    HR_CUSTOMIZATION = “customization name
  • If the menu entry calls the first form in a task flow, use the following parameter:
    WORKFLOW_NAME = “task flow name
  • If the menu entry calls a form in query-only mode, use the following parameter:
    QUERY_ONLY=YES
  • If the menu entry calls a people management template, use the following parameter:
    TEMPLATE_NAME=”name of your template
  • If the menu entry calls the Define Rate form (PAYWSGEV), use the following parameter: 
    FORM_MODE = “grade” (for the Grade Rate window)
    FORM_MODE = “spine” (for the Scale Rate window)
  • If the menu entry calls the Payroll and Assignment Processes form (PAYWSACT – used in Oracle Payroll), use the following parameter:
    FORM_MODE = “assignment” (for the Assignment Processes window)
    FORM_MODE = “payroll” (for the Payroll Processes window)
  • If the menu entry calls the Organization Manager Relationship form (PERWSCCM), use the following parameter to limit the list of organizations to those with a particular classification. You can find the organization classification code for a classification from the ORG_CLASS Lookup Type, for example the code for HR Organization is HR_ORG:
    RESTRICT_CLASSIFICATION = “organization classification code”
  • If the menu entry calls the Enter Person window (PERWSEMP), you use the following parameter to hide sensitive data:
    HIDE_SENSITIVE_DATA = Y
  • To prevent position users from attaching a position to an existing control budget and entering budget data, set the form function parameter DISABLE_BUDGETS=”Y” for the Position window (HRWSPSF).
  • The Position, Position Transaction, and Position Copy forms enable you to perform secondary queries when searching for positions, using a Combinations button. The Combinations button enables you to see positions across business groups. If you want to restrict the positions users can see to those within their own business group, hide the Combinations button by setting the parameter SHOW_COMBINATIONS=N.

If you need to specify more than one parameter for a form function, separate the parameters with a space.

For more information about using the Form Functions window see: Form Functions Window, Oracle Applications Developer’s Guide

AuditTrail

AuditTrail Overview

The system administrator is responsible for performing AuditTrail on Oracle HRMS data.

Performing AuditTrail

AuditTrail provides a flexible approach to tracking the changes to your data. It enables you to keep a history of changes to your important data: what changed, who changed it, and when. With AuditTrail, you can easily determine how any data row or element obtained its current value. You can track information on most types of fields, including character, number and date fields.

You enable auditing for audit groups. These are groups of tables and columns you want to audit, where you do not necessarily need to include all the columns in a given table. You typically group together those tables that belong to the same business process, such as employee compensation tables.

During your AuditTrail implementation, you need to decide your audit requirements:

  • Which tables and columns you want to audit
  • How you plan to report on the audit data
  • How long you want to keep the audit data active
    • Audit information reports
    • Custom audit reports

See: Oracle Applications System Administrator’s Guide.

Audit Information Reports

The AuditTrail process creates a shadow table for each audited table, to hold the audit information.

For tables that are not datetracked, you can write a report that uses the views on the shadow tables to access the audit data. However, for datetracked tables, the information from the shadow tables must be extracted and written to the HR_AUDITS table and the HR_AUDIT_COLUMNS table before you can report on it.

The system’s audit report performs this additional processing. You can use it as supplied or as an example of how to report on audit information. It can report on both datetracked and non-datetracked tables that have a numeric primary key.

Note: It can report on up to approximately 90 columns in datetracked tables and 80 columns in non-datetracked tables.

The report lists every change made to the table you select in the time period you specify when you run the report. You can restrict the reported changes to those made by a specified username. The changes are listed by date and time of the change. For each change, the report shows:

  • The date and time of the change
  • The user ID who made the change
  • The type of change
  • The fields that changed and either their old values, or their new values, or both, depending on the type of change

Table of Transaction Types in the Audit Report

The following table lists the 12 types of change and the information shown in the audit report for each type.

Type of ChangeField Values Shown in the Report
Normal Insert(creates a non-datetracked record)The non-null values in the new record.
Normal Update(updates a non-datetracked record)The old and new values for all fields that changed.
Normal Delete(deletes a non-datetracked record)The non-null values in the record that was deleted.
DT First Insert(creates a datetracked record)The non-null values in the new record.
DT Update(date-effectively ends the last row on a datetracked record and creates a new row)The old and new values of all fields that changed, and the new effective end date on the old row.
DT Correction(corrects a row of a datetracked record and does not change the effective dates)The old and new values of all fields that changed, and the effective dates of the corrected row.
DT Replace(creates a new row on a datetracked record that replaces all rows that start after its start date)The non-null values in the rows that were deleted, the new effective end date on the row preceding the new row, and the old and new values of all fields that changed.
DT Insert(creates a new row on a datetracked record that ends on the old effective end date of the preceding row)The old and new values of all fields that changed, and the new effective end date on the row preceding the new row.
DT Purge(deletes all rows of a datetracked record)The non-null values in all rows of the record that was deleted.
DT End Date(adds an effective end date to the last row of a datetracked record)The new effective end date of the row.
DT All(sets a new effective end date on a row of a datetracked record and deletes all following rows)The non-null values in the rows that were deleted, and the new effective end date on the last row.
DT Next(deletes a row of a datetracked record and uses its effective end date to set an new end date on the preceding row)The non-null values in the row that was deleted, and the old and new effective end dates on the preceding row.

Custom Audit Reports

If you want to design your own audit report, you can copy the supplied report and use it as the basis of your own version. The supplied report uses a dynamic SQL structure to retrieve information for the report, and an Oracle Report to format it.

Dynamic SQL Structure

For a non-datetracked table, the dynamic SQL structure retrieves information and uses a private procedure to retrieve the new values for an update.

For a datetracked table, the dynamic SQL structure retrieves information from the function and procedure created for each datetracked table by the Audit Trail Update Datetracked Tables process:

  • The tablename_TT function identifies the type of datetracked transaction represented by each row of the shadow table.
  • The tablename_VP procedure gets new values from the shadow table for update and insert transactions. It writes these to the HR_AUDITS and HR_AUDIT_COLUMNS tables.

The dynamic SQL structure comprises several character strings, which are concatenated into one long string, then parsed and executed using the dynamic SQL generator. If you change a string, you must ensure that you do not exceed the text space allocated to it, as listed in the package header.

The structure is built up by identifying the audited table column information, which is retrieved from the FND_AUDIT_COLUMNS table. The logic varies depending on the data type being audited.

The package for the dynamic SQL is called py_audit_report_pkg. It is found in the script pyadyn.pkh/pyadyn.pkb.

HR Audit Tables

The HR_AUDITS table holds audit information about the transaction. The HR_AUDIT_COLUMNS table holds the changed column information for that transaction.

HR_AUDITS Table

The following table shows the structure of the HR_AUDIT table:

COLUMNTYPENULL
audit_idnumber(15)not null  
commit_idnumber(9)not null  
current_session_idnumbernot null  
primary_keyvarchar2(30)not null  
primary_key_value       number(15)not null  
sequence_idnumber(9)not null  
session_idnumbernot null  
table_namevarchar2(30)not null  
timestampdatenot null  
transactionvarchar2(30)not null  
transaction_typevarchar2(30)not null  
user_namevarchar2(100)       not null  
effective_end_datedatenull
effective_start_date       datenull

HR_AUDIT_COLUMNS Table

The following table shows the structure of the HR_AUDIT_COLUMNS table:

COLUMNTYPENULL
audit_idnumber(15)not null  
column_idnumber(9)not null  
column_name       varchar2(30)not null  
new_valuevarchar2(240)       null
old_valuevarchar2(240)       null

Setting Up AuditTrail

Setting up AuditTrail is usually a task for the system administrator.

The first six steps are required to enable auditing of any Oracle Applications table. They are explained in more detail in the Oracle Applications System Administrator’s Guide. The final step is required only for tables in the HR application.

To set up AuditTrail

  1. Have your database administrator grant SELECT privileges on SYS.DBA_TABLES to the APPLSYS account. Normally this step will already have been done as part of your installation or upgrade.
    Using a System Administrator responsibility:
  2. In the System Profile Values window, set the AuditTrail:Activate profile option to Yes at Site or Application level.
  3. In the Audit Installations window, query the application(s) you want to audit, and check the Audit Enabled box next to the Oracle User Name.
  4. In the Audit Groups window, query the application and enter a name for the audit group, then select the tables you want to audit (using the User Table name). For a new audit group, select Enable Requested in the Group State field.
  5. In the Audit Tables window, query each table you want to audit, and select which columns in these tables you want to audit.
    Note: You cannot audit LONG, RAW, or LONG RAW columns.
  6. In the Submit Request window, run the AuditTrail Update Tables process. This process:
    • Creates database triggers on your audited tables
    • Creates one shadow table for each audited table, to contain the audit information
    • Builds special views on non-datetracked tables, which you can use to retrieve your audit data for reporting
    Using an HR Manager responsibility:
  7. In the Submit Request window, run the AuditTrail Update Datetracked Tables process. For each datetracked table, this process:
    • Creates an index on the shadow table
    • Creates the function tablename_TT and the procedure tablename_VP, which extracts information from the shadow table when you run the predefined audit report
    Important: You must rerun the AuditTrail Update Tables process and the AuditTrail Update Datetracked Tables process if you make any changes in the Audit Groups or Audit Tables windows.

Disabling AuditTrail

To disable AuditTrail

  1. You can disable the auditing of an audit group at any time by selecting a Disable state in the Audit Groups window.
    Tip: If you are planning high volume transactions on an audited table, such as loading a batch of information from another system, consider disabling auditing for the table’s audit group. This will enable the batch loading to complete more quickly.
    Before you restart auditing, you should archive your audit data, according to your business needs, and purge the shadow tables. You purge the tables by setting the audit group to Disable – Purge Table and running the Audit Trail Update Tables report. To restart auditing, you set the audit group to Enable Requested and rerun the Audit Trail Update Tables process and the Audit Trail Update Datetracked Tables process.

Running the Predefined Audit Report

You can run an audit report using the system’s predefined structure, or you can design your own audit report.

To run the predefined audit report

  1. Using an HR Manager responsibility, open the Submit Request window and select Audit Report in the Name field.
  2. Enter the Parameters field to open the Parameters window.
  3. Select an audited table (that is, one in an audit group) using the Table name.
  4. Select a value for the Initialization parameter:
    • Yes means that the report removes any existing data related to your selected table from the HR_AUDITS table and the HR_AUDIT_COLUMNS table. It then populates these tables with the current values from your selected table and reports on these.
    • No means that the report runs on the existing data in the HR_AUDITS table and the HR_AUDIT_COLUMNS table.
    • Refresh means that the report removes existing data for all tables from the HR_AUDITS table and the HR_AUDIT_COLUMNS table. It then populates these tables with the current values for your selected table and reports on these.
  5. If you only want to report on the changes made by one user, enter the user name.
  6. Enter start and end dates to limit the time period for reporting audit information.
  7. Choose the Submit button.
    You can use the View Requests window to check the progress of the report.

Let's set up a call?

Send over your name and email and we can coordinate to do call over coffee!

We'll get in touch

Let's set up a call

Send over your name and email and we can coordinate to do call over coffee!

We'll get in touch

Let's get on a call!

Send over your name and email and we can coordinate to do call over coffee!

We'll get in touch

Subscribe To Keep Up To Date

Subscribe To Keep Up To Date

Join our mailing list to receive the latest news and updates.

You have Successfully Subscribed!

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close