r/oracle • u/Adridubidan • 1h ago
r/oracle • u/AutoModerator • Feb 15 '22
Post to r/Oracle immediately auto-deleted? Here's why...
This subreddit receives a lot of spam--we mean a LOT of spam--specially from Asia/India. Thus, we have Mr. Automoderator auto-delete posts from users due to the following reasons:
- Too new of an account
- Not enough comment karma
To avoid abuse of the above, exact details are not being shared, but please do your best to get your comment karma up over a couple days time. Also please refrain from messaging the mods asking why your post got removed.
r/oracle • u/AutoModerator • Sep 11 '25
Use r/employeesOfOracle to discuss employment/layoffs/financials/stocks/etc.
A new sub has been created to discuss all non-technical aspects of Oracle -- r/employeesOfOracle. Posts that are not related to technical aspects or usage of Oracle products -- most specifically DBMS -- will be blocked or auto-removed. This sort of discourse is important -- this just isn't the sub for it.
r/oracle • u/justpostinlyfe • 19h ago
EHRM Pharmacy Tips
So, of im looking for tips because we are starting to use this at our VA location soon. Anyone got good tips and tricks, or where to go for some so I am ready.
r/oracle • u/JuggernautVMZ • 1d ago
Oracle VBCS is going away
blogs.oracle.com
Beginning October 8, 2026, Oracle is changing the availability of two Oracle Visual Builder offerings for customers who have not previously used the service.
Oracle Visual Builder ( SKU B89646) offered from OCI console (aka standalone VBCS)
Oracle Visual Builder enabled from within Integration Cloud (aka OIC VBCS)
Both these offerings will no longer be available for new purchase or enablement. Official notice can be found here.
r/oracle • u/NiteshDragneel • 2d ago
OAS 7.6 installation RCU.bat Issue (with fmw 19c db)
hi, I'm trying to install OAS in a server which already has OAM 12c installed
there's seperate DB server which has FMW19C DB
oam is installed with that db
I'm using same Db, installing OAS in this OAM server but created a new domain (installed fmw infrastructure in different folder)
and then after installing OAS, i tried to run RCU. bat in this domain but getting this error at summary
r/oracle • u/Rich_Edge_6992 • 3d ago
NetSuite WMS randomly logs users out during order processing
r/oracle • u/Character-Feed-7722 • 3d ago
how to install oracle 11g on my debian 13
hello, i meet difficulties to install oracle 11g on my debian 13.
i tried to use bottles to install it but i didn't understand how, and also i need to install it but i still cannot find a way to install easily because i hvae for this week for my homework and my university
so who can gimme a way to make it, please share with me and thanks
r/oracle • u/LivelyAccountant • 3d ago
VAT Groups
Does anyone know if Oracle NetSuite can handle VAT Groups? As in, VAT for a Group of Companies operating under a single VAT Return submission? And if there are any limitations/constraints on what it can handle?
Claude says it isn't able to work out that only some companies are in the Group and not others, and that the Group hierarchy dictates that the highest hierarchy company has to be the VAT lead company.
Any idea if that is true?
r/oracle • u/Bulky-Newspaper-857 • 5d ago
Where to learn to get ready for OCI foundation associate
title. thank you.
r/oracle • u/Longjumping_Tap7939 • 6d ago
Does anyone have an extra AI World pass or want to split it?
I saw they sell five for $2k, but I am looking to secure only one. Does anyone know someone with extras? I’ve been trying to go for a while, but I haven’t had the opportunity to secure a pass any of these years.
Thank you!
r/oracle • u/Lost_Relationship_41 • 8d ago
System integration
Hello, I'm currently working on a big project. We are using Oracle, ProjectWise and Procore. Does anyone know of software that can integrate them? I'm talking about communication between the platforms to have the same documentation updates and avoid running around between platforms to update them.
Thanks for your advise/help
r/oracle • u/ryanmerket • 9d ago
Eon launches a simulated enterprise for testing agents across business software — RuntimeWire
runtimewire.comr/oracle • u/AlexAtOracleAIDB • 11d ago
Running Oracle Database across AWS, Azure, and Google Cloud
Someone from an AWS shop asked me whether Oracle even runs outside OCI. They'd inherited a small Oracle footprint, don't ask. In my experience, multi-cloud Oracle gets there sideways. A customer demands it, or it gets adopted for one service and then nobody can move off it.
AWS gives you two ways in. RDS for Oracle if you want it managed, or EC2 if you'd rather own the whole instance yourself.
Azure has the tighter story these days through the Oracle Database@Azure setup, where the instances run in your Azure network and the networking feels close to built-in.
The last time I checked, GCP runs Oracle Database@Google Cloud as a managed service with VPC and IAM integration. If you ruled GCP out for Oracle a while back, that's changed.
None of the three make the database itself hard. The networking is what you plan around, and that mostly means how you handle VPC and Data Guard across subnets on AWS and virtual network peering on Azure. On GCP it's ODB Networks and VPC integration. Tooling follows each cloud's own console and IaC setup. Expect the management layer to look different even when the database underneath is the same.
The local dev to cloud step is the easy one though. Run it in a container locally, then Data Pump or a backup restore into whatever target you picked.
I still haven't seen a multi-cloud Oracle setup where connectivity was the easy part.
r/oracle • u/Bothurin • 13d ago
Company stuck on Oracle ADF, not migrating to Spring
I work at a small software company and unfortunately I've ended up working on an old Oracle ADF project and there is almost no willingness from management to move this project to Spring Boot.
On the team are two very senior developers who have worked on this project from the start (approx 15 years) and this project has become so messy and huge (with no testing and limited documentation) that it is basically impossible to migrate (functions and procedures with thousands of lines etc.).
Has anyone experienced this situation and do you have any recommendations on how to proceed as a junior developer? I have already brought up the possibility of breaking the project into smaller applications which could be built with Spring / React while keeping the old database and plsql procedures. Or we could map out all of the functionality or refactor the current code into smaller functions or start implementing tests and then migrate. Rebuilding it from scratch is not an option since it is a government project and this would trigger the the goverment to auction the project for other companies to take over.
Alternatively, should I just let them keep this project in ADF for 10 more years until it is deprecated by Oracle while the application becomes worse and worse?
r/oracle • u/kneedtolive • 14d ago
Why does Primavera P6 still feel stuck in the early 2000s?
r/oracle • u/SpicyRomek • 14d ago
AI-assisted Oracle Forms to Java migration on Summit's ORDERS form: what it got wrong
I work at Vaadin, and we migrated onto our own framework, so weigh that however you
like. I'm posting here because everything interesting happened on the Forms side, and
most of it is a failure report.
Setup: ORDERS from the Summit demo schema. 4 blocks, 34 items, 45 PL/SQL triggers, 183
elements. Real Oracle database, no schema changes allowed. AI did the bulk of the work
and we ran the whole thing three times.
The PL/SQL was a non-event. 34 of the 45 triggers were one call, one assignment, or a
SELECT-INTO. Formulas and summary totals came out as plain Java almost line for line.
Audit and integrity triggers never left the database.
What hurt was the runtime behaviour that isn't in the .fmb at all:
- Forms won't let you leave a field that fails validation. On the web you can leave it, you just can't commit. Users notice.
- Row locked on the first keystroke became an optimistic check at commit, `UPDATE … WHERE id = ? AND ORA_ROWSCN = ?`. No schema change, no version column, but conflicts now show up at save instead of at edit.
- Enter-Query became a filter bar. Arbitrary query-by-example is gone.
- Trigger firing order became explicit code that somebody has to work out by hand.
The failure that worries me most came after the first pass. Our own completeness report
said "183 elements, nothing dropped", and that was true. The screen still had fields
reordered, bordered groups missing and section titles gone. A later audit turned up four
more things that were in the spec, covered by our own mapping rules, and never built:
DATE_ORDERED's default, QUANTITY_SHIPPED being insert-only, the GLOBAL.customer_id
contract from the calling form, and SALES_REP_ID quietly made read-only. Every one of
those is a property of an object rather than an object, and we were counting objects, so
the count stayed green the whole way through.
Obvious caveat: Summit is a teaching schema. No packages, no dynamic SQL, no cursors over
big sets, no package state. So it says nothing about your code.
Repo with the specs, the mapping rules and the audit: https://github.com/jcgueriaud1/forms-summit-migration
If you run a real Forms estate, what would you throw at this first to break it? I'd guess
package state shared across triggers, but I'd rather be told.
r/oracle • u/VinayakFromIndia • 15d ago
Open-Source Oracle Datasource plugin for Grafana
Hi everyone,
I needed a straightforward way to query Oracle databases directly from Grafana without dealing with Oracle Instant Client installations or Enterprise plugin licenses.
I took the original oracle-grafana plugin created by albertowd, which has been inactive for a few years, and updated it to work cleanly on modern Grafana versions.
Repository: VinayakSomvanshi/oracle-grafana
What it does:
- No Oracle Instant Client required on the server (pure driver backend).
- Connects using either Service Name or SID (tested against Oracle 19c, 21c, 23ai, and 26ai).
- Supports native Grafana Alerting rules on Oracle queries.
- Supports both time-series and standard table queries, plus dashboard template variables.
If you run Oracle with Grafana, feel free to try it out and let me know if you run into any issues or have suggestions.
r/oracle • u/InputOracle • 15d ago
Non riesco ad accedere, niente funziona e non riesco a capire come parlare con qualcuno.
r/oracle • u/vinishkapoor • 20d ago
New book: Oracle APEX 26.1 API by Example (JavaScript & PL/SQL)
When I wrote my Oracle APEX 26.1 book, I ran out of pages before I could cover the APIs properly. So I wrote a second one just for them.
Oracle APEX 26.1 API by Example covers every JavaScript namespace and PL/SQL package, 1,850+ methods, events, procedures and functions, each with a runnable example and the real output it gives.
All the code is free on GitHub, including the API Lab app and 518 examples with their outputs:
https://github.com/devvinish/apex-book-code-examples/tree/main/api-book
528 pages, paperback and Kindle. Details and sample pages:
https://vinish.dev/oracle-apex-26-api-by-example-book
I'm the author, so happy to answer any questions. Which APEX APIs do you find the most confusing?
r/oracle • u/vinishkapoor • 21d ago
I wrote a book on Oracle APEX 26.1 (828 pages, install to production) – the code is free on GitHub
I've been building database applications with Oracle for 20+ years (Forms, then APEX), and I've just published **Oracle APEX 26.1: The Complete Guide**.
It follows one realistic application, Orbit Sales, from an empty laptop to production:
- Installing Oracle AI Database 26ai Free, APEX 26.1, and ORDS (Docker, Windows, Linux, macOS)
- Page Designer, interactive reports and grids, forms, faceted search, charts, maps
- Dynamic actions, Ajax, authentication, authorization, CSP
- Approvals and workflows (including the new parallel flows in 26.1)
- Generative AI: AI agents with tools, an in-app assistant, APEX_AI, local models with Ollama
- RESTful services with ORDS, APEXlang, debugging, deployment, and administration
Every script and code example, plus the finished app export, is free on GitHub, so you can use it even without the book:
https://github.com/devvinish/apex-book-code-examples
Book details and sample pages: https://vinish.dev/oracle-apex-26-1-book-the-complete-guide
Happy to answer questions about APEX 26.1 or anything in the book, and feedback is very welcome.
r/oracle • u/JaysonHanes • 21d ago
Free Oracle APEX Bootcamp in Kansas City, MO on Oct 6th
Hosted by the HOUG, Oracle and Argano!
https://www.eventbrite.com/e/houg-boot-camp-2026-oracle-apex-tickets-2000083990055
Come join me and some of the APEX team to learn about how to use Oracle APEX for a day - lunch included! #orclAPEX
Please feel free to reply with any questions! I hope we can see you there!
Interested in learning more about APEX? https://oracleAPEX.com
r/oracle • u/Extreme-Soil-3800 • 22d ago
Select AI and Feedback Usage
Hey folks - I’m curious how many of you all use Select AI and/or the specific FEEDBACK feature within the Select AI architecture, either for PL/SQL or agents. It seems like Oracle has thrown a lot of weight behind it, but I’m not seeing a lot of buzz/discussion among practitioners here on Reddit or elsewhere.
Anybody out there using it?
