Identify Oracle Database Locks

The below SQL gives the list of locks on the Database Objects and the corresponding Terminal

select nvl(S.USERNAME,'Internal') username,
       nvl(S.TERMINAL,'None') terminal,
       L.SID||','||S.SERIAL# Kill,
       U1.NAME||'.'||substr(T1.NAME,1,20) tab,
       decode(L.LMODE,1,'No Lock',
                      2,'Row Share',
                      3,'Row Exclusive',
                      4,'Share',
                      5,'Share Row Exclusive',
                      6,'Exclusive',null) lmode,
       decode(L.REQUEST,1,'No Lock',
                       2,'Row Share',
                       3,'Row Exclusive',
                       4,'Share',
                       5,'Share Row Exclusive',
                       6,'Exclusive',null) request
 from V$LOCK L,
      V$SESSION S,
      SYS.USER$ U1,
      SYS.OBJ$ T1
where L.SID = S.SID
  and T1.OBJ# = decode(L.ID2,0,L.ID1,L.ID2)
  and U1.USER# = T1.OWNER#
  and S.TYPE != 'BACKGROUND'
  and S.sid in(select blocking_session from v$session where blocking_session is not null)
order by 1,2,5


Print This Post

Enabling Oracle Apps 11i/R12 Regional EMEA APAC LATIN-AMERICAN Localizations

When you implement Oracle E-Business suite for different Regional Rollouts, you would want to adhere and implement Country Specific Statutory requirements.

Today, in this topic I would like to show how could we enable Regional Country Specific Localizations

Firstly, we check whether any of the Following Localizations are applied:

1. JA Asia/Pacific Localizations      
2. JE European Localizations         
3. JG Regional Localizations         
4. JL Latin-American Localizations

SELECT application_id, patch_level, product_version, decode(upper(status), 'N', 'Not Installed', 'I','Installed', 'L', 'Custom') "Status"
FROM fnd_product_installations fpi
WHERE application_id in (7000,  7002, 7003, 7004);

Application Id   Patch level  Product Version  Status
---------------      ------------ ---------------- ----------
7000             R12.JA.B.3   12.0.0           Not Installed
7002             R12.JE.B.3   12.0.0           Not Installed
7003             R12.JG.B.3   12.0.0           Not Installed
7004             R12.JL.B.3   12.0.0           Not Installed

If and when you want to use those country Specific Localization Functionality, you need to Licence the

Products, which is just registering of those products as below,

System Administartor -> Oracle Applications manager -> Licence Manager -> Site Map -> Country Specific Functionalities -> Selected Country specific functionality

Asia/Pacific countries for JA
European countries for JE - As an example here France is selected
Latin-American countries for JL

Click on Next






Click on Submit




And Finally the Specific Localizations should come as installed

SELECT application_id, patch_level, product_version, decode(upper(status), 'N', 'Not Installed', 'I','Installed', 'L', 'Custom') "Status"
FROM fnd_product_installations fpi
WHERE application_id in (7000,  7002, 7003, 7004);

Application Id   Patch level  Product Version  Status
---------------  ------------ ---------------- ----------
7000             R12.JA.B.3   12.0.0           Not Installed
7002             R12.JE.B.3   12.0.0           Installed
7003             R12.JG.B.3   12.0.0           Not Installed
7004             R12.JL.B.3   12.0.0           Not Installed

Print This Post

R12: Add on Localization Patches

Whenever any company implements Americas, Europe, the Middle East & Africa, APAC specific Rollouts of the Oracle EBS Implementation, it is necessary to check the Add-on Localization Features provided by ORACLE and apply the specific patches to the respective Development/Test environments.

All the Add on Localization Patches for R12 are under the ORACLE Meta link Note: 429042.1

Video to guide you how to look for Add on Localization patches for R12

Print This Post