Search Results unit of measure

The AP_PAYCARD_TRX_FEE_HEADER_ALL table in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 is a critical data structure within the Accounts Payable (AP) module, specifically designed to manage transaction fee headers associated with payment card transactions. This table serves as a repository for high-level information about fees incurred during payment card processing, enabling organizations to track, analyze, and reconcile these costs systematically. Below is a detailed breakdown of its purpose, structure, and functional relevance.

Purpose and Functional Context

The AP_PAYCARD_TRX_FEE_HEADER_ALL table stores metadata related to transaction fees assessed by payment card networks (e.g., Visa, Mastercard) or financial institutions. These fees may include interchange fees, assessment fees, or processing charges tied to corporate card payments. The table acts as a header record, linking to detailed fee line items stored in related tables like AP_PAYCARD_TRX_FEE_LINES_ALL. It supports Oracle's Payables Payment Card functionality, which automates the reconciliation of card transactions and associated fees.

Key Columns and Data Structure

The table includes columns to capture essential attributes of fee headers, such as:

TRX_FEE_HEADER_ID: Primary key uniquely identifying each fee header record.
PAYCARD_TRX_ID: Foreign key linking to the parent payment card transaction in AP_PAYCARD_TRX_ALL.
FEE_TYPE_CODE: Categorizes the fee (e.g., "INTERCHANGE," "ASSESSMENT").
CURRENCY_CODE: The currency in which the fee is denominated.
FEE_AMOUNT: The total fee amount for the header.
STATUS: Indicates the processing status (e.g., "PENDING," "PROCESSED").
CREATION_DATE and LAST_UPDATE_DATE: Audit columns tracking record lifecycle.
ORG_ID: Multi-org identifier for partitioning data by operating unit.

Integration with Oracle EBS Modules

The table integrates with:

Accounts Payable: Fee data is used during invoice creation and reconciliation, ensuring accurate expense reporting.
General Ledger (GL): Fees may be posted to GL accounts for financial reporting.
Subledger Accounting (SLA): Rules in SLA may reference fee headers for accounting entries.

Technical Considerations

Multi-Org Support: The _ALL suffix denotes multi-org visibility, with ORG_ID enabling secure access control.
Indexing: Indexes on TRX_FEE_HEADER_ID and PAYCARD_TRX_ID optimize joins with related tables.
API Dependencies: The table is typically populated via Oracle's Payment Card APIs or auto-reconciliation workflows.

Business Process Flow

A payment card transaction is imported into AP_PAYCARD_TRX_ALL.
Associated fees are recorded in AP_PAYCARD_TRX_FEE_HEADER_ALL, with line details in child tables.
During reconciliation, fees are matched to invoices or expensed directly.
Accounting entries are generated based on fee types and GL mappings.

Customization and Extensions

Organizations may extend the table's utility by:

Adding descriptive flexfields (DFFs) to capture industry-specific fee attributes.
Developing custom reports using the table to analyze card program costs.
Integrating with third-party card processors via APIs.

Conclusion

The AP_PAYCARD_TRX_FEE_HEADER_ALL table is a foundational component of Oracle EBS's payment card management framework. By centralizing fee header data, it ensures transparency in card-related expenses and streamlines financial operations. Its design reflects Oracle's emphasis on auditability, multi-org scalability, and integration with core financial processes, making it indispensable for organizations leveraging corporate card programs.

