Results for “igi_ar_misc_cash_dists”

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

Overview

The IGI_AR_MISC_CASH_DISTS view is a secured, organization-filtered read layer maintained in the APPS schema as part of the IGI – Public Sector Financials International product family. It exposes information about miscellaneous cash distributions, which are receipt-related accounting distributions generated when miscellaneous cash receipts are processed in Oracle Receivables and subsequently interfaced to the General Ledger. The view presents the same column set as its underlying _ALL table but restricts the visible rows to the operating unit (ORG_ID) associated with the current session. In Oracle EBS 12.1.1 and 12.2.2 this behavior is enforced through the USERENV('CLIENT_INFO') mechanism, which stores the session's current organization identifier in a standardized client information string.

The practical role of the view is that of an Operating Unit (multi-org) security wrapper. Application code, concurrent programs, and ad-hoc reports query it instead of the base table so that users see only distributions belonging to the organization they are currently signed into. Because the underlying identifier is called MISC_CASH_DISTRIBUTION_ID, users searching for that term—frequently as the primary key of a miscellaneous cash receipt distribution—are directed to this view.

Underlying Base Objects

The documented base object for this view is IGI_AR_MISC_CASH_DISTS_ALL, accessed through a SYNONYM in the APPS schema. As the _ALL suffix indicates, the base table stores distribution rows for every organization, with the operating unit identifier carried in ORG_ID. The view text is a simple projection:

• SELECT of nine named columns from IGI_AR_MISC_CASH_DISTS_ALL, with no joins, grouping, or aggregation.
• A WHERE clause that resolves the current session's organization using SUBSTR(USERENV('CLIENT_INFO'), 1, 10), then compares it to the row's ORG_ID.
• Both sides of the comparison are wrapped in NVL(..., -99), and the client-info fragment is passed through TO_NUMBER with a DECODE guard that returns NULL when the first character of the string is a blank. This produces the familiar "no-view" behavior: sessions with no organization set match only rows whose ORG_ID resolves to -99, effectively returning no operational data.

The relationship is therefore one-to-one at the row level: every qualifying row in the view corresponds to exactly one row in the base table, and no data is transformed except for the organization filter.

Key Columns

• MISC_CASH_DISTRIBUTION_ID – Surrogate primary key uniquely identifying each miscellaneous cash distribution record.
• ARC_POSTING_CONTROL_ID – Identifier linking the distribution to the Receivables posting control record that governs its accounting and GL transfer status.
• ARC_GL_POSTED_DATE – Date on which the associated accounting entry was posted to the General Ledger; a NULL value typically indicates the distribution has not yet been transferred.
• ORG_ID – Operating unit identifier; the column used by the view's security predicate to filter rows.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN – Standard WHO (audit) columns recording creation and modification metadata.

Common Use Cases and Queries

Typical scenarios include reconciling miscellaneous cash receipts to their GL postings, identifying distributions that remain unposted, and joining the identifier to downstream accounting tables. Because the view is organi zation-sensitive, the query must be executed in a session where CLIENT_INFO has been initialized—normally any Oracle Forms or concurrent manager session.

To locate a distribution by its primary key:

• SELECT misc_cash_distribution_id, org_id, arc_posting_control_id, arc_gl_posted_date FROM igi_ar_misc_cash_dists WHERE misc_cash_distribution_id = :id;

To identify distributions not yet posted to GL within the current operating unit:

• SELECT misc_cash_distribution_id, arc_posting_control_id FROM igi_ar_misc_cash_dists WHERE arc_gl_posted_date IS NULL ORDER BY creation_date;

Automated interfaces, reconciliations, and public-sector reporting extensions use these patterns to audit miscellaneous cash activity while relying on the view, rather than the base table, to enforce operating unit isolation.