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:
- INTEREST_INVOICE_ID – Surrogate primary key component uniquely identifying each interest invoice.
- ORG_ID – Operating unit identifier; second component of the composite primary key and the multi-org discriminator.
- INTEREST_BATCH_ID – Foreign key to
JG_ZZ_INTEREST_BATCHES_ALL; links the invoice to the generating batch. - CUSTOMER_ID – The Receivables customer to whom the interest invoice is issued.
- CUSTOMER_SITE_USE_ID – The specific customer site/usage receiving the invoice.
- CUSTOMER_PROFILE_ID – Reference to the customer profile governing interest rules.
- CURRENCY_CODE – Transaction currency of the interest invoice.
- EXCHANGE_RATE_TYPE and EXCHANGE_RATE – Rate type and value used for currency conversion between the batch currency and the invoice currency.
- COLLECTOR_ID – Foreign key to
AR_COLLECTORS, identifying the assigned collector. - Audit columns –
CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGINcapture WHO columns for auditing and concurrency.
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_IDandORG_ID. - JG_ZZ_INT_INV_LINES_ALL – Child line table referencing this table via
INTEREST_INVOICE_IDandORG_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.
-
Invoice header information for interest invoices
-
Invoice header information for interest invoices
-
Detail invoice lines for interest invoices
-
Detail invoice lines for interest invoices
-
- Retrofitted
Not implemented in this database·Explore JG module →
-
- Retrofitted
Not implemented in this database·Explore JG module →
-
- Retrofitted
Not implemented in this database·Explore JG module →
-
- Retrofitted
Not implemented in this database·Explore JG module →
-
Not implemented in this database·Explore JG module →
-
Not implemented in this database·Explore JG module →
-
Not implemented in this database·Explore JG module →
-
Not implemented in this database·Explore JG module →
-
eTRM - JG Tables and Views 12.2.2
Additional country-specific information for vendor sites
-
eTRM - JG Tables and Views 12.1.1
Additional country-specific information for vendor sites
-
eTRM - JG Tables and Views 12.2.2
Additional country-specific information for vendor sites
-
eTRM - JG Tables and Views 12.1.1
Additional country-specific information for vendor sites