Search Results AR_MEMO_LINES_ALL_B




Overview
Explore in AI Chat

Overview

The AR_MEMO_LINES_ALL_B table is a core data repository within the Oracle E-Business Suite (EBS) Receivables (AR) module. It functions as the master definition table for standard memo lines, which are reusable templates that define the accounting and descriptive attributes for specific types of non-invoice transactions. These transactions primarily include debit memos, on-account credits, debit memo reversals, and chargebacks. The table's role is to centralize the configuration of these line types, ensuring consistency in revenue recognition, accounting, and reporting across all such transactions entered into the system. The '_ALL' and '_B' suffixes indicate it is a multi-organization access enabled (MOAC) table that stores base transactional data, forming a critical link between transaction entry and the general ledger.

Key Information Stored

The table stores the defining attributes for each standard memo line. While the full column list is extensive, the primary and foreign keys from the metadata highlight its most critical relationships. The MEMO_LINE_ID column serves as the unique primary key identifier. Key descriptive columns typically include NAME and DESCRIPTION. Crucially, the table links to accounting rules through ACCOUNTING_RULE_ID and to invoicing rules via INVOICING_RULE_ID, both referencing the RA_RULES table, which governs revenue scheduling. The SET_OF_BOOKS_ID foreign key (referencing GL_SETS_OF_BOOKS_11I) ties the memo line definition to a specific ledger, ensuring proper accounting context. Other significant columns often include REVENUE_ACCOUNT, TAX_CODE, and TYPE to classify the nature of the memo line (e.g., 'DEB' for debit memo).

Common Use Cases and Queries

A primary use case is the creation and maintenance of standard memo lines via the Oracle Receivables application path (Setup > Transactions > Memo Lines). These definitions are then selected during transaction entry. For reporting and analysis, common queries involve joining this table to transaction lines to analyze volumes and values by memo line type. A typical diagnostic query to list active memo lines and their linked accounting rules would be:

  • SELECT ml.memo_line_id, ml.name, ml.description, ml.type, r.name accounting_rule_name
  • FROM ar_memo_lines_all_b ml, ra_rules r
  • WHERE ml.accounting_rule_id = r.rule_id(+)
  • AND ml.set_of_books_id = :ledger_id;

Data fixes or audits may require queries to identify all transaction lines (RA_CUSTOMER_TRX_LINES_ALL) that used a specific memo line template, linking via the MEMO_LINE_ID foreign key relationship documented in the metadata.

Related Objects

As indicated by the foreign key constraints, AR_MEMO_LINES_ALL_B has integral relationships with several key EBS objects. It is a parent table to RA_CUSTOMER_TRX_LINES_ALL, where the MEMO_LINE_ID foreign key resides, meaning transaction lines reference definitions stored here. It is a child table to GL_SETS_OF_BOOKS_11I (via SET_OF_BOOKS_ID) and to RA_RULES twice (via ACCOUNTING_RULE_ID and INVOICING_RULE_ID). For application development, the standard API ARP_ML_MAINTAIN is typically used for creating and updating memo lines programmatically. The related view AR_MEMO_LINES provides a filtered, often more accessible, perspective on this base table data.