Monday, 7 July 2025

Oracle Fusion Cash Management: Key Tables and Sample SQL Queries

›
  Oracle Fusion Cash Management: Key Tables and Sample SQL Queries Oracle Fusion Cash Management (CE) plays a critical ro...

Oracle Fusion Fixed Assets Tables – Key Tables and Sample Queries

›
Oracle Fusion Fixed Assets (FA) is a comprehensive module used for managing an organization's fixed assets lifecycle—f...
Tuesday, 1 July 2025

All about Cursors in Oracle PL/SQL

›
 In this blog post, we will see how to use cursors to fetch multiple rows from a query result set Implicit Cursor: Here is...

How to write a Anonymous Block in PL/SQL

›
An anonymous block is a PL/SQL program without a name. It is used for quick tasks and testing. BEGIN DBMS_OUTPUT.PUT_LINE(...
Saturday, 28 June 2025

SQL Query to Fetch Price List Lines for Items

›
 Here is the sample SQL Query to fetch the Price List Lines for the Items. Please modify the query as per the requirements...

SQL Query to fetch the Active Price Lists

›
 Here is the sample SQL Query to fetch the Price Lists in Oracle fusion. SELECT qlb.list_header_id, qlb.name, qlb.descript...

Building a Custom Report in Oracle Fusion Using BI Publisher

›
  Building a Custom Report in Oracle Fusion Using BI Publisher Oracle Fusion BI Publisher (BIP) is a powerful reporting t...

Oracle Fusion Reporting - OTBI vs BI Publisher vs Smart View

›
  Oracle Fusion Reporting: How to Use OTBI vs BI Publisher vs Smart View Oracle Fusion Cloud provides multiple tools for r...