Search Results zx_rec_nrec_dist




The ZX_REC_NREC_DIST table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a critical repository for tax-related data, specifically designed to store recoverable and non-recoverable tax distribution details. This table is part of the Oracle E-Business Tax (EBTax) module, which manages tax calculations, reporting, and compliance within the financial architecture of Oracle EBS. Below is a detailed analysis of its structure, purpose, and integration within the Oracle EBS ecosystem.

Purpose and Functional Overview

The ZX_REC_NREC_DIST table serves as a ledger for tax distributions, distinguishing between recoverable (input tax that can be reclaimed) and non-recoverable (taxes that cannot be reclaimed) amounts. It is primarily used to support tax accounting, reconciliation, and reporting processes. The table captures transactional tax details, enabling organizations to comply with regional tax regulations, such as VAT, GST, or sales tax requirements. Key functionalities include:
  • Tax Allocation: Segregates tax amounts into recoverable and non-recoverable categories based on tax rules and jurisdiction.
  • GL Integration: Links tax distributions to General Ledger (GL) accounts for accurate financial posting.
  • Audit Trail: Maintains historical records of tax adjustments and distributions for compliance and auditing purposes.

Table Structure and Key Columns

The ZX_REC_NREC_DIST table comprises columns that store identifiers, amounts, and metadata for tax distributions. Notable columns include:
  • REC_NREC_DIST_ID: Primary key, uniquely identifying each distribution record.
  • APPLICATION_ID: References the Oracle EBS module (e.g., AP, AR, GL) generating the tax transaction.
  • ENTITY_CODE: Indicates the entity type (e.g., invoice, journal entry) associated with the tax distribution.
  • EVENT_CLASS_CODE: Classifies the tax event (e.g., invoice validation, payment).
  • TRX_ID: Foreign key linking to the source transaction (e.g., AP_INVOICES_ALL.INVOICE_ID).
  • RECOVERABLE_AMOUNT: The portion of tax deemed recoverable.
  • NON_RECOVERABLE_AMOUNT: The non-reclaimable tax amount.
  • TAX_RATE_ID: References the tax rate applied, from ZX_RATES_B.
  • ACCOUNT_CCID: GL account code combination ID for posting.

Integration with Oracle EBS Modules

The table interacts with multiple Oracle EBS modules, including:
  • Accounts Payable (AP): Captures tax distributions for supplier invoices.
  • Accounts Receivable (AR): Manages tax allocations for customer transactions.
  • General Ledger (GL): Ensures accurate tax accounting through journal entries.
  • EBTax Engine: Populates the table during tax calculation workflows.

Technical Considerations

  • Indexing: Key columns like REC_NREC_DIST_ID, TRX_ID, and APPLICATION_ID are indexed for performance.
  • Partitioning: In high-volume environments, partitioning by TRX_DATE or APPLICATION_ID may be implemented.
  • Purge Policies: Data retention aligns with fiscal and legal requirements, often archived post-reporting cycles.

Conclusion

