Oracle Community

The social network for Oracle people

Jiltin
  • 43
  • Santa Clara, CA
  • United States
Share on Facebook
Share Twitter
  • Blog Posts (16)
  • Discussions
  • Events
  • Groups (14)
  • Featured Photos
  • Photo Albums
  • Featured Videos

Jiltin's Friends

  • James Su
  • abul kalam
  • Priyadarshi Nayak
  • Todd Sheetz
  • Mahmoud Gaber Metwally
  • Chola
  • ramesh babu V
  • Rianne van Duijn - Aziz
  • Carl Guse
  • Larry Sherrod
  • Surachart Opun
  • venkatesh
  • Asif Momen
  • Dave Best
  • Fuad Arshad

Jiltin's Groups

Gifts Received

Gift

Jiltin has not received any gifts yet

Give a Gift

 

Jiltin's Page

Latest Activity

danny left a comment for Jiltin
"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.…"
Feb 8, 2011
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,…"
Jan 3, 2011
James Su and Jiltin are now friends
Jun 24, 2010
Jiltin is now friends with Chola, Surachart Opun, ramesh babu V and 2 more
Sep 16, 2009
Jiltin posted a blog post

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 instead of…See More
May 14, 2009
Jiltin posted blog posts
May 11, 2009
Jiltin posted a blog post

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");byJiltinSee More
Apr 24, 2009
Jiltin posted a blog post

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 oracle3. You need apps password to run this script. Alternately…See More
Apr 20, 2009
Jiltin posted blog posts
Apr 15, 2009
Jiltin posted blog posts
Apr 14, 2009
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."
Apr 13, 2009
Jiltin posted a blog post

Here 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
Apr 3, 2009
Jiltin posted blog posts
Mar 31, 2009
Jiltin posted a blog post

List 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
Mar 24, 2009
Jiltin joined Eddie Awad's group
Thumbnail

Database Developers

Join us if you develop database applications using SQL and PL/SQL.
Mar 18, 2009
Jiltin joined Todd Sheetz's group
Thumbnail

Independent Oracle User Group

For the complete technology and database professional.
Mar 18, 2009

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

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

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

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

Posted on April 20, 2009 at 12:00pm

Comment Wall (2 comments)

You need to be a member of Oracle Community to add comments!

Join Oracle Community

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.

Badges  |  Report an Issue  |  Terms of Service