ARBOne

Concurrent Manager (CM) Overview and Real-Time Handling – Oracle EBS Overview of Concurrent Manager (CM): Concurrent Manager is an important part of Oracle E-Business Suite. It is responsible for running background jobs and tasks submitted by users. These tasks are called concurrent requests and can be reports, PL/SQL programs, or system-related jobs. CM makes sure these jobs are handled properly without overloading the system. There are different types of managers like Standard Manager, Inventory CM, and Internal Manager, each handling different kinds of jobs. How a User Request Becomes a CM Job: When a user submits a job from the front-end (like Payroll or a report), Oracle creates a concurrent request for it. This gets stored in a table ( FND_CONCURRENT_REQUESTS ). The request includes details like program name, parameters, and status. The Internal Manager assigns the job to the right CM based on setup. Some programs also trigger multiple sub-requests or child requests. The ac...

How to Upgrade the Oracle Database: A Complete Guide When Should You Upgrade Your Oracle Database? If you're using older Oracle database versions like 10g or 11g, it's time to consider upgrading. Oracle has officially stopped supporting these versions, meaning they no longer receive security updates, bug fixes, or performance enhancements. To ensure better security, improved performance, and compliance with Oracle's latest features, upgrading to a newer version such as Oracle 19c or 21c is recommended. Does Upgrading Always Improve Performance? While upgrading provides many benefits, it doesn't always guarantee improved performance. In some cases, you may encounter issues if the upgrade is not properly planned. One critical factor to consider is server compatibility. Example: If your database is running on Oracle Linux 7.9, upgrading to Oracle 19c should work fine. However, Oracle 21c is not compatible with this OS version. This means you cannot directly upgrade to Orac...