Search Results jl_ar_receivable_applications

Overview

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

Overview

The APPS.JL_AR_RECEIVABLE_APPLICATIONS package is a Brazil Localization (JL) component within Oracle E-Business Suite, classified under the ETRM as an API of type OTHER with a VALID status in the APPS schema. Its central business function is to process and manage the application, unapplication, reversal, and interest treatment of receipts against transactions in Oracle Receivables, while enforcing Brazilian localization rules. The package bridges standard Oracle Receivables application logic with localization-specific requirements such as interest adjustments, tolerance handling, and the collection documentation maintained in JL_BR_AR_COLLECTION_DOCS. It is documented in both Oracle EBS 12.1.1 and 12.2.2 environments and is exposed through sixteen documented procedures and functions that support the complete receipt-adjustment lifecycle for Brazilian operations.

Key Procedures and Functions

The package exposes the following documented entry points:

ADJUSTMENT_GENERATION – Generates adjustments associated with receivable applications.
GET_ACCOUNTS – Retrieves the accounting information relevant to an application.
GET_PS_PARAMETERS – Obtains parameter values from the payment schedule or related setup.
CALC_GREATERTHAN_REC – Calculates amounts where the applied value exceeds the receipt value.
CALC_GREATERTHAN_REC_TOL – Performs the greater-than receipt calculation while applying a tolerance.
CALC_LESSTHAN_REC – Calculates amounts where the applied value is less than the receipt value.
CALC_EQUAL_REC – Handles the case where receipt and application amounts are equal.
INTEREST_TREATMENT – Applies localization-specific interest rules to a receipt or application.
APPLY_BR, UNAPPLY_BR, REVERSE_BR – Brazil-specific variants of the apply, unapply, and reverse operations.
APPLY, UNAPPLY, REVERSE – Generic entry points for the core receipt application, unapplication, and reversal logic.
CREATE_INTEREST_ADJUSTMENT and DELETE_INTEREST_ADJUSTMENT – Create and remove interest adjustments tied to an application.

Tables Accessed

The package reads and writes across the core Receivables and Trading Community tables, referenced through APPS synonyms:

AR_RECEIVABLE_APPLICATIONS and AR_RECEIVABLE_APPLICATIONS_ALL – the primary tables holding receipt-to-transaction applications.
AR_ADJUSTMENTS and AR_ADJUSTMENTS_ALL – stores the adjustments created by ADJUSTMENT_GENERATION and interest-processing procedures.
AR_CASH_RECEIPTS_ALL and AR_INTERIM_CASH_RCPT_LINES_ALL – the receipt and interim receipt records being applied or reversed.
AR_PAYMENT_SCHEDULES – provides installment and payment schedule details during application.
AR_APPROVAL_USER_LIMITS – used for approval-related validation on adjustments.
AR_RECEIPT_METHODS and AR_SYSTEM_PARAMETERS – supply receipt method and system configuration values.
HZ_CUST_ACCT_SITES, HZ_CUST_SITE_USES, HZ_LOCATIONS, and HZ_PARTY_SITES – customer, site, and location data used for validation.
JL_BR_AR_COLLECTION_DOCS – the Brazilian collection document table, central to localization processing.

Usage Notes

In typical Oracle EBS deployments this package is invoked indirectly by Oracle Receivables forms, by the standard AutoLockbox and receipt application workflows, and by concurrent programs that process receipts and adjustments. It is also referenced by two additional packages, JG_AR_CASH_RECEIPTS and JG_AR_RECEIVABLE_APPLICATIONS, and by its own package body. Custom code and localization extensions that need to apply, unapply, or reverse a receipt under Brazilian rules, or that generate interest adjustments, should call the _BR procedures (APPLY_BR, UNAPPLY_BR, REVERSE_BR) rather than the generic variants to ensure localization logic and tolerance handling are honored. Because the package depends on SYS.STANDARD, it is a standard PL/SQL unit that should be invoked within the APPS schema context. Direct modifications to the underlying AR_ and JL_BR_AR_COLLECTION_DOCS tables bypass the validation, tolerance, and interest calculations embedded in this package and are therefore discouraged.

