Results for “adjustment_generation”

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

Overview

APPS.JL_AR_RECEIVABLE_APPLICATIONS is a Brazilian localization (JL) package body in Oracle E-Business Suite that manages the application, unapplication, and reversal of receipts against receivables transactions. It extends the standard Oracle Receivables functionality to support Brazil-specific requirements such as collection documents (JL_BR_AR_COLLECTION_DOCS), interest treatment, and tolerance-based matching logic. The package name and header ($Header: jlbrrrab.pls) confirm it belongs to the globalizations layer typically delivered for Brazilian legal entities operating in EBS 12.1.1 and 12.2.2. The package has an API classification of OTHER, indicating it is not part of a formally published public API but is nonetheless referenced by two other packages and by Oracle Receivables forms and concurrent programs within the Brazilian localization.

Key Procedures and Functions

The package exposes sixteen documented procedures and functions grouped by purpose:

• ADJUSTMENT_GENERATION — A private procedure that creates an AR adjustment (AR_ADJUSTMENTS) after validating the amount against the user's approval limits stored in AR_APPROVAL_USER_LIMITS. It also derives the transaction date from RA_CUSTOMER_TRX and validates the GL date.
• GET_ACCOUNTS / GET_PS_PARAMETERS — Helper routines that retrieve account and payment schedule parameters required during receipt application processing.
• CALC_GREATERTHAN_REC / CALC_GREATERTHAN_REC_TOL / CALC_LESSTHAN_REC / CALC_EQUAL_REC — Calculation routines that evaluate how a receipt amount compares with the receivable balance, including a tolerance-aware variant, to determine the correct application strategy.
• INTEREST_TREATMENT — Applies Brazilian interest handling logic, supported by the CREATE_INTEREST_ADJUSTMENT and DELETE_INTEREST_ADJUSTMENT procedures for generating or removing interest-related adjustments.
• APPLY_BR / UNAPPLY_BR / REVERSE_BR — The Brazil-specific implementations of receipt application, unapplication, and reversal against AR_RECEIVABLE_APPLICATIONS. REVERSE_BR is the routine most commonly sought by users searching for "reverse_br," since it handles the localized reversal of an applied receipt.
• APPLY / UNAPPLY / REVERSE — Wrapper procedures that invoke the corresponding _BR routines, providing a consistent entry point for callers.

Tables Accessed

The package reads and writes several Receivables and Brazil-specific tables via APPS synonyms:

• AR_RECEIVABLE_APPLICATIONS / AR_RECEIVABLE_APPLICATIONS_ALL — Core tables recording how cash is applied to transactions; directly affected by APPLY_BR, UNAPPLY_BR, and REVERSE_BR.
• AR_ADJUSTMENTS / AR_ADJUSTMENTS_ALL — Written by ADJUSTMENT_GENERATION and the interest adjustment procedures.
• AR_CASH_RECEIPTS_ALL / AR_INTERIM_CASH_RCPT_LINES_ALL / AR_RECEIPT_METHODS — Source data for receipt and receipt-method validation.
• AR_PAYMENT_SCHEDULES — Provides installment balances used by the CALC_* routines.
• AR_APPROVAL_USER_LIMITS / AR_SYSTEM_PARAMETERS — Govern approval and set-of-books defaults.
• HZ_CUST_ACCT_SITES / HZ_CUST_SITE_USES / HZ_LOCATIONS / HZ_PARTY_SITES — TCA customer and site information used in Brazil-specific validations.
• JL_BR_AR_COLLECTION_DOCS — The Brazil localization table holding collection document details tied to receipts.

Usage Notes

JL_AR_RECEIVABLE_APPLICATIONS is invoked primarily from the Oracle Receivables Receipts and Applications forms and from the Brazilian localization concurrent programs that process collection documents. Because it is referenced by two other packages, custom extensions in a Brazil localization may call its APPLY, UNAPPLY, and REVERSE entry points (or their _BR counterparts such as REVERSE_BR) directly. The package should not be modified; any customization should wrap the documented procedures in a separate custom package. When debugging reversal behavior (for example, a search for "reverse_br"), confirm that the receipt resides in a Brazilian operating unit and that the relevant JL_BR_AR_COLLECTION_DOCS record exists, because REVERSE_BR depends on both conditions to complete successfully.