Results for “jl_zz_ar_tx_lmsg_create_v”

4 results




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

Overview

The view JL_ZZ_AR_TX_LMSG_CREATE_V belongs to the Oracle EBS Latin America Localizations (JL) module, specifically the Brazilian and broader LatAm tax reporting enhancements layered on Oracle Receivables. It is a reporting and integration construct that surfaces legal messages, fiscal classifications, and exception descriptions associated with Receivables tax rules. Its purpose is to expose the configuration data needed to generate statutory tax messages that accompany fiscal documents, allowing external reporting processes, localization reports, or downstream interfaces to retrieve the appropriate message text and classification metadata for a given tax rule.

Importantly, the ETRM metadata records this object as Not implemented in this database in the reference instance. This is a configuration-dependent status: the view is shipped as part of the JL localization schema, but it exists only where the relevant LatAm tax localization patches have been applied and the supporting tables have been created. Its appearance is therefore tied to specific country localizations rather than to a base EBS installation.

Underlying Base Objects

The view is defined over a UNION of queries built from the following documented base objects:

The join conditions enforce active/dated lookup values through SYSDATE BETWEEN NVL(START_DATE_ACTIVE...) AND NVL(END_DATE_ACTIVE...), ensuring only currently effective classifications and messages are returned. A UNION combines parallel rule branches that share the same output shape.

Key Columns

The user search term "ship_from_code" maps directly to the SHIP_FROM_CODE column. Because it is defined as TO_CHAR(NULL) in the documented query text, callers filtering on ship-from values will receive no data from that branch; the value is intended to be supplied by other UNION legs of the view.

Common Use Cases and Queries

Typical usage centers on retrieving the legal message text and fiscal classification for tax rule output. A representative query is:

  • SELECT rule_id, fiscal_classification_code, exception_desc, text FROM jl_zz_ar_tx_lmsg_create_v WHERE fiscal_classification_code = :code;
  • Filtering by ship-from origin: SELECT ship_from_code, message_id, text FROM jl_zz_ar_tx_lmsg_create_v WHERE ship_from_code = :ship_from; — noting the NULL placeholder caveat.
  • Validity-windowed extraction joining effective dates for a reporting period.

Because the view aggregates lookup meanings, standard text, and fiscal classification in a single denormalized result set, it is suited to localization report generation and interface extraction rather than transactional processing.