Results for “je_cz_cont_alloc”

8 results




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

Overview

JE_CZ_CONT_ALLOC is a reporting view in the Oracle E-Business Suite European Localizations module (product code JE), specifically associated with the Czech localization. The view exposes contract allocation data linking contracts to bank accounts, together with the standard Oracle EBS multi-organization and audit columns plus a flexible attribute set (ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE20). Its primary role is to provide a secured, org-filtered read interface over the underlying allocation table so that inquiry forms, reports, and integrations can access allocation records without directly querying the transactional base table.

As documented in the ETRM 12.2.2 metadata, the view is not materially implemented in the reference database instance captured during documentation, meaning the base table may exist only where the Czech localization patchset has been applied and configured. Notably, the view is not referenced by any documented base objects, and the metadata lists no dependencies, which is consistent with a localization object that is conditionally deployed.

Underlying Base Objects

The view is defined over a single base table, JE_CZ_CONT_ALLOC_ALL, selecting an explicit column list rather than using a wildcard. The "_ALL" suffix indicates the table stores records across all organizations, and the view therefore acts as the organization-specific face of that table. The view text applies a security predicate on ORG_ID using USERENV('CLIENT_INFO'): it extracts the organization identifier from the client information string (handling both the leading-blank and populated formats) and compares it, via NVL defaults of -99, against the row's ORG_ID. This is the classic Oracle EBS Multi-Org secure view pattern.

Because the view selects columns verbatim from the base table and applies only the ORG_ID filter, no joins, aggregations, or derived calculations are introduced. The view is therefore logically equivalent to JE_CZ_CONT_ALLOC_ALL restricted to the current session's operating unit.

Key Columns

  • CONTRACT_ID — Identifier of the contract to which the allocation record pertains; the principal business key.
  • BANK_ACCOUNT_ID — Identifier of the bank account associated with the contract allocation.
  • ORG_ID — Operating unit (organization) identifier; drives the Multi-Org security predicate in the view.
  • INACTIVE_DATE — Date on which the allocation record becomes inactive; used for effective-dating queries.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Oracle EBS audit columns capturing record creation and last modification.
  • ATTRIBUTE_CATEGORY, ATTRIBUTE1–ATTRIBUTE20 — Descriptive flexfield (DFF) columns allowing the Czech localization to capture customer-specific or statutory allocation attributes without schema changes.

Common Use Cases and Queries

Typical uses include listing active contract-to-bank-account allocations for an operating unit, joining allocations to contract and bank master data, and extracting DFF attributes for localization reporting. The org security predicate means queries must run with the correct CLIENT_INFO / operating unit context.

  • List active allocations: SELECT contract_id, bank_account_id, inactive_date FROM je_cz_cont_alloc WHERE inactive_date IS NULL;
  • Filter by contract: SELECT * FROM je_cz_cont_alloc WHERE contract_id = :contract_id;
  • Retrieve DFF values: SELECT contract_id, attribute_category, attribute1, attribute2 FROM je_cz_cont_alloc ORDER BY contract_id;
  • Join to bank accounts: SELECT c.contract_id, c.bank_account_id, b.bank_account_name FROM je_cz_cont_alloc c, ap_bank_accounts_all b WHERE c.bank_account_id = b.bank_account_id;

Because the metadata documents no implemented base object in the reference instance, teams should confirm deployment of the Czech localization before relying on these queries.