Results for “interest_invoice_id”

24 results




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

Overview

The JG_ZZ_INTEREST_INVOICES_ALL table is a core transaction table within the JG – Regional Localizations product family of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It is owned by the AR (Receivables) schema and is registered as VALID, reflecting its active role in supporting country-specific interest invoicing requirements—most notably the Brazilian localization where late-payment interest on customer receivables is calculated and posted as an invoice.

The table stores invoice header information for interest invoices. Each record represents a single interest invoice generated against a customer, tied back to the interest calculation batch that produced it. The table is partitioned conceptually by operating unit via ORG_ID, and its primary key JG_ZZ_INTEREST_INVOICES_PK is composed of INTEREST_INVOICE_ID and ORG_ID, ensuring multi-org security compliance.

From a data-modeling perspective, the ETRM metadata classifies this object as satellite-leaning. This heuristic reflects that the table carries descriptive attributes (currency, exchange rate, customer references) keyed to a parent business entity, rather than acting as a pure hub or link. Analysts building a Data Vault layer should treat the interest invoice as a satellite of the interest batch hub, with the batch identifier serving as the natural parent reference.

Key Information Stored

The table comprises 15 documented columns. The most significant are:

The unique index JG_ZZ_INTEREST_INVOICES_U1 on (INTEREST_INVOICE_ID, ORG_ID) is the business-key candidate, coinciding with the primary key definition.

Common Use Cases and Queries

Typical scenarios include reconciling interest invoices to their batches, reporting interest billed per customer and operating unit, and validating currency conversion on interest postings.

SELECT ii.interest_invoice_id,
       ii.customer_id,
       ii.currency_code,
       ii.exchange_rate,
       ib.batch_number
  FROM ar.jg_zz_interest_invoices_all ii,
       ar.jg_zz_interest_batches_all ib
 WHERE ii.interest_batch_id = ib.interest_batch_id
   AND ii.org_id = ib.org_id
   AND ii.org_id = :p_org_id;

Reporting interest by collector and customer profile is a common receivables-localization requirement. Line-level detail is joined via JG_ZZ_INT_INV_LINES_ALL on INTEREST_INVOICE_ID and ORG_ID.

Related Objects

  • JG_ZZ_INTEREST_BATCHES_ALL – Parent batch table; joined on INTEREST_BATCH_ID and ORG_ID.
  • JG_ZZ_INT_INV_LINES_ALL – Child line table referencing this table via INTEREST_INVOICE_ID and ORG_ID.
  • AR_COLLECTORS – Referenced by COLLECTOR_ID.
  • RA_CUSTOMERS / HZ_CUST_ACCOUNTS – Implicit references via CUSTOMER_ID.
  • AR_CASH_RECEIPTS_ALL and AR invoice interfaces – downstream consumers during invoice creation and settlement.

Together these objects form the JG interest-invoicing model, with this table acting as the header anchor for batch-level interest calculations, customer references, and monetary attributes.