Search Results ce_statement_recon_gt_v




Overview
Explore in AI Chat

Overview

CE_STATEMENT_RECON_GT_V is a security-filtered view owned by the APPS schema in Oracle Cash Management (CE). It exposes reconciliation records from the bank statement reconciliation process, presenting the data that links bank statement lines to the underlying transactions they have been reconciled against. The view derives its name from the "_GT" suffix convention, indicating that it is designed to operate in conjunction with a global temporary table used by the Cash Management security profile mechanism. Rather than returning all reconciliation rows in the database, the view restricts the result set to those records that fall within the organization and legal entity access privileges defined by the current user's Cash Management security profile.

This view plays a supporting role in Cash Management reporting, reconciliation inquiries, and integration flows where the application must present only the reconciliation activity that the logged-in user is authorized to see. It is particularly relevant to multi-organization deployments in Oracle EBS 12.1.1 and 12.2.2, where data segregation by operating unit, business group, and legal entity is enforced at query time.

Underlying Base Objects

The view is defined over a single primary base object, CE_STATEMENT_RECONCILS_ALL, which stores the reconciliation relationships between bank statement lines and the transactions, journal lines, or other reference records they reconcile. The documented referenced objects are:

  • CE_STATEMENT_RECONCILS_ALL (SYNONYM) — the primary source of reconciliation rows.
  • CE_SECURITY_PROFILES_GT (SYNONYM) — the global temporary table populated with the current user's authorized organization and legal entity identifiers.

The view applies an OR-based predicate against these two objects. Rows are returned when the reconciliation record's ORG_ID matches an organization in the security profile whose ORGANIZATION_TYPE is 'BUSINESS_GROUP' or 'OPERATING_UNIT', when its LEGAL_ENTITY_ID matches a profile entry of type 'LEGAL_ENTITY', or when the REFERENCE_TYPE is one of 'JE_LINE', 'ROI_LINE', or 'STATEMENT'. This third branch ensures that certain reconciliation record types are always accessible regardless of organization or legal entity filtering, reflecting their cross-organizational nature.

Key Columns

Common Use Cases and Queries

The view is typically used in reconciliation inquiries, custom security-aware reports, and integration extracts where only authorized reconciliation data should be surfaced.

Retrieve reconciliations for a specific statement line:

SELECT statement_line_id, reference_type, reference_id, amount,
       status_flag, auto_reconciled_flag
FROM   apps.ce_statement_recon_gt_v
WHERE  statement_line_id = :p_statement_line_id;

List auto-reconciled records visible to the current user:

SELECT reference_type, reference_id, org_id, legal_entity_id, amount
FROM   apps.ce_statement_recon_gt_v
WHERE  auto_reconciled_flag = 'Y'
AND    current_record_flag = 'Y';

Because the underlying security profile global temporary table is populated by the Cash Management security initialization, queries should be executed within an initialized session so the ORG_ID and LEGAL_ENTITY_ID predicates resolve correctly.