PACKAGE: APPS.JL_AR_RECEIVABLE_APPLICATIONS 12.1.1
owner:APPS, object_type:PACKAGE, object_name:JL_AR_RECEIVABLE_APPLICATIONS, status:VALID,
PACKAGE: APPS.JL_AR_RECEIVABLE_APPLICATIONS 12.2.2
owner:APPS, object_type:PACKAGE, object_name:JL_AR_RECEIVABLE_APPLICATIONS, status:VALID,
PACKAGE BODY: APPS.JL_AR_RECEIVABLE_APPLICATIONS 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:JL_AR_RECEIVABLE_APPLICATIONS, status:VALID,
PACKAGE BODY: APPS.JL_AR_RECEIVABLE_APPLICATIONS 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JL_AR_RECEIVABLE_APPLICATIONS, status:VALID,
PACKAGE: APPS.JL_BR_AR_GENERATE_DEBIT_MEMO 12.1.1
owner:APPS, object_type:PACKAGE, object_name:JL_BR_AR_GENERATE_DEBIT_MEMO, status:VALID,
PACKAGE: APPS.JL_ZZ_SYS_OPTIONS_PKG 12.1.1
owner:APPS, object_type:PACKAGE, object_name:JL_ZZ_SYS_OPTIONS_PKG, status:VALID,
SYNONYM: APPS.JL_BR_AR_REC_MET_ACCTS_EXT 12.2.2
owner:APPS, object_type:SYNONYM, object_name:JL_BR_AR_REC_MET_ACCTS_EXT, status:VALID,
PACKAGE: APPS.JL_ZZ_AR_LIBRARY_1_PKG 12.1.1
owner:APPS, object_type:PACKAGE, object_name:JL_ZZ_AR_LIBRARY_1_PKG, status:VALID,
SYNONYM: APPS.AR_APPROVAL_USER_LIMITS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:AR_APPROVAL_USER_LIMITS, status:VALID,
PACKAGE: APPS.JG_ZZ_GLOBAL_FLEX_VALD_PKG 12.2.2
owner:APPS, object_type:PACKAGE, object_name:JG_ZZ_GLOBAL_FLEX_VALD_PKG, status:VALID,
SYNONYM: APPS.AR_INTERIM_CASH_RCPT_LINES_ALL 12.1.1
owner:APPS, object_type:SYNONYM, object_name:AR_INTERIM_CASH_RCPT_LINES_ALL, status:VALID,
PACKAGE: APPS.JL_BR_AR_GENERATE_DEBIT_MEMO 12.2.2
owner:APPS, object_type:PACKAGE, object_name:JL_BR_AR_GENERATE_DEBIT_MEMO, status:VALID,
SYNONYM: APPS.AR_INTERIM_CASH_RCPT_LINES_ALL 12.2.2
owner:APPS, object_type:SYNONYM, object_name:AR_INTERIM_CASH_RCPT_LINES_ALL, status:VALID,
SYNONYM: APPS.JL_BR_AR_REC_MET_ACCTS_EXT 12.1.1
owner:APPS, object_type:SYNONYM, object_name:JL_BR_AR_REC_MET_ACCTS_EXT, status:VALID,
PACKAGE: APPS.JL_BR_WORKDAY_CALENDAR 12.2.2
owner:APPS, object_type:PACKAGE, object_name:JL_BR_WORKDAY_CALENDAR, status:VALID,
PACKAGE: APPS.JG_ZZ_GLOBAL_FLEX_VALD_PKG 12.1.1
owner:APPS, object_type:PACKAGE, object_name:JG_ZZ_GLOBAL_FLEX_VALD_PKG, status:VALID,
PACKAGE: APPS.JL_ZZ_AR_LIBRARY_1_PKG 12.2.2
owner:APPS, object_type:PACKAGE, object_name:JL_ZZ_AR_LIBRARY_1_PKG, status:VALID,
PACKAGE: APPS.JL_BR_INTEREST_HANDLING 12.2.2
owner:APPS, object_type:PACKAGE, object_name:JL_BR_INTEREST_HANDLING, status:VALID,
PACKAGE: APPS.JL_BR_INTEREST_HANDLING 12.1.1
owner:APPS, object_type:PACKAGE, object_name:JL_BR_INTEREST_HANDLING, status:VALID,
SYNONYM: APPS.AR_APPROVAL_USER_LIMITS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:AR_APPROVAL_USER_LIMITS, status:VALID,
PACKAGE BODY: APPS.JG_AR_RECEIVABLE_APPLICATIONS 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JG_AR_RECEIVABLE_APPLICATIONS, status:VALID,
PACKAGE: APPS.AR_ADJUST_PUB 12.2.2
owner:APPS, object_type:PACKAGE, object_name:AR_ADJUST_PUB, status:VALID,
SYNONYM: APPS.JL_BR_AR_COLLECTION_DOCS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:JL_BR_AR_COLLECTION_DOCS, status:VALID,
PACKAGE: APPS.JL_ZZ_SYS_OPTIONS_PKG 12.2.2
owner:APPS, object_type:PACKAGE, object_name:JL_ZZ_SYS_OPTIONS_PKG, status:VALID,
PACKAGE BODY: APPS.JG_AR_CASH_RECEIPTS 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:JG_AR_CASH_RECEIPTS, status:VALID,
PACKAGE BODY: APPS.JG_AR_RECEIVABLE_APPLICATIONS 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:JG_AR_RECEIVABLE_APPLICATIONS, status:VALID,
PACKAGE: APPS.AR_ADJUST_PUB 12.1.1
owner:APPS, object_type:PACKAGE, object_name:AR_ADJUST_PUB, status:VALID,
PACKAGE BODY: APPS.JG_AR_CASH_RECEIPTS 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JG_AR_CASH_RECEIPTS, status:VALID,
12.1.1 DBA Data 12.1.1
12.1.1 DBA Data 12.1.1
PACKAGE: APPS.ARP_PS_PKG 12.1.1
owner:APPS, object_type:PACKAGE, object_name:ARP_PS_PKG, status:VALID,
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
PACKAGE: APPS.ARP_PS_PKG 12.2.2
owner:APPS, object_type:PACKAGE, object_name:ARP_PS_PKG, status:VALID,
PACKAGE: APPS.JG_ZZ_SHARED_PKG 12.1.1
owner:APPS, object_type:PACKAGE, object_name:JG_ZZ_SHARED_PKG, status:VALID,
SYNONYM: APPS.AR_ADJUSTMENTS_ALL 12.1.1
owner:APPS, object_type:SYNONYM, object_name:AR_ADJUSTMENTS_ALL, status:VALID,
SYNONYM: APPS.AR_ADJUSTMENTS_ALL 12.2.2
owner:APPS, object_type:SYNONYM, object_name:AR_ADJUSTMENTS_ALL, status:VALID,
PACKAGE: APPS.JG_ZZ_SHARED_PKG 12.2.2
owner:APPS, object_type:PACKAGE, object_name:JG_ZZ_SHARED_PKG, status:VALID,
PACKAGE: APPS.JL_AR_RECEIVABLE_APPLICATIONS 12.2.2
PACKAGE: APPS.JL_AR_RECEIVABLE_APPLICATIONS 12.1.1
SYNONYM: APPS.AR_RECEIVABLE_APPLICATIONS_ALL 12.1.1
owner:APPS, object_type:SYNONYM, object_name:AR_RECEIVABLE_APPLICATIONS_ALL, status:VALID,
SYNONYM: APPS.AR_CASH_RECEIPTS_ALL 12.2.2
owner:APPS, object_type:SYNONYM, object_name:AR_CASH_RECEIPTS_ALL, status:VALID,
SYNONYM: APPS.AR_CASH_RECEIPTS_ALL 12.1.1
owner:APPS, object_type:SYNONYM, object_name:AR_CASH_RECEIPTS_ALL, status:VALID,
SYNONYM: APPS.AR_RECEIVABLE_APPLICATIONS_ALL 12.2.2
owner:APPS, object_type:SYNONYM, object_name:AR_RECEIVABLE_APPLICATIONS_ALL, status:VALID,
SYNONYM: APPS.AR_RECEIPT_METHODS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:AR_RECEIPT_METHODS, status:VALID,
SYNONYM: APPS.AR_ADJUSTMENTS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:AR_ADJUSTMENTS, status:VALID,
SYNONYM: APPS.AR_ADJUSTMENTS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:AR_ADJUSTMENTS, status:VALID,
SYNONYM: APPS.AR_RECEIVABLE_APPLICATIONS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:AR_RECEIVABLE_APPLICATIONS, status:VALID,
SYNONYM: APPS.AR_RECEIVABLE_APPLICATIONS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:AR_RECEIVABLE_APPLICATIONS, status:VALID,
SYNONYM: APPS.HZ_CUST_ACCT_SITES 12.2.2
owner:APPS, object_type:SYNONYM, object_name:HZ_CUST_ACCT_SITES, status:VALID,