Uncategorized

Assembly and Component Items Demand Shortage Report in Fusion SCP

Introduction/ Issue: Developing a BIP report in Fusion to identify component demand shortages for assembly items and improve supply planning decisions. Why we need to do / Cause of the…

Read More

How a Redwood Page differs from a Classic ADF page

Introduction:     Redwood Pages and standard ADF pages represent two different approaches to building user interfaces within Oracle applications. While standard ADF pages have traditionally been used to develop enterprise-grade web applications…

Read More

A Practical Guide to Validating Oracle EBS R12.2 DMZ Node Health and Security

Introduction In an Oracle E-Business Suite (EBS) R12.2 environment, the DMZ web tier acts as the first line of defense between external users and internal application services. Because this tier…

Read More

Speeding Up SQL Server Operations with Instant File Initialization (IFI)

In SQL Server environments, routine administrative operations such as database restores, data file growth, and the addition of new data files can become increasingly time-consuming as databases grow in size…

Read More

Step-by-Step Guide: Configure Debezium with PostgreSQL 17 and Apache Kafka

Prerequisites  PostgreSQL 17 installed and running. • Java 11 or later installed. • Apache Kafka and Kafka Connect. • Debezium PostgreSQL connector JAR placed in Kafka Connect plugin path. • A PostgreSQL…

Read More

Creating a MongoDB Database and User with Permissions

Connect to MongoDB usingmongosh To begin working with MongoDB, open your terminal and connect using the MongoDB shell (mongosh):  mongosh  Create a Database MongoDB creates databases implicitly when you first…

Read More

Creation of Bursting using XML Data Template

Step 1: Create XML Data Template <?xml version=”1.0″ encoding=”UTF-8″ ?> <dataTemplate name=”AP_INVOICE_DETAILS” description=”AP_INVOICE_DETAILS” version=”1.0″> <properties> <property name=”xml_tag_case” value=”upper”/> <property name=”Include_Parameters” value=”True”/> </properties> <parameters> <parameter name=”P_VENDOR_ID”  dataType=”NUMBER”/> <parameter name=”P_INVOICE_NUM” dataType=”CHARACTER”/> <parameter…

Read More

Dynamic Printable PDF Document in Oracle APEX

Dynamic Printable PDF Document in Oracle APEX Introduction In this document, we demonstrate how to create a dynamic printable document in Oracle APEX using a Dynamic Content Region.The content is…

Read More

Query to get vendor master with missing GST Numbers report in fusion.

SELECT Qry_rslt.”Supplier Name”       ,Qry_rslt.”Supplier Number”   ,Qry_rslt.”Supplier Site Name”   ,Qry_rslt.”Supplier Status”   ,Qry_rslt.”Inactive Date”   ,Qry_rslt.”Procurement Business Unit”   ,Qry_rslt.”Currency”   ,Qry_rslt.”Total Amount”   ,Qry_rslt.”No Data…

Read More

Resolving PRCR-1079 / CRS-5076 Due to DB_UNIQUE_NAME Mismatch in Oracle RAC 

Error  While starting an Oracle RAC database using srvctl, the startup failed with:  PRCR-1079: Failed to start resource ora.RACDB.db  CRS-5076: Startup of database resource ‘ora.RACDB.db’ is failing because  DB_UNIQUE_NAME ‘RAC_DB’ is not expected  Description …

Read More