Month: May 2017

May 12, 2017 Autoconfig Error after clone in 12.1.3 Instance

APPS DBAErrors/Workarounds-Applications

ERROR

Running autoconfig on a cloned instance , the below mentioned error occurred:

PL/SQL procedure successfully completed.
declare
*
ERROR at line 1:
ORA-00001: unique constraint (APPLSYS.AD_APPL_TOPS_U2) violated
ORA-06512: at line 32

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
adadmprf.sh exiting with status 1
ERRORCODE = 1 ERRORCODE_END
.end std out.
.end err out.

AutoConfig could not successfully execute the following scripts:
Directory: /u01/ebs/oracle/inst/apps/test_mine/admin/install
adadmprf.sh INSTE8_PRF 1

SOLUTION

1.RUN the Following given Query with APPS user and notedown the SID from Output:

select applications_system_name from applsys.fnd_product_groups;

2.Update the entry with target instance name:

update applsys.fnd_product_groups set applications_system_name = ‘<target instance>’;

3.Run autoconfig again.

May 11, 2017 Quarterly EBS Upgrade Recommendations: May 2017 Edition

NEWS AND UPDATES

Quarterly EBS Upgrade Recommendations: May 2017 Edition

By: Steven Chan| Senior Director

We’ve previously provided advice on the general priorities for applying EBS updates and creating a comprehensive maintenance strategy.

Here are our latest upgrade recommendations for E-Business Suite updates and technology stack components. These quarterly recommendations are based upon the latest updates to Oracle’s product strategies, latest support timelines, and newly-certified releases.

You can research these yourself using this Note:

How to Find E-Business Suite Patches & E-Business Suite Technology Stack Patches (Note 1633974.2)

Upgrade Recommendations for May 2017

	EBS 12.2	EBS 12.1	EBS 12.0	EBS 11.5.10
Check your EBS support status and patching baseline	Apply the minimum 12.2 patching baseline (EBS 12.2.3 + latest technology stack updates listed below)In Premier Support to September 30, 2023	Apply the minimum 12.1 patching baseline (12.1.3 Family Packs for products in use + latest technology stack updates listed below)In Premier Support to December 31, 2021	In Sustaining Support. No new patches available. Upgrade to 12.1.3 or 12.2 Before upgrading, 12.0 users should be on the minimum 12.0 patching baseline	In Sustaining Support. No new patches available. Upgrade to 12.1.3 or 12.2 Before upgrading, 11i users should be on the minimum 11i patching baseline
Apply the latest EBS suite-wide RPC or RUP	12.2.6 Sept. 2016	12.1.3 RPC5 Aug. 2016	12.0.6	11.5.10.2
Use the latest Rapid Install	StartCD 51 Feb. 2016	StartCD 13 Aug. 2011	12.0.6	11.5.10.2
Apply the latest EBS technology stack, tools, and libraries	AD/TXK Delta 9 Apr. 2017FND Aug. 2016EBS 12.2.5 OAF Update 12 May 2017 EBS 12.2.4 OAF Update 15 Mar. 2017 ETCC May 2017 Web Tier Utilities 11.1.1.9 Daylight Savings Time DSTv28 Nov. 2016	12.1.3 RPC5 OAF Bundle 5 Jun. 2016 JTT Update 4 Oct. 2016 Daylight Savings Time DSTv28 Nov. 2016
Apply the latest security updates	Apr. 2017 Critical Patch Update SHA-2 PKI Certificates SHA-2 Update for Web ADI & Report Manager Migrate from SSL or TLS 1.0 to TLS 1.2 Sign JAR files	Apr. 2017 Critical Patch Update SHA-2 PKI Certificates SHA-2 Update for Web ADI & Report Manager Migrate from SSL or TLS 1.0 to TLS 1.2 Sign JAR files	Oct. 2015 Critical Patch Update	April 2016 Critical Patch Update
Use the latest certified desktop components	Use the latest JRE 1.8, 1.7, or 1.6 release that meets your requirements. Switch to Java Web Start Upgrade to IE 11 Upgrade to Firefox ESR 52 Upgrade Office 2003 and Office 2007 to later Office versions (e.g. Office 2016) Upgrade Windows XP and Vista and Win 10v1507 to later versions (e.g. Windows 10v1607)	Use the latest JRE 1.8, 1.7, or 1.6 release that meets your requirements Switch to Java Web Start Upgrade to IE 11 Upgrade to Firefox ESR 52 Upgrade Office 2003 and Office 2007 to later Office versions (e.g. Office 2016) Upgrade Windows XP and Vista and Win 10v1507 to later versions (e.g. Windows 10v1607)
Upgrade to the latest database	Database 11.2.0.4 or 12.1.0.2	Database 11.2.0.4 or 12.1.0.2	Database 11.2.0.4 or 12.1.0.2	Database 11.2.0.4 or 12.1.0.2
If you’re using Oracle Identity Management	Upgrade to Oracle Access Manager 11.1.2.3 Upgrade to Oracle Internet Directory 11.1.1.9	Migrate from Oracle SSO to OAM 11.1.2.3 Upgrade to Oracle Internet Directory 11.1.1.9
If you’re using Oracle Discoverer	Migrate to Oracle Business Intelligence Enterprise Edition (OBIEE), Oracle Business Intelligence Applications (OBIA).Discoverer 11.1.1.7 reaches End of Life June 2017	Migrate to Oracle Business Intelligence Enterprise Edition (OBIEE), Oracle Business Intelligence Applications (OBIA).Discoverer 11.1.1.7 reaches End of Life June 2017
If you’re using Oracle Portal	Migrate to Oracle WebCenter 11.1.1.9	Migrate to Oracle WebCenter 11.1.1.9 or upgrade to Portal 11.1.1.6 (End of Life Jun. 2017).