Search Results import




The HZ_IMP_WORK_UNITS table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 plays a critical role in the Trading Community Architecture (TCA) module, specifically in the context of customer data import and integration processes. This table is part of the Oracle Customer Data Hub (CDH) framework, which facilitates the consolidation, cleansing, and standardization of customer data across multiple systems. Below is a detailed 500-word summary of its functionality, structure, and significance.

Overview and Purpose

The HZ_IMP_WORK_UNITS table serves as a staging area for managing work units during the customer data import process. Work units are logical partitions of data that enable parallel processing, improving performance and scalability when importing large volumes of customer records. This table is primarily used by the TCA Data Quality (DQ) and Data Import processes to track and manage the progress of data loads, ensuring efficient processing and error handling.

Key Columns and Structure

The table contains several critical columns that define its functionality:
  • WORK_UNIT_ID: A unique identifier for each work unit, often generated sequentially or via a sequence.
  • BATCH_ID: References the batch to which the work unit belongs, linking it to the parent import process.
  • STATUS: Indicates the current state of the work unit (e.g., PENDING, PROCESSING, COMPLETED, or ERROR).
  • RECORD_COUNT: Tracks the number of records within the work unit, aiding in load balancing.
  • CREATION_DATE and LAST_UPDATE_DATE: Timestamps for auditing and tracking purposes.
  • ERROR_MESSAGE: Stores error details if the work unit fails during processing.

Integration with TCA Import Processes

The HZ_IMP_WORK_UNITS table is tightly integrated with other TCA import tables such as HZ_IMP_BATCHES, HZ_IMP_CONTACTS, and HZ_IMP_ADDRESSES. When data is imported via the Customer Interface or Data Quality Management (DQM) processes, the system divides the data into work units to enable parallel execution. This approach minimizes bottlenecks and ensures optimal resource utilization, especially in high-volume environments.

Performance and Scalability Considerations

In EBS 12.1.1 and 12.2.2, the partitioning of data into work units allows for distributed processing, which is particularly beneficial for large-scale implementations. Administrators can configure the size of work units (e.g., 1,000 records per unit) to balance performance and system overhead. The table’s indexing strategy, typically on WORK_UNIT_ID and BATCH_ID, ensures efficient querying during the import lifecycle.

Error Handling and Recovery

If a work unit encounters errors (e.g., data validation failures), the STATUS column is updated to ERROR, and the ERROR_MESSAGE column captures diagnostic details. This enables administrators to isolate and reprocess failed units without restarting the entire batch, reducing downtime and improving data consistency.

Conclusion

