Search Results transaction account

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:

Trial Balance Reporting: Stores summarized accounting entries (debits and credits) for suppliers, invoices, and payment transactions during report generation.
Period Close: Temporarily holds balances for validation before posting to the General Ledger (GL).
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

Performance: Indexes on SET_OF_BOOKS_ID and PERIOD_NAME optimize large data operations.
Purging: Records are typically transient; Oracle recommends scheduled cleanup to avoid storage bloat.
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

Monitor table growth during period closes to prevent space issues.
Leverage Oracle's standard APIs (e.g., AP_ACCOUNTING_PKG) for data access rather than direct SQL.
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.

Lookup Type: ACCOUNT TYPE 12.1.1
product: AP - Payables , meaning: Account Type , description: Bank Account Record Types ,
Lookup Type: ACCOUNT TYPE 12.2.2
product: AP - Payables , meaning: Account Type , description: Bank Account Record Types ,
Lookup Type: TRANSACTION ACTION 12.1.1
product: AP - Payables , meaning: Transaction Action , description: Used by check recon to determine how to handle flat-file records ,
Lookup Type: TRANSACTION ACTION 12.2.2
product: AP - Payables , meaning: Transaction Action , description: Used by check recon to determine how to handle flat-file records ,
Lookup Type: BANK ACCOUNT OPTIONS 12.1.1
product: AP - Payables , meaning: Bank Account Options , description: Navigation Option in Set Up Banks Form ,
Lookup Type: BANK ACCOUNT OPTIONS 12.2.2
product: AP - Payables , meaning: Bank Account Options , description: Navigation Option in Set Up Banks Form ,
Lookup Type: INV DIST ACCOUNT TYPES 12.2.2
product: AP - Payables , meaning: Inv Dist Account Types , description: Lists the 3 different account types on dists ,
Lookup Type: EDI TRANSACTION HANDLING 12.1.1
product: AP - Payables , meaning: Edi Transaction Handling , description: EDI transaction code ,
Lookup Type: EDI TRANSACTION HANDLING 12.2.2
product: AP - Payables , meaning: Edi Transaction Handling , description: EDI transaction code ,
Lookup Type: INV DIST ACCOUNT TYPES 12.1.1
product: AP - Payables , meaning: Inv Dist Account Types , description: Lists the 3 different account types on dists ,
Lookup Type: CARD EXCEPTION 12.1.1
product: AP - Payables , meaning: Card Exception , description: Procurement card transaction validation exception ,
Lookup Type: CARD EXCEPTION 12.2.2
product: AP - Payables , meaning: Card Exception , description: Procurement card transaction validation exception ,
Lookup Type: POSTED_PAYMENT_RPT_SORT 12.1.1
product: AP - Payables , meaning: Posted Payment Rpt Sort , description: Sort by option for posted payment report ,
Lookup Type: POSTED_PAYMENT_RPT_SORT 12.2.2
product: AP - Payables , meaning: Posted Payment Rpt Sort , description: Sort by option for posted payment report ,
Lookup Type: POSTING EXCEPTIONS 12.2.2
product: AP - Payables , meaning: Posting Exceptions , description: Posting exceptions for the invoices ,
Lookup Type: POSTING EXCEPTIONS 12.1.1
product: AP - Payables , meaning: Posting Exceptions , description: Posting exceptions for the invoices ,
Lookup Type: BANK_LISTING_ORDERS 12.1.1
product: AP - Payables , meaning: Bank Listing Orders , description: Select method of sorting in bank listing ,
Lookup Type: BANK_LISTING_ORDERS 12.2.2
product: AP - Payables , meaning: Bank Listing Orders , description: Select method of sorting in bank listing ,
Lookup Type: HOLD CODE 12.1.1
product: AP - Payables , meaning: Hold Code , description: The hold codes are also stored as lookups for NLS translations ,
Lookup Type: FUTURE PAY ACCT SOURCE 12.1.1
product: AP - Payables , meaning: Future Pay Acct Source , description: Source for future dated payment account ,
Lookup Type: FUTURE PAY ACCT SOURCE 12.2.2
product: AP - Payables , meaning: Future Pay Acct Source , description: Source for future dated payment account ,
Lookup Type: HOLD CODE 12.2.2
product: AP - Payables , meaning: Hold Code , description: The hold codes are also stored as lookups for NLS translations ,
Lookup Type: OIE_ALLOCATION_VIEWS 12.1.1
product: AP - Payables , meaning: Allocation Views ,
Lookup Type: OIE_ALLOCATION_VIEWS 12.2.2
product: AP - Payables , meaning: Allocation Views ,
Concurrent Program: APXBABAL 12.1.1
execution_filename: APXBABAL , product: AP - Payables , user_name: APXBABAL , description: Bank Account Listing , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: APXAAREP 12.2.2
execution_filename: APXAAREP , product: AP - Payables , user_name: APAAREP , description: Payables Account Analysis Report , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
Concurrent Program: APXBABAL 12.2.2
execution_filename: APXBABAL , product: AP - Payables , user_name: APXBABAL , description: Bank Account Listing , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: APXAAREP 12.1.1
execution_filename: APXAAREP , product: AP - Payables , user_name: APAAREP , description: Payables Account Analysis Report , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
Concurrent Program: APEFCSUM 12.2.2
execution_filename: APEFCSUM , product: AP - Payables , user_name: APEFCSUM , description: MRC Payables-GL Account Summary , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
Concurrent Program: APEFCSUM 12.1.1
execution_filename: APEFCSUM , product: AP - Payables , user_name: APEFCSUM , description: MRC Payables-GL Account Summary , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
Lookup Type: DISCOUNT_DIST_OPTIONS 12.2.2
product: AP - Payables , meaning: Discount Dist Options , description: Method used for distribution discount amounts for payments ,
Lookup Type: DISCOUNT_DIST_OPTIONS 12.1.1
product: AP - Payables , meaning: Discount Dist Options , description: Method used for distribution discount amounts for payments ,
Concurrent Program: APXBABAL_XML 12.2.2
product: AP - Payables , user_name: Bank Account Listing (XML) - Not Supported: Reserved For Future Use , description: Bank Account Listing , argument_method: Standard , enabled: No , execution_method: Java Concurrent Program ,
Concurrent Program: APXBABAL_XML 12.1.1
product: AP - Payables , user_name: Bank Account Listing (XML) - Not Supported: Reserved For Future Use , description: Bank Account Listing , argument_method: Standard , enabled: No , execution_method: Java Concurrent Program ,
Lookup Type: LIABILITY FLEXBUILD METHOD 12.1.1
product: AP - Payables , meaning: Liability Flexbuild Method , description: Liability Flexbuild Method ,
Lookup Type: LIABILITY FLEXBUILD METHOD 12.2.2
product: AP - Payables , meaning: Liability Flexbuild Method , description: Liability Flexbuild Method ,
Lookup Type: PCARD TRX STATUS 12.2.2
product: AP - Payables , meaning: Pcard Trx Status , description: Verification and approval status for transaction distributions ,
Lookup Type: OIE_ENABLE_PROJECT_ALLOCATIONS 12.2.2
product: AP - Payables , meaning: OIE:Enable Project Allocations , description: Contains the values for the OIE:Enable Project Allocations profile option. ,
Lookup Type: PAY_DIST_TYPES 12.1.1
product: AP - Payables , meaning: Pay Dist Types , description: Line types of the ap_payment_distributions table ,
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 ,
Lookup Type: OIE_ENABLE_PROJECT_ALLOCATIONS 12.1.1
product: AP - Payables , meaning: OIE:Enable Project Allocations , description: Contains the values for the OIE:Enable Project Allocations profile option. ,
Lookup Type: PAY_DIST_TYPES 12.2.2
product: AP - Payables , meaning: Pay Dist Types , description: Line types of the ap_payment_distributions table ,
Lookup Type: PCARD TRX STATUS 12.1.1
product: AP - Payables , meaning: Pcard Trx Status , description: Verification and approval status for transaction distributions ,
Lookup Type: AP_CARDPROGRAM_PROMPT 12.1.1
product: AP - Payables , meaning: Lookup code to achieve Card Program form dynamic prompt , description: Lookup code to achieve Card Program form dynamic prompt ,
Lookup Type: AWT ERROR 12.1.1
product: AP - Payables , meaning: Awt Error , description: Automatic Withholding Tax Errors ,
Lookup Type: AWT ERROR 12.2.2
product: AP - Payables , meaning: Awt Error , description: Automatic Withholding Tax Errors ,
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 ,
Lookup Type: AP_CARDPROGRAM_PROMPT 12.2.2
product: AP - Payables , meaning: Lookup code to achieve Card Program form dynamic prompt , description: Lookup code to achieve Card Program form dynamic prompt ,
Lookup Type: INVOICE IMPORT REJECTION 12.1.1
product: AP - Payables , meaning: Invoice Import Rejection , description: Reason for the rejection of an imported invoice ,
Lookup Type: ACCOUNTING ERROR TYPE 12.1.1
product: AP - Payables , meaning: Accounting Error Type , description: Types of Accounting Errors ,