Search Results billing_cycle_id




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.

  • Table: AR_CONS_BILL_CYCLE_DATES 12.2.2

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.AR_CONS_BILL_CYCLE_DATES,  object_name:AR_CONS_BILL_CYCLE_DATES,  status:VALID,  product: AR - Receivables ,  description: This table stores billing dates for given billing cycle. ,  implementation_dba_data: AR.AR_CONS_BILL_CYCLE_DATES , 

  • Table: AR_CONS_BILL_CYCLE_DATES 12.1.1

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.AR_CONS_BILL_CYCLE_DATES,  object_name:AR_CONS_BILL_CYCLE_DATES,  status:VALID,  product: AR - Receivables ,  description: This table stores billing dates for given billing cycle. ,  implementation_dba_data: AR.AR_CONS_BILL_CYCLE_DATES , 

  • Table: AR_CONS_BILL_CYCLES_TL 12.2.2

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.AR_CONS_BILL_CYCLES_TL,  object_name:AR_CONS_BILL_CYCLES_TL,  status:VALID,  product: AR - Receivables ,  description: The AR_CONS_BILL_CYCLES_TL table provides multilingual support (MLS) for each billing cycle that you define in Receivables. MLS lets you store and print data that you define in multiple languages. ,  implementation_dba_data: AR.AR_CONS_BILL_CYCLES_TL , 

  • Table: AR_CONS_BILL_CYCLES_B 12.1.1

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.AR_CONS_BILL_CYCLES_B,  object_name:AR_CONS_BILL_CYCLES_B,  status:VALID,  product: AR - Receivables ,  description: The AR_CONS_BILL_CYCLES_B table stores information on defined cycles. Receivables creates one row for each billing cycle that you define. This information iis used to distinguish which activity to include on a bill. ,  implementation_dba_data: AR.AR_CONS_BILL_CYCLES_B , 

  • Table: AR_CONS_BILL_CYCLES_TL 12.1.1

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.AR_CONS_BILL_CYCLES_TL,  object_name:AR_CONS_BILL_CYCLES_TL,  status:VALID,  product: AR - Receivables ,  description: The AR_CONS_BILL_CYCLES_TL table provides multilingual support (MLS) for each billing cycle that you define in Receivables. MLS lets you store and print data that you define in multiple languages. ,  implementation_dba_data: AR.AR_CONS_BILL_CYCLES_TL , 

  • Table: AR_CONS_BILL_CYCLES_B 12.2.2

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.AR_CONS_BILL_CYCLES_B,  object_name:AR_CONS_BILL_CYCLES_B,  status:VALID,  product: AR - Receivables ,  description: The AR_CONS_BILL_CYCLES_B table stores information on defined cycles. Receivables creates one row for each billing cycle that you define. This information iis used to distinguish which activity to include on a bill. ,  implementation_dba_data: AR.AR_CONS_BILL_CYCLES_B , 

  • View: RA_TERMS_VL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:AR.RA_TERMS_VL,  object_name:RA_TERMS_VL,  status:VALID,  product: AR - Receivables ,  description: (Release 11.5 and Release 12.0) ,  implementation_dba_data: APPS.RA_TERMS_VL , 

  • View: AR_CONS_BILL_CYCLES_VL 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:AR.AR_CONS_BILL_CYCLES_VL,  object_name:AR_CONS_BILL_CYCLES_VL,  status:VALID,  product: AR - Receivables ,  implementation_dba_data: APPS.AR_CONS_BILL_CYCLES_VL , 

  • View: RA_TERMS_VL 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:AR.RA_TERMS_VL,  object_name:RA_TERMS_VL,  status:VALID,  product: AR - Receivables ,  description: (Release 11.5 and Release 12.0) ,  implementation_dba_data: APPS.RA_TERMS_VL , 

  • View: AR_CONS_BILL_CYCLES_VL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:AR.AR_CONS_BILL_CYCLES_VL,  object_name:AR_CONS_BILL_CYCLES_VL,  status:VALID,  product: AR - Receivables ,  implementation_dba_data: APPS.AR_CONS_BILL_CYCLES_VL , 

  • View: AR_CONS_INV_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:AR.AR_CONS_INV_V,  object_name:AR_CONS_INV_V,  status:VALID,  product: AR - Receivables ,  implementation_dba_data: APPS.AR_CONS_INV_V , 

  • View: AR_CONS_INV_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:AR.AR_CONS_INV_V,  object_name:AR_CONS_INV_V,  status:VALID,  product: AR - Receivables ,  implementation_dba_data: APPS.AR_CONS_INV_V ,