Sandeep Panchal Blog

Clear case Version 7.0.1 does not provide the feature of recurcive. Using these scripts you can make your life easy, I had to upload 1000s of files and directory to clear case and I was able to do it recursively. Use the great scripts. http://www.ibm.com/developerworks/rational/library/4687.html#N101AF

This is one of my favourite website from Oracle.... - What you can do with this website - You can get the latest OBJECT information about any object in Oracle applications. APPLSYSPUB (Schema) , Has 17 Synonyms and they are very well described. You can explore all schema using this website. BSC_SECURITY_PKG Base Object: APPS.BSC_SECURITY_PKG FND_APPLICATION FND_APPLICATION_TL FND_APPLICATION_VL FND_DISCONNECTED FND_LANGUAGES_TL FND_LANGUAGES_VL FND_LOOKUPS FND_MESSAGE FND_PRODUCT_GROUPS FND_PRODUCT_INSTALLATIONS FND_PUB_MESSAGE FND_SECURITY_PKG FND_SESSIONS FND_SIGNON FND_UNSUCCESSFUL_LOGINS FND_WEBFILEPUB

Applications Product Prefixes ABM - Activity Based Management (Obsolete) AD - Applications DBA AHL - Complex Maintenance Repair and Overhaul AHM - Hosting Manager(Obsolete) AK - Common Modules-AK ALR - Alert AME - Approvals Management AMF - Fulfillment Services (Obsolete) AMS - Marketing AMV - Marketing Encyclopedia System AMW - Internal Controls Manager AN - Sales Analysis AP - Payables AR - Receivables AS - Sales Foundation ASF - Sales Online ASG - CRM Gateway for Mobile Devices ASL - Sales Offline ASN - Sales ASO - Order Capture ASP - Oracle Sales for Handhelds AST - TeleSales AU - Application Utilities AX - Global Accounting Engine AZ - Application Implementation BEN - Advanced Benefits BIC - Customer Intelligence (obsolete) BIE - eCommerce Intelligence BIL - Sales Intelligence BIM - Marketing Intelligence BIN - Communications Intelligence BIS - Applications BIS BIV - Service Intelligence BIX - Interaction Center Intelligence BIY - Systems Intelligence BLC - Utility Billing BNE - W...

Resource Contact Information or Web Site Purchase additional products, full-use licenses, version updates, and documentation in the U.S.A. http://oraclestore.oracle.com Access technical resources for developers http://www.oracle.com/technology Access installation documentation http://www.oracle.com/technology /documentation Access information about technical support http://www.oracle.com/support Locate local Oracle Support Centers outside the U.S.A. http://www.oracle.com/support Locate local Oracle offices outside the U.S.A http://www.oracle.com/global Oracle Software downloads http://www.oracle.com/technology/software/index.html Oracle By Example ( One of my favoutire link) http://www.oracle.com/technology/obe/start/index.html Oracle documentation http://www.oracle.com/technology/documentation/index.html Hope this helps.

New features R12 Topic 1 Case Sensitivity in Oracle Applications User Passwords In previous releases of Oracle Applications, user passwords were treated as case insensitive. Now, Oracle Applications user passwords can optionally be treated as case sensitive, depending on the mode you choose. Case-sensitivity in passwords is controlled by the site-level profile option Signon Password Case. This profile has two possible settings: • Sensitive - Passwords are stored and compared as they are, with the password case • Insensitive (or unset) - Passwords are treated as case insensitive. In Insensitive mode, passwords are stored and compared in uppercase, similar to that in earlier releases. The entered password and the decrypted password are converted to uppercase prior to comparison.

Creating number of directories and subdirectories is kind of often required. Setting up Array in shell scripts really helps..how ? Here is it. set -A ARR a b c d e f g h i j k l m n o p i=0 while [ $i -lt 12 ] do curdir=${ARR[$i]} cd $curdir cd scripts print " Doind something" $curdir mkdir/any other unix command..which you want to do in all sub directories cd ../.. (( i=i+1 )) done

It is often necessary to make connections to the database from shell scripts held on the file system. This can be a major security issue if these scripts contain the database connection details. Oracle gives us the option of using a secure external password store where the Oracle login credentials are stored in a client-side Oracle wallet. This allows scripts to contain connections using the "/@db_alias" syntax. Create a wallet and wallet entry for database connection. Identify the wallet location set the wallet location as TNS_ADMIN export TNS_ADMIN= create the sqlnet.ora file Create the tnsnames.ora file with the wallet entries run create_wallet.sh which will ask you about the schema and wallet password. Create_wallet.sh..You can wrap up commands in a single shell file if you need to create lot of wallet entries on many locations. echo -n "Creating Wallet entries.." print $password \n | mkstore -wrl $TNS_ADMIN -createCredential walletname username...