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 can [...]

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 [...]

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, blow code will help to [...]

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:   DECLARE [...]

 Introduction: This SQL query is used to fetch the data Inventory Onhand By Location Cause of the issue: Business wants a report that details Inventory Onhand By Location How do we solve: Create [...]

Introduction:   This SQL query is used to fetching the data Backlog Orders with freight Details   Cause of the issue: Business wants a report that details of Backlog Orders How do we [...]

Introduction:   This SQL query is used to fetching the data of FG Items where used details like  Component Item, Component Item Description, Parent ,Parent Item Description, Item Seq, [...]

Introduction:   This SQL query is used to fetching the data of Bill of Materials Explosion details like Order Level, Root Assembly, Assembly Item, Assembly Item Description, Assembly Item [...]

Introduction This Query will help to Extract the Customer Wise Accrual Details in Trade Management in Oracle Apps. SQL Query: SELECT DECODE (qualifier_context, ‘CUSTOMER’, (SELECT [...]

Introduction This Query will help to Extract the Credit Memo Data in Oracle Apps. SQL Query: SELECT CASE rcta.interface_header_context WHEN ‘CLAIM’ THEN ‘TRADE MANAGEMENT’ [...]