Posts by Venkatesh Balasubramanian

Fixing Stuck Trips When Delivery Is Closed but Trip Stop Interface Isn’t Triggered (Oracle WMS)

Introduction / Issue In Oracle Shipping Execution (WSH), it’s common to run into a situation where a delivery has been closed, but the associated trip remains open because the trip…

Read More

Extracting Bank Detail Reports in Oracle Apps R12

Introduction In Oracle Applications R12, supplier bank account details are not stored in a single, easily queryable table. They’re spread across the Oracle Payments (IBY) schema and Accounts Payable (AP)…

Read More

Mass Inventory Category Cleanup Using Oracle Inventory API

Mass Inventory Category Cleanup Using Oracle Inventory API In large Oracle E-Business Suite (EBS) implementations, item categories often become inconsistent over time due to data migrations, manual corrections, or changes…

Read More

Applying and Releasing Sales Order Holds Based on Customer Item Cross-Reference Commodity Code

Applying and Releasing Sales Order Holds Based on Customer Item Cross-Reference Commodity Code In Oracle Order Management, business rules often require dynamic control over Sales Order processing. In this case,…

Read More

API to Update Item Status in Oracle E-Business Suite

API to Update Item Status in Oracle E-Business Suite Introduction In Oracle E-Business Suite (EBS), Item Status controls key aspects of how an item behaves across different modules such as…

Read More

API to Update the Item Categories in Oracle EBS

API to Update the Item Categories in Oracle EBS Introduction In Oracle E-Business Suite (EBS), item categories play a crucial role in organizing and classifying items for inventory, costing, and…

Read More

Delivery is Shipped Status but Order is Not Closed

Delivery is Shipped Status but Order is Not Closed Introduction In Oracle EBS, there are instances where a delivery reaches the Shipped status, but the associated Trip remains open. This…

Read More

Extracting Data for Oracle Supply Chain Planning Cloud

Extracting Data for Oracle Supply Chain Planning Cloud – Steps to Customize the Integration Logic   Introduction Oracle Supply Chain Planning (SCP) Cloud is a powerful tool for demand forecasting,…

Read More

Mass Update the Customer Matesr Price List

Introduction: We have a requirement when the new pricelist has been created that needs to be updated in the customer master account level and Bill To and Ship To level,…

Read More

Unapply Incorrect Closed Claims

Introduction: We have a Receipt with a “Claim Investigation” where the Claim # was not populated. The below script will help to resolve that issue.   w do we solve:…

Read More