Search Results assignment_code




Overview
Explore in AI Chat

Overview

XLA_ACCT_CLASS_ASSGNS_F_V is a read-only view owned by the APPS schema within the Oracle E-Business Suite Subledger Accounting (XLA) module. It exposes the accounting class assignments configured in the Subledger Accounting application, presenting them in a denormalized form that includes the base assignment attributes along with the translated accounting class name. Because it is a view rather than a table, it performs no physical storage of its own; its rows are derived at runtime from the underlying XLA_ACCT_CLASS_ASSGNS entity and the XLA_LOOKUPS lookup view. The view carries a "VALID" status in the ETRM 12.2.2 metadata, confirming that it is supported and queryable in both 12.1.1 and 12.2.2 environments.

In the context of Oracle EBS reporting and integration, the view serves as a stable, developer-friendly access point for the accounting class assignment setup. Rather than forcing report authors and interface developers to join the base assignment table to the lookup view manually, XLA_ACCT_CLASS_ASSGNS_F_V performs the join internally, exposing both the raw accounting class code and its user-facing meaning. This simplifies the construction of queries used in value sets, custom concurrent programs, BI Publisher data models, and outbound integration extracts.

Underlying Base Objects

The view is defined over two documented base objects: XLA_ACCT_CLASS_ASSGNS (exposed through a SYNONYM) and XLA_LOOKUPS (itself a VIEW). The XLA_ACCT_CLASS_ASSGNS object supplies the core assignment records, including the program code, program owner code, assignment code, assignment owner code, and accounting class code, as well as the standard WHO audit columns. XLA_LOOKUPS contributes the lookup meaning that resolves the internal accounting class code into a descriptive label.

The join condition links XLA_ACCT_CLASS_ASSGNS.ACCOUNTING_CLASS_CODE to XLA_LOOKUPS.LOOKUP_CODE where XLA_LOOKUPS.LOOKUP_TYPE equals 'XLA_ACCOUNTING_CLASS'. This restricts the lookup rows to the Subledger Accounting class lookup set, ensuring each assignment row is paired with exactly the intended meaning. The view also selects the ROWID of the base assignment row as ROW_ID, which preserves a unique identifier that can be traced back to the underlying record.

Key Columns

  • ROW_ID — The row identifier of the base XLA_ACCT_CLASS_ASSGNS record, useful for traceability and row-level correlation.
  • PROGRAM_CODE — Identifies the subledger program to which the assignment applies. This is the column most frequently targeted by searches referencing program_code.
  • PROGRAM_OWNER_CODE — The owner (product/application) code associated with the program.
  • ASSIGNMENT_CODE — The specific accounting class assignment identifier.
  • ASSIGNMENT_OWNER_CODE — The owner code for the assignment.
  • ACCOUNTING_CLASS_CODE — The internal code representing the accounting class in the assignment.
  • ACCOUNTING_CLASS_NAME — The translated meaning of the accounting class code, sourced from XLA_LOOKUPS.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard Oracle audit columns tracking who created and last modified each row.

Common Use Cases and Queries

A frequent requirement is to list accounting class assignments filtered by program code, often as part of configuration review or data validation. The following query retrieves assignments for a specific program:

  • SELECT program_code, program_owner_code, assignment_code, accounting_class_code, accounting_class_name FROM xla_acct_class_assgns_f_v WHERE program_code = :p_program_code;

Reporting extracts commonly need the descriptive class name rather than the internal code, which the view supplies directly:

  • SELECT accounting_class_code, accounting_class_name, COUNT(*) FROM xla_acct_class_assgns_f_v GROUP BY accounting_class_code, accounting_class_name ORDER BY accounting_class_code;

Integration and migration scripts frequently select the audit columns to reconcile records between environments:

  • SELECT row_id, program_code, assignment_code, last_update_date, last_updated_by FROM xla_acct_class_assgns_f_v ORDER BY last_update_date DESC;

Because the view hides the join to XLA_LOOKUPS, these queries remain concise while still returning business-meaningful values, making the view well suited to ad hoc analysis, value-set definitions, and custom reporting against Subledger Accounting configuration in Oracle EBS 12.1.1 and 12.2.2.