Search Results arp_dates




Overview
Explore in AI Chat

Overview

ARP_DATES is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It is classified as an OTHER API within the Receivables (AR) module and exists to resolve General Ledger accounting period and transaction date logic for revenue recognition and rule-based transaction processing. Specifically, the package determines which GL periods are valid for a given accounting rule and derives the correct GL dates for transaction lines based on those rules. Because Receivables must align customer transaction accounting dates with open or valid GL periods in the ledger, ARP_DATES acts as the bridge between transaction scheduling (RA_RULES / RA_RULE_SCHEDULES) and the General Ledger period calendar (GL_PERIODS, GL_PERIOD_TYPES, GL_SETS_OF_BOOKS). The package body carries a status of VALID and is registered as a standalone object; the ETRM metadata records that it is not referenced by any other database object but is itself referenced by two other packages, indicating it is consumed as a utility layer rather than invoked directly from the user interface.

Key Procedures and Functions

The documented API surface contains two program units:

  • VAL_GL_PERIODS_FOR_RULES — Validates the GL periods associated with a set of accounting rules. It confirms that the periods implied by the rule schedules (typically the number of periods and the period type) correspond to real, valid periods in the ledger's period calendar before downstream processing proceeds.
  • DERIVE_GL_TRX_DATES_FROM_RULES — Derives the GL transaction dates for transaction lines by applying the accounting rule definition and its associated rule schedules. This routine computes the date sequence that Receivables uses to distribute revenue or accounting entries across periods.

Both units are designed for invocation from within the Receivables processing chain; the exact parameter signatures are defined in the package specification and are not reproduced here.

Tables Accessed

The package references a mix of transaction, rule, and GL calendar tables:

  • RA_RULES and RA_RULE_SCHEDULES — the accounting rule header and its period schedule, which define the period count and sequencing used to derive dates.
  • RA_CUSTOMER_TRX, RA_CUSTOMER_TRX_LINES, and RA_CUST_TRX_LINE_GL_DIST — source transaction, line, and distribution records whose GL dates are evaluated or populated.
  • GL_PERIODS, GL_PERIOD_TYPES, and GL_SETS_OF_BOOKS — the General Ledger period calendar and ledger definition used to validate periods.
  • AR_SYSTEM_PARAMETERS — Receivables system-level settings that influence period and date behavior.
  • AR_TRX_HEADER_GT — a global temporary table used to stage transaction header data during processing.
  • DBMS_SQL and the STANDARD package are used for dynamic SQL and standard PL/SQL support.

Usage Notes

ARP_DATES is a private utility package rather than a published integration API. It is not exposed through concurrent program parameters or form fields directly; instead it is called by other Receivables packages (the metadata shows two dependent packages) during transaction entry, revenue scheduling, and accounting date derivation. Typically it is invoked implicitly when a transaction is saved or completed and Receivables must determine valid GL dates, or when AutoAccounting or revenue recognition processes evaluate rule schedules. Custom code should avoid calling ARP_DATES directly; Oracle does not document or guarantee its signature across releases. Instead, customizations should use supported Receivables APIs (such as AR_RECEIVABLE_APPLICATIONS_API or the standard transaction APIs) that internally rely on this package. Because it depends on GL_PERIODS and GL_PERIOD_TYPES, any issues with an open or closed GL period calendar will surface as errors originating from this utility.