"Hi Jiltin, Hope you're doing fine please go thourgh the below requirement for a contract oppurtunity.. If interested please reply with your updated resume and contact details please.. Email ID : dinesh.chegoni@innosensesolutions.com.…"
The social network for Oracle people
-
Jiltin
- 43
- Santa Clara, CA
- United States
- Blog Posts (16)
- Discussions
- Events
- Groups (14)
- Featured Photos
- Photo Albums
- Featured Videos
- Jiltin's Apps (1)
Jiltin's Groups
-
Database Developers
232 members
-
Independent Oracle User …
15 members
-
Oracle Indonesia
65 members
-
Oracle OpenWorld 2008
63 members
-
Oracle Application Expre…
152 members
Gifts Received
Jiltin has not received any gifts yet
Jiltin's Page
Latest Activity
danny left a comment for Jiltin"Hi,Please go thorugh the below position and let me know your interest. Send me your updated Resume to dinesh.chegoni@innosensesolutions.com for future contract opputunities..Title: Oracle Functional R12 Financials LEADLocation: St. Louis,…"
Jiltin posted a blog postOracle Applications: Production to Development Refresh/Clone Parameter Change SQL Script
Big companies that follow Process oriented project management team, with multiple projects executed at phased manner, may face challenges during database refresh from production system to development or test systems. Many programs customized to connect to external systems such as lockbox servers, payment processing servers and other boundary server systems.After every refresh, it is imperative to change the development systems to point to null or Development external test servers instead of…See More
Jiltin posted a blog postHow to I see the debug messages either in log file or output file in oracle applications?
When you register a concurrent programs, such plsql packages, you can display the debug outputs either at output file or log file or both depending on the api you use. There are two functions from fnd_file packages that can be used to display the debug messages.fnd_file.put_line(FND_FILE.LOG,"This is logfile test");fnd_file.put_line(FND_FILE.out,"This is output test");byJiltinSee More
Jiltin posted a blog postHow To Add Responsibility to USER using pl/sql? - Oracle Applications
If you have the Apps Password, its quite easy to create a FND_USER for yourself by using the API. I find this script very useful when development environment gets cloned from Production(that is when i do not have FND_USER in Production).Please note that:-1. You will be allocated System Administrator by this script. Hence you can assign whatever responsibilities that you desire latter, after logging in.2. The password will be set to oracle3. You need apps password to run this script. Alternately…See More
Jiltin replied to Dinesh KV's discussion Help me- Data Synchronization in the group Performance Tuning"Normally, we have redundant servers on application servers as apps server is facing the people taking load
In such case, you need to have one db server and two or more apps server."
Jiltin posted a blog postHere are the excerpts of the Oracle 11g new password algorithm.
Here are the excerpts of the Oracle 11g new password algorithm. You can see the complete disclosure of the password algorithm and the history of tracingNothing to panic!: Research results suggest that SHA1 has, at most, 69 bit strength, significantly less than the 80 bits, but still no easy matter to attack with current technology. SHA-1 is secure and stronger than previous algorithm. According to wikipedia you can find a collision for SHA-1 in 2 to the power of 69 operations. This probably…See More
Jiltin posted a blog postList of Reposibilities for an user - Handy sql reference
I often get this issue to find out list of responsibilities assigned to an user, mainly to review the SOX controls or to enable new responsibilities.Lazy enough to go to System Administrator screen to query it. I always keep the TOAD open session and it is easy to grab the details using this sql.SELECT fu.user_name,frt.RESPONSIBILITY_NAME, fu.user_id,furg.responsibility_idFROMfnd_user_resp_groups furg,FND_RESPONSIBILITY fr,fnd_responsibility_tl frt,fnd_user fuWHERE fu.user_name =upper(…See More
Profile Information
- About Me:
- Oracle applications expert in financial. Wrote few applications/utilities, web master, Unix expert, php,plsql, Oracle & Mysql are favorites. My site jiltin.com. Many free utilities, and scripts useful for developer community. Feel free to stop by when you find time.
- My Blog:
- http://www.jiltin.com
- My Website:
- http://www.jiltin.com
Jiltin's Blog
Oracle Applications: Production to Development Refresh/Clone Parameter Change SQL Script
Big companies that follow Process oriented project management team, with multiple projects executed at phased manner, may face challenges during database refresh from production system to development or test systems. Many programs customized to connect to external systems such as lockbox servers, payment processing servers and other boundary server systems.
After every refresh, it is imperative to change the development systems to point to null or Development external test servers… Continue
After every refresh, it is imperative to change the development systems to point to null or Development external test servers… Continue
Posted on May 14, 2009 at 8:06am
Oracle Applications - Simple Query to find FND_LOOKUP Values.
Oracle Applications - Simple Query to find FND_LOOKUP Values.
SELECT B.ROWID ROW_ID, B.APPLICATION_ID, B.LOOKUP_TYPE, B.CUSTOMIZATION_LEVEL, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.SECURITY_GROUP_ID, B.VIEW_APPLICATION_ID, T.MEANING, T.DESCRIPTION
FROM FND_LOOKUP_TYPES_TL T, FND_LOOKUP_TYPES B
WHERE B.LOOKUP_TYPE = T.LOOKUP_TYPE
AND B.SECURITY_GROUP_ID = T.SECURITY_GROUP_ID
AND B.VIEW_APPLICATION_ID =… Continue
SELECT B.ROWID ROW_ID, B.APPLICATION_ID, B.LOOKUP_TYPE, B.CUSTOMIZATION_LEVEL, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.SECURITY_GROUP_ID, B.VIEW_APPLICATION_ID, T.MEANING, T.DESCRIPTION
FROM FND_LOOKUP_TYPES_TL T, FND_LOOKUP_TYPES B
WHERE B.LOOKUP_TYPE = T.LOOKUP_TYPE
AND B.SECURITY_GROUP_ID = T.SECURITY_GROUP_ID
AND B.VIEW_APPLICATION_ID =… Continue
Posted on May 11, 2009 at 10:00pm
Oracle Applications Script : Sample Script to Debug the Procedure, Packages Running At Backend
For mission critical operations with big - complex PLSQL packages, we may need to know the path or the way the data is processed. In such case, it is very hard to debug the flow. I had such situation many times and it is easy to implement a simple solution using a debug log table for future review purpose. Make sure you delete or purge the table often and also create a proper index on this table to avoid performance issues later. This procedure can be global or inside a package. With oracle… Continue
Posted on May 11, 2009 at 9:30pm
How to I see the debug messages either in log file or output file in oracle applications?
When you register a concurrent programs, such plsql packages, you can display the debug outputs either at output file or log file or both depending on the api you use. There are two functions from fnd_file packages that can be used to display the debug messages.
fnd_file.put_line(FND_FILE.LOG,"This is logfile test");
fnd_file.put_line(FND_FILE.out,"This is output test");
by
Jiltin
fnd_file.put_line(FND_FILE.LOG,"This is logfile test");
fnd_file.put_line(FND_FILE.out,"This is output test");
by
Jiltin
Posted on April 24, 2009 at 6:59am
How To Add Responsibility to USER using pl/sql? - Oracle Applications
If you have the Apps Password, its quite easy to create a FND_USER for yourself by using the API. I find this script very useful when development environment gets cloned from Production(that is when i do not have FND_USER in Production).
Please note that:-
1. You will be allocated System Administrator by this script. Hence you can assign whatever responsibilities that you desire latter, after logging in.
2. The password will be set to oracle
3. You need apps password… Continue
Please note that:-
1. You will be allocated System Administrator by this script. Hence you can assign whatever responsibilities that you desire latter, after logging in.
2. The password will be set to oracle
3. You need apps password… Continue
Posted on April 20, 2009 at 12:00pm
Comment Wall (2 comments)
- At 8:14am on February 8, 2011, danny said…
- Hi Jiltin,
Hope you're doing fine please go thourgh the below requirement for a contract oppurtunity.. If interested please reply with your updated resume and contact details please.. Email ID : dinesh.chegoni@innosensesolutions.com.
Position : Oracle Apex developer
Position OPEN until 10th of Feb 2011
Location: NEW YORK, NY
Duration: 6 months
Rate : Mention least workable rates please
Skills Set :
• Oracle Application Express development – Minimum 3 years
• Experience in converting MS Access application to Oracle Application Express/Oracle Database – Minimum 3 years
• Strong PL/SQL working knowledge - Minimum 5 years
• Oracle BI Publisher - Minimum 2 Years
• Knowledge of Java Script
• Exposure to HTML development
• Relational Database schema design – Minimum 4 Years
• Manipulation of MS Access and MS Excel
• Report development using Oracle Discoverer
• Development of reports using SAS statistical software
Warm Regards,
Dinesh Chegoni
Innosense Solutions Inc
Direct : 773-741-6400
Email : dinesh.chegoni@innosensesolutions.com
Web : www.innosensesolutions.com
Yahoo IM : dinesh.recruiter
- At 12:12pm on January 3, 2011, danny said…
- Hi,
Please go thorugh the below position and let me know your interest. Send me your updated Resume to dinesh.chegoni@innosensesolutions.com for future contract opputunities..
Title: Oracle Functional R12 Financials LEAD
Location: St. Louis, MO
Duration: 1 Year
Residency Restriction: None
Rate Target: $80 + Expenses
Release 12 Finance resource with GL, AP, AR, FA, CM Must be lead level and have excellent communications skills Will lead SDL workshops through end of global design phase and stay on for duration of implementation phase.
Warm Regards,
Dinesh Chegoni
Innosense Solutions Inc
Direct : 773-741-6400
Email : dinesh.chegoni@innosensesolutions.com
Web : www.innosensesolutions.com
Yahoo IM : dinesh.recruiter
© 2013 Created by Eddie Awad.
