Search Results accounts payable

The AR_CCID_CORRECTIONS_ALL table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a critical repository for storing code combination identifier (CCID) corrections related to the Accounts Receivable (AR) module. This table plays a pivotal role in maintaining financial data integrity by allowing corrections to invalid or misaligned accounting flexfield combinations before they are posted to the general ledger. Below is a detailed analysis of its structure, purpose, and functional significance in Oracle EBS.

Purpose and Functional Overview

The AR_CCID_CORRECTIONS_ALL table is primarily used in scenarios where accounting flexfield combinations (CCIDs) in AR transactions are found to be invalid or require adjustments. When transactions are imported or processed, Oracle validates the CCID against the GL_CODE_COMBINATIONS table. If discrepancies arise—such as disabled, invalid, or inactive combinations—the system flags these entries, and corrections are stored in AR_CCID_CORRECTIONS_ALL. This ensures that accounting entries align with the chart of accounts before GL posting.

Key Columns and Structure

The table includes columns that capture metadata about the correction process:

CORRECTION_ID: A unique identifier for each correction record.
ORIGINAL_CCID: The original invalid CCID that requires correction.
NEW_CCID: The corrected CCID validated against the chart of accounts.
TRANSACTION_ID: References the AR transaction (e.g., invoice, receipt) needing correction.
STATUS: Indicates whether the correction is pending, processed, or errored.
CREATION_DATE, CREATED_BY: Audit columns tracking when and who initiated the correction.
LAST_UPDATE_DATE, LAST_UPDATED_BY: Timestamps for modifications.
ORG_ID: Supports multi-org structures by segregating data by operating unit.

Integration with Oracle EBS Modules

The table interacts with several EBS components:

Accounts Receivable (AR): Captures corrections for invoices, receipts, and adjustments before GL transfer.
General Ledger (GL): Ensures only valid CCIDs are posted, preventing reconciliation issues.
Subledger Accounting (SLA): Aligns corrected CCIDs with accounting rules for accurate journal generation.

Business Process Flow

The typical workflow involves:

Identification: Invalid CCIDs are flagged during transaction validation or batch processes.
Correction: Users or automated scripts update the NEW_CCID field with a valid combination.
Validation: The system verifies the new CCID against active GL combinations.
Processing: Approved corrections are applied, and transactions are reprocessed for GL posting.

Technical Considerations

Indexing: Columns like CORRECTION_ID and TRANSACTION_ID are indexed for performance.
Purge Policies: Corrected records may be archived to avoid table bloating.
APIs: Oracle provides PL/SQL APIs (e.g., AR_CCID_CORRECTION_PKG) to programmatically handle corrections.

Conclusion

The AR_CCID_CORRECTIONS_ALL table is a safeguard for financial accuracy in Oracle EBS, ensuring accounting flexfield integrity across AR transactions. Its design supports auditability, multi-org compliance, and seamless integration with GL, making it indispensable for organizations leveraging Oracle EBS 12.1.1 or 12.2.2.

