Oracle Tutorials

FndOSCSIndexIngestJob_shopca

How to Fix Missing Smart Forms and Empty Catalog Pages in Oracle Fusion Cloud Procurement After an Environment Refresh

Any team running Oracle Fusion Cloud Procurement across multiple environments will eventually face the same post-refresh puzzle: a user who works perfectly in Production suddenly cannot find their Smart Form in the test environment, even though the refresh was taken from Production only weeks ago. The symptoms are very specific: The user has all the […]

How to Fix Missing Smart Forms and Empty Catalog Pages in Oracle Fusion Cloud Procurement After an Environment Refresh Read More »

How to Create a Dedicated Oracle Apps Identity Domain for EPM Enterprise in OCI

Any organization running Oracle Fusion Apps for ERP or HCM that also needs to deploy EPM Cloud Enterprise in the same OCI tenancy will eventually hit a wall with identity domains. The Default domain is reserved for OCI administration. The Fusion Apps domains are locked to ERP and HCM. And when you open the OCI

How to Create a Dedicated Oracle Apps Identity Domain for EPM Enterprise in OCI Read More »

Import Oracle Fusion Data Extensions for Transactional Business Intelligence Screenshot

How to Fix the “Error Getting Cursor in GenerateHead” in Oracle Cloud ERP BI Publisher After an Oracle Cloud Upgrade

Occasionally, after Oracle Cloud ERP’s quarterly release upgrades, you might encounter a frustrating error when running a previously functional BI Publisher report: “Error generating view. Error getting cursor in GenerateHead.” “Column doesn’t exist” This error typically appears when the data model behind your BI Publisher report references a column that OTBI or Fusion Analytics no […]

How to Fix the “Error Getting Cursor in GenerateHead” in Oracle Cloud ERP BI Publisher After an Oracle Cloud Upgrade Read More »

How to Enable And Query Audit Tables in Oracle Fusion Cloud ERP

Auditing in Oracle Fusion Cloud ERP provides a powerful mechanism for tracking the full change history of critical business objects. By enabling auditing, you can capture create, update, and delete operations on selected attributes of objects such as journals, journal batches, and journal lines. This enables you to: In this article, we’ll walk through, step

How to Enable And Query Audit Tables in Oracle Fusion Cloud ERP Read More »

Navigating ERP Cloud Migrations: Lessons from Complex Enterprise Deployments

Cloud migration is a critical transformation initiative that enterprises undertake to enhance scalability, optimize costs, and improve performance. However, transitioning workloads from on-premise infrastructure to the cloud comes with unique challenges, including compliance risks, security concerns, and operational disruptions. Drawing from experience in leading Oracle Cloud Financials, HCM Cloud, and other cloud migration projects, this […]

Navigating ERP Cloud Migrations: Lessons from Complex Enterprise Deployments Read More »

How to Set a Banner Message in Oracle Fusion Cloud Non-Production Environments

Any team working across multiple Oracle Fusion Cloud environments, DEV, TEST, UAT, PRE-PROD, will eventually run into the same problem: every pod looks identical. The URL might technically tell you where you are, but in the middle of a busy workday, a quick glance at the browser bar is not a reliable safeguard against executing […]

How to Set a Banner Message in Oracle Fusion Cloud Non-Production Environments Read More »

Run Quick SQL Queries on Oracle Cloud ERP with SQL Studio a SQL Developer like tool from Fusion Toolkit

One common challenge my clients face when using Oracle Cloud ERP is the complexity involved in running quick, recurring SQL queries against their database. Oracle ERP typically relies on BI Publisher, which, despite being a powerful reporting tool, requires creating data models and reports even for simple data checks. This process can feel overly complicated

Run Quick SQL Queries on Oracle Cloud ERP with SQL Studio a SQL Developer like tool from Fusion Toolkit Read More »

Boosting Security with Machine Learning in Oracle Autonomous Database

In our era of growing cyber threats, data security is of paramount importance. Companies are continuously exploring advanced methodologies to safeguard their sensitive information. One of these methodologies is the use of machine learning (ML) for enhancing data security. Oracle Autonomous Database comes with in-built Oracle Machine Learning, making it a compelling choice for securing

Boosting Security with Machine Learning in Oracle Autonomous Database Read More »

Text Mining in Oracle Autonomous Database with Oracle Machine Learning

In the era of Big Data, a significant percentage of the data comes in unstructured text format, coming from various sources like emails, social media, reviews, and more. Extracting valuable insights from this textual data is where text mining comes in, and Oracle Autonomous Database with Oracle Machine Learning (OML) offers a useful platform for

Text Mining in Oracle Autonomous Database with Oracle Machine Learning Read More »

Scroll to Top