Search Results ap_card_gl_accts_all




Overview
Explore in AI Chat

Overview

The AP_CARD_GL_ACCTS_ALL table is a core data structure within Oracle E-Business Suite Payables (AP) that defines the General Ledger (GL) account mapping for corporate credit card transactions. It serves as the detailed repository for the specific GL accounts assigned to a credit card GL account set. These account sets are critical for the automated accounting of credit card expenses, ensuring that transactions are posted to the correct liability, expense, and clearing accounts. The table's role is to provide the necessary link between Payables' credit card functionality and the General Ledger, enabling accurate and auditable financial postings for corporate card programs.

Key Information Stored

The table stores the GL account combinations and descriptive information for each segment of a credit card account set. While the full column list is extensive, key columns typically include CARD_GL_SET_ID, which links to the parent set definition in AP_CARD_GL_SETS_ALL. The table will contain separate records for different account types, such as the liability account (for the outstanding card balance), the expense account (for the default charge account), and potentially clearing or interim accounts. Each record will hold the specific CODE_COMBINATION_ID for the assigned GL account and descriptive text fields for the account's purpose within the set. The ALL suffix indicates the table is multi-organization enabled, containing data for all operating units.

Common Use Cases and Queries

The primary use case is the configuration and maintenance of credit card accounting rules during the setup of a corporate card program. It is also heavily referenced during the invoice creation and validation process for credit card transactions. Common reporting and query scenarios involve verifying account set assignments and troubleshooting posting errors. A sample query to list account sets with their mapped GL accounts might be:

  • SELECT acgsa.card_gl_set_name, acgaa.account_description, gcc.segment1, gcc.segment2
  • FROM ap_card_gl_accts_all acgaa,
  • ap_card_gl_sets_all acgsa,
  • gl_code_combinations gcc
  • WHERE acgaa.card_gl_set_id = acgsa.card_gl_set_id
  • AND acgaa.code_combination_id = gcc.code_combination_id
  • AND acgsa.org_id = :p_org_id;

Related Objects

As indicated by the provided metadata, the most direct relationship is a foreign key dependency on the AP_CARD_GL_SETS_ALL table via the CARD_GL_SET_ID column. This parent table defines the header-level account set. This table is also intrinsically linked to GL_CODE_COMBINATIONS, which holds the actual account segment values. Key Payables APIs and processes that create credit card invoices will reference the mappings stored in this table to derive the correct accounting. While not listed in the excerpt, related transactional tables like AP_INVOICES_ALL and AP_PAYMENT_SCHEDULES_ALL may indirectly rely on the accounts defined here through the invoice accounting workflow.