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...
Lists the Business Units the current BI Publisher user has data access to, based on their user role data assignments &md...
Lists the Data Access Sets (GL access sets) the current user has access to — used as the LOV source for a "Data Ac...
SELECT IOP.ORGANIZATION_CODE, IOP.ORGANIZATION_ID, IOP.INVENTORY_FLAG, (SELECT NAME FROM...
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-parametersLists 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-parametersLists the Business Units the current user has procurement agent access to, via their PO agent assignment — used as...
Updated Oct 12, 2026
security-parametersLists 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-parametersLists 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-parametersLists the Intercompany Organizations the current user has data access to — used as the LOV source for an intercomp...
Updated Oct 03, 2026
Guides filed under this topic.
SELECT haotl.NAME, iop.*, MC.calendar_Code, mc.description FROM Inv_Org_Parameters iop, HR_ORGANIZATION_UNITS_F_TL haotl...
SELECT haotl.NAME BU_NAME, hao.LOCATION_ID, haotl.BUSINESS_GROUP_ID, haotl.EFFECTIVE_START_DATE DATE_FROM, haotl.EFFECTI...
Includes multiple selectors for: GL_LEDGERS, XLE_ENTITY_PROFILES, CST_COST_ORGS_V, FUN_ALL_BUSINESS_UNITS_V, and INV_ORG...
SELECT IOP.ORGANIZATION_CODE, IOP.ORGANIZATION_ID, IOP.INVENTORY_FLAG, (SELECT NAME FROM HR_ORGANIZATION_UNITS_F_TL WHER...
SELECT haotl.NAME, iop.*, MC.calendar_Code, mc.description FROM Inv_Org_Parameters iop, HR_ORGANIZATION_UNITS_F_TL haotl...
SELECT haotl.NAME BU_NAME, hao.LOCATION_ID LOCATION_ID, haotl.BUSINESS_GROU...
-- Ledgers SELECT LEDGER_ID, NAME, SHORT_NAME, DESCRIPTION, CURRENCY_CODE, CHART_OF_ACCOUNTS_ID, LEDGER_CATEGORY_CODE,...
SELECT IOP.ORGANIZATION_CODE, IOP.ORGANIZATION_ID, IOP.INVENTORY_FLAG, (SELECT NAME FROM...
SELECT haotl.NAME, iop.*, MC.calendar_Code, mc.description FROM Inv_Org_Parameters iop,...