Wednesday, November 15, 2017

Oracle EBS 12.2.7 Docs

Installation
=========
Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for Linux x86-64 ( Doc ID 1330701.1 )
Troubleshooting Rapid Install for E-Business Suite Release 12.2 ( Doc ID 1378579.1 )

ETCC Patches
===============
1) How To Run The 12.2 EBS Technology Code Level Checker (ETCC) ? ( Doc ID 2008451.1 )
2) Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes ( Doc ID 1594274.1 )
3) Oracle E-Business Suite 12.2 Patching Technology Components Guide ( Doc ID 1355068.1 )
4) For post-install steps for RDBMS Patches, run "datapatch"

Upgrading AD/TXK
================
Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 ( Doc ID 1617461.1 )

12.2.7
=====
Oracle E-Business Suite Release 12.2.7 Readme ( Doc ID 2230783.1 )

Additional Resources
=================
Oracle E-Business Suite Release Notes, Release 12.2 (Doc ID 1320300.1)
Useful E-Business Suite 12.2 Documents ( Doc ID 1585889.1 )
Oracle E-Business Suite 12.2 Patching Technology Components Guide (Doc ID 1355068.1)


Friday, August 4, 2017

Kill Oracle EBS Database Sessions

Issue : Oracle EBS Database does not shutdown properly during the scheduled backup script.

Solution : Schedule below command to kill the Oracle database sessions few minutes after database shutdown initiation.

ps -ef|grep 'oraclePROD (LOCAL=NO)'|grep -v grep|awk '{print$2}'|xargs kill -9

Monday, May 8, 2017

EBS 12.2 Apps Cloning Error in OEL 6.7

Error 

 txkWfClone.sh exited with status 127 ERROR: txkWfClone.sh execution failed, exit code 127

Solution

 yum install glibc-devel.i686

Friday, May 5, 2017

After 12.2.5 upgrade adop phase=fs_clone fails ( adop exiting with status = 1 (Fail) )

Error

Use of uninitialized value $result in split at /u01/UAT/fs1/EBSapps/appl/au/12.0.0/perl/TXK/ADOPValidationUtils.pm line 1291.
No such file or directory at /u01/UAT/fs1/EBSapps/appl/au/12.0.0/perl/TXK/ADOPValidationUtils.pm line 230.

Solution 

Error "Use of uninitialized value $result in split" In File txkADOPValidations.error When Running fs_clone (Doc ID 2090393.1)

Thursday, March 23, 2017

SLA Hot Patch for After Upgrade Data Migration

a. Run this SQL script:
select * from gl_period_statuses where migration_status_code='P'
-- this script should return zero rows, only then should you consider running the SLA Hot Patch.

b. Take a backup of the xla_upgrade_dates table before running the SLA Hot Patch

c. Set a realistic date for the SLA: Initial Date for Historical Upgrade profile.

    (i)  Change the SLA: Initial Date for Historical Upgrade profile to 01-OCT-2015
    (ii) Then run the Hot Patch

adop phase=apply options=nocopyportion patchtop=$XLA_TOP/patch/115          patches=driver:xla5584908.drv hotpatch=yes options=forceapply

    (iii) Repeat the above steps for 6-month increments until all the data from start has been upgraded. 

    The 6-month increment is not a rule because it depends of the amount of history to be upgraded.


Friday, March 17, 2017

Important Queries to check Oracle EBS users logged

select count(distinct d.user_name) from apps.fnd_logins a,
v$session b, v$process c, apps.fnd_user d
where b.paddr = c.addr
and a.pid=c.pid
and a.spid = b.process
and d.user_id = a.user_id
and (d.user_name = 'USER_NAME' OR 1=1);

select * from apps.fnd_logins a,
v$session b, v$process c, apps.fnd_user d
where b.paddr = c.addr
and a.pid=c.pid
and a.spid = b.process
and d.user_id = a.user_id
and (d.user_name = 'USER_NAME' OR 1=1)

select last_connect, usr.user_name, resp.responsibility_key, function_type, icx.*
  from apps.icx_sessions icx
  join apps.fnd_user usr on usr.user_id=icx.user_id
  left join apps.fnd_responsibility resp on resp.responsibility_id=icx.responsibility_id
  where last_connect>sysdate-nvl(FND_PROFILE.VALUE('ICX_SESSION_TIMEOUT'),30)/60/24
and disabled_flag != 'Y' and pseudo_flag = 'N'
AND USER_NAME <>'GUEST'

select count(distinct user_id) "users" from icx_sessions where  last_connect > sysdate - 1/24 and user_id != '-1';

select * from v$license;