Search Results vendors

The FV.FV_CCR_VENDORS table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a critical data structure within the Financials module, specifically associated with the Credit Card Reconciliation (CCR) process. This table stores vendor-related information that is essential for reconciling credit card transactions with corresponding vendor records in the Accounts Payable (AP) system. Below is a detailed breakdown of its purpose, structure, and functional significance.

Purpose and Context

The FV.FV_CCR_VENDORS table serves as a repository for vendor data that is either manually entered or automatically imported during the credit card reconciliation process. It acts as a staging area or reference table to map credit card transaction vendors to Oracle EBS vendor records. This mapping ensures that expenses from corporate credit cards are accurately assigned to the correct suppliers in the AP module, facilitating seamless reconciliation and audit compliance.

Key Columns and Structure

The table typically includes the following key columns:

VENDOR_ID: A unique identifier linking to the AP_SUPPLIERS table, ensuring referential integrity.
VENDOR_NAME: The name of the vendor as it appears on credit card statements.
CCR_VENDOR_ID: A surrogate key for the vendor record within the CCR process.
CREATION_DATE and LAST_UPDATE_DATE: Timestamps for tracking record lifecycle.
STATUS: Indicates whether the vendor mapping is active, pending, or invalid.
ATTRIBUTE_CATEGORY and ATTRIBUTE1-15: Flexfields for custom data capture.

Integration with Other Modules

The table integrates with:

AP_SUPPLIERS: For validating and mapping vendor records.
FV_CCR_TRANSACTIONS: To associate transactions with reconciled vendors.
GL_JE_LINES: For posting reconciled expenses to the General Ledger.

Functional Workflow

Data Import: Credit card transactions are imported into FV_CCR_TRANSACTIONS, with vendor names extracted from statement descriptions.
Vendor Matching The system queries FV_CCR_VENDORS to find existing mappings or prompts users to create new ones.
Reconciliation: Matched transactions are posted to AP and GL, with vendor IDs ensuring accurate accounting.

Customization and Extensions

Organizations often extend the table's functionality by:

Adding custom columns via flexfields to capture industry-specific vendor attributes.
Implementing triggers or APIs to automate vendor creation in AP_SUPPLIERS.
Leveraging the table for analytics by joining it with FV_CCR_STATEMENTS.

Audit and Compliance

The table supports audit trails through:

Timestamps tracking record changes.
Status flags ensuring only validated vendors are processed.
Integration with Oracle Audit Vault for compliance reporting.

Performance Considerations

For optimal performance:

Indexes should be created on VENDOR_ID and VENDOR_NAME.
Regular purging of inactive records may be necessary.
Partitioning is recommended for high-volume implementations.

Conclusion

The FV.FV_CCR_VENDORS table is a pivotal component in Oracle EBS's credit card reconciliation framework, bridging the gap between credit card transactions and accounts payable. Its design ensures data integrity, streamlines reconciliation workflows, and supports customization for diverse business needs. Proper configuration and maintenance of this table are essential for efficient financial operations and compliance.

