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 : ,

Receipt API in Oracle Receivables

Posted by Jiltin     Tags: , , 23 February, 2009    1,967 views    (0) Comment

Autolock box provides a functionality to create receipts using interface method. Recent versions of oracle applications, especially 11.5 onwards, Receipt API is getting used as they are flexible to the user’s need, and customization across all kinds of interfaces, loading. Here are the receipt APIs used in 11i Read Full Article (Click here)...

Categories : 11i Scripts, Receivables Tags : , ,

How to run a unix host command from oracle plsql package?

Posted by Jiltin     Tags: , , 16 February, 2009    9,450 views    (3) Comment

Often you will come across a situation in which you need to execute unix commands from plsql packages. If a simple utility exists to run unix command within plsql that simplifies your life instead of changing the design or finding an alternate approach to meet the goal. Oracle has provided a utility dbms_pipe run the UNIX host command from sql, plsql. Here are the sample script to run the host_command. SELECT apps.host_command(‘ls -ltr’)  FROM dual SELECT Read Full Article (Click here)...

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

Power of Linux / Unix – Sed – return previous line for pattern match

Posted by Jiltin     Tags: , , , 25 January, 2009    969 views    (2) Comment

This shows the power of Linux Bash script to “return previous line for pattern match” Need some idea on file processing, I have file like below, Processing al sources … …No value found : CHECK. Completed comparing all  sources. Comparing schedulers… Processing al targets … …No value found : From above I need to extract the line where “No value found” is available, which is simple, but I also wanna print the line before Read Full Article (Click here)...

Categories : Scripts Unix Tags : , , ,

Sample Unix/Linux sftp shell scripting to read and xml, find data file, and transfer to another server

Posted by Jiltin     Tags: , , , , 22 January, 2009    770 views    (0) Comment

The following linux bash script shows sample sftp shell script to read and xml, find data file, and transfer to another server. You must have set the ssh trust setup between the servers. By setting up the trust, you do not need to input a password. #!/bin/sh #************************************************************************************************** # # Script Name: sftpdata.sh # # Developed by Read Full Article (Click here)...

Categories : Scripts Unix Tags : , , , ,