Results for “jg_zz_ar_tmp_account”

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

Overview

The JG_ZZ_AR_TMP_ACCOUNT table is a Regional Localizations (product code JG) object owned by the AR schema in Oracle E-Business Suite. As documented in the ETRM repository for release 12.2.2, it contains information about each contra account associated with Receivables tax processing. The table acts as a temporary or staging structure used by the localization logic to record the contra accounting entries that offset primary tax lines before they are posted to the General Ledger. Each row represents a single contra account line, linked back to the originating memo line in Receivables, and carries the full accounting flexfield, entered and accounted debit/credit amounts, and the posting status flag that controls transfer to GL. With 26 documented columns, the table is compact and highly focused on the accounting side of the localization tax flow.

From a Data Vault modeling perspective, the FK structure was mined heuristically and classified as standalone. No parent-child hubs or links were detected from the foreign key graph. This suggests the table be treated as a satellite-like detail object, or alternatively as a standalone transactional staging table, rather than as a hub or link. Analysts should not assume dimension-style relationships beyond the single FK to AR_MEMO_LINES_ALL_B.

Key Information Stored

• REQUEST_ID — identifies the concurrent program run that populated the row; useful for isolating a single localization batch.
• MEMO_LINE_ID — foreign key to AR_MEMO_LINES_ALL_B; the only documented FK and the primary link back to the source memo line.
• VAT_TAX_ID — tax identifier associated with the contra entry.
• CONTRA_HEADER_ID — groups contra lines under their parent header.
• CODE_COMBINATION_ID — the accounting flexfield combination used for the contra account.
• LINE_NUMBER / LINK_LINE_NUM — line sequencing and linkage to the corresponding original line.
• LINE_TYPE — classifies the nature of the contra line.
• ACCT_FLEX_FIELD / ACCT_FLEX_DESC — the flexfield segment value and its description.
• ACCOUNT / ACCOUNT_DESC — the natural account value and description.
• ENTERED_DR / ENTERED_CR — entered debit and credit amounts in the transaction currency.
• ACCTD_DR / ACCTD_CR — accounted debit and credit amounts in the functional currency.
• BALANCE / BALANCE_DESC — contra balance amount and its description.
• POSTED_TO_GL_FLAG — indicates whether the row has been transferred to General Ledger.
• TAX_NAME / DESCRIPTION — reporting attributes for the tax and line.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

The documented metadata does not expose a surrogate primary key or a unique business-key index for this table; MEMO_LINE_ID combined with LINE_NUMBER and LINE_TYPE is the logical business-key candidate for de-duplication and reconciliation.

Common Use Cases and Queries

Typical use cases include reconciling localization tax contra entries, verifying that all contra lines posted to GL, and auditing batches by request. A representative query retrieves unposted contra lines for a given request:

• SELECT memo_line_id, line_number, account, entered_dr, entered_cred FROM jg_zz_ar_tmp_account WHERE posted_to_gl_flag = 'N' AND request_id = :p_request_id;
• Join to AR_MEMO_LINES_ALL_B on MEMO_LINE_ID to trace each contra entry back to its source memo line.
• Aggregate ACCTD_DR and ACCTD_CR by CONTRA_HEADER_ID to validate that debits equal credits before GL transfer.
• Report by TAX_NAME to analyze tax distribution across localization runs.

Related Objects

• AR_MEMO_LINES_ALL_B — joined via MEMO_LINE_ID; the documented parent reference for the contra line.
• AR_MEMO_LINES_ALL_TL — translated descriptions for the source memo lines.
• GL_CODE_COMBINATIONS — resolves CODE_COMBINATION_ID to flexfield segment values.
• AR_CASH_RECEIPTS_ALL and AR_TRANSACTIONS_ALL — upstream Receivables objects supplying the originating transactions.
• GL_JE_LINES / GL_JE_HEADERS — destination of posted journal entries after POSTED_TO_GL_FLAG is set.
• FND_CONCURRENT_REQUESTS — resolves REQUEST_ID to the program that generated the rows.

Because the localization contra logic is delivered as part of the JG product, the table is typically consumed through the concurrent programs that populate it rather than through direct online maintenance in the Receivables forms.