This blog opens with:
“A couple of my students wanted me to write a switch and parameter handler for Python scripts. I wrote it just to show them it’s possible but I also show them how to do it correctly with the Python getopt library, which was soft-deprecated in Python 3.13 and replaced by the Python argparse library. The debate is which one I show you first in the blog.”
2. FCC – Loading data as admin not working (issue, workaround, and fix)
Erik Erikson writes:
“Some FCC applications have an issue where data loads done with an admin ID are not calculating correctly after the data load. What is happening is that the data status isn’t correctly being set to impacted and so the subsequent calculation/consolidation doesn’t bring forward opening balances, calculate movement, etc.
The workaround for this is simply to do the data loads with a non-admin ID. Or do something that impacts all status, like a database refresh.”
Erman Arslan says, “Today, we’re diving into the exciting world of Retrieval-Augmented Generation (RAG) systems. Here I ‘am blogging again. This time with the motivation of Oracle Database 23 AI’s vector capabilities, that we leveraged while building ourselves a Sales Assistant. While leveraging the power of Oracle 23AI, we also used OCI ‘s and Cohere’s large language models (and integrations), and Flask for building our solution. This AI bases Sales Assistant is in beta version, but we can make it production ready by putting a little more effort, and making it reach perfection.”
4. Oracle Analytics Default date format in parameter
This blog is a quick reminder:
“When creating a parameter and want to use it in filter / calculation, there must be a default. For date default this is the default format:
DATE ‘2014-04-12′”
5. Part 2; Upgrading OEM to 24ai
Emmer Benner writes, “So, in the prior post, we patched OEM 13.5 to the latest RU, and made sure our database was patched.
Now, it’s time for the big task, upgrading to OEM 24ai!”
6. New views in Oracle Data Guard 23c
Ludovico Caldara says, “Oracle Data Guard 23c comes with many nice improvements for observability, which greatly increase the usability of Data Guard in environments with a high level of automation.”
Then the blog goes on to explore:
V$DG_BROKER_ROLE_CHANGE
V$DG_BROKER_PROPERTY
V$FAST_START_FAILOVER_CONFIG
V$FS_LAG_HISTOGRAM
V$FS_FAILOVER_OBSERVERS
Then it concludes with: “These new views should greatly improve the experience when monitoring or diagnosing problems with Data Guard. But they are just a part of many improvements we introduced in 23c. Stay tuned for more 🙂”
7. Resolving Oracle GoldenGate Replicat Abends with Error OGG-00918: Key Column Missing from Map
Nassyam Basha writes, “Oracle GoldenGate is a powerful tool for real-time data replication. However, during replication setups, encountering errors like OGG-00918: Key Column <Column Name> is Missing from Map can be a challenge. This blog will walk you through diagnosing and resolving this error with a practical example.”
8. ORA-46373 – Correct Error number or Not?
Pete Finnigan says, “I talked last week about an issue where I wanted to pre-create a unified audit policy with no rules so that I could create a number of policies for a customer in advance and then we could add the actions/rules later.
I got an error ORA-46373 that if there were no rules on the unified policy then this is not allowed. Fine, we have a simple solution to create a dummy role and make sure its not granted to anyone and then create the policy with a ROLES rule for that dummy role. We can do this again now before we discuss the new point.
9. YouTube Video: ALL YOU NEED TO KNOW ABOUT ORACLE’SREAL APPLICATION TESTING PART-1
10. Vision LLM Structured Output with Sparrow
This blog shares the following video from Andrej Baranovskij