Database Blog

Oracle iSetup document – Automatic migration of setups in EBS R12

https://docs.google.com/document/d/1CtKNFnMP1w39y0Z8RfCnLZykPWB_qBQiyMDlfxDl8c8/edit

Read More

Script to Check Oracle EBS Profile options based on Profile Value

select p.profile_option_name SHORT_NAME, n.user_profile_option_name NAME, decode(v.level_id, 10001, ‘Site’, 10002, ‘Application’, 10003, ‘Responsibility’, 10004, ‘User’, 10005, ‘Server’, ‘UnDef’) LEVEL_SET, decode(to_char(v.level_id), ‘10001’, ”, ‘10002’, app.application_short_name, ‘10003’, rsp.responsibility_key, ‘10005’, svr.node_name, ‘10006’, org.name, ‘10004’,…

Read More

Useful options in FNDCPASS…Which is good to know!!

Generally we know that FNDCPASS utility can be used to change the apps schema password andindividual base/application schemas (ap,ar,gl,etc etc) password. But there are few options which we should know.1.…

Read More

Oracle EBS user level scripts

Read More

Various scripts used with Concurrent Manager/Requests

Read More

Easy Way to find Ports in Oracle Applications

Here is one of the easy way to find PORT details in Oracle Application environment.1. Login to applmgr user2. cat $CONTEXT_FILE “Pipe” grep “Port” “Pipe” grep -v start_cmd 3. Here…

Read More

Environment Details Template [ E-Business Environment ]

please find Template to store Environment Details [ E-Business Environment ] in the below link. Click ME !!! for template – Environment Details Hope it helps…

Read More

Steps to test Oracle DR switchover Simulation with Oracle EBS

Environment Details: Operating System       : EL 4 Update 6 Oracle DB                   : 10.2.0.4 EBiz                             : 11.5.10.2 Two node architecture: DB & Concurrent  in one node ( PRIMDBSERV) Web ,Reports &…

Read More

Oracle EBS password security measure

Password Related Profile Options in APPS: Signon Password Case :-This profile option is used to force case sensitivity in user passwords. This option allows for tighter security, as well as…

Read More

Steps to Debug Oracle Patch Failure in Oracle Applications

Following are the steps to debug Patch failures in Oracle applications 1) Check the patch log file :  Log file for adpatch or apps patch will exist as specified while…

Read More