M&S is excited to be the Principle Sponsor for the Pittsburgh OAUG Annual Golf Outing. We hope you’ll join us for a fun morning of Golf, Food, and Prizes on August 15th. We play a Par Quota Scramble held at Buffalo Golf Course, where you can enjoy “one of the best golfing experiences in the Pittsburgh area.” There will be a 9am shotgun start, so please join us early on the course at 8am. The cost is $40 per person or $160 per foursome. For registration information visit the PittOAUG website and download the flyer today. We hope to see you out there!
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
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 11.1.1.6
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
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 11.1.1.6
OBIEE 11.1.1.6 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)
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
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