Search Results card_gl_set_id

Overview

The AP_CARD_GL_SETS_ALL table is a core data structure within the Oracle E-Business Suite Payables (AP) module, specifically for the management of corporate credit card programs. It functions as a master repository for defining General Ledger (GL) account sets used in corporate card expense processing. Its primary role is to provide a reusable framework for mapping credit card transaction types—such as travel, meals, or supplies—to the appropriate accounting flexfields (code combinations) within the organization's chart of accounts. This setup is essential for ensuring that expenses incurred via corporate credit cards are automatically posted to the correct GL accounts during the invoice creation and accounting processes, thereby enforcing financial controls and streamlining reconciliation.

Key Information Stored

The table stores descriptive and control information for each unique GL account set definition. While the specific column list is not fully detailed in the provided metadata, the structure and foreign key relationships indicate its core components. The primary key is the CARD_GL_SET_ID, a unique system-generated identifier for each account set. Other critical columns typically include the NAME and DESCRIPTION of the set for user identification. Crucially, the table operates with a multi-org architecture, as denoted by the "_ALL" suffix, meaning it likely contains an ORG_ID column to partition data by operating unit, allowing for different account set definitions across different business units within a single installation.

Common Use Cases and Queries

The primary use case is the configuration and assignment of default accounting rules to corporate credit card programs. An administrator creates a GL account set in this table and then populates the related AP_CARD_GL_ACCTS_ALL table with the specific account mappings for various expense categories. This set is then assigned to one or more credit card profiles (AP_CARD_PROFILES_ALL). Common queries involve auditing these setups. For instance, to list all defined account sets with their associated card profiles, a query might join these tables:

• SELECT cgs.name set_name, cgs.description, ccp.card_program_name FROM ap_card_gl_sets_all cgs, ap_card_profiles_all ccp WHERE cgs.card_gl_set_id = ccp.card_gl_set_id AND cgs.org_id = :p_org_id;

Another critical reporting use case is validating the completeness of account assignments by joining to AP_CARD_GL_ACCTS_ALL to ensure all required expense categories have a defined default account.

Related Objects

As indicated by the foreign key metadata, AP_CARD_GL_SETS_ALL is a central reference point for two key transactional tables. First, the AP_CARD_GL_ACCTS_ALL table holds the detailed account mappings (specific code combinations) for each expense category within a given set; it references this table via CARD_GL_SET_ID. Second, the AP_CARD_PROFILES_ALL table, which defines parameters for a corporate card program, references this table to assign a default GL account set to a profile. Therefore, any changes to a set's definition in AP_CARD_GL_SETS_ALL can propagate to all associated card profiles and their transaction accounting. This object is also integral to the Payables API and user interfaces used for configuring corporate card setups.