Search Results ra_customer_trx_lines_s




Overview
Explore in AI Chat

Overview

The APPS.JL_BR_AR_GENERATE_DEBIT_MEMO package body is a Brazilian localization (JL_BR) component in Oracle E-Business Suite Receivables. Its business purpose is to generate interest debit memos against overdue customer transactions, a statutory requirement under Brazilian tax and financial regulations for documenting late-payment interest charges. The package operates as an internal ETRM-classified "OTHER" API and is validated in both 12.1.1 and 12.2.2 environments. It reads open receivable balances from payment schedules, computes interest amounts, and constructs the complete debit memo transaction stack — batch, transaction header, transaction line, sales credit, accounting distributions, and payment schedule — before forwarding the accounting event to Subledger Accounting (SLA). It is not referenced by any other database object, indicating it is an entry-point routine rather than a shared utility.

Key Procedures and Functions

Tables Accessed

Insert operations target RA_BATCHES, RA_CUSTOMER_TRX / RA_CUSTOMER_TRX_ALL, RA_CUSTOMER_TRX_LINES / RA_CUSTOMER_TRX_LINES_S (the table underlying the ra_customer_trx_lines_s search), RA_CUST_TRX_LINE_GL_DIST, RA_CUST_TRX_LINE_SALESREPS / RA_CUST_TRX_LINE_SALESREPS_S, and AR_PAYMENT_SCHEDULES / AR_PAYMENT_SCHEDULES_S. Reference data is drawn from AR_SYSTEM_PARAMETERS, GL_SETS_OF_BOOKS, FND_CURRENCIES_VL, FND_ID_FLEX_STRUCTURES, GL_PERIOD_STATUSES, HZ_CUST_SITE_USES, RA_CUST_TRX_TYPES, RA_SALESREPS, RA_ACCOUNT_DEFAULTS, and RA_ACCOUNT_DEFAULT_SEGMENTS. The RA_CUSTOMER_TRX_LINES_S insert maintains the line-level unique key demanded by multi-organization architecture.

Usage Notes

This package is typically invoked from Brazilian localization concurrent programs or Receivables autointerest workflows rather than from standard EBS forms. Custom code callers must supply a valid batch source, transaction type, and GL date; the package then performs validation internally via VALIDATE_AND_DEFAULT_GL_DATE. Because the package directly writes base Receivables tables and fires SLA events, it should be called only with committed control over period status and accounting setups. In 12.2.x, the SLA integration through ARP_XLA_EVENTS remains the authoritative posting path, so the debit memo amount is always reflected through the subledger journal rather than the legacy GL interface.