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 18, 2026
security-parametersLists the Business Units the current user has procurement agent access to, via their PO agent assignment — used as...
Updated Aug 22, 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 22, 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 22, 2026
security-parametersLists the Intercompany Organizations the current user has data access to — used as the LOV source for an intercomp...
Updated Aug 22, 2026
Guides filed under this topic.
SELECT REQUESTID, DEFINITION FROM FUSION.ESS_REQUEST_HISTORY WHERE state IN (3,6,7,13,19) AND DEFINITION IN (...
SELECT DECODE(state, 1,'Wait', 2,'Ready', 3,'Running', 5,'Bloc...
SELECT requestid, DECODE(state,1,'Scheduled',10,'ERROR',11,'WARNING',12,'SUCCEEDED',6,'Hold',state) AS STAT...
SELECT REQUESTID, SYSDATE, SUBMISSION, REQUESTEDSTART, READYTIME, PROCESSSTART FROM FUSION_ORA_ESS.request_hist...
SELECT ROUND(AVG(TO_NUMBER(TO_CHAR(PROCESSEND,'YYYYMMDDHH24MISS')) - TO_NUMBER(TO_CHAR(PROCESSSTART,'YYYYMMDDHH24MISS'))...
SELECT COUNT(DEFINITION) AS COUNT, DEFINITION FROM FUSION_ORA_ESS.request_HISTORY WHERE STATE = 3 GROUP BY DEFINIT...
SELECT DECODE(state, 1,'Wait', 2,'Ready', 3,'Running', 5,'Blocked',...
SELECT requestid, DEFINITION, ELAPSEDTIME FROM FUSION.ESS_REQUEST_HISTORY WHERE SUBMISSION < SYSDATE - 1 AND sta...
SELECT ERH.REQUESTID, DECODE(state,1,'Wait',2,'Ready',3,'Running',5,'Blocked',7,'Cancelling',9,'Cancelled',...