Search Results sap hr tables




The IGF_AW_CORRESP_ALL table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a critical data structure within the iGrants (Internet Grants) module, which is part of the Oracle Grants Accounting (IGF) product family. This table primarily stores correspondence-related data for grant and award management processes, facilitating communication between institutions, funding agencies, and recipients. Below is a detailed technical and functional analysis of this table:

1. Table Purpose and Functional Context

The IGF_AW_CORRESP_ALL table serves as a repository for tracking all correspondence associated with grants, awards, and financial aid processes. It captures metadata such as correspondence type, dates, statuses, and related document references. This enables institutions to maintain audit trails, comply with reporting requirements, and automate communication workflows.

2. Key Columns and Data Structure

The table includes columns such as:

  • CORRESP_ID: Primary key, uniquely identifying each correspondence record.
  • AWARD_ID: Foreign key linking to the IGF_AW_AWARD table, associating correspondence with specific awards.
  • CORRESP_TYPE: Defines the type of correspondence (e.g., approval letters, rejection notices, compliance requests).
  • STATUS: Tracks the lifecycle stage (e.g., "DRAFT," "SENT," "ARCHIVED").
  • CREATION_DATE and LAST_UPDATE_DATE: Standard Oracle audit columns.
  • DOCUMENT_REF: Stores references to attached documents or templates.
  • ORG_ID: Supports multi-org functionality, segregating data by operating unit.

3. Integration with Other Modules

The table integrates with:

  • Grants Accounting (IGF): Links to award data via AWARD_ID.
  • Document Management: References attachments via DOCUMENT_REF.
  • Workflow (WF): Triggers notifications based on correspondence status changes.

4. Technical Considerations

  • Multi-Org Support: The _ALL suffix indicates it stores data for all operating units, filtered by ORG_ID.
  • Indexing: Typically indexed on CORRESP_ID, AWARD_ID, and ORG_ID for performance.
  • APIs: Custom PL/SQL APIs (e.g., IGF_AW_CORRESP_PKG) handle CRUD operations.

5. Customization and Extensions

Common extensions include:

  • Adding custom correspondence types via lookup codes.
  • Integrating with third-party document generation tools.
  • Extending status values to support institution-specific workflows.

6. Version-Specific Notes

Differences between 12.1.1 and 12.2.2 are minimal for this table, but 12.2.2 may leverage Oracle's newer features like:

  • Enhanced audit capabilities via ORA_ARCHIVE_STATE.
  • Tighter integration with Oracle Fusion Middleware for document management.

7. Conclusion

The IGF_AW_CORRESP_ALL table is a cornerstone for grant-related communication in Oracle EBS. Its design supports compliance, automation, and scalability, making it indispensable for institutions managing complex award cycles. Proper understanding of its structure and relationships is essential for customization and reporting.

  • Lookup Type: IGF_AP_SYSTEM_SAP_TYPE 12.1.1

    product: IGF - Financial Aid ,  meaning: System SAP Types - Obsolete ,  description: System SAP Types - Obsolete , 

  • Concurrent Program: IGFAPJ12 12.1.1

    execution_filename: IGF_AP_SAP_PROC.RUN ,  product: IGF - Financial Aid ,  user_name: SAP Processing ,  description: SAP Processing - Obsolete ,  argument_method: Standard ,  enabled: No ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: IGFAPJ17 12.1.1

    execution_filename: IGF_AP_LI_ISIR_IMP_PROC.MAIN ,  product: IGF - Financial Aid ,  user_name: Legacy - ISIR Import Process ,  description: Legacy - ISIR Import Process ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: IGFAPJ20 12.1.1

    execution_filename: IGF_AP_LI_PROF_IMP_PROC.MAIN ,  product: IGF - Financial Aid ,  user_name: Legacy - PROFILE Import Process ,  description: Legacy - Profile Import Process ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • File: IGF_Dependencies.html 12.1.1

    product: IGF - Financial Aid ,  size: 658.384 KBytes ,  file_type: HTML Report ,  description: IGF_Dependencies.html is an html report that documents dependencies to tables and views in the IGF product. , 

  • File: IGFProduct_Dependencies.html 12.1.1

    product: IGF - Financial Aid ,  size: 33.734 KBytes ,  file_type: HTML Report ,  description: IGFProduct_Dependencies.html is an html report that documentsexternal dependencies to tables and views in the IGF product. , 

  • Table: IGF_AW_CORRESP_ALL 12.1.1

    owner:IGF,  object_type:TABLE,  fnd_design_data:IGF.IGF_AW_CORRESP_ALL,  object_name:IGF_AW_CORRESP_ALL,  status:VALID,  product: IGF - Financial Aid ,  description: Temporary staging entity that is commonly used for Printing message information and the award matrix . The correspondence engine then pulls values from this table and stores it in letter specific tables ,  implementation_dba_data: IGF.IGF_AW_CORRESP_ALL , 

  • Concurrent Program: IGFAPJ25 12.1.1

    execution_filename: IGF_AP_MK_PROF_ACT_PKG.LG_MAKE_ACTIVE_PROFILE ,  product: IGF - Financial Aid ,  user_name: Legacy - Make PROFILE Active Process ,  description: Legacy - Make Profile Active Process ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: IGFAPJ22 12.1.1

    execution_filename: IGF_AP_LG_VER_IMP.MAIN ,  product: IGF - Financial Aid ,  user_name: Legacy - Verification Item Import Process ,  description: Legacy - Historical Verification Item Import Process ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: IGFAPJ24 12.1.1

    execution_filename: IGF_AP_LG_TD_IMP.MAIN ,  product: IGF - Financial Aid ,  user_name: Legacy - To Do Item Import Process ,  description: Legacy - To Do Item Import Process ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: IGFAPJ18 12.1.1

    execution_filename: IGF_AP_LI_ISIR_IMP_PROC.CPS_IMPORT ,  product: IGF - Financial Aid ,  user_name: Legacy - CPS Import Process ,  description: Legacy - CPS Import Process ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: IGFAPJ21 12.1.1

    execution_filename: IGF_AP_LI_PROF_IMP_PROC.CSS_IMPORT ,  product: IGF - Financial Aid ,  user_name: Legacy - CSS PROFILE Import Process ,  description: Legacy - CSS Import Process ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: IGFAWJ13 12.1.1

    execution_filename: IGF_AP_LI_AWARDS_PKG.MAIN_IMPORT_PROCESS ,  product: IGF - Financial Aid ,  user_name: Legacy - Aggregate Award Data Import Process ,  description: Legacy - Aggregate Award Data Import Process ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: IGFAWJ14 12.1.1

    execution_filename: IGF_AP_LG_COA_IMP.MAIN ,  product: IGF - Financial Aid ,  user_name: Legacy - Cost of Attendance Item Import Process ,  description: Legacy - Cost of Attendance Item Import Process ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Lookup Type: IGF_GE_PARAMETERS 12.1.1

    product: IGF - Financial Aid ,  meaning: Concurrent Job Parameters ,  description: Concurrent Job Parameters ,