Oracle Applications: Production to Development Refresh/Clone Parameter Change SQL Script.

Posted by Jiltin     Tags: , 12 May, 2009    2,005 views    (1) Comment

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 Read Full Article (Click here)...

Categories : 11i Scripts, Oracle AOL, Oracle Applications, Scripts Oracle Tags : ,

Oracle Applications: Another SQL script to find the profile option values.

Posted by Jiltin     Tags: , 6 May, 2009    1,309 views    (0) Comment

Here is another script that reports Profile Options For Oracle Applications. You can also Download a_profile_opt_r11i.sql here rem       rem     File:      a_profile_opt_R11i.sql rem     DESC:      Reports Profile Options FOR Oracle Applications rem                WITH NOT NULL VALUES, groups BY Profile OPTION Name rem                breaks BY Read Full Article (Click here)...

Categories : 11i Scripts Tags : ,

How to I see the debug messages either in log file or output file in oracle applications?

Posted by Jiltin     Tags: , 24 April, 2009    1,063 views    (1) Comment

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"); Following Google Searches Lead To This Post: Read Full Article (Click here)...

Categories : 11i Scripts, Oracle Applications Tags : ,

How To Add Responsibility to USER using pl/sql? – Oracle Applications

Posted by Jiltin     Tags: , 20 April, 2009    6,374 views    (10) Comment

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 to run this script. Read Full Article (Click here)...

Categories : 11i Scripts, Oracle AOL, Scripts Oracle Tags : ,

Oracle Applications – Acoounts Receivables (AR) Tables Information.

Posted by Jiltin     Tags: , , , 13 April, 2009    9,696 views    (5) Comment

RA_CUSTOMER_TRX_ALL This table stores invoice, debit memo, commitment, and credit memo header information. Each row includes general invoice information such as customer, transaction type, and printing instructions. You need one row for each invoice, debit memo, commitment, and credit memo you create in Oracle Receivables. Invoices, debit memos, credit memos, and commitments are all distinguished by their transaction types stored in RA_CUST_TRX_TYPES_ALL. If you entered a credit memo, Read Full Article (Click here)...

Categories : Oracle Applications, Receivables Tags : , , ,