Yearly Archives: 2025

Exporting Plan Data in Oracle Fusion Supply Chain Planning

Introduction/ Issue:  In Oracle Fusion Supply Chain Planning, planners often need to extract plan measure data from demand or supply plan layouts for reporting and analysis outside the application. Instead…

Read More

Configuring Work Orders to Align with Resource Requirements in Fusion Supply Chain Planning

Issue:   The Work Orders for a specific item loaded from EBS into Fusion Supply Chain Planning are appearing in the Buyer Material Plan within the supply plan. However, they are…

Read More

Item Regulatory Interface

Procedure: Item Regulatory Interface Objective The purpose of this document is to outline the process for loading and updating Item Regulatory Information into Oracle using an API, based on data…

Read More

UPDATE PO SHIPMENT LINE USING API

UPDATE PO SHIPMENT LINE USING API   Objective: The intent of this document is to understand how we can update or split the PO Shipment line using API Scenario: Currently…

Read More

23ai_Unified_Auditing_feature_and_Best_Practices

Oracle 23ai Auditing: Unified Audit Trail, Features, and Best Practices Why Auditing Matters in Oracle Database 23ai In today’s high-stakes data environment, knowing who accessed your database, what they did,…

Read More

Creating_Auditing_in_Oracle_Database_23ai

How to Check and Create Auditing Policies in Oracle Database 23ai Auditing in Oracle Database 23ai is not just about compliance — it’s about knowing exactly who did what in…

Read More

Troubleshooting EBS 12.2 adcfgclone Failure: JAVA_HOME Issue in commEnv.sh

EBS 12.2 Cloning Issue – adcfgclone Fails Due to Incorrect JAVA_HOME in commEnv.sh Background During one of my Oracle E-Business Suite (EBS) 12.2 cloning activities, I encountered an issue where…

Read More

Oracle Table Partitioning Strategies

Managing Partitions in Oracle Database – A Complete Guide for DBAs Partitioning in Oracle Database offers a powerful way to improve performance, manageability, and scalability for large datasets. By dividing…

Read More

Dataguard manual switchover

Introduction      Oracle Data Guard plays a pivotal role in ensuring business continuity by maintaining synchronized standby databases that can seamlessly take over when the primary database is unavailable. Among its…

Read More

Oracle ERP Cloud Period Close Procedures & Runbook Considerations

Introduction/ Issue:  Oracle ERP Cloud customers have a need to close their books every period, quarter and/or year.   This paper provides guidance on the period-end close procedures for Oracle Cloud…

Read More