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...
Writing Basic SELECT Queries in MySQL
Basic SELECTSELECT name, salary FROM employees;All ColumnsSELECT * FROM employees;
application SN&name
SELECT DISTINCT A.APPLICATION_ID , A.application_short_name , b.application_name , c.RESPO...
CP running from Backend
DECLARE l_responsibility_id NUMBER; l_application_id NUMBER; l_user_id NUMBER; l_request_id...
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 Aug 28, 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 Aug 18, 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 Aug 22, 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 Aug 22, 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 Aug 22, 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 Aug 22, 2026
BEFORE and AFTER Triggers
Guides filed under this topic.
No guides match your search.
Try another keyword, topic, or error code.