Search Results assign_finance_charge

Overview

FV_DC_ASSIGN_FINANCE_CHRG is a public PL/SQL package owned by the APPS schema within the Oracle E-Business Suite Receivables family, specifically belonging to the FlexValue/Receivables (FV) finance-charge subsystem used in releases 12.1.1 and 12.2.2. Its status is VALID, and its API classification in Enterprise Transaction and Reference Model (ETRM) documentation is listed as OTHER, indicating that it is not a fully published public API but an internal utility package invoked by standard Receivables processing.

The package implements the core business logic required to evaluate delinquent customer balances, determine whether a finance charge (late-payment interest) is applicable, and then either assign the calculated charge to a customer account or accrue it for subsequent invoicing. In practice, this supports automated finance-charge generation for open debit items identified through AR_PAYMENT_SCHEDULES, working in conjunction with the FV finance-charge control, group, and history tables that define charge rates, grace periods, and customer eligibility.

Key Procedures and Functions

The documented package exposes two procedures:

• ASSIGN_FINANCE_CHARGE — Assigns a calculated finance charge against an eligible customer balance. This procedure drives the evaluation of overdue transactions and applies the assessed charge to the appropriate customer and invoice records, populating the finance-charge invoice and line structures used for downstream billing.
• ACCRUE_FINANCE_CHARGE — Accrues finance-charge amounts for posting. Accrual logic records the charge amounts so that they can be recognized in the general ledger and picked up by the Finance Charge Invoice generation process, maintaining an audit trail through the finance-charge history tables.

The ETRM metadata does not publish parameter lists, and the documented dependency footprint is limited to SYS.STANDARD, so callers must treat these as internal entry points rather than supported public APIs.

Tables Accessed

The package reads and writes a defined set of Receivables and FlexValue tables via APPS synonyms:

• AR_PAYMENT_SCHEDULES — source of open debit items and due dates used to identify delinquent balances eligible for a charge.
• FV_AR_CONTROLS, FV_FINANCE_CHARGE_CONTROLS — system-level control settings governing whether finance charges are enabled and how they are calculated.
• FV_FINANCE_CHARGE_GRP_HDRS, FV_FINANCE_CHARGE_GRP_DTLS — finance-charge group definitions and their detail rate/term lines.
• FV_FINANCE_CHRG_CUST_CLASSES, FV_CUST_FINANCE_CHRGS, FV_CUST_FINANCE_CHRGS_ALL — customer and customer-class level finance-charge assignments and eligibility.
• FV_INVOICE_FINANCE_CHRGS, FV_INVOICE_FINANCE_CHRGS_ALL, FV_AR_FIN_CHRG_INVOICES, FV_AR_FIN_CHRG_INV_LINES — finance-charge invoice and line records generated or updated by the assignment and accrual routines.
• FV_FINANCE_CHARGE_HISTORY — historical audit of charge activity.
• AR_TRX_ERRORS_GT — temporary error capture for transactions rejected during processing.
• FV_RA_CUSTOMER_TRX_S — sequence source for transaction identifiers.

Usage Notes

FV_DC_ASSIGN_FINANCE_CHRG is referenced only by itself according to ETRM, and references zero other packages, confirming it is a leaf-level implementation package. It is typically invoked from the Receivables Finance Charge concurrent program flow (for example, the Late Charges and Finance Charges batch processes) and from related internal FV packages rather than directly from Oracle Forms or custom extensions. Developers researching a specific finance department or city-level charge configuration should treat this as the engine that consumes the FV control and group setup tables; the metadata contains no parameters, so direct invocation from custom code is not supported and any call should go through the standard concurrent program interface available in 12.1.1 and 12.2.2.