Uncategorized

ASBN Creation Error for Multiple Purchase Orders Due to Transportation Arrangement Mismatch

Introduction/ Issue:  An Advanced Shipment and Billing Notice (ASBN) in Oracle E-Business Suite is a document sent by the supplier to notify the buying organization about an upcoming shipment and,…

Read More

Modifying WMS Rule in Oracle EBS R12: A Safe Approach

Introduction/ Issue:  In Oracle E-Business Suite R12 Warehouse Management System (WMS), Cost Group Rules are commonly used to dynamically assign cost groups during inventory transactions. Once a cost group rule…

Read More

Increase on-hand quantity interface using miscellaneous receipt in Oracle apps R12

Increase on-hand quantity interface using miscellaneous receipt To increase on-hand quantity via a miscellaneous receipt interface, you use an ERP/Inventory system ( to record items found during a physical count that exceed…

Read More

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