Search Results ar_cons_bill_cycle_dates




Overview
Explore in AI Chat

Overview

The AR_CONS_BILL_CYCLE_DATES table is a core data repository within the Oracle E-Business Suite Receivables (AR) module, specifically for versions 12.1.1 and 12.2.2. It serves a fundamental role in the management of consolidated billing cycles. As defined in the ETRM documentation, this table stores the specific billing dates associated with a given billing cycle. Its primary function is to define the schedule of billable dates that govern when consolidated invoices are generated for customers assigned to a recurring billing cycle, enabling systematic and automated billing operations.

Key Information Stored

The table's structure is defined by its primary key constraint, AR_CONS_BILL_CYCLE_DATES_PK, which uniquely identifies each record. The key columns are BILLING_CYCLE_ID and BILLABLE_DATE. The BILLING_CYCLE_ID column stores a foreign key reference to the master billing cycle definition, linking a set of dates to a specific cycle. The BILLABLE_DATE column stores the actual calendar date on which billing activity is scheduled to occur for that cycle. Together, these columns create a one-to-many relationship where a single billing cycle contains multiple predefined billable dates, forming the complete schedule for the cycle.

Common Use Cases and Queries

This table is central to processes that generate recurring invoices. A common use case is the "Consolidated Billing" program, which queries this table to determine which customers are due for invoicing on the current system date or a specified run date. For reporting and analysis, administrators often query this table to audit or forecast billing schedules. A typical query pattern involves joining to the master billing cycle table to retrieve cycle details for a specific date range.

  • Retrieve all billable dates for a specific cycle: SELECT billable_date FROM ar_cons_bill_cycle_dates WHERE billing_cycle_id = :cycle_id ORDER BY billable_date;
  • Find cycles with a billable date in the upcoming week: SELECT DISTINCT billing_cycle_id FROM ar_cons_bill_cycle_dates WHERE billable_date BETWEEN SYSDATE AND SYSDATE+7;

Related Objects

The table's primary relationship, as documented by its primary key, is established through the BILLING_CYCLE_ID column. This column is a foreign key referencing the primary key of the master billing cycle definition table, which is typically AR_CONS_BILLING_CYCLES. This relationship ensures that every date record is associated with a valid, predefined billing cycle. The table is directly referenced by the consolidated billing engine and any custom programs or reports that need to determine the schedule for invoice generation. It is a child table in the consolidated billing data model.