Results for “ra_account_combinations”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

RA_ACCOUNT_COMBINATIONS is an Oracle Receivables (AR) table classified under the ETRM metadata as "Account information for internal Oracle users." It resides in the AR schema and holds a status of VALID across both 12.1.1 and 12.2.2 releases. The table stores account combination references that Receivables uses when generating accounting entries, deriving distribution accounts, and reconciling subledger activity against the General Ledger. In the context of Oracle EBS subledger accounting, this table supports the mapping between transactional accounting attributes and the chart of accounts segments required for journal creation.

Under the heuristic Data Vault classification mined from its foreign key structure, RA_ACCOUNT_COMBINATIONS is modeled as a standalone entity. From a Data Vault modeling perspective, this suggests treating the table as a reference or lookup construct rather than a transaction hub or a dependent link, since no inbound or outbound FK relationships are documented. The ETRM notes emphasize the standalone nature of the object, meaning it should be modeled independently without implied parent-child dependencies on transactional tables.

Key Information Stored

The table contains 25 documented columns. The most significant are summarized below, distinguishing the surrogate primary key from business-key candidates:

• ACCOUNT_COMBINATION_ID — The surrogate primary key, enforced by RA_ACCOUNT_COMBINATIONS_PK. It also appears in the unique index RA_ACCOUNT_COMBINATIONS_U1.
• CODE_COMBINATION_ID — The foreign key reference into the General Ledger chart of accounts combinations, linking Receivables distributions to GL accounting flexfields.
• VALUE1, VALUE2 — Segment values forming the second unique index, RA_ACCOUNT_COMBINATIONS_U2, acting as a business-key candidate for account identification.
• ATTRIBUTE_CATEGORY — Descriptive flexfield context for the account combination record.
• ATTRIBUTE1 through ATTRIBUTE15 — Descriptive flexfield segment columns used to capture additional, customer-defined account attributes.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Oracle EBS WHO columns capturing audit and user tracking information.

The dual unique indexes (U1 on ACCOUNT_COMBINATION_ID and U2 on VALUE1/VALUE2) indicate that both a technical surrogate and a natural composite key are enforced, which is useful when reconciling account references across subledger and GL reporting.

Common Use Cases and Queries

Typical usage involves resolving Receivables account references to their underlying GL code combinations and reporting on account assignments used during AutoInvoice, receipt accounting, and adjustments. A common query joins the combination to GL_CODE_COMBINATIONS via CODE_COMBINATION_ID to retrieve the full flexfield string:

• Retrieve all account combinations with their audit trail for a given user: SELECT account_combination_id, code_combination_id, value1, value2 FROM ra_account_combinations WHERE last_updated_by = :user_id;
• Look up an account by business key: SELECT account_combination_id, code_combination_id FROM ra_account_combinations WHERE value1 = :v1 AND value2 = :v2;
• Report account combinations created or modified within a period using CREATION_DATE or LAST_UPDATE_DATE filters.
• Validate that every Receivables distribution resolves to a valid account combination prior to period close.

Related Objects

Because the ETRM metadata classifies this object as standalone, direct FK relationships are not enumerated. The most relevant related objects, inferred from documented columns and standard AR/GL integration, include:

• GL_CODE_COMBINATIONS — joined on CODE_COMBINATION_ID to resolve the chart of accounts flexfield.
• RA_CUSTOMER_TRX_LINES and RA_CUST_TRX_LINE_GL_DIST — distributions referencing account combinations.
• AR_CASH_RECEIPTS and AR_ADJUSTMENTS — transactions whose accounting depends on account combination lookups.
• AR_DISTRIBUTIONS_ALL — the subledger accounting distribution table consuming these combinations.
• FND_FLEX_VALUES — source of flexfield segment values referenced by ATTRIBUTE and VALUE columns.

Together these objects support the Receivables-to-General-Ledger accounting flow in Oracle EBS 12.1.1 and 12.2.2.