Scripts to recursively checkin / checkout / add to source control in Clear case.

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

http://etrm.oracle.com

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

R12 Topic 2: Oracle Applications Product Prefixes / Oracle applications Products short name list in R12

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 - Web Applications Desktop Integrator
BOM - Bills of Material
BSC - Balanced Scorecard
CCT - Telephony Manager
CDR - Oracle Clinical Data Repository
CE - Cash Management
CHV - Supplier Scheduling
CLA - APAC Consulting Localizations
CLE - EMEA Consulting Localizations
CLJ - Japan Consulting Localizations
CLL - LAD Consulting Localizations
CLN - Supply Chain Trading Connector for RosettaNet
CN - Incentive Compensation
CPGC - CPG - CDOA
CRP - Capacity
CS - Service
CSC - Customer Care
CSD - Depot Repair
CSE - Asset Tracking
CSF - Field Service
CSI - Install Base
CSL - Field Service/Laptop
CSM - Field Service/Palm
CSN - Call Center
CSP - Spares Management
CSR - Scheduler
CSS - Support (obsolete)
CST - Cost Management
CTB - Clinical Transaction Base
CUA - Capital Resource Logistics - Assets
CUC - Revenue Accounting
CUE - Billing Connect (obsolete)
CUF - Capital Resource Logistics - Financials
CUG - Citizen Interaction Center
CUI - Network Logistics - Inventory
CUN - Network Logistics - NATS (obsolete)
CUP - Network Logistics - Purchasing
CUR - Mass Market Receivables for Comms
CUS - Network Logistics
CZ - Configurator
DDD - CADView-3D
DDR - Demand Signal Repository
DEM01 - Team 01 Order Entry Demo
DNA - Development
DOM - Document Managment and Collaboration
DPP - Oracle Price Protection
DT - DateTrack
DUMMY_GMO - Obsolete Process Operations
EAA - SEM Exchange (obsolete)
EAM - Enterprise Asset Management
EC - e-Commerce Gateway
ECX - XML Gateway
EDR - E-Records
EGO - Advanced Product Catalog
EMS - Environment Management System
ENG - Engineering
ENI - Product Intelligence
EVM - Value Based Management
FEM - Enterprise Performance Foundation
FF - FastFormula
FII - Financial Intelligence
FLM - Flow Manufacturing
FND - Application Object Library
FPA - Project Portfolio Analysis
FPT - Banking Center (obsolete)
FRM - Report Manager
FTE - Transportation Execution
FTP - Transfer Pricing
FUN - Financials Common Modules
FV - Federal Financials
GCS - Financial Consolidation Hub
GHR - US Federal Human Resources
GL - General Ledger
GMA - Process Manufacturing Systems
GMD - Process Manufacturing Product Development
GME - Process Manufacturing Process Execution
GMF - Process Manufacturing Financials
GMI - Process Manufacturing Inventory
GML - Process Manufacturing Logistics
GMO - Manufacturing Execution System for Process Manufacturing
GMP - Process Manufacturing Process Planning
GMS - Grants Accounting
GMW - Process Manufacturing Portal
GNI - Genealogy Intelligence
GR - Process Manufacturing Regulatory Management
HCA - Healthcare
HCC - iHCConnect
HCN - iHCIntegrate
HCP - Healthcare Intelligence
HCT - Healthcare Terminology Server
HRI - Human Resources Intelligence
HXC - Time and Labor Engine
HXT - Time and Labor
IA - iAssets
IAM - Digital Asset Management
IBA - iMarketing (Obsolete)
IBC - Content Manager
IBE - iStore
IBP - Bill Presentment & Payment
IBT - iAuction
IBU - iSupport
IBW - Oracle Web Analytics
IBY - Payments
ICX - Oracle iProcurement
IEB - Interaction Blending
IEC - Advanced Outbound Telephony
IEM - Email Center
IEO - Interaction Center Technology
IEP - Predictive
IES - Scripting
IET - Call Center Connectors
IEU - Universal Work Queue
IEV - IVR Integrator
IEX - Collections
IGC - Contract Commitment
IGF - Financial Aid
IGI - Public Sector Financials International
IGS - Student System
IGW - Grants Proposal
IMC - Customers Online
IMT - iMeeting (obsolete)
INL - Oracle Landed Cost Management
INV - Inventory
IPA - Capital Resource Logistics - Projects
IPD - Product Development (obsolete)
IPM - Oracle Imaging Process Management
IRC - iRecruitment
ISC - Supply Chain Intelligence
ISX - iSettlement
ITA - Information Technology Audit
ITG - Internet Procurement Enterprise Connector
IZU - Oracle E-Business Suite Diagnostics
JA - Asia/Pacific Localizations
JE - European Localizations
JG - Regional Localizations
JL - Latin America Localizations
JMF - Supply Chain Localizations
JTF - CRM Foundation
JTM - Mobile Application Foundation
JTS - CRM Self Service Administration
LNS - Loans
ME - Controlled Availability Product(Obsolete)
MFG - Manufacturing
MIA - Mobile Applications for Inventory Management
MIV - Media Interactive
MQA - Mobile Quality Applications
MRP - Master Scheduling/MRP
MSC - Advanced Supply Chain Planning
MSD - Demand Planning
MSO - Constraint Based Optimization
MSR - Inventory Optimization
MST - Transportation Planning
MTH - Oracle Manufacturing Operations Center
MWA - Mobile Applications
OAM - Oracle Applications Manager
ODQ - Data Query
OE - Order Entry
OFA - Assets
OKB - Contracts for Subscriptions (Obsolete)
OKC - Contracts Core
OKC_REP_TXT_INDEX_OPTIMIZE - Optimize Contracts Repository Text index
OKC_REP_TXT_INDEX_SYNC - Build/syncronize Contracts Repository Text index
OKE - Project Contracts
OKI - Contracts Intelligence
OKL - Leasing and Finance Management
OKO - Contracts for Sales (Obsolete)
OKP - Contracts for Procurement (Obsolete)
OKR - Contracts for Rights (Obsolete)
OKS - Service Contracts
OKT - Royalty Management
OKX - Contracts Integration
ONT - Order Management
OPI - Operations Intelligence
OTA - Learning Management
OUC - University Curriculum
OZF - Trade Management
OZP - Trade Planning (Obsolete)
OZS - iClaims (Obsolete)
PA - Projects
PAY - Payroll
PBR - Budgeting and Planning
PER - Human Resources
PFT - Oracle Profitability Manager
PJI - Project Intelligence
PJM - Project Manufacturing
PMI - Process Manufacturing Intelligence
PN - Property Manager
PO - Purchasing
POA - Purchasing Intelligence
POM - Exchange
PON - Sourcing
POS - iSupplier Portal
PQH - Public Sector HR
PQP - Public Sector Payroll
PRP - Proposals
PSA - Public Sector Financials
PSB - Public Sector Budgeting
PSP - Labor Distribution
PSR - Public Sector Receivables
PTX - Patch Tracking System
PV - Partner Management
QA - Quality
QOT - Quoting
QP - Advanced Pricing
QPR - Oracle Deal Management
QRM - Risk Management
RCM - Regulatory Capital Manager (obsolete)
RG - Application Report Generator
RHX - Advanced Planning Foundation(obsolete)
RLA - Release Management Integration Kit (Obsolete)
RLM - Release Management
RMG - Risk Manager
RRC - Retail Core
RRS - Site Management
SHT - Applications Shared Technology
SSP - SSP
SYSADMIN - System Administration
TEST - test
VEA - Automotive
VEH - Automotive Integration Kit (Obsolete)
WIP - Work in Process
WMA - Manufacturing Mobile Applications
WMS - Warehouse Management
WPS - Manufacturing Scheduling
WSH - Shipping Execution
WSM - Shop Floor Management
XDO - XML Publisher
XDP - Provisioning
XLA - Subledger Accounting
XLE - Legal Entity Configurator
XNA - Service Assurance for Communications
XNB - Oracle Telecommunications Billing Integrator
XNC - Sales for Communications (Obsolete)
XNI - Install Base Intelligence (Obsolete)
XNM - Marketing for Communications (Obsolete)
XNP - Number Portability
XNS - Service for Communications (obsolete)
XNT - TeleBusiness for Telecom/Utilities
XTR - Treasury
ZFA - Financial Analyzer
ZPB - Enterprise Planning and Budgeting
ZSA - Sales Analyzer
ZX - E-Business Tax

Quick Reference about oracle website

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.

R12 new features : Topic 1

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.

Array in shell script.

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

Playing with mkstore..

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 password << END_OF_MKSTORE
END_OF_MKSTORE

echo -n "Done creating wallet entry for user"