Oracle EBS

Find the current patchset levels for products in Oracle Apps

To obtain the current patchset levels for each specific E-Business Suite functional product test the following steps: 1. Log into OAM. (Responsibility System Administrator,”Oracle Applications Manager”, menu “OAM Support Cart”)…

Read More

Ignore Duplicate Rows (ORA-00001) with the ignore_row_on_dupkey_index Hint

The simplest method is to add a hint to the query to overcome ORA-00001 Added in 11.2, the ignore_row_on_dupkey_index hint silently ignores duplicate values: insert /*+ ignore_row_on_dupkey_index ( acct (…

Read More

EBS Clone Log Parser Utility (Rapid Clone 11i,12.0, 12.1)

Oracle proactive services team has provided the tool for analyzing the clone log files in a readable html format. This is very helpful for the DBA’s to quickly read the…

Read More

SSL Configuration on R12

Posted by Gangainathan Muthuraman Introduction: This Document demonstrates how to do SSL Configuration on R12. Prerequisite: OS level Required rpm’s: xmlsec1-openssl-1.2.6-3 openssl-0.9.7a-43.18.el4 openssl-devel-0.9.7a-43.18.el4 openssl-devel-0.9.7a-43.18.el4 xmlsec1-openssl-1.2.6-3 openssl096b-0.9.6b-22.46.el4_8.1 openssl-perl-0.9.7a-43.18.el4 openssl-0.9.7a-43.18.el4 openssl096b-0.9.6b-22.46.el4_8.1 1. Generate…

Read More

REP-3000: Internal error starting Oracle Toolkit

Posted by Sundaravel Ramasubbu  Issue: Recently we had issue with Concurrent requests which having print format of PDF or XML, and the exact error is “REP-3000: Internal error starting Oracle Toolkit”…

Read More

Profile Options that are used commonly by APPS DBA’s

Posted by  Abishek kathiresan Introduction: Here we will see the Profile Options that are used commonly by APPS DBA’s Concurrent Related Profile Options Concurrent: Active Request Limit   Value: Numeric This…

Read More

How to create Oracle EBS (Applications User ) with only read privilege

Posted by Abishek kathiresan Introduction: Hi Everyone here will discuss how to create Oracle EBS(application user) with only read privilege Steps to be followed: 1.Connect to the Oracle EBS 2.…

Read More

Concurrent request running abnormally for very long time without completion

Posted by  Abishek kathiresan Introduction: In this document I will show you a solution for Concurrent request running abnormally for very long time without completion 1. Identified the long running…

Read More

Oracle E-Business Suite Extensions for Oracle Endeca

Posted by : Narasimha Rao   Introduction This post demonstrated about Oracle E-Business Suite Extensions for Oracle Endeca Overview: Oracle Endeca Information Discovery (EID) is a sophisticated data discovery platform…

Read More

EBS R12.2 Cloning Steps

Posted by Venkatesh R K Introduction: In this document we are going to discuss the steps for EBS Cloning. NOTE: The following Clone approach is applicable for the APPLICATION version from…

Read More