The ZX_REC_NREC_DIST table is a cornerstone of Oracle EBS's tax functionality, ensuring precise tax accounting and compliance. Its integration with core financial modules and detailed data structure make it indispensable for organizations navigating complex tax landscapes. Understanding its design and usage is essential for tax configuration, reporting, and troubleshooting in Oracle EBS implementations.

  • Table: ZX_REC_NREC_DIST 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_REC_NREC_DIST,  object_name:ZX_REC_NREC_DIST,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores tax distributions. Each record stores a recoverable or non-recoverable tax distribution line. ,  implementation_dba_data: ZX.ZX_REC_NREC_DIST , 

  • Table: ZX_REC_NREC_DIST 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_REC_NREC_DIST,  object_name:ZX_REC_NREC_DIST,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores tax distributions. Each record stores a recoverable or non-recoverable tax distribution line. ,  implementation_dba_data: ZX.ZX_REC_NREC_DIST , 

  • Table: ZX_RATES_B 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_RATES_B,  object_name:ZX_RATES_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores rates for multiple configuration owners. Each row stores a rate that is effective for a specific period and is applicable to a specific tax status or tax jurisdiction. ,  implementation_dba_data: ZX.ZX_RATES_B , 

  • Table: ZX_RATES_B 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_RATES_B,  object_name:ZX_RATES_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores rates for multiple configuration owners. Each row stores a rate that is effective for a specific period and is applicable to a specific tax status or tax jurisdiction. ,  implementation_dba_data: ZX.ZX_RATES_B , 

  • Table: ZX_RECOVERY_TYPES_B 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_RECOVERY_TYPES_B,  object_name:ZX_RECOVERY_TYPES_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the recovery types. Each row stores a recovry type corresponding to a tax. ,  implementation_dba_data: ZX.ZX_RECOVERY_TYPES_B , 

  • Table: ZX_RECOVERY_TYPES_B 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_RECOVERY_TYPES_B,  object_name:ZX_RECOVERY_TYPES_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the recovery types. Each row stores a recovry type corresponding to a tax. ,  implementation_dba_data: ZX.ZX_RECOVERY_TYPES_B , 

  • Table: ZX_EVENT_CLASSES_B 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_EVENT_CLASSES_B,  object_name:ZX_EVENT_CLASSES_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores tax event classes. This table contains seeded data only. ,  implementation_dba_data: ZX.ZX_EVENT_CLASSES_B , 

  • Table: ZX_STATUS_B 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_STATUS_B,  object_name:ZX_STATUS_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores tax statuses for multiple configuration owners. Each row stores a status for a tax and configuration owner. ,  implementation_dba_data: ZX.ZX_STATUS_B , 

  • Table: ZX_STATUS_B 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_STATUS_B,  object_name:ZX_STATUS_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores tax statuses for multiple configuration owners. Each row stores a status for a tax and configuration owner. ,  implementation_dba_data: ZX.ZX_STATUS_B , 

  • Table: ZX_EVENT_CLASSES_B 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_EVENT_CLASSES_B,  object_name:ZX_EVENT_CLASSES_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores tax event classes. This table contains seeded data only. ,  implementation_dba_data: ZX.ZX_EVENT_CLASSES_B , 

  • Table: ZX_TAXES_B 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_TAXES_B,  object_name:ZX_TAXES_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores taxes for multiple configuration owners. Each row stores a tax for a specific regime and configuration owner. ,  implementation_dba_data: ZX.ZX_TAXES_B , 

  • Table: ZX_LINES_SUMMARY 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_LINES_SUMMARY,  object_name:ZX_LINES_SUMMARY,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the summarized tax lines for transactions of multiple event classes. ,  implementation_dba_data: ZX.ZX_LINES_SUMMARY , 

  • Table: ZX_EVNT_TYP_MAPPINGS 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_EVNT_TYP_MAPPINGS,  object_name:ZX_EVNT_TYP_MAPPINGS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores mappings of application event types to tax event types for all event classes mapped to tax event classes in ZX_EVNT_CLS_MAPPINGS. This table contains seeded data only. ,  implementation_dba_data: ZX.ZX_EVNT_TYP_MAPPINGS , 

  • Table: ZX_EVNT_TYP_MAPPINGS 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_EVNT_TYP_MAPPINGS,  object_name:ZX_EVNT_TYP_MAPPINGS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores mappings of application event types to tax event types for all event classes mapped to tax event classes in ZX_EVNT_CLS_MAPPINGS. This table contains seeded data only. ,  implementation_dba_data: ZX.ZX_EVNT_TYP_MAPPINGS , 

  • Table: ZX_TAXES_B 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_TAXES_B,  object_name:ZX_TAXES_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores taxes for multiple configuration owners. Each row stores a tax for a specific regime and configuration owner. ,  implementation_dba_data: ZX.ZX_TAXES_B , 

  • Table: ZX_LINES_SUMMARY 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_LINES_SUMMARY,  object_name:ZX_LINES_SUMMARY,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the summarized tax lines for transactions of multiple event classes. ,  implementation_dba_data: ZX.ZX_LINES_SUMMARY , 

  • Table: ZX_PROCESS_RESULTS 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_PROCESS_RESULTS,  object_name:ZX_PROCESS_RESULTS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the outcome of evaluation for tax rules. Each record stores the process result for evaluation of a specific condition group in a tax rule. ,  implementation_dba_data: ZX.ZX_PROCESS_RESULTS , 

  • Table: ZX_PROCESS_RESULTS 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_PROCESS_RESULTS,  object_name:ZX_PROCESS_RESULTS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the outcome of evaluation for tax rules. Each record stores the process result for evaluation of a specific condition group in a tax rule. ,  implementation_dba_data: ZX.ZX_PROCESS_RESULTS , 

  • Table: ZX_REGIMES_B 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_REGIMES_B,  object_name:ZX_REGIMES_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table defines and describes Tax Regime and related attributes. There will be one row per distinct tax regime. There are default entry columns to facilitate data entry process. ,  implementation_dba_data: ZX.ZX_REGIMES_B , 

  • Table: ZX_REGIMES_B 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_REGIMES_B,  object_name:ZX_REGIMES_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table defines and describes Tax Regime and related attributes. There will be one row per distinct tax regime. There are default entry columns to facilitate data entry process. ,  implementation_dba_data: ZX.ZX_REGIMES_B , 

  • Table: ZX_PARTY_TAX_PROFILE 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_PARTY_TAX_PROFILE,  object_name:ZX_PARTY_TAX_PROFILE,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores tax profiles for third parties, third party sites, third party providers, first party legal entities, first party legal establishments, operating units and tax authorities. ,  implementation_dba_data: ZX.ZX_PARTY_TAX_PROFILE , 

  • Table: ZX_PARTY_TAX_PROFILE 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_PARTY_TAX_PROFILE,  object_name:ZX_PARTY_TAX_PROFILE,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores tax profiles for third parties, third party sites, third party providers, first party legal entities, first party legal establishments, operating units and tax authorities. ,  implementation_dba_data: ZX.ZX_PARTY_TAX_PROFILE ,