Search Results program_owner_code




Overview
Explore in AI Chat

Overview

The XLA_POST_ACCT_PROGS_F_V view is a reporting and integration artifact within the Oracle E-Business Suite Subledger Accounting (XLA) product. It resides in the APPS schema and consolidates multilingual program definitions used by the Subledger Accounting posting and accounting engine. The view presents subledger accounting programs identified by a compound program key composed of PROGRAM_CODE and PROGRAM_OWNER_CODE, joined to their translated names, descriptions, owning application, and a lookup-derived display value. Because XLA program registration is metadata-driven, this view provides a denormalized, user-language-aware snapshot of the registered programs that generate and post accounting entries.

The view is read-only and is intended for inquiry, reporting, and integration rather than transactional maintenance. The F suffix convention in Oracle EBS indicates a "flex" or formatted view typically consumed by Oracle Application Framework (OAF) pages, forms, and diagnostic reports. It exposes translated values based on the session language (USERENV('LANG')), so consumers automatically receive descriptions in the logged-in user's language.

Underlying Base Objects

The view is defined over four referenced objects:

Join conditions link the translation rows to the base rows on PROGRAM_CODE and PROGRAM_OWNER_CODE, restrict translations to the current session language, match the owner code to the XLA_OWNER_TYPE lookup, and match APPLICATION_ID to FND_APPLICATION_VL. The view therefore absorbs the cardinality of the translation join and returns one row per program per session language.

Key Columns

  • ROW_ID — the ROWID of the underlying XLA_POST_ACCT_PROGS_B row, useful for direct-row identification.
  • PROGRAM_CODE — the internal identifier of the subledger accounting program.
  • PROGRAM_OWNER_CODE — the code identifying the owner of the program; the search term program_owner_code maps directly to this column, which is central to program resolution logic.
  • PROGRAM_OWNER_DSP — the decoded, user-facing meaning of PROGRAM_OWNER_CODE from the XLA_OWNER_TYPE lookup.
  • APPLICATION_ID / APPLICATION_NAME — the owning application identifier and its translated name.
  • NAME / DESCRIPTION — the language-specific program name and description from the translation table.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns sourced from the base table.

Common Use Cases and Queries

Typical scenarios include validating which programs are registered for a given owner, building LOV or inquiry pages, and tracing the application that owns a posting program. Filtering by PROGRAM_OWNER_CODE is the most frequent access path.

SELECT program_code, program_owner_code, program_owner_dsp,
       application_name, name, description
FROM   apps.xla_post_acct_progs_f_v
WHERE  program_owner_code = '&owner_code'
ORDER  BY program_code;

To enumerate all distinct owners and their display meanings:

SELECT DISTINCT program_owner_code, program_owner_dsp
FROM   apps.xla_post_acct_progs_f_v
ORDER  BY program_owner_code;

To join the view to custom reporting on accounting programs, key on PROGRAM_CODE and PROGRAM_OWNER_CODE, which together form the logical unique identifier shared with XLA_POST_ACCT_PROGS_B and XLA_POST_ACCT_PROGS_TL.