Results for “ap_card_gl_sets_all”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AP_CARD_GL_SETS_ALL is a Payables-owned table in the Oracle E-Business Suite AP schema that stores descriptive information about credit card GL account sets. These account sets define the collections of General Ledger accounts used when corporate credit card transactions are accounted for and transferred to the General Ledger. The table plays a supporting configuration role within the Payables credit card subsystem, tying together credit card profiles and the individual GL accounts that comprise an accounting set.

Under the heuristic Data Vault classification derived from the foreign key structure, this object is hub-leaning. In Data Vault modeling terms, it behaves like a hub: it holds a stable, uniquely identified business concept (the credit card GL account set) whose surrogate key is referenced by surrounding entities. The _ALL suffix indicates that the table participates in the multi-org (Operating Unit) security model, with data segmented by ORG_ID.

Key Information Stored

The table contains 25 documented columns. The most significant are summarized below.

• CARD_GL_SET_ID — The surrogate primary key, enforced by AP_CARD_GL_SETS_PK and also covered by the unique index AP_CARD_GL_SETS_U1. It uniquely identifies each credit card GL account set and serves as the join key to dependent tables.
• GL_SET_NAME — The user-defined name of the GL account set, functioning as the principal business-key candidate by which users identify the configuration. Together with CARD_GL_SET_ID, it distinguishes one set from another.
• DESCRIPTION — Free-form descriptive text clarifying the purpose or scope of the account set.
• ORG_ID — The Operating Unit identifier that partitions the rows and enforces multi-org access security.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard audit columns capturing who last modified a row and when.
• CREATION_DATE, CREATED_BY — Standard audit columns recording row creation.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — The Oracle Applications descriptive flexfield (DFF) columns, enabling customers to extend the table with site-specific attributes without modifying the underlying schema.

Common Use Cases and Queries

Typical usage centers on configuration validation, reconciliation, and reporting. Common scenarios include verifying which GL account sets are defined per Operating Unit, reconciling credit card profiles against their account sets, and extracting named sets for downstream accounting reports.

A representative query lists the defined sets with audit context:

• SELECT card_gl_set_id, gl_set_name, description, org_id, creation_date, last_update_date FROM ap_card_gl_sets_all ORDER BY gl_set_name;

A join-oriented pattern resolves the accounts belonging to a named set:

• SELECT s.gl_set_name, a.* FROM ap_card_gl_sets_all s JOIN ap_card_gl_accts_all a ON a.card_gl_set_id = s.card_gl_set_id WHERE s.org_id = :p_org_id;

A third pattern identifies profiles referencing a given set:

• SELECT p.* FROM ap_card_profiles_all p JOIN ap_card_gl_sets_all s ON p.card_gl_set_id = s.card_gl_set_id WHERE s.gl_set_name = :p_name;

Related Objects

The following depend on or reference AP_CARD_GL_SETS_ALL through the documented foreign keys.

• AP_CARD_GL_ACCTS_ALL — References AP_CARD_GL_SETS_ALL.CARD_GL_SET_ID via AP_CARD_GL_ACCTS_ALL.CARD_GL_SET_ID; stores the individual GL accounts that constitute each set.
• AP_CARD_PROFILES_ALL — References AP_CARD_GL_SETS_ALL.CARD_GL_SET_ID via AP_CARD_PROFILES_ALL.CARD_GL_SET_ID; associates credit card profiles with an accounting set.

These relationships confirm the table's hub role: the account set is the central entity, while accounts and profiles are the dependent satellites that reference it by surrogate key. Administrators should treat deletions cautiously given these active foreign key dependencies.