Find practical knowledge without the noise.
Search guides, SQL, error codes, and procedures — or browse by topic below.
388 guides · 8 topics
Explore knowledge
Popular this week
See allAPI_to_Update_FND_LOOKUP
API to Update FND_LOOKUP DECLARE l_lookup_type VARCHAR2 (250); l_lookup_code VARCHAR2 (250);...
Performance & Tuning
Oracle SQL Performance & TuningOracle provides features and tools to analyze and tune query performance.Execution PlansI...
Business Unit LOV (Non-Procurement) — Security-Filtered Report Parameter
Lists the Business Units the current BI Publisher user has data access to, based on their user role data assignments &md...
Data Access Set LOV — Security-Filtered Report Parameter
Lists the Data Access Sets (GL access sets) the current user has access to — used as the LOV source for a "Data Ac...
Organization Details - Organization Details
SELECT IOP.ORGANIZATION_CODE, IOP.ORGANIZATION_ID, IOP.INVENTORY_FLAG, (SELECT NAME FROM...
Recently added
See allData Access Set LOV — Security-Filtered Report Parameter
Lists the Data Access Sets (GL access sets) the current user has access to — used as the LOV source for a "Data Ac...
Updated Oct 13, 2026
security-parametersBusiness Unit LOV (Non-Procurement) — Security-Filtered Report Parameter
Lists the Business Units the current BI Publisher user has data access to, based on their user role data assignments &md...
Updated Oct 10, 2026
security-parametersBusiness Unit LOV (Procurement) — Security-Filtered Report Parameter
Lists the Business Units the current user has procurement agent access to, via their PO agent assignment — used as...
Updated Oct 12, 2026
security-parametersLedger LOV — Security-Filtered Report Parameter
Lists the Ledgers the current user has direct data access to — used as the LOV source for a "Ledger" report parame...
Updated Oct 06, 2026
security-parametersFixed Asset Book LOV — Security-Filtered Report Parameter
Lists the Fixed Asset Books the current user has data access to — used as the LOV source for a Fixed Assets report...
Updated Oct 03, 2026
security-parametersIntercompany Organization LOV — Security-Filtered Report Parameter
Lists the Intercompany Organizations the current user has data access to — used as the LOV source for an intercomp...
Updated Oct 03, 2026
VARRAYS
Guides filed under this topic.
No guides match your search.
Try another keyword, topic, or error code.