The HZ_IMP_WORK_UNITS table is a foundational component of Oracle EBS’s customer data integration framework, enabling scalable, fault-tolerant, and high-performance data imports. Its design aligns with TCA’s broader objectives of data quality and operational efficiency, making it indispensable for organizations leveraging Oracle CDH in EBS 12.1.1 or 12.2.2 environments.

  • Lookup Type: HZ_IMP_RUN_OPTIONS 12.1.1

    product: AR - Receivables ,  meaning: Import Run Options ,  description: Different Options for running the import process , 

  • Lookup Type: HZ_IMP_RUN_OPTIONS 12.2.2

    product: AR - Receivables ,  meaning: Import Run Options ,  description: Different Options for running the import process , 

  • Lookup Type: HZ_IMP_STATUS 12.1.1

    product: AR - Receivables ,  meaning: Import Statuses ,  description: Different processing statuses of Import , 

  • Lookup Type: HZ_IMP_STATUS 12.2.2

    product: AR - Receivables ,  meaning: Import Statuses ,  description: Different processing statuses of Import , 

  • Concurrent Program: ARHDCH 12.1.1

    execution_filename: HZ_DQM_SYNC.sync_work_unit ,  product: AR - Receivables ,  user_name: DQM Import Sync Child Program ,  description: DQM Import Sync Child Program ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Lookup Type: HZ_DUP_REQUEST_TYPE 12.2.2

    product: AR - Receivables ,  meaning: Duplicate Set Request Type , 

  • Lookup Type: HZ_DUP_REQUEST_TYPE 12.1.1

    product: AR - Receivables ,  meaning: Duplicate Set Request Type , 

  • Concurrent Program: ARHDCH 12.2.2

    execution_filename: HZ_DQM_SYNC.sync_work_unit ,  product: AR - Receivables ,  user_name: DQM Import Sync Child Program ,  description: DQM Import Sync Child Program ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: ARHIMAIN 12.2.2

    execution_filename: HZ_BATCH_IMPORT_PKG.import_batch ,  product: AR - Receivables ,  user_name: ARHIMAIN ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: ARHIMAIN 12.1.1

    execution_filename: HZ_BATCH_IMPORT_PKG.import_batch ,  product: AR - Receivables ,  user_name: ARHIMAIN ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: ARGTIMP 12.2.2

    execution_filename: AR_GTA_CONC_PROG.Import_GT_invoices ,  product: AR - Receivables ,  user_name: ARGTIMP ,  description: Import invoice from temporary table ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: ARTAPRLD_LOAD 12.1.1

    execution_filename: ARTAPRLD ,  product: AR - Receivables ,  user_name: ARTAPRLD_LOAD ,  description: Import Legacy Promotions ,  argument_method: Standard ,  enabled: No ,  execution_method: SQL*Loader , 

  • Concurrent Program: ARHLWRPO 12.1.1

    execution_filename: HZ_IMP_LOAD_WRAPPER.ONLINE_DATA_LOAD ,  product: AR - Receivables ,  user_name: ARHLWRPO ,  description: TCA Import - Online Data Load Main Wrapper ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: ARBNKDIR 12.1.1

    execution_filename: arbnkdir ,  product: AR - Receivables ,  user_name: ARBNKDIR ,  description: Import Bank Directory data ,  argument_method: Standard ,  enabled: Yes ,  execution_method: SQL*Loader , 

  • Concurrent Program: ARHLVOUT 12.1.1

    execution_filename: ARHLVOUT ,  product: AR - Receivables ,  user_name: ARHLVOUT ,  description: Import Batch De-Duplication Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: ARHLPPLS 12.1.1

    execution_filename: HZ_IMP_LOAD_POST_PROCESS_PKG.POSTPROCESS ,  product: AR - Receivables ,  user_name: ARHLPPLS ,  description: TCA Import Postprocessing Worker ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Lookup Type: HZ_IMP_BATCH_DEDUP_STATUS 12.1.1

    product: AR - Receivables ,  meaning: Import Batch De-Duplication Status ,  description: Status for Master and Duplicate Records , 

  • Lookup Type: HZ_IMP_BATCH_DEDUP_STATUS 12.2.2

    product: AR - Receivables ,  meaning: Import Batch De-Duplication Status ,  description: Status for Master and Duplicate Records , 

  • Concurrent Program: ARHLERRPT 12.2.2

    execution_filename: ARHLERPT ,  product: AR - Receivables ,  user_name: ARHLERRPT ,  description: Report of Errors Within an Import Batch ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: HZ_DNB_ADAPTER2 12.1.1

    product: AR - Receivables ,  user_name: Request Set D&B Import Adapter ,  description: D&B Import Adapter for loading flat file data into the import interface tables ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: ARBNKDIR 12.2.2

    execution_filename: arbnkdir ,  product: AR - Receivables ,  user_name: ARBNKDIR ,  description: Import Bank Directory data ,  argument_method: Standard ,  enabled: Yes ,  execution_method: SQL*Loader , 

  • Concurrent Program: HZ_DNB_ADAPTER2 12.2.2

    product: AR - Receivables ,  user_name: Request Set D&B Import Adapter ,  description: D&B Import Adapter for loading flat file data into the import interface tables ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: ARHLPURB 12.2.2

    execution_filename: HZ_IMP_PURGE_PKG.purge_batch ,  product: AR - Receivables ,  user_name: ARHLPURB ,  description: TCA Import Process to Purge a Batch ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Lookup Type: HZ_CREATED_BY_MODULES 12.2.2

    product: AR - Receivables ,  meaning: Modules Used to Create TCA Data ,  description: Identifies a registered list of modules, for example APIs, that call the TCA Public APIs to create party related information. , 

  • Concurrent Program: ARTAPRLD_LOAD 12.2.2

    execution_filename: ARTAPRLD ,  product: AR - Receivables ,  user_name: ARTAPRLD_LOAD ,  description: Import Legacy Promotions ,  argument_method: Standard ,  enabled: No ,  execution_method: SQL*Loader , 

  • Concurrent Program: ARGTIMS 12.2.2

    execution_filename: ARGTAIM ,  product: AR - Receivables ,  user_name: ARGTIMS ,  description: Import invoice from flat file to temporary table ,  argument_method: Standard ,  enabled: Yes ,  execution_method: SQL*Loader , 

  • Lookup Type: HZ_CREATED_BY_MODULES 12.1.1

    product: AR - Receivables ,  meaning: Modules Used to Create TCA Data ,  description: Identifies a registered list of modules, for example APIs, that call the TCA Public APIs to create party related information. , 

  • Concurrent Program: ARHLPURB 12.1.1

    execution_filename: HZ_IMP_PURGE_PKG.purge_batch ,  product: AR - Receivables ,  user_name: ARHLPURB ,  description: TCA Import Process to Purge a Batch ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: ARHLVOUT 12.2.2

    execution_filename: ARHLVOUT ,  product: AR - Receivables ,  user_name: ARHLVOUT ,  description: Import Batch De-Duplication Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: ARHLPPLS 12.2.2

    execution_filename: HZ_IMP_LOAD_POST_PROCESS_PKG.POSTPROCESS ,  product: AR - Receivables ,  user_name: ARHLPPLS ,  description: TCA Import Postprocessing Worker ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: ARHLWRPB 12.1.1

    execution_filename: HZ_IMP_LOAD_WRAPPER.BATCH_DATA_LOAD ,  product: AR - Receivables ,  user_name: ARHLWRPB ,  description: TCA Import - Batch Data Load Main Wrapper ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: ARHLERRPT 12.1.1

    execution_filename: ARHLERPT ,  product: AR - Receivables ,  user_name: ARHLERRPT ,  description: Report of Errors Within an Import Batch ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: ARHLWRPO 12.2.2

    execution_filename: HZ_IMP_LOAD_WRAPPER.ONLINE_DATA_LOAD ,  product: AR - Receivables ,  user_name: ARHLWRPO ,  description: TCA Import - Online Data Load Main Wrapper ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: ARHLWRPB 12.2.2

    execution_filename: HZ_IMP_LOAD_WRAPPER.BATCH_DATA_LOAD ,  product: AR - Receivables ,  user_name: ARHLWRPB ,  description: TCA Import - Batch Data Load Main Wrapper ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Table: HZ_IMP_WORK_UNITS 12.2.2

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.HZ_IMP_WORK_UNITS,  object_name:HZ_IMP_WORK_UNITS,  status:VALID,  product: AR - Receivables ,  description: TCA import table used to manage work units during the import process ,  implementation_dba_data: AR.HZ_IMP_WORK_UNITS , 

  • Table: HZ_IMP_TMP_ERRORS 12.1.1

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.HZ_IMP_TMP_ERRORS,  object_name:HZ_IMP_TMP_ERRORS,  status:VALID,  product: AR - Receivables ,  description: TCA import table used during runtime to record errors found during import process ,  implementation_dba_data: AR.HZ_IMP_TMP_ERRORS , 

  • Table: HZ_IMP_TMP_ERRORS 12.2.2

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.HZ_IMP_TMP_ERRORS,  object_name:HZ_IMP_TMP_ERRORS,  status:VALID,  product: AR - Receivables ,  description: TCA import table used during runtime to record errors found during import process ,  implementation_dba_data: AR.HZ_IMP_TMP_ERRORS , 

  • Concurrent Program: FNDRSSUB3405 12.2.2

    product: AR - Receivables ,  user_name: Request Set Golden Tax Invoice Import ,  description: Golden Tax Invoice Import ,  argument_method: Database fetch ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Table: HZ_IMP_WORK_UNITS 12.1.1

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.HZ_IMP_WORK_UNITS,  object_name:HZ_IMP_WORK_UNITS,  status:VALID,  product: AR - Receivables ,  description: TCA import table used to manage work units during the import process ,  implementation_dba_data: AR.HZ_IMP_WORK_UNITS , 

  • Concurrent Program: ARHLVOUT_XML 12.1.1

    product: AR - Receivables ,  user_name: Import Batch De-Duplication Report (XML) ,  description: Import Batch De-Duplication Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Table: HZ_IMP_ERRORS 12.2.2

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.HZ_IMP_ERRORS,  object_name:HZ_IMP_ERRORS,  status:VALID,  product: AR - Receivables ,  description: TCA import table used to record error found during the import process ,  implementation_dba_data: AR.HZ_IMP_ERRORS , 

  • Concurrent Program: ARHLERRPT_XML 12.1.1

    product: AR - Receivables ,  user_name: TCA Import Error Report (XML) ,  description: Report of Errors Within an Import Batch ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: ARHLERRPT_XML 12.2.2

    product: AR - Receivables ,  user_name: TCA Import Error Report (XML) ,  description: Report of Errors Within an Import Batch ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Table: HZ_IMP_ERRORS 12.1.1

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.HZ_IMP_ERRORS,  object_name:HZ_IMP_ERRORS,  status:VALID,  product: AR - Receivables ,  description: TCA import table used to record error found during the import process ,  implementation_dba_data: AR.HZ_IMP_ERRORS , 

  • Concurrent Program: ARHLVOUT_XML 12.2.2

    product: AR - Receivables ,  user_name: Import Batch De-Duplication Report (XML) ,  description: Import Batch De-Duplication Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Lookup Type: GL_DATE_SOURCE 12.2.2

    product: AR - Receivables ,  meaning: Gl Date Source ,  description: Indicates where GL date is derived for transmission , 

  • Concurrent Program: ARHLDDNB4 12.1.1

    execution_filename: arhldnb4 ,  product: AR - Receivables ,  user_name: ARHLDDNB4 ,  description: Preprocessing for D&B Import Adapter ,  argument_method: Standard ,  enabled: Yes ,  execution_method: SQL*Plus , 

  • Lookup Type: HZ_IMP_LOAD_TYPES 12.1.1

    product: AR - Receivables ,  meaning: Import Types ,  description: Type of Import based on the source of the data , 

  • Lookup Type: HZ_IMP_LOAD_TYPES 12.2.2

    product: AR - Receivables ,  meaning: Import Types ,  description: Type of Import based on the source of the data , 

  • Concurrent Program: FNDRSSUB3445 12.2.2

    product: AR - Receivables ,  user_name: Request Set Golden Tax Invoice Import(1) ,  description: Golden Tax Invoice Import(1) ,  argument_method: Database fetch ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure ,