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.
Showing posts with label api/sql. Show all posts
Showing posts with label api/sql. Show all posts
Saturday, August 23, 2008
0
comments
Useful Sysadmin SQL statements
Labels: api/sql, SQL
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.
1. SQL Statement to find the list of responsibilities, which got the access to a particular function.
Thursday, July 17, 2008
0
comments
FND_PROFILE API
Labels: api/sql, oracle api
In oracle user Profile functionality is provided in the FND_PROFILE package and the FNDSQF library.
What is inside this API:
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
Subscribe to:
Posts (Atom)
About Me
-
AK Lakshmanan - I am an oracle EBS technical enthusiastic. I have hands full of experience on Oracle forms, reports, BI Publisher and also familiar with the Techno Functional aspects of Order 2 Cash and Manufacturing modules. The views expressed on this blog are my own and do not reflect the position of Oracle or any other corporation.
Follow This Blog
Creative Common
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License.