Oracle Apps Notes

A collection of my random notes, primarily on Oracle Apps

Category Archives: Metalink

Prevent users from uploading specific files in Oracle EBS

Oracle EBS provides a way to restrict the type of files which can be uploaded though the front end. This will, for example, prevent users from uploading specific file types through the Generic File Manager or from uploading XML report files (which is how I came across this feature).
The two main parts to this feature is the Attachment File Upload Restriction Default profile option and the FILE_MIME_TYPES table.
The FILE_MIME_TYPES table lists the various file types and specifies whether they are allowed to be uploaded or not. The Attachment File Upload Restriction Default profile option controls those file types which have not been explicitly allowed or disallowed in the FILE_MIME_TYPES. Attachment File Upload Restriction Default can have a value of Yes or No. If it is set to Yes, a file type can be uploaded from the front-end even if it has not been explicitly allowed or disallowed in FILE_MIME_TYPES. Setting this value to No will prevent the user from uploading any file type which has not been explicitly allowed in FILE_MIME_TYPES.
When this feature prevents users from uploading a file, they will see this message on the screen: This file type is not allowed. Please choose another file
For more details please check Metalink Note#1357849.1: Security Configuration Mechanism in the Attachments Feature in Oracle E-Business Suite.

Changing Oracle HRMS installation from FULL to SHARED

When Oracle HRMS is installed in the FULL mode, users may encounter errors while accessing HRMS forms from non-HRMS responsibilities. For example, users cannot access the Employees form from Customer Support responsibility or the Positions form from Purchasing Super User responsibility. This happens because forms included in non-HRMS responsibility menus are to be used on a Shared HR environment and cannot be used on an HR full installed environment.

The best way to resolve this problem is to work on the forms from an HRMS responsibility. But if that option is not available, then the Oracle HRMS installation has to be manually changed from FULL mode to SHARED mode.

The steps involved in changing Oracle HRMS installation from FULL to SHARED are:

1. Check whether the hrglobal.drv file has been run in the instance. In case the hrglobal.drv file has already been run against the instance, then the only way out is to perform a new installation in SHARED mode and export all data from the old instance to the new one. (I sincerely hope that no one reading this post has to choose this option! )

2. If the hrglobal.drv file has NEVER been run against the system, then find the application_id of all HRMS related products installed in FULL mode in the instance.

3. Update the FND_PRODUCT_INSTALLATIONS table to change all HRMS related products from FULL to SHARED

set STATUS = 'S'
where APPLICATION_ID IN (<appl_id1>,<appl_id2>);

Where appl_id1, appl_id2 are the application_id obtained from step#2.


1. Consult Oracle Support and raise an SR before trying to change the installation mode of Oracle HRMS.

2. The following SQL query checks whether hrglobal.drv has been run in an instance

select substr(application_short_name,1,4) app
, rpad(decode
(Legislation_code,null,'GLOBAL',Legislation_code),7,' ') LE_CODE
, rpad(status,14,' ') "Install Status"
, rpad(action,15,' ') "DataInst Action"
, last_update_date
from hr_legislation_installations
where application_short_name in ('PER','PAY')
order by LE_CODE,app;

If the Install Status column is ‘I’ for any row, it means that hrglobal.drv has been run in the instance.

3. The following SQL query shows the install status of HRMS related products

col a.application_name for a40
col a.application_short_name for a4
col b.status for a1
SELECT a.application_name,
FROM fnd_application_vl a, fnd_product_installations b
WHERE a.application_id = b.application_id
AND b.application_id IN (453,800,801,804,805,808,809,810,8301,8302,8303,8403)
ORDER BY a.application_id;


Metalink Note#369459.1: How Does One Verify which HRMS Products have been Installed?

Metalink Note#414631.1: SQL: HRMS Products Installation Status

Metalink Note#116376.1: You Have Installed, Now Before You Setup, Read This! – HR Shared

There was another note on the entire process of going from full to shared install but that seems to be no longer publicly available.


Long awaited goodbye to the Flash-based My Oracle Support

I came to know from Marc Fielding’s post that the Flash-based My Oracle Support is finally on the way out. Just the kind of good news to brighten up a Tuesday morning. Ever since it was introduced in 2009 with noble intentions, Flash-based MOS has had more critics than supporters. And with HTML5 starting to kill off Adobe Flash, it was about time MOS realised that the Flash-based version had to go.

The HTML version of MOS, is available for user acceptance testing while the Flash-based version will continue to be available. As the kinks get ironed out MOS should finally transition into the HTML version in the near future.

Speaking of kinks, there already seems to be one since the HTML version does not work in Google Chrome(16.0.912.77). It works fine in Internet Explorer(8) and Firefox(7.0.1) though.

Update: Now, works on Google Chrome too 🙂

And here is an example of one of those annoying bugs in the Flash-version(observed using Firefox and Chrome):

1. Log on MOS, enter a search term in the search box on the top-right corner and click on the search icon.
2. After the results are displayed, another search box is displayed on the left hand side of the page. Click on the ‘Advanced’ link for this search box.
3. In the Advanced search section that is displayed, select a relevant ‘Product’ to refine your search and click on ‘Search’.
4. You will notice that the area of the page where the Advanced search section was displayed in the previous step is now blank and the search results are visible below the blank area.

Do I need to tell you explicitly that the HTML does not exhibit this buggy behaviour?

Thank you Flash-based MOS, your short-lived, bug-ridden life is almost over. Welcome HTML MOS.