Watch the best of live programming from Oracle OpenWorld, including major keynotes, Q&A with OTN Heavy Hitters, special editions of TechCast, technical keynotes and sessions and more.
Live programming
Sunday 10/11: 12:30 p.m. – 7:00 p.m. PT
Monday 10/12, Tuesday 10/13, Wednesday 10/15: 8:00 a.m. – 5:00 p.m. PT
Replay programming
Monday 10/12, Tuesday 10/13, Wednesday 10/15: 5:00 p.m. – [...]
| Read More.... | Comments |
After seeing Tim Dixter post about fixed line and row filler I decided to post about the handling string wrapping in the template.
Here is the invoice template screens hot,
Ok let me start explaining how I handle the string wrapping. Before that let me let me tell you the requirement.
1. Need to display fixed lines.
2. If [...]
| Read More.... | Comments |
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 [...]
| Read More.... | Comments |
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 tableICX_PARAMETERS which gives you the information of the application URL. But keep in mind you need the username and [...]
| Read More.... | Comments |
We had seen lot of occassions to submit a concurrent program from pl/sql program using FND_REQUEST.SUBMIT_REQUEST. But how many of us had really came accross real scenario where you need to submit a request set.
I had done this 5 years ago in one my project. Recently I had again came across a situvation where I [...]
| Read More.... | Comments |
Some of you must have noticed the check amount that is getting printing words may not be printing the units and subunits of the amount.
For example, if you have the check currency code in USD, then the amount in words will be printing some thing like “One Thousand Four Hundred Twenty-Two Dollars And Eighty-Two Cents*****“
but if [...]
| Read More.... | Comments |
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.
SELECT *
FROM fnd_responsibility_vl
WHERE menu_id IN
(SELECT menu_id
FROM fnd_menus_vl
WHERE menu_id IN
(SELECT menu_id
FROM fnd_menu_entries_vl START
WITH function_id =
(SELECT [...]
| Read More.... | Comments |
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 [...]
| Read More.... | Comments |
The latest Doodle:
|
