Search Results occurrence_status




Overview
Explore in AI Chat

Overview

JL_BR_AR_BT_BASE_V is a reporting and integration view within the Oracle E-Business Suite Latin America Localizations module (JL), specifically the Brazilian Accounts Receivable (AR) localization. The view consolidates bank return and remittance processing data — the Brazilian "borderô" / retorno bancário workflow — into a single, denormalized record set suitable for concurrent program reporting, GL posting logic, and downstream financial integration. Its primary role is to unify occurrences sourced from bank collection files with their associated receivable documents, portfolio assignments, trade notes (duplicatas), interest, discount, abatement, endorsement credit, and bank charge accounting information so that a single query can drive accounting event generation and reconciliation output.

The view reflects a union-style construction, as evidenced by the anchoring comment "SELECTION 1 – ENDORSEMENT_CREDIT" and the use of placeholder NULL columns (for example, ENDORSEMENT_DEBIT_CCID, BANK_CHARGES_CREDIT_CCID, BANK_CHARGES_DEBIT_CCID) that are populated only in other selections of the union. This design lets the consuming accounting engine treat each occurrence type uniformly through a common set of columns and an ACCT_LINE_TYPE discriminator.

Underlying Base Objects

The ETRM metadata for this object does not document referenced base tables, and the view is listed as "Not implemented in this database," meaning the definition is supplied by the localizations patch but may not be deployed in a given instance. The view text itself reveals its operational dependencies without naming the physical tables:

Because the base tables are not enumerated in the metadata, the safest interpretation is that the view is built over the Brazilian AR bank-occurrence entity and its companion document/portfolio tables, exposed as a flattened read model rather than as a normalized schema object.

Key Columns

Common Use Cases and Queries

Typical uses include reconciling bank returns to open receivables, reporting endorsement and bank charge accounting lines, and tracing trade note numbers for a customer or portfolio.

  • Locate a receivable by trade note number: SELECT occurrence_id, document_id, trade_note_number, customer_id, document_amount, due_date FROM jl_br_ar_bt_base_v WHERE trade_note_number = :p_trade_note;
  • Report unposted accounting lines: SELECT acct_line_type_name, gl_date, gl_posted_date, document_amount, interest_amount FROM jl_br_ar_bt_base_v WHERE flag_post_gl = 'N' AND org_id = :p_org;
  • Summarize endorsement credit by portfolio: SELECT portfolio_code, SUM(endorsement_credit_amount) FROM jl_br_ar_bt_base_v WHERE acct_line_type = 'ENDOCR' GROUP BY portfolio_code;

Because availability depends on localization deployment, verify existence in ALL_VIEWS before relying on the view in custom reports.