Results for “document_number”

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

Overview

FII_AR_ARDN_DOC_NUM_LCV is a collection view within the Oracle Financial Intelligence (FII) product family, historically shipped under the Enterprise Technical Reference Model (ETRM) and now classified as obsolete. In Oracle EBS 12.1.1 and 12.2.2 the object exists as part of the Financial Intelligence data model used by the Daily Business Intelligence (DBI) and Financial Intelligence reporting stack, where dimension levels are materialized into "collection views" that feed the analytic warehouse layer. This particular view represents the AR Document Number level of the AR Document Number dimension — that is, the finest grain at which Accounts Receivable documents are identified within the AR subledger analytics.

The view's role is to expose a stable, denormalized projection of AR document identifiers so that downstream reporting objects, concurrent programs, and BI collection routines can consume them without joining numerous base tables directly. Because it is a collection view rather than a transactional view, it is populated by the FII collection process rather than by real-time query against the AR transaction tables.

Underlying Base Objects

The ETRM metadata documents the view as being defined over a single underlying object: FIIBV_AR_ARDN_DOC_NUM_LCV. No additional base tables or referenced base objects are documented. The "FIIBV" prefix (Financial Intelligence Base View) indicates that FII_AR_ARDN_DOC_NUM_LCV is a thin presentation wrapper layered on top of an FII base collection view, which in turn is populated from the AR document tables during the FII collection cycle.

The ETRM record states explicitly that the object is Not implemented in this database in the environment where the metadata was captured. This is consistent with its obsolete status: in many 12.1.1 / 12.2.2 instances the FII AR dimensions were either never deployed, were de-supported, or were superseded by other EBS reporting mechanisms. Where the object does exist, it depends entirely on the presence and population state of FIIBV_AR_ARDN_DOC_NUM_LCV.

Key Columns

• DOC_NUM_PK — Surrogate primary key identifying the AR document number level member within the FII dimension.
• ALL_FK — The "all" foreign key, linking the member to the top of the dimension hierarchy.
• DOC_NUM_DP — Dimension position or display order attribute for the document number member.
• NAME — Descriptive name of the document number dimension member.
• DOCUMENT_NUMBER — The actual AR document number value; this is the column most relevant to searches for "document_number."
• INSTANCE — Identifies the source instance or collection context from which the member was populated.
• USER_ATTRIBUTE1 through USER_ATTRIBUTE5 — Reserved, extensible attributes; the view text shows these positions as NULL placeholders.
• LAST_UPDATE_DATE — Timestamp of the most recent modification to the member record, supporting incremental collection and change tracking.

Common Use Cases and Queries

The primary use case is enumeration and lookup of AR document numbers within the FII analytical model, for example when building dimension-aware reports or validating collected document members. Because the object is obsolete, it should be treated as a reference artifact rather than an actively supported integration point in 12.1.1 or 12.2.2. A representative query is:

• SELECT DOC_NUM_PK, DOCUMENT_NUMBER, NAME, INSTANCE, LAST_UPDATE_DATE FROM FII_AR_ARDN_DOC_NUM_LCV ORDER BY DOCUMENT_NUMBER;
• SELECT DOCUMENT_NUMBER, NAME FROM FII_AR_ARDN_DOC_NUM_LCV WHERE DOCUMENT_NUMBER = :document_number;
• SELECT COUNT(*) FROM FII_AR_ARDN_DOC_NUM_LCV; — used to verify that the FII collection populated the AR document number dimension level.

Where the view is absent, equivalent document-number lookups should be performed directly against the AR transaction tables (for example, RA_CUSTOMER_TRX_ALL) instead of relying on this obsolete FII collection object.