Search Results fii_global1

Overview

APPS.PJI_CURRENCY_TYPES_V is a reporting view in Oracle EBS that exposes currency-type lookup values used by Oracle Projects (PA) and its associated implementation framework. It is a small, UNION-based view that presents two distinct categories of currency rows to consumer forms, reports, and integrations: a per-organization currency derived from the set of books assigned to a project implementation, and a single global currency entry identified by the literal key FII_GLOBAL1. The view is owned by the APPS schema and is documented in ETRM 12.2.2, and applies equally to earlier 12.1.1 environments where the same implementation framework is present.

The user search term “fii_global1” maps directly to the second branch of the view's UNION, where ID = 'FII_GLOBAL1' selects a global currency value. This indicates the view is typically queried to resolve currency values for either a specific organization or a global fallback context.

Underlying Base Objects

Three underlying objects are referenced in the view definition:

• FII_CURRENCIES_V — the primary source of currency values; it supplies the VALUE column and the ID used to match a set-of-books currency or the global entry.
• PA_IMPLEMENTATIONS_ALL — provides the ORG_ID and the SET_OF_BOOKS_ID that links an organization to its ledger.
• GL_SETS_OF_BOOKS — supplies the CURRENCY_CODE used to join to FII_CURRENCIES_V.ID.

The first query joins all three tables on GSOB.SET_OF_BOOKS_ID = PIMP.SET_OF_BOOKS_ID and GSOB.CURRENCY_CODE = CURR.ID, returning the organization-specific currency with a literal ID of 'F'. The second query performs a cartesian-free singleton lookup against FII_CURRENCIES_V alone, returning the global currency with a literal ID of 'G' and a NULL ORG_ID. No base tables beyond these three views/tables are documented.

Key Columns

• ORG_ID — the operating unit or organization identifier from PA_IMPLEMENTATIONS_ALL. It is populated only for the ‘F’ (organization-specific) rows and is NULL for the global row.
• ID — a discriminator literal that distinguishes the two row types: 'F' identifies the organization/functional currency derived from the set of books, while 'G' identifies the global currency from the FII_GLOBAL1 lookup.
• VALUE — the currency value string drawn from FII_CURRENCIES_V. This is the display/selection value returned to the consumer.

Common Use Cases and Queries

The view is commonly consumed to populate currency lists in Projects-related setups and integrations, or to validate which currency is associated with an organization versus the global default. A typical query retrieving the global currency specifically is:

• SELECT ID, ORG_ID, VALUE FROM APPS.PJI_CURRENCY_TYPES_V WHERE ID = 'G';
• SELECT ORG_ID, VALUE FROM APPS.PJI_CURRENCY_TYPES_V WHERE ID = 'F' AND ORG_ID = :p_org_id;
• SELECT ID, VALUE FROM APPS.PJI_CURRENCY_TYPES_V ORDER BY ID, ORG_ID;

The first query isolates the FII_GLOBAL1 entry, allowing callers to obtain the global currency used when no organization-specific currency applies. The second resolves the functional currency for a given organization via its set of books. Because the view returns only three columns and performs no filtering on ORG_ID, consumers should always qualify queries by ID or ORG_ID to avoid mixing global and organization-scoped values.