Lookup Type: TIME UNIT 12.1.1
product: AP - Payables , meaning: Time Unit , description: Time unit used for credit card profile limit ,
Lookup Type: TIME UNIT 12.2.2
product: AP - Payables , meaning: Time Unit , description: Time unit used for credit card profile limit ,
Lookup Type: OIE_CAT_FIELDS_SEARCH_BY 12.2.2
product: AP - Payables , meaning: Category Options Search By , description: Category Options Search By columns ,
Lookup Type: OIE_CAT_FIELDS_SEARCH_BY 12.1.1
product: AP - Payables , meaning: Category Options Search By , description: Category Options Search By columns ,
Lookup Type: OIE_DISTANCE_UOM 12.1.1
product: AP - Payables , meaning: Distance Unit of Measure , description: Distance Unit of Measure used for policy compliance ,
Lookup Type: OIE_DISTANCE_UOM 12.2.2
product: AP - Payables , meaning: Distance Unit of Measure , description: Distance Unit of Measure used for policy compliance ,
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: INVOICE IMPORT REJECTION 12.2.2
product: AP - Payables , meaning: Invoice Import Rejection , description: Reason for the rejection of an imported invoice ,
Lookup Type: REJECT CODE 12.1.1
product: AP - Payables , meaning: Reject Code , description: Reject Codes for AP Open Interface ,
Lookup Type: REJECT CODE 12.2.2
product: AP - Payables , meaning: Reject Code , description: Reject Codes for AP Open Interface ,
Lookup Type: OIEDETAILMILEAGE 12.1.1
product: AP - Payables , meaning: Mileage Detail , description: Mileage Detail ,
Lookup Type: OIEDETAILMILEAGE 12.2.2
product: AP - Payables , meaning: Mileage Detail , description: Mileage Detail ,
Lookup Type: LINE_FIELD 12.1.1
product: AP - Payables , meaning: Invoice Line Field ,
Lookup Type: OIE_POL_NOTE_LANGUAGE_SEARCH 12.2.2
product: AP - Payables , meaning: Note Language Search By , description: Note Language Search By ,
Lookup Type: OIE_AUD_RS_ASSIGN_SEARCH_BY 12.1.1
product: AP - Payables , meaning: Audit Rule Set Assignment Search By , description: Audit Rule Set Assignment Search By ,
Lookup Type: XML TOKEN NAME 12.1.1
product: AP - Payables , meaning: XML Token Name , description: Stores contextual information for Rejected Invoices in Invoice Interface tables ,
Lookup Type: XML TOKEN NAME 12.2.2
product: AP - Payables , meaning: XML Token Name , description: Stores contextual information for Rejected Invoices in Invoice Interface tables ,
Lookup Type: OIE_POL_NOTE_LANGUAGE_SEARCH 12.1.1
product: AP - Payables , meaning: Note Language Search By , description: Note Language Search By ,
Lookup Type: LINE_FIELD 12.2.2
product: AP - Payables , meaning: Invoice Line Field ,
Lookup Type: OIE_POL_CC_ENFORCE_SEARCH 12.1.1
product: AP - Payables , meaning: Transaction Age Limits Search By , description: Transaction Age Limits Search By ,
Lookup Type: OIE_AUD_RS_ASSIGN_SEARCH_BY 12.2.2
product: AP - Payables , meaning: Audit Rule Set Assignment Search By , description: Audit Rule Set Assignment Search By ,
Lookup Type: OIE_POL_FUTURE_EXPENSE_SEARCH 12.2.2
product: AP - Payables , meaning: Future-Dated Expense Search By , description: Future-Dated Expense Search By ,
Lookup Type: OIE_POL_CC_ENFORCE_SEARCH 12.2.2
product: AP - Payables , meaning: Transaction Age Limits Search By , description: Transaction Age Limits Search By ,
Lookup Type: OIE_POL_CC_USAGE_SEARCH 12.2.2
product: AP - Payables , meaning: Card Usage Search By , description: Card Usage Search By ,
Lookup Type: OIE_POL_FUTURE_EXPENSE_SEARCH 12.1.1
product: AP - Payables , meaning: Future-Dated Expense Search By , description: Future-Dated Expense Search By ,
Lookup Type: OIE_POL_CC_USAGE_SEARCH 12.1.1
product: AP - Payables , meaning: Card Usage Search By , description: Card Usage Search By ,
Lookup Type: OIE_POL_DUPLICATE_SEARCH 12.2.2
product: AP - Payables , meaning: Duplicate Expense Search By , description: Duplicate Expense Search By ,
Lookup Type: OIE_POL_EXCHANGERATE_SEARCH_BY 12.2.2
product: AP - Payables , meaning: Exchange Rate Search By , description: Exchange Rate Search By columns ,
Lookup Type: OIE_POL_DUPLICATE_SEARCH 12.1.1
product: AP - Payables , meaning: Duplicate Expense Search By , description: Duplicate Expense Search By ,
Lookup Type: OIE_POL_EXCHANGERATE_SEARCH_BY 12.1.1
product: AP - Payables , meaning: Exchange Rate Search By , description: Exchange Rate Search By columns ,
Lookup Type: LINE SOURCE 12.1.1
product: AP - Payables , meaning: Line Source , description: Defines possible sources to capture source of creation of a line ,
Lookup Type: LINE SOURCE 12.2.2
product: AP - Payables , meaning: Line Source , description: Defines possible sources to capture source of creation of a line ,
Lookup Type: OIE_AMEX_GLOBAL_PARAMS 12.2.2
product: AP - Payables , meaning: Amex Global Datafile Transfer Parameters , description: Amex Global Datafile Transfer Parameters ,
Table: AP_PAYCARD_TRX_FEE_HEADER_ALL 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_PAYCARD_TRX_FEE_HEADER_ALL, object_name:AP_PAYCARD_TRX_FEE_HEADER_ALL, status:VALID, product: AP - Payables , description: This table holds the Charges information for Payment Card.This table contains Operating Unit, Currency Code, Vendor and Vendor site information corresponding to one or more transaction fee details belonging to non overlapping periods. , implementation_dba_data: AP.AP_PAYCARD_TRX_FEE_HEADER_ALL ,
Lookup Type: OIE_DATA_CAPTURE_ATTRIBUTES 12.2.2
product: AP - Payables , meaning: Additional Attributes Enabled for Expense Types , description: List of additional columns that can be enabled for capture at expense type level ,
Lookup Type: OIE_AUTO_AUDIT_REASONS 12.1.1
product: AP - Payables , meaning: Automatic Audit Reasons , description: Automatic Audit Reasons ,
Lookup Type: OIE_DATA_CAPTURE_ATTRIBUTES 12.1.1
product: AP - Payables , meaning: Additional Attributes Enabled for Expense Types , description: List of additional columns that can be enabled for capture at expense type level ,
Lookup Type: OIE_AUTO_AUDIT_REASONS 12.2.2
product: AP - Payables , meaning: Automatic Audit Reasons , description: Automatic Audit Reasons ,
Lookup Type: OIE_POL_DEFAULT_EXCHANGE_RATES 12.2.2
product: AP - Payables , meaning: Default Exchange Rates , description: Default Exchange Rates ,
Lookup Type: OIE_POL_DEFAULT_EXCHANGE_RATES 12.1.1
product: AP - Payables , meaning: Default Exchange Rates , description: Default Exchange Rates ,
Lookup Type: OIE_POL_VIOLATION_TYPES 12.1.1
product: AP - Payables , meaning: Policy Violation Types , description: Policy Violation Types ,
Lookup Type: RECORD TYPE 12.1.1
product: AP - Payables , meaning: Record Type , description: Used by check recon to determine what table to store flat-file record in ,
Lookup Type: OIE_POL_VIOLATION_TYPES 12.2.2
product: AP - Payables , meaning: Policy Violation Types , description: Policy Violation Types ,
Lookup Type: RECORD TYPE 12.2.2
product: AP - Payables , meaning: Record Type , description: Used by check recon to determine what table to store flat-file record in ,
Lookup Type: FUNDS CONTROL METHOD 12.1.1
product: AP - Payables , meaning: Method of funds control , description: Method of funds control ,
Lookup Type: FUNDS CONTROL METHOD 12.2.2
product: AP - Payables , meaning: Method of funds control , description: Method of funds control ,
Lookup Type: ERROR CHECK FUNCTION 12.2.2
product: AP - Payables , meaning: Error Check Function , description: Defines method of error-checking for check reconciliation ,
Lookup Type: NEXT STEP EXEC STATE 12.1.1
product: AP - Payables , meaning: Next Step Exec State , description: Values for the next step for a payment batch ,
Lookup Type: NEXT STEP EXEC STATE 12.2.2
product: AP - Payables , meaning: Next Step Exec State , description: Values for the next step for a payment batch ,
Concurrent Program: APXBOAV 12.1.1
execution_filename: apxboav , product: AP - Payables , user_name: APXBOAV , description: Bank of America Visa Transaction Loader , argument_method: Standard , enabled: Yes , execution_method: SQL*Loader ,