Farhaj Lodhi's :: Ilm Sub Ke Liye

Introduction Oracle E-Business Suite (EBS) R12 General Ledger (GL) is the core Financial module in Oracle EBS R12. It is used to manage journal entries, accounting periods, balances, and financial reporting. The GL module integrates with Payables (AP), Receivables (AR), Fixed Assets (FA), Purchasing (PO), and Inventory (INV). The main purpose of a general ledger system is to record financial activity of a company and to produce financial and management reports to help the organization make decisions. Below are real-world SQL queries commonly used.   1) View configured Ledgers      Purpose: Fetch Ledger Configuration Details SELECT       ledger_id,      name  AS   ledger_name ,    short_name ,   currency_code FROM     gl_ledgers ORDER BY     ledger_id ;   2) Ledger Information Query Purpose: Fetch Ledger Configuration Details SELECT     gl.name   ...

  Introduction Oracle APEX provides built-in region titles for reports and Interactive Grids. However, in enterprise applications developers often need more control over the appearance of page headings, especially when displaying contextual information such as employee names, vehicle numbers.  This article demonstrates how to create a custom styled heading with dynamic page item values above a report region while avoiding duplicate titles and unnecessary spacing. Prerequisites   ·   One Interactive Grid region named Service Request Detail  ·   Basic familiarity with APEX Page Designer Objective We want to display a styled heading such as 'Vehicle Service Request Details : [ Vehicle No - Vehicle Description ]' above a report region by combining a Static Content region with the substitution string &P398_VEHICLE_NO. Solution Step 1: Create Interactive Report Region   a) Set the Report Region Title In Page Designer, click your re...