Search Results gl_access_set_id

Overview

APPS.FV_TBAL_BY_TS_V is a Treasury (ETRM/FFV) reporting view that presents beginning, period, and ending balances for General Ledger accounts, aggregated by treasury symbol. It joins Treasury fact data in FV_FACTS_TEMP to treasury symbols in FV_TREASURY_SYMBOLS to return, for each treasury symbol and Organization, the currency, account description, and the segment values of the associated accounting flexfield account.

The view is access-set aware. Rather than exposing data across all ledgers, it restricts results to the ledgers associated with the Data Access Set returned by FND_PROFILE.VALUE('GL_ACCESS_SET_ID'), enforced through the GL_ACCESS_SET_LEDGERS table. This makes it suitable for reporting contexts where row-level ledger security must be respected, and it is the reason queries referencing GL_ACCESS_SET_ID are commonly associated with this view and its underlying tables.

Underlying Base Objects

The view is defined over the following documented base objects:

• FV_TREASURY_SYMBOLS — source of ORG_ID, TREASURY_SYMBOL, and the treasury symbol identifier, and the join to the ledger.
• FV_FACTS_TEMP — source of the balance facts; filtered to FCT_INT_RECORD_CATEGORY = 'STBAL'.
• GL_ACCESS_SET_LEDGERS — the access set / ledger association table, joined to GL_ACCESS_SET_ID from the profile option.
• GL_LEDGERS — provides the CURRENCY_CODE and CHART_OF_ACCOUNTS_ID for the ledger.
• FND_FLEX_VALUES and FND_FLEX_VALUES_TL — resolve the account flex value and its language-specific description.
• FND_ID_FLEX_SEGMENTS and FND_SEGMENT_ATTRIBUTE_VALUES — restrict and validate the accounting flexfield structure and the GL_ACCOUNT segment attribute.

The joins are driven by the application 101 (General Ledger) flexfield code 'GL#' and the ledger chart of accounts, and all relevant objects are referenced through APPS synonyms.

Key Columns

• ORG_ID — the organization identifier for the returned row.
• TREASURY_SYMBOL — the treasury symbol being reported on.
• CURRENCY_CODE — functional currency of the associated ledger.
• DESCRIPTION — the flex value description from FND_FLEX_VALUES_TL.
• SGL_ACCT_NUMBER — the account code combination.
• BEGINNING_BALANCE — opening amount (FFT.AMOUNT).
• PERIOD_DR — period-to-date debit amount (FFT.AMOUNT1).
• PERIOD_CR — period-to-date credit amount (FFT.AMOUNT2).
• ENDING_BALANCE — computed as AMOUNT + AMOUNT1 − AMOUNT2.
• SEGMENT1 through SEGMENT30 — the individual accounting flexfield segment values.

Common Use Cases and Queries

The view is typically queried in Treasury balance reporting for the current access set. Because the access set is resolved internally via FND_PROFILE, no explicit access-set predicate is required in the query, though the profile must be initialized in the session.

Example: report balances for a treasury symbol

SELECT org_id, treasury_symbol, sgl_acct_number, currency_code,
       beginning_balance, period_dr, period_cr, ending_balance
FROM   apps.fv_tbal_by_ts_v
WHERE  treasury_symbol = :p_symbol;

Example: inspect the flex segments for an account

SELECT treasury_symbol, segment1, segment2, segment3, ending_balance
FROM   apps.fv_tbal_by_ts_v
WHERE  sgl_acct_number = :p_account;

Example: verify which ledgers the current access set exposes

SELECT l.name, l.currency_code
FROM   gl_ledgers l, gl_access_set_ledgers gsl
WHERE  gsl.access_set_id = fnd_profile.value('GL_ACCESS_SET_ID')
AND    l.ledger_id = gsl.ledger_id;

Because the view depends on the GL_ACCESS_SET_ID profile, results change with the user's assigned access set; troubleshooting missing rows generally begins by validating that profile value and the corresponding GL_ACCESS_SET_LEDGERS entries.