Tuesday, July 22, 2008 0 comments

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.


Thursday, July 17, 2008 0 comments

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