Farhaj Lodhi's :: Ilm Sub Ke Liye

Overview Oracle APEX Debug is a troubleshooting tool that provides detailed information about page processing, session state, and application execution. By reviewing the Debug Log and Session State, developers can trace application behavior and identify the root cause of issues Scenario Suppose an Interactive Grid is filtered using four hidden Page Items. The grid is not returning the expected records, and the developer needs to confirm whether the Page Items contain the correct values during execution In this article, we will discuss how to verify that the values stored in Hidden Page Items are correct by using Oracle APEX Debug and the Session viewer for a point-in-time snapshot. Hidden Item In Oracle APEX, a Hidden Page Item stores values that are not visible to end users but remain available during page processing, validations, computations, Dynamic Actions, and PL/SQL execution Requirement:   Before following these steps, ensure we have: 1.    ...

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