Tag: R12

Pythian’s New Single Sign-on (SSO) Solution for Oracle E-Business Suite (EBS) – Part Two

Pythian’s New Single Sign-on (SSO) Solution for Oracle E-Business Suite (EBS) – Part Two

Our mission at Pythian is to help you Love Your Data. Because security is a crucial part of managing your data, we are pleased to tell you about the identity management (IDM) solution Pythian has developed to make it easier…

Read More >

Oracle EBS – Cost Savings for Test Environments on the Cloud

As a managed service company, we see our customers and partners shifting their workloads to the cloud. There are various reasons for this decision, but the most important ones are cost and agility. Once on a cloud, the infrastructure team…

Read More >

One-Click E-Business Suite Cloning on AWS Using Systems Manager

oracle ebs

Cloning an Oracle E-Business Suite system is a complicated process, and depending on the environment topology, it can involve various steps to accomplish the task.     Partial automation of the E-Business Suite cloning procedure is often done with local…

Read More >

Slow Query in eBS AutoConfig with DB 19c

slow query

We recently completed a few e eBS R12.2 database upgrade installations and noticed an issue with a particular SQL running as part of the AutoConfig.       The query sql_id is 5da8tjzfafw6j and it looks like this (formatted): select…

Read More >

CVE-2022-21500 and Your Oracle E-Business Suite

CVE-2022-21500

Something  exciting happened a few days ago. It started with a tweet and a blog post, and has evolved into an official CVE-2022-21500. I thought it would be good to publish some details beyond the official MOS note document.  …

Read More >

How to Add Data Visualization and Empower EBS Users With Enterprise Command Centers

data visualization

In 2018, Oracle announced the release of Oracle Enterprise Command Centers (ECC) for E-Business Suite. This EBS add-on provides users with discovery-oriented dashboards that bring together diverse operational data from across Oracle E-Business Suite.     Oracle Endeca, its predecessor, needed…

Read More >

CVE-2021-44228 and Your Oracle E-Business Suite/Fusion Middleware Systems

CVE-2022-21500

For many of us, the recent log4j vulnerability (CVE-2021-44228) became a severe headache this past weekend. I thought we’d publish a summary of some of our findings gathered so far. We’ll  keep it updated with news and details published by…

Read More >

Be Warned: cmclean.sql Is Dangerous!

I’m sure one of the most popular scripts for Apps DBAs on My Oracle Support is cmclean.sql from MOS Article ID 134007.1 “Concurrent Processing – CMCLEAN.SQL – Non Destructive Script to Clean Concurrent Manager Tables”. DBAs usually use the script…

Read More >

Performance Settings of Concurrent Managers

This is the second article in a series about internals and performance of concurrent managers. In this post, we’ll take a look at three important settings that affect the performance of the concurrent managers: number of processes, “sleep seconds”, and “cache size”. This article might be a bit on the theoretical side, but it should provide a good understanding of how these settings actually affect the behavior and performance of concurrent managers.

Read More >

The Internal Workflow of an E-Business Suite Concurrent Manager Process

This is the first article in a series about performance of concurrent processing. We’ll take a closer look at the internals of concurrent managers, the settings that affect their performance and the ways of diagnosing performance and configuration issues. Today we’ll start with an overview of the internal workflow of a concurrent manager process. Enjoy the reading!

Read More >