Search guides, SQL, error codes, and procedures — or browse by topic below.
388 guides · 8 topics
API to Update FND_LOOKUP DECLARE l_lookup_type VARCHAR2 (250); l_lookup_code VARCHAR2 (250);...
Oracle SQL Performance & TuningOracle provides features and tools to analyze and tune query performance.Execution PlansI...
Basic SELECTSELECT name, salary FROM employees;All ColumnsSELECT * FROM employees;
SELECT DISTINCT A.APPLICATION_ID , A.application_short_name , b.application_name , c.RESPO...
DECLARE l_responsibility_id NUMBER; l_application_id NUMBER; l_user_id NUMBER; l_request_id...
Lists the Data Access Sets (GL access sets) the current user has access to — used as the LOV source for a "Data Ac...
Updated Aug 28, 2026
security-parametersLists the Business Units the current BI Publisher user has data access to, based on their user role data assignments &md...
Updated Aug 28, 2026
security-parametersLists the Business Units the current user has procurement agent access to, via their PO agent assignment — used as...
Updated Aug 28, 2026
security-parametersLists the Ledgers the current user has direct data access to — used as the LOV source for a "Ledger" report parame...
Updated Aug 28, 2026
security-parametersLists the Fixed Asset Books the current user has data access to — used as the LOV source for a Fixed Assets report...
Updated Aug 28, 2026
security-parametersLists the Intercompany Organizations the current user has data access to — used as the LOV source for an intercomp...
Updated Aug 28, 2026
Guides filed under this topic.
-- SQL Query to obtain Order Management Parameters. SELECT qppvl.NAME , qppvl.DESCRIPTION , qppvl.PARAMETER_CODE...
-- The following SQL can be run from BI to obtain Customer information. SELECT dha.ORDER_NUMBER , dha.source_order_nu...
SELECT h.source_order_number Src_Order , h.order_number Order_Num , h.source_order_id , h.status_code ,...
select dh.source_order_number , df.source_line_number as SO_LINE_NUMBER , df.fulfill_line_number , ddr.doc_user_k...
--SQL used to obtain Invoicing and Account rules used by Order Management. SELECT RULE_ID , NAME , DESCRIPTION ,...
-- Obtain Order Approver details. SELECT dha.order_number order_number , dha.header_id , dha.approval_sequence_numb...
-- SQL Query - Obtain Hold Details for an Order and Hold Code and Release Reason Code Defintitions ; -- Holds which have...
SELECT dfla.source_order_number , dla.SOURCE_LINE_NUMBER , dla.DISPLAY_LINE_NUMBER , dfla.FULFILL_LINE_NUMBER ,...
-- All Orders In Error -- Errors reported on ALL Orders. SELECT dha.source_order_number , dha.order_number , dha.he...