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 fss.SET_ID , FSS.SET_NAME , FSA.DETERMINANT_VALUE , fsa.ENTERPRISE_ID , fsa.REFERENCE_GROUP_NAME...
-- SELECT pu.username , pur.role_id , pr.active_flag , pr.role_common_name FROM fusion.per_users pu...
SELECT HP.PARTY_NAME , poz_util.format_name(PVC.per_party_id) FULL_NAME , PVC.VENDOR_CONTACT_ID...
-- SELECT FSS.SET_ID , FSS.SET_NAME , FLVT.LOOKUP_TYPE , FLVT.LOOKUP_CODE FROM FND_LOOKUP_VALUES_TL FLVT...
-- Query for Supplier ,Supplier Sites and Supplier Bank Information In oracle Fusion SELECT PSV.VENDOR_NAME SUPPLIER_NA...
SELECT cit.* /*3-22834429151*/ FROM fusion.CST_INV_TRANSACTIONS cit , fusion.cst_cost_distribution_lines ccd...
-- SELECT FSS.ENTERPRISE_ID , FSS.SET_CODE , FSS.SET_NAME FROM fnd_SETID_SETS FSS
-- select fpob.ENTERPRISE_ID , fpob.PROFILE_OPTION_NAME , fpot.DESCRIPTION , fpob.USER_ENABLED_FLAG , fpob....
-- select p.profile_option_name , l.level_name , v.level_value , l.enabled_flag , v.profile_option_value fr...