Ever since I have been introduced to the world of Oracle apps almost 9 yeas back, the most admirable thing about Oracle apps has been the possibilities of accessing the data using the backend tables.
The uses of having the backend access are nearly endless and any consultant can immensely benefit from knowing the proper table structures and joins .
I had been able to write some very useful SQL's (useful for me :-) ) during the course of my career. But whenever I had needed it again after sometime, I had found that I had not stored that SQL in a proper place so that I could use it again. Ofcourse its just a matter of spending a few minutes to reconstruct it from scratch. But sometimes, I've wondered if I could store it in a place where I could access them easily so that it would help not just me but also other people.
I am not claiming that my SQL's and tips are accurate and they have been authorized by Oracle Corporation. Its a voluntary blog trying to help. The Profile Options, Financial Setups and other setups might affect the outcome of the SQL's and small customizations might be required to get proper data. Sometimes the objective is only to get an insight and might not result in unique records.
Thursday, September 4, 2008
Subscribe to:
Posts (Atom)