for those looking for oracle certification exam DM ME

Hi everyone! 👋 Is anyone here currently working at Deloitte as an Oracle Integration Cloud (OIC) Developer?
I’d love to connect and ask a few questions about the role, projects, and overall experience at Deloitte.
Please DM me if you’re open to connecting. Thanks! 😊

just here to get an opinion. we just converted our ERP to Oracle, and a big selling point was report building in FRS and everything that comes along with that. Ive see a few reports (mostly p&l packages etc) and they just look horrible. The report builder is clunky and Rigid. Does anyone have any tips or ways to use the report builder in here that would be better than just building in excel? I’m trying to find a better way to utilize the new tools but I can find a good reason to switch anything from excel to FRS due to its limitations.

We have been using spreadsheet server to build reports as it is connected to Oracle, which is fine but slow. Smartview isnt really usable for our reporting either.

I need help, but the sub keeps blocking me from posting.

Is there a way to have a transaction timeout and return the screen to either the start screen or a prompt to cancel or complete the transaction?

With the recent change of the Free Tier going from VM.Standard.A1.Flex (4 OCPU / 24 GB RAM) to VM.Standard.A1.Flex (2 OCPU / 12 GB RAM), my instance has been deactivated.

When i try to change the shape to the new requirments I get the following error

Instance ocid1.instance.oc1.xxxxxxxxxxxxxxxxxxxxxx is disabled and will not accept any action requests. Please contact customer support to reenable.

Anyone know how I can get this re-activated without upgrading to Pay as you Go plan?

I don't mind recreating from scrach as i have backups but it took me 3 months to get get the initial Intance and I am pretty sure if I terminate I won't get another one (unless I upgrade to Pay as you go plan)

Has anyone able to send the generated pdf of Create Customer Statement to an FTP server? I have been stuck on this for days. I tested and worked on a couple of approaches but all are dead end.

Thank you!

Hi all! I have to take two certs for my company requirements, and because I have a short amount of time to get them done, I wanted one of the certs to be easy/less time consuming.

Would you recommend the Oracle AI Foundations Associate to be an easy, quick cert? Also, I heard they just updated the exam, so has anyone recently taken the 2026 version of this cert?

TIA!!!

Hi all,

I'm taking my first Oracle exam this month, 1Z0-1046, if anyone has experience with this exam please let me know

As the title suggests, after scheduling the report, I am unable to download the report. I have given everything correctly, yet it's failing. Please provide some suggestions, thank you.

Anyone know of any?

Hi
I am currently working as oracle HCM consultant. I am tired of working nonstop for the 12-14 hrs daily and covering both India and US time.
I want to work in the morning time as I don't like working late nights.
How can I get a role that has a proper 9-5 timings?
Also, are there any other alternate roles that I can target?
I have tried applying for HR roles as my masters is in HR but they are paying peanuts.
Any help or suggestions are highly appreciated.

A friend asked for inputs and I was blank. Any cost or features or service inputs anyone can share ? Just for my knowledge sake no real use case here.

I’ve gotten pretty good at oracle networking and firewalling, tshooting with logging. I want to use terraform to speed up networking and firewall rule tasks. What are good resources or certs with useful training?

Hey all, I am a SQL Server DBA that is inheriting a pretty big oracle environment and was wondering if you folks could point me in the right direction of a course for learning. Work is going to pay for training so money isn't a problem, l'd prefer a couple of day course. We have anywhere from 11.2 up to 19c Running lots of different apps and even SAP if that matters.

I am comfortable in Linux/Unix as well because I used to be a Unix sysadmin in a previous life

For people writing SQL against Oracle and mapping results by hand: I maintain scythe, a build-time code generator that reads annotated SQL and emits typed access code (Oracle backend via the standard JDBC/driver stack).

The core value is nullability inference from the query structure. A LEFT (OUTER) JOIN makes the right side nullable:

-- @name GetUserOrders
SELECT u.id, u.name, o.total, o.notes
FROM users u
LEFT JOIN orders o ON u.id = o.user_id
WHERE u.status = :status;

The generated types mark total and notes nullable, so the no-matching-row case is a compile-time concern instead of a NullPointerException in production. Also covers COALESCE/NVL-style expressions, CASE, and aggregates.

Static queries only, which is the deliberate tradeoff: no dynamic runtime composition, but everything is analyzable and typed. Curious how teams here handle the Oracle-to-application type boundary.