Search Results trial balances




The AP_TB_BALANCES_TMP table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a temporary table primarily used within the Accounts Payable (AP) module to store trial balance data during the execution of key financial processes. This table plays a critical role in facilitating the generation of trial balance reports, reconciliation activities, and period-end closing procedures. Below is a detailed breakdown of its purpose, structure, and functional relevance in Oracle EBS.

Purpose and Functional Context

The AP_TB_BALANCES_TMP table acts as a staging area for trial balance data before it is finalized or exported to reports. It is commonly utilized by the following processes:
  1. Trial Balance Reporting: Stores summarized accounting entries (debits and credits) for suppliers, invoices, and payment transactions during report generation.
  2. Period Close: Temporarily holds balances for validation before posting to the General Ledger (GL).
  3. Reconciliation: Facilitates comparison between AP subledger and GL balances.

Table Structure

While the exact columns may vary slightly between EBS versions, the table typically includes the following key fields:
  • SET_OF_BOOKS_ID: Links to the GL ledger for multi-ledger environments.
  • PERIOD_NAME: Identifies the accounting period for the balances.
  • ACCOUNTED_CR/DR: Stores cumulative credit/debit amounts.
  • CODE_COMBINATION_ID: References the GL account combination.
  • CREATED_BY/LAST_UPDATE_DATE: Audit columns tracking record creation/modification.

Integration with Other Modules

The table interacts with core EBS components:
  • General Ledger (GL): Balances are validated against GL data before permanent posting.
  • Subledger Accounting (SLA): Receives accounted entries from SLA rules.
  • AP_INVOICES/AP_PAYMENTS: Sources transactional data for balance calculations.

Technical Considerations

  1. Performance: Indexes on SET_OF_BOOKS_ID and PERIOD_NAME optimize large data operations.
  2. Purging: Records are typically transient; Oracle recommends scheduled cleanup to avoid storage bloat.
  3. Custom Extensions: Customers may add columns for localized reporting needs, though Oracle discourages direct modifications.

Version-Specific Notes

  • EBS 12.1.1: Requires manual intervention for temporary data cleanup in some edge cases.
  • EBS 12.2.2: Enhanced integration with Online Patching (ADOP) reduces downtime during maintenance.

Best Practices

  1. Monitor table growth during period closes to prevent space issues.
  2. Leverage Oracle's standard APIs (e.g., AP_ACCOUNTING_PKG) for data access rather than direct SQL.
  3. Include this table in backup strategies for disaster recovery scenarios.
In summary, AP_TB_BALANCES_TMP serves as a critical intermediary in Oracle EBS' financial architecture, ensuring data integrity during AP-GL reconciliation and reporting cycles. Its design reflects Oracle's modular approach, balancing temporary storage needs with system performance requirements.

  • Table: AP_TB_BALANCES_TMP 12.1.1

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_TB_BALANCES_TMP,  object_name:AP_TB_BALANCES_TMP,  status:VALID,  product: AP - Payables ,  description: AP_TB_BALANCES_TMP stores balance amounts for each liability account within a ledger as of the balance date. This table is used during trial balance upgrade to populate the account balances based on XLA_UPGRADE_DATES.start_date ,  implementation_dba_data: AP.AP_TB_BALANCES_TMP , 

  • Table: AP_TB_BALANCES_TMP 12.2.2

    owner:AP,  object_type:TABLE,  fnd_design_data:SQLAP.AP_TB_BALANCES_TMP,  object_name:AP_TB_BALANCES_TMP,  status:VALID,  product: AP - Payables ,  description: AP_TB_BALANCES_TMP stores balance amounts for each liability account within a ledger as of the balance date. This table is used during trial balance upgrade to populate the account balances based on XLA_UPGRADE_DATES.start_date ,  implementation_dba_data: AP.AP_TB_BALANCES_TMP , 

  • Concurrent Program: APXTRBAL 12.1.1

    execution_filename: APXTRBAL ,  product: AP - Payables ,  user_name: APXTRBAL ,  description: Payables Trial Balance ,  argument_method: Standard ,  enabled: No ,  execution_method: Oracle Reports , 

  • Concurrent Program: APXRTB 12.2.2

    execution_filename: APXRTB ,  product: AP - Payables ,  user_name: APXRTB ,  description: Accounts Payable Trial Balance ,  argument_method: Database fetch ,  enabled: No ,  execution_method: Spawned , 

  • Concurrent Program: APXRTB 12.1.1

    execution_filename: APXRTB ,  product: AP - Payables ,  user_name: APXRTB ,  description: Accounts Payable Trial Balance ,  argument_method: Database fetch ,  enabled: No ,  execution_method: Spawned , 

  • Concurrent Program: APXTBRTB 12.2.2

    execution_filename: APXTBRTB ,  product: AP - Payables ,  user_name: APXTBRTB ,  description: Accounts Payable Trial Balance (obsolete - replaced by APXRTB) ,  argument_method: Standard ,  enabled: No ,  execution_method: FlexRpt , 

  • Concurrent Program: APXTRBAL 12.2.2

    execution_filename: APXTRBAL ,  product: AP - Payables ,  user_name: APXTRBAL ,  description: Payables Trial Balance ,  argument_method: Standard ,  enabled: No ,  execution_method: Oracle Reports , 

  • Concurrent Program: APXTBRTB 12.1.1

    execution_filename: APXTBRTB ,  product: AP - Payables ,  user_name: APXTBRTB ,  description: Accounts Payable Trial Balance (obsolete - replaced by APXRTB) ,  argument_method: Standard ,  enabled: No ,  execution_method: FlexRpt , 

  • Concurrent Program: APTBRPT 12.2.2

    product: AP - Payables ,  user_name: Accounts Payable Trial Balance ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: APTBRPT 12.1.1

    product: AP - Payables ,  user_name: Accounts Payable Trial Balance ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Lookup Type: SUBTOTAL OPTION 12.1.1

    product: AP - Payables ,  meaning: Subtotal Option ,  description: Choose ordering by vendor or currency in Trial Balance report , 

  • Lookup Type: SUBTOTAL OPTION 12.2.2

    product: AP - Payables ,  meaning: Subtotal Option ,  description: Choose ordering by vendor or currency in Trial Balance report , 

  • Concurrent Program: APOBRR 12.2.2

    product: AP - Payables ,  user_name: AP Open Balances Revaluation Report ,  description: AP Open Balances Revaluation Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: APOBRR 12.1.1

    product: AP - Payables ,  user_name: AP Open Balances Revaluation Report ,  description: AP Open Balances Revaluation Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program ,