Lookup Type: RESPONSIBILITY 12.2.2
product: AR - Receivables , meaning: Responsibility , description: Possible responsibilities for the primary customer contact ,
Lookup Type: DEPARTMENT_TYPE 12.2.2
product: AR - Receivables , meaning: Department Type , description: Department Type ,
Lookup Type: RESPONSIBILITY 12.1.1
product: AR - Receivables , meaning: Responsibility , description: Possible responsibilities for the primary customer contact ,
Lookup Type: DEPARTMENT_TYPE 12.1.1
product: AR - Receivables , meaning: Department Type , description: Department Type ,
Lookup Type: FINANCIAL_NUMBER_NAME 12.2.2
product: AR - Receivables , meaning: Financial Number Name , description: Financial Number Name ,
Lookup Type: FINANCIAL_NUMBER_NAME 12.1.1
product: AR - Receivables , meaning: Financial Number Name , description: Financial Number Name ,
Lookup Type: ADDRESS_LABEL 12.1.1
product: AR - Receivables , meaning: Address Label , description: Messages used in address label ,
Lookup Type: ADDRESS_LABEL 12.2.2
product: AR - Receivables , meaning: Address Label , description: Messages used in address label ,
Lookup Type: CREDIT_SCORE_COMMENTARY 12.1.1
product: AR - Receivables , meaning: Credit Score Commentary , description: Credit Score Commentary. ,
Lookup Type: FAILURE_SCORE_COMMENTARY 12.1.1
product: AR - Receivables , meaning: Failure Score Commentary , description: Failure Score Commentary ,
Lookup Type: FAILURE_SCORE_COMMENTARY 12.2.2
product: AR - Receivables , meaning: Failure Score Commentary , description: Failure Score Commentary ,
Lookup Type: CREDIT_SCORE_COMMENTARY 12.2.2
product: AR - Receivables , meaning: Credit Score Commentary , description: Credit Score Commentary. ,
Lookup Type: ARI_ACCOUNT_GROUPING_OPTIONS 12.2.2
product: AR - Receivables , meaning: ARI Account Grouping Options , description: Account Grouping Options ,
Lookup Type: ARI_ACCOUNT_GROUPING_OPTIONS 12.1.1
product: AR - Receivables , meaning: ARI Account Grouping Options , description: Account Grouping Options ,
Lookup Type: ARXTWACC_REGION_CONTROL 12.2.2
product: AR - Receivables , meaning: Arxtwacc Region Control , description: Accounting alternative region ,
Lookup Type: ARXTWACC_REGION_CONTROL 12.1.1
product: AR - Receivables , meaning: Arxtwacc Region Control , description: Accounting alternative region ,
Lookup Type: ARXCOARV_CNS 12.1.1
product: AR - Receivables , meaning: Arxcoarv Cns , description: Account Review Form - Choose Next Screen ,
Lookup Type: ARXCOARV_CNS 12.2.2
product: AR - Receivables , meaning: Arxcoarv Cns , description: Account Review Form - Choose Next Screen ,
Concurrent Program: ARXAGFMX 12.2.2
execution_filename: ARPrintAgingReports , product: AR - Receivables , user_name: AR Aging Reports , description: AR Aging Reports , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Table: AR_CCID_CORRECTIONS_ALL 12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_CCID_CORRECTIONS_ALL, object_name:AR_CCID_CORRECTIONS_ALL, status:VALID, product: AR - Receivables , description: Individual GL distribution lines that contain invalid code combinations (GL accounts) , implementation_dba_data: AR.AR_CCID_CORRECTIONS_ALL ,
Table: AR_CCID_CORRECTIONS_ALL 12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_CCID_CORRECTIONS_ALL, object_name:AR_CCID_CORRECTIONS_ALL, status:VALID, product: AR - Receivables , description: Individual GL distribution lines that contain invalid code combinations (GL accounts) , implementation_dba_data: AR.AR_CCID_CORRECTIONS_ALL ,
Lookup Type: ADDRESS_OPTIONS 12.1.1
product: AR - Receivables , meaning: Address Options , description: Options for address form ,
Table: HZ_FINANCIAL_PROFILE 12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.HZ_FINANCIAL_PROFILE, object_name:HZ_FINANCIAL_PROFILE, status:VALID, product: AR - Receivables , description: Financial accounts of parties , implementation_dba_data: AR.HZ_FINANCIAL_PROFILE ,
Lookup Type: ADDRESS_OPTIONS 12.2.2
product: AR - Receivables , meaning: Address Options , description: Options for address form ,
Table: HZ_CUST_ACCT_RELATE_ALL 12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.HZ_CUST_ACCT_RELATE_ALL, object_name:HZ_CUST_ACCT_RELATE_ALL, status:VALID, product: AR - Receivables , description: Relationships between customer accounts , implementation_dba_data: AR.HZ_CUST_ACCT_RELATE_ALL ,
Table: HZ_CUST_ACCT_RELATE_ALL 12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.HZ_CUST_ACCT_RELATE_ALL, object_name:HZ_CUST_ACCT_RELATE_ALL, status:VALID, product: AR - Receivables , description: Relationships between customer accounts , implementation_dba_data: AR.HZ_CUST_ACCT_RELATE_ALL ,
Lookup Type: CREDIT_MEMO_REASON 12.1.1
product: AR - Receivables , meaning: Credit Memo Reason , description: Credit Memo Reason ,
Table: AR_CMGT_BANK_REF_DATA 12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_CMGT_BANK_REF_DATA, object_name:AR_CMGT_BANK_REF_DATA, status:VALID, product: AR - Receivables , description: The AR_CMGT_BANK_REF_DATA table stores information about the banks where a company under credit review has active accounts. , implementation_dba_data: AR.AR_CMGT_BANK_REF_DATA ,
Table: AR_CMGT_BANK_REF_DATA 12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_CMGT_BANK_REF_DATA, object_name:AR_CMGT_BANK_REF_DATA, status:VALID, product: AR - Receivables , description: The AR_CMGT_BANK_REF_DATA table stores information about the banks where a company under credit review has active accounts. , implementation_dba_data: AR.AR_CMGT_BANK_REF_DATA ,
Lookup Type: CUSTOMER_DETAIL_OPTIONS 12.2.2
product: AR - Receivables , meaning: Customer Detail Options , description: Options for customer form ,
Table: HZ_FINANCIAL_PROFILE 12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.HZ_FINANCIAL_PROFILE, object_name:HZ_FINANCIAL_PROFILE, status:VALID, product: AR - Receivables , description: Financial accounts of parties , implementation_dba_data: AR.HZ_FINANCIAL_PROFILE ,
Lookup Type: CUSTOMER_DETAIL_OPTIONS 12.1.1
product: AR - Receivables , meaning: Customer Detail Options , description: Options for customer form ,
Table: HZ_ROLE_RESPONSIBILITY 12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.HZ_ROLE_RESPONSIBILITY, object_name:HZ_ROLE_RESPONSIBILITY, status:VALID, product: AR - Receivables , description: Responsibilities for parties related to their roles in the accounts , implementation_dba_data: AR.HZ_ROLE_RESPONSIBILITY ,
Lookup Type: AR_CMGT_CUSTOMER_LEVEL 12.1.1
product: AR - Receivables , meaning: Credit Management Customer Level , description: Credit Management Customer Level ,
Lookup Type: AR_CMGT_CUSTOMER_LEVEL 12.2.2
product: AR - Receivables , meaning: Credit Management Customer Level , description: Credit Management Customer Level ,
Table: HZ_ROLE_RESPONSIBILITY 12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.HZ_ROLE_RESPONSIBILITY, object_name:HZ_ROLE_RESPONSIBILITY, status:VALID, product: AR - Receivables , description: Responsibilities for parties related to their roles in the accounts , implementation_dba_data: AR.HZ_ROLE_RESPONSIBILITY ,
Lookup Type: CREDIT_MEMO_REASON 12.2.2
product: AR - Receivables , meaning: Credit Memo Reason , description: Credit Memo Reason ,
Table: AR_TA_RECV_TRXSET_ALL 12.1.1
product: AR - Receivables , description: Stores association of Transaction Sets with Receivable accounts , implementation_dba_data: Not implemented in this database ,
Table: AR_TA_RECV_TRXSET_ALL 12.2.2
product: AR - Receivables , description: Stores association of Transaction Sets with Receivable accounts , implementation_dba_data: Not implemented in this database ,
Lookup Type: CHOOSE_NEXT_INV1 12.2.2
product: AR - Receivables , meaning: Choose Next Inv1 , description: Choose Next Option1 in Invoice Entry Screen ,
Lookup Type: HZ_SSM_ENTITY_GROUPS 12.1.1
product: AR - Receivables , meaning: Entity Groups for Source System Management , description: Entity Groups for Source System Management ,
Lookup Type: HZ_SSM_ENTITY_GROUPS 12.2.2
product: AR - Receivables , meaning: Entity Groups for Source System Management , description: Entity Groups for Source System Management ,
Table: HZ_CUSTOMER_PROFILES 12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.HZ_CUSTOMER_PROFILES, object_name:HZ_CUSTOMER_PROFILES, status:VALID, product: AR - Receivables , description: Credit information for customer accounts and customer account sites , implementation_dba_data: AR.HZ_CUSTOMER_PROFILES ,
View: AR_INVOICE_HEADER_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AR.AR_INVOICE_HEADER_V, object_name:AR_INVOICE_HEADER_V, status:VALID, product: AR - Receivables , description: Collects invoice header-level information , implementation_dba_data: APPS.AR_INVOICE_HEADER_V ,
Lookup Type: CHOOSE_NEXT_INV1 12.1.1
product: AR - Receivables , meaning: Choose Next Inv1 , description: Choose Next Option1 in Invoice Entry Screen ,
Lookup Type: CHOOSE_NEXT_INV2 12.1.1
product: AR - Receivables , meaning: Choose Next Inv2 , description: Choose Next Option in Invoice Entry Screen with Complete ,
Table: HZ_CUSTOMER_PROFILES 12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.HZ_CUSTOMER_PROFILES, object_name:HZ_CUSTOMER_PROFILES, status:VALID, product: AR - Receivables , description: Credit information for customer accounts and customer account sites , implementation_dba_data: AR.HZ_CUSTOMER_PROFILES ,
View: AR_INVOICE_HEADER_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AR.AR_INVOICE_HEADER_V, object_name:AR_INVOICE_HEADER_V, status:VALID, product: AR - Receivables , description: Collects invoice header-level information , implementation_dba_data: APPS.AR_INVOICE_HEADER_V ,
Lookup Type: CHOOSE_NEXT_INV2 12.2.2
product: AR - Receivables , meaning: Choose Next Inv2 , description: Choose Next Option in Invoice Entry Screen with Complete ,
Table: AR_MC_CASH_BASIS_DISTS_ALL 12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_MC_CASH_BASIS_DISTS_ALL, object_name:AR_MC_CASH_BASIS_DISTS_ALL, status:VALID, product: AR - Receivables , description: Distribution of payments over revenue accounts, used in Cash Basis Accounting for MRC , implementation_dba_data: AR.AR_MC_CASH_BASIS_DISTS_ALL ,