Stew Ashton writes, “Finding the difference between two dates or timestamps is hard! I am not fully satisfied with any of the solutions I have already proposed (or read), but I think this time I may have a decent answer.”
2. Step-by-Step Guide to Creating a New Forms Server in EBS R12.2
This blog starts with, “In this guide, we will walk you through the steps to add and manage a new managed server in Oracle E-Business Suite (EBS). This process involves creating the managed server, updating configuration files, and starting the server.”
Then goes onto:
- Creating a Managed Server
- Updating Configuration Files
- Starting the Managed Server
- Restarting Apache
- Running fs_clone
- Deleting Forms Server
3. Interesting links – February 2025
Robin Moffatt shares a bunch of links and articles that he’s come across of late.
4. News and updates in opatch 12.2.0.1.45 (Jan 2025)
Mike Dietrich shares what’s new in opatch 12.2.0.1.45 and links to an older article
5. Demos of Oracle 23ai New Features
Quanwen Zhao shares some helpful links and demos in this post.
6. Resuming OMSPatcher Session When it Failed to Apply a Patch
Maiquel De Oliveira starts by writing: “Oracle Enterprise Manager Server ( OMS ) could be tricky when you have a bug, known issues or even an abnormal termination on the patch you intend to apply.
Before you apply the patch, make sure you have the following requirements set…”
7. Got Technology, Need Data? Here’s the Best Free (+ obscure) Data Sources for Analytics & AI
Renee Miller asks:
“Have you ever wanted to assess or explore a new BI, analytics, data visualization, data science, etc. technology, but struggled to find a data set to use for your assessment and exploration activities? Have you grown tired of analyzing the “typical” free data sources–think census, stock market, and employment and inflation rate data–known to be publicly available? Are you seeking data relevant to a particular concept, but aren’t sure how to collect it? Are you wanting to generate world-changing insights on a fresh, rarely analyzed, concept?”
8. Infinity – Old Oracle Numbers
Neil Chandler reminisces about when Oracle had a couple of special numbers that you were allowed to store in a NUMBER datatype.
(They were Infinity and Negative Infinity).
Read the full blog to find out why this is relevant.
Connor McDonald gives a quick heads up for anyone using JSON_OBJECT_T in PL/SQL
He writes, “It looks like repeated use of JSON_OBJECT_T in an associative array can consume PGA until such point as you’ll hit errors.”
He goes on to say, “the issue does not occur in 23ai, but you’ll need to take care in 19c.”
10. How to Configure WebUtil in Oracle Forms 11g – A Step-by-Step Guide
This blog begins, “Oracle Forms 11g lacks native support for client-side operations, such as file selection dialogs, clipboard access, or interactions with Microsoft Office. WebUtil bridges this gap by enabling Oracle Forms applications to perform these client-side operations.
This guide provides a detailed step-by-step procedure to configure WebUtil in Oracle Forms 11g, complete with actual commands.”