Understanding the Core Oracle E-Business Suite HRMS Tables

Shannon MiskevicsOracle2 Comments

Understanding the Core Oracle E-Business Suite HRMS Tables

There are hundreds of tables in Oracle E-Business Suite HRMS, but some are used more frequently than others. When querying, it is important to not only know the common tables that are used, but also to understand how the tables link together. Some of the common tables are listed below. Common HRMS Tables The chart above shows some of the most common tables that are used in Oracle HRMS. Often, a column in one table will link to a column in a different table. For example, the primary key PERSON_ID in the PER_ALL_PEOPLE_F table will link to the foreign key … Read More

Everything You’ve Ever Wanted to Know About HR Date-Tracking in Oracle EBS

Shannon MiskevicsOracle, Technical TipsLeave a Comment


Date-tracking is an original function through Oracle E-Business Suite (EBS) Human Capital Management (HCM). This function allows companies to edit their employees’ information and create continuity between different records. Date-tracking is an important function in EBS HCM, especially when it comes to changing employee person status, job position, etc. Correction and Update For this example, Jim Jones started as a Sales Consultant. To change information after it is entered so that instead Jim is married, use the correction function. When correcting an entry, it overrides the previous record with the error and replaces it with the new information. Therefore now it … Read More

Customizing the Auto-Complete Prompt Functionality in OBIEE

Brian BurdiOracle, Technical TipsLeave a Comment


There are some features that the auto-complete prompt functionality has. It can be turned on and off by either the user or the dashboard designer and the administrator can change different parameters in the code that was implemented to help meet the business’s needs. Turning off auto-complete on the dashboard level: Edit Dashboard and select Dashboard Properties: There will be an option to turn the Auto-Complete off:   Turning off auto-complete on the user level: Click on the user name -> My Account: Under Preferences the user can turn the Auto-Complete off:   [divider scroll_text=””] The administrator can configure the … Read More

Oracle EBS Query-by-Example – Query like a Pro

Tom GilpinOracle, Technical TipsLeave a Comment

abstract geometric colorful pattern

Knowing all of the options when querying in forms will help take users beyond average and toward ‘power user’ status. Master the use of query wildcards, and query operators as described below. Query Basics Query-by-Example is a simple three step process: While in a form, switch to query mode by selecting <F11> from the keyboard enter the criteria for the query execute the query by selecting <ctrl><F11> simultaneously from the keyboard   While performing step 2 (enter the criteria), with either wildcards or operators as shown in the tables below. Query Wildcards Query Operators In the examples below, the query … Read More

Enabling the Auto-Complete Prompt Functionality in OBIEE

Brian BurdiOracle, Technical TipsLeave a Comment

user interface form

OBIEE has an auto-complete prompt feature which when enabled allows users to begin typing a selection in the prompts and OBIEE will suggest and highlight the matching prompt values. This option is only available on the “Choice List” when “Enable user to type values” is selected. When the following code is implemented will also allow the auto-complete to be case insensitive. 1. Navigate to: 1 $MW_HOME/instances/instance1/config/OracleBIPresentationServicesComponent/coreapplication_obips1$MW_HOME/instances/instance1/config/OracleBIPresentationServicesComponent/coreapplication_obips1 2. Open instanceconfig.xml file (make a backup of the file prior to making any changes). 3. Add the following code between the <ServerInstance> … </ServerInstance><ServerInstance> … </ServerInstance> tags: <Prompts> <MaxDropDownValues>256</MaxDropDownValues> <AutoApplyDashboardPromptValues>true</AutoApplyDashboardPromptValues> <AutoSearchPromptDialogBox>true</AutoSearchPromptDialogBox> <AutoCompletePromptDropDowns> … Read More

Installing OEL on Specialized Storage Device (iSCSI SAN)

Joe PerksOracle, Technical TipsLeave a Comment

When installing Oracle Enterprise Linux via graphical interface, we are given the option to install on “Specialized Storage Devices”. This is an alternative to installing on a local hard drive. Select “Specialized Storage Devices”.   Select the “Other SAN Devices” tab, the click “Add Advanced Target”.   Since here we are using iSCSI, we select iSCSI target. Click “Configure network” and ensure your networking adapter is properly configured. Then click “Add Drive”.   Select the network interface that was previously configured.   Enter the IP address of your SAN server and the initiator name.   You will be presented with … Read More

E-Business Suite R12.1.3 HCM changes to VETS-100 Reporting

Tom GilpinOracle, Technical TipsLeave a Comment

E-Business Suite R12.1.3 HCM changes to VETS-100 Reporting

The Challenge VETS-100 reports present data for a 12 month period. Prior to R12.1.3, the E-Business Suite HCM processes used to create those reports, included parameters labelled ‘Report From Date’ and ‘Report To Date’.  This allowed users to select a duration of less than 12 months. The Solution To ensure that the report covers the appropriate time span, beginning with R12.1.3, Oracle E-Business HCM functionality replaces the date fields (Report From Date and Report To Date) with the date on which the 12 months conclude: 12 Month Period End Date. The field change affects the following reports: VETS-100 Suite Of … Read More