How-To: Disable the preference menu from SSA page

Today I remembered one my task which I had done few days ago. The actual given to me is to disable the Preferences menu option from few responsibilities which is actually a Self Service Application page. So as-usual I started searched metalink and google and found three solutions for this. Let me list all the three type of solutions for this.

Solution 1:

Updating the profile option "General Preferences Show Flag" value to 'No'.

Read more »

Getting the application URL

In some cases you might be having the access to the application database but not the URL to access the application. If you had come across any of this situation then no worries here is a table ICX_PARAMETERS which gives you the information of the application URL. But keep in mind you need the username and password for the application ;)

API to insert GL Code Combination

I had seen in many projects during the initial instance setup the functionals used to use the data loader to insert the GL code combinations. In fact if its just 1000 or 2000 records then it may be fine. But I had seen them using the data-loader to insert 70k - 200k records, which will take at-least 2 days for them to insert. Apart from this there will be some value set values might be missing which will interrupt there data loader.

Read more »

Useful Sysadmin SQL statements

As I mentioned in my last post, here in this post I would like to share some SQL queries which will/might be useful for the sysadmins.

1. SQL Statement to find the list of responsibilities, which got the access to a particular function.

Read more »

How-To: Find all the menus to which a function is attached?

I was wondering how to find the list of menus to which a function is attached in the oracle application. Everybody will think of writing a SQL query to find it. Even I did the same before knowing about Functional Administrator responsibility. Thanks to my colleague and good friend Vivek Srinivasan who told me about this responsibility.

Read more »

XSL function to convert number to word

For long time we have been searching for one function which can be used to convert the number into words. You all might know why this function is mandatory.

Yes this helps a lot when you are doing a check print report. Lot of them posted questions on oracle forum. The great Gareth, gave a suggestion to use package from database & convert into the words. Everybody thought they need to create some custom function for this. But AP module have its own function ap_amount_utilities_pkg.ap_convert_number to do this.

Read more »

FND_PROFILE API

In oracle user Profile functionality is provided in the FND_PROFILE package and the FNDSQF library.

What is inside this API:

• Retrieve user profile values for the current run-time environment


• Set user profile values for the current run-time environment

Read more »