APPS.OKL_VP_CR_WF dependencies on PO_VENDORS 12.2.2
APPS.PO_RFQS_SV dependencies on PO_VENDOR_LIST_ENTRIES_V 12.1.1
APPS.AHL_DI_SUBSCRIPTION_PUB dependencies on PO_VENDORS 12.2.2
APPS.PO_RFQS_SV dependencies on PO_VENDOR_LIST_ENTRIES 12.2.2
APPS.AHL_DI_DOC_INDEX_PUB dependencies on PO_VENDORS 12.2.2
APPS.PO_RFQS_SV dependencies on PO_VENDOR_LIST_ENTRIES_V 12.2.2
APPS.OKL_VP_CR_WF dependencies on PO_VENDORS 12.1.1
Concurrent Program: POXVDVOH 12.2.2
execution_filename: POXVDVOH , product: PO - Purchasing , user_name: POXVDVOH , description: Vendors on Hold Report , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
APPS.AHL_DI_SUBSCRIPTION_PUB dependencies on PO_VENDORS 12.1.1
APPS.AHL_DI_DOC_INDEX_PUB dependencies on PO_VENDORS 12.1.1
APPS.PO_RFQS_SV dependencies on PO_VENDOR_LIST_ENTRIES 12.1.1
Concurrent Program: POXVDVOH 12.1.1
execution_filename: POXVDVOH , product: PO - Purchasing , user_name: POXVDVOH , description: Vendors on Hold Report , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
APPS.OKL_VP_OA_WF dependencies on PO_VENDORS 12.2.2
Concurrent Program: POXVDVOH_XML 12.1.1
product: PO - Purchasing , user_name: Vendors on Hold Report (XML) , description: Vendors on Hold Report , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Concurrent Program: POXVDVOH_XML 12.2.2
product: PO - Purchasing , user_name: Vendors on Hold Report (XML) , description: Vendors on Hold Report , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Lookup Type: PO SOURCE DOCUMENT TYPE 12.1.1
product: PO - Purchasing , meaning: PO Source Document Types from Vendors , description: PO Source Document Types from Vendors ,
Lookup Type: ALL OR ACTIVE 12.1.1
product: AP - Payables , meaning: All Or Active , description: Vendors Report vendors, sites, contacts selection option ,
APPS.OKL_VP_OA_WF dependencies on PO_VENDORS 12.1.1
Lookup Type: SOURCE DOCUMENT TYPE 12.1.1
product: PO - Purchasing , meaning: Source Document Types from Vendors , description: Source Document Types from Vendors ,
APPS.OKL_VP_PA_WF dependencies on PO_VENDORS 12.2.2
Lookup Type: CHANGE_CURRENCY 12.2.2
product: GML - Process Manufacturing Logistics , meaning: Using vendor default currency. , description: Using vendor default currency. ,
APPS.PO_HEADERS_SV1 dependencies on PO_RFQ_VENDORS_PKG_S2 12.1.1
APPS.PO_INTERFACE_S dependencies on PO_VENDOR_LIST_ENTRIES_V 12.2.2
APPS.OKL_VP_CR_WF dependencies on OKC_SUBCLASSES_V 12.1.1
APPS.PO_INTERFACE_S dependencies on PO_VENDOR_LIST_ENTRIES_V 12.1.1
TABLE: FV.FV_CCR_VENDORS 12.2.2
owner:FV, object_type:TABLE, fnd_design_data:FV.FV_CCR_VENDORS, object_name:FV_CCR_VENDORS, status:VALID,
Lookup Type: CHANGE_CURRENCY 12.1.1
product: GML - Process Manufacturing Logistics , meaning: Using vendor default currency. , description: Using vendor default currency. ,
Lookup Type: RFQ HEADER INFO 12.1.1
product: PO - Purchasing , meaning: Additional information options for headers in Enter RFQs form , description: Additional information options for headers in Enter RFQs form ,
Lookup Type: RFQ HEADER INFO 12.2.2
product: PO - Purchasing , meaning: Additional information options for headers in Enter RFQs form , description: Additional information options for headers in Enter RFQs form ,
TABLE: FV.FV_CCR_VENDORS 12.1.1
owner:FV, object_type:TABLE, fnd_design_data:FV.FV_CCR_VENDORS, object_name:FV_CCR_VENDORS, status:VALID,
Concurrent Program: FVCCRXML 12.2.2
execution_filename: CcrRecordRequest , product: FV - Federal Financials , user_name: FVCCRXML , description: Program to query CCR vendors against the CCR database , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
APPS.OKL_VP_PA_WF dependencies on PO_VENDORS 12.1.1
Lookup Type: VENDOR_INQUIRY_OPTIONS 12.1.1
product: PO - Purchasing , meaning: Additional information options for vendors in the vendor inquiry form , description: Additional information options for vendors in the vendor inquiry form ,
Lookup Type: VENDOR_INQUIRY_OPTIONS 12.2.2
product: PO - Purchasing , meaning: Additional information options for vendors in the vendor inquiry form , description: Additional information options for vendors in the vendor inquiry form ,
APPS.OKL_VP_CR_WF dependencies on OKC_K_HEADERS_V 12.1.1
APPS.PO_HEADERS_SV1 dependencies on PO_RFQ_VENDORS_PKG_S2 12.2.2
Lookup Type: PO SOURCE DOCUMENT TYPE 12.2.2
product: PO - Purchasing , meaning: PO Source Document Types from Vendors , description: PO Source Document Types from Vendors ,
APPS.OKL_VP_CR_WF dependencies on OKC_K_PARTY_ROLES_B 12.2.2
Lookup Type: ALL OR ACTIVE 12.2.2
product: AP - Payables , meaning: All Or Active , description: Vendors Report vendors, sites, contacts selection option ,
Lookup Type: SOURCE DOCUMENT TYPE 12.2.2
product: PO - Purchasing , meaning: Source Document Types from Vendors , description: Source Document Types from Vendors ,
Concurrent Program: FVCCRXML 12.1.1
execution_filename: CcrRecordRequest , product: FV - Federal Financials , user_name: FVCCRXML , description: Program to query CCR vendors against the CCR database , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
APPS.PO_INTERFACE_S dependencies on PO_RFQ_VENDORS 12.2.2
APPS.AHL_DI_SUBSCRIPTION_PUB dependencies on PO_HEADERS_V 12.1.1
APPS.POS_SUP_PROF_PRG_GRP dependencies on AP_SUPPLIERS 12.1.1
APPS.AHL_DI_SUBSCRIPTION_PUB dependencies on PO_HEADERS_V 12.2.2
APPS.OKL_VP_CR_WF dependencies on OKC_SUBCLASSES_V 12.2.2
APPS.OKL_VP_CR_WF dependencies on OKC_K_HEADERS_V 12.2.2
APPS.OKL_VP_CR_WF dependencies on OKC_K_PARTY_ROLES_B 12.1.1
APPS.INV_CONSUMPTION_ADVICE_PROC dependencies on PO_VENDORS 12.2.2
Lookup Type: PO_CLM_CCR_EXP_REASON 12.2.2
product: PO - Purchasing , meaning: CCR Exception Reason ,