Search Results  01_preservation activity for soc  7000_instrument  02_preservation record

The AP_LINE_APRVL_HIST_ALL table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a critical repository for tracking approval history at the line level for invoices processed through the Accounts Payable (AP) module. This table captures detailed transactional data related to invoice line approvals, including timestamps, approver details, and approval statuses, ensuring auditability and compliance with financial controls. Below is a detailed breakdown of its structure, functionality, and significance within Oracle EBS.

Purpose and Functional Context

The AP_LINE_APRVL_HIST_ALL table stores historical records of approval actions performed on individual invoice lines. Unlike header-level approval tables, it provides granular visibility into the approval workflow for multi-line invoices, which is essential for organizations with complex approval hierarchies or segmented approval rules (e.g., based on cost centers, GL accounts, or project codes). This table is integral to Oracle's Approval Management Engine (AME) and supports audit trails, reporting, and reconciliation.

Key Columns and Data Structure

The table includes columns that map to approval workflow attributes:

INVOICE_ID: Foreign key linking to AP_INVOICES_ALL, identifying the invoice.
INVOICE_LINE_NUMBER: References the line in AP_INVOICE_LINES_ALL.
APPROVAL_HISTORY_ID: Primary key, a unique identifier for each approval event.
APPROVER_ID: Foreign key to PER_ALL_PEOPLE_F, identifying the approver.
APPROVAL_STATUS: Values like 'APPROVED', 'REJECTED', or 'PENDING'.
APPROVAL_DATE: Timestamp of the approval action.
ACTION_CODE: Indicates the type of action (e.g., 'SUBMIT', 'APPROVE').
COMMENTS: Optional notes from the approver.
ORG_ID: Multi-org identifier for partitioned data.

Integration with Approval Workflows

The table is populated during invoice approval processes, including:

Standard Approvals: Triggered via Oracle Workflow or AME rules.
Ad-Hoc Delegations: When approvers delegate authority temporarily.
Hierarchical Approvals: Multi-level approvals based on monetary thresholds.

Data flows into this table from the AP approval engine, ensuring synchronization with AP_INVOICE_LINES_ALL and related audit tables like AP_INV_APRVL_HIST_ALL (header-level history).

Technical Considerations

Indexing: Typically indexed on INVOICE_ID, INVOICE_LINE_NUMBER, and APPROVAL_HISTORY_ID for performance.
Partitioning: In multi-org environments, ORG_ID enables partitioning for scalability.
Retention: Historical data is retained per audit policies, often archived periodically.

Reporting and Compliance

The table supports:

Audit Reports: For SOX or internal audits, tracking who approved what and when.
Exception Reporting: Identifying bottlenecks (e.g., lines stuck in 'PENDING').
Custom Extracts: For integration with third-party analytics tools.

Customization and Extensions

While Oracle discourages direct DML on this table, extensions can be achieved via:

API Calls: Using AP_INVOICE_PUB or AP_APPROVAL_PKG.
Triggers: To enforce additional validation rules during insert/update.
Views: Creating custom joins with AP_INVOICES_ALL for reporting.

Conclusion

The AP_LINE_APRVL_HIST_ALL table is a cornerstone of Oracle AP's approval tracking, providing traceability and compliance for invoice line approvals. Its design aligns with Oracle's multi-org, multi-currency architecture, ensuring scalability. Understanding its structure and integration points is essential for troubleshooting, customization, and optimizing approval workflows in Oracle EBS 12.1.1/12.2.2.

Lookup Type: RECORD TYPE 12.2.2
product: AP - Payables , meaning: Record Type , description: Used by check recon to determine what table to store flat-file record in ,
Lookup Type: RECORD TYPE 12.1.1
product: AP - Payables , meaning: Record Type , description: Used by check recon to determine what table to store flat-file record in ,
Lookup Type: AUTOCLEAR STATUS 12.2.2
product: AP - Payables , meaning: Autoclear Status , description: Status of AutoClear Items ,
Lookup Type: AUTOCLEAR STATUS 12.1.1
product: AP - Payables , meaning: Autoclear Status , description: Status of AutoClear Items ,
Lookup Type: OIE_FREE_MEALS_RULE 12.2.2
product: AP - Payables , meaning: Free Meals Rule , description: Free Meals Rule ,
Lookup Type: OIE_FREE_MEALS_RULE 12.1.1
product: AP - Payables , meaning: Free Meals Rule , description: Free Meals Rule ,
Lookup Type: ERROR CHECK FUNCTION 12.2.2
product: AP - Payables , meaning: Error Check Function , description: Defines method of error-checking for check reconciliation ,
Lookup Type: ERROR CHECK FUNCTION 12.1.1
product: AP - Payables , meaning: Error Check Function , description: Defines method of error-checking for check reconciliation ,
Lookup Type: ACCESS_TYPE 12.2.2
product: AP - Payables , meaning: Access Type , description: Access Type ,
Lookup Type: ACCESS_TYPE 12.1.1
product: AP - Payables , meaning: Access Type , description: Access Type ,
Table: AP_LINE_APRVL_HIST_ALL 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_LINE_APRVL_HIST_ALL, object_name:AP_LINE_APRVL_HIST_ALL, status:VALID, product: AP - Payables , description: AP_LINE_APRVL_HIST_ALL contains the approval and rejection history of each invoice line that passes through the Invoice Approval Workflow's approval phase process. The process inserts a record for each approver assigned to review an invoice , implementation_dba_data: AP.AP_LINE_APRVL_HIST_ALL ,
Table: AP_LINE_APRVL_HIST_ALL 12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_LINE_APRVL_HIST_ALL, object_name:AP_LINE_APRVL_HIST_ALL, status:VALID, product: AP - Payables , description: AP_LINE_APRVL_HIST_ALL contains the approval and rejection history of each invoice line that passes through the Invoice Approval Workflow's approval phase process. The process inserts a record for each approver assigned to review an invoice , implementation_dba_data: AP.AP_LINE_APRVL_HIST_ALL ,
Table: AP_INV_APRVL_HIST_ALL 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_INV_APRVL_HIST_ALL, object_name:AP_INV_APRVL_HIST_ALL, status:VALID, product: AP - Payables , description: AP_INV_APRVL_HIST_ALL contains the approval and rejection history of each invoice that passes through the Invoice Approval Workflow process. The process inserts a record for each approver assigned to review an invoice. , implementation_dba_data: AP.AP_INV_APRVL_HIST_ALL ,
Table: AP_INV_APRVL_HIST_ALL 12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_INV_APRVL_HIST_ALL, object_name:AP_INV_APRVL_HIST_ALL, status:VALID, product: AP - Payables , description: AP_INV_APRVL_HIST_ALL contains the approval and rejection history of each invoice that passes through the Invoice Approval Workflow process. The process inserts a record for each approver assigned to review an invoice. , implementation_dba_data: AP.AP_INV_APRVL_HIST_ALL ,
Lookup Type: EXCEPTIONS PRINT CHOICES 12.1.1
product: AP - Payables , meaning: Exceptions Print Choices , description: Used by check recon exceptions form to choose next action ,
Lookup Type: EXCEPTIONS PRINT CHOICES 12.2.2
product: AP - Payables , meaning: Exceptions Print Choices , description: Used by check recon exceptions form to choose next action ,
Lookup Type: INVOICE IMPORT REJECTION 12.1.1
product: AP - Payables , meaning: Invoice Import Rejection , description: Reason for the rejection of an imported invoice ,
Lookup Type: INVOICE IMPORT REJECTION 12.2.2
product: AP - Payables , meaning: Invoice Import Rejection , description: Reason for the rejection of an imported invoice ,
Lookup Type: CODE TYPE 12.1.1
product: AP - Payables , meaning: Code Type , description: Defines date format of bank-file field ,
Lookup Type: CODE TYPE 12.2.2
product: AP - Payables , meaning: Code Type , description: Defines date format of bank-file field ,
Lookup Type: CHECKRUN ACTIONS 12.1.1
product: AP - Payables , meaning: Checkrun Actions , description: Actions user can take after confirming the results of printing a checkrun ,
Lookup Type: CHECKRUN ACTIONS 12.2.2
product: AP - Payables , meaning: Checkrun Actions , description: Actions user can take after confirming the results of printing a checkrun ,
Table: AP_INVOICES_UPG_CONTROL 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_INVOICES_UPG_CONTROL, object_name:AP_INVOICES_UPG_CONTROL, status:VALID, product: AP - Payables , description: AP_INVOICES_UPG_CONTRO is used to maintain the record of pre-upgrade programs submitted and their progress. , implementation_dba_data: AP.AP_INVOICES_UPG_CONTROL ,
Table: AP_INVOICES_UPG_CONTROL 12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_INVOICES_UPG_CONTROL, object_name:AP_INVOICES_UPG_CONTROL, status:VALID, product: AP - Payables , description: AP_INVOICES_UPG_CONTRO is used to maintain the record of pre-upgrade programs submitted and their progress. , implementation_dba_data: AP.AP_INVOICES_UPG_CONTROL ,
Lookup Type: INSTITUTION TYPE 12.1.1
product: AP - Payables , meaning: Institution Type , description: Bank Branch Record Types ,
Table: AP_LINES_UPG_SYNC_DATA 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_LINES_UPG_SYNC_DATA, object_name:AP_LINES_UPG_SYNC_DATA, status:VALID, product: AP - Payables , description: AP_LINES_UPG_SYNC_DATA is used to record the invoice information that are captured through the triggers on the invoice transaction tables. , implementation_dba_data: AP.AP_LINES_UPG_SYNC_DATA ,
Lookup Type: INSTITUTION TYPE 12.2.2
product: AP - Payables , meaning: Institution Type , description: Bank Branch Record Types ,
Table: AP_LINES_UPG_SYNC_DATA 12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_LINES_UPG_SYNC_DATA, object_name:AP_LINES_UPG_SYNC_DATA, status:VALID, product: AP - Payables , description: AP_LINES_UPG_SYNC_DATA is used to record the invoice information that are captured through the triggers on the invoice transaction tables. , implementation_dba_data: AP.AP_LINES_UPG_SYNC_DATA ,
Lookup Type: MSB UPGRADE TEXT 12.2.2
product: AP - Payables , meaning: Msb Upgrade Text ,
Table: AP_RECON_RECORD_CODES 12.1.1
product: AP - Payables , description: Bank reconciliation record descriptions used by AutoClear , implementation_dba_data: Not implemented in this database ,
Lookup Type: MSB UPGRADE TEXT 12.1.1
product: AP - Payables , meaning: Msb Upgrade Text ,
Table: AP_RECON_RECORD_CODES 12.2.2
product: AP - Payables , description: Bank reconciliation record descriptions used by AutoClear , implementation_dba_data: Not implemented in this database ,
Lookup Type: STOP PAYMENT ACTION 12.1.1
product: AP - Payables , meaning: Stop Payment Action , description: Action choices from Stop Payment form ,
Lookup Type: STOP PAYMENT ACTION 12.2.2
product: AP - Payables , meaning: Stop Payment Action , description: Action choices from Stop Payment form ,
Table: AP_SUP_SITE_CONTACT_INT 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_SUP_SITE_CONTACT_INT, object_name:AP_SUP_SITE_CONTACT_INT, status:VALID, product: AP - Payables , description: AP_SUP_SITE_CONTACT_INT holds Supplier contact data. The columns in the table map to corresponding columns in PO_VENDOR_CONTACTS table. The Oracle Payables application uses this information to create a new Supplier Contact record when th , implementation_dba_data: AP.AP_SUP_SITE_CONTACT_INT ,
Table: AP_SUP_SITE_CONTACT_INT 12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_SUP_SITE_CONTACT_INT, object_name:AP_SUP_SITE_CONTACT_INT, status:VALID, product: AP - Payables , description: AP_SUP_SITE_CONTACT_INT holds Supplier contact data. The columns in the table map to corresponding columns in PO_VENDOR_CONTACTS table. The Oracle Payables application uses this information to create a new Supplier Contact record when th , implementation_dba_data: AP.AP_SUP_SITE_CONTACT_INT ,
Table: AP_ALLOCATION_RULES 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_ALLOCATION_RULES, object_name:AP_ALLOCATION_RULES, status:VALID, product: AP - Payables , description: AP_ALLOCATION_RULES contains records establishing how charge lines (Freight and Miscellaneous) should be allocated to Item lines. Each record in this table indicates the type of allocation rule that will be generated. The available rule ty , implementation_dba_data: AP.AP_ALLOCATION_RULES ,
Table: AP_ALLOCATION_RULES 12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_ALLOCATION_RULES, object_name:AP_ALLOCATION_RULES, status:VALID, product: AP - Payables , description: AP_ALLOCATION_RULES contains records establishing how charge lines (Freight and Miscellaneous) should be allocated to Item lines. Each record in this table indicates the type of allocation rule that will be generated. The available rule ty , implementation_dba_data: AP.AP_ALLOCATION_RULES ,
Lookup Type: ACCOUNT TYPE 12.2.2
product: AP - Payables , meaning: Account Type , description: Bank Account Record Types ,
Lookup Type: ACCOUNT TYPE 12.1.1
product: AP - Payables , meaning: Account Type , description: Bank Account Record Types ,
Lookup Type: OIE_AUD_RETURN_REASONS 12.2.2
product: AP - Payables , meaning: Audit Return Reasons , description: Audit Return Reasons ,
Lookup Type: OIE_AUD_RETURN_REASONS 12.1.1
product: AP - Payables , meaning: Audit Return Reasons , description: Audit Return Reasons ,
Lookup Type: OIE_POL_OPTIONAL_RULES 12.2.2
product: AP - Payables , meaning: Policy Compliance Optional Rules , description: Policy Compliance Optional Rules ,
Lookup Type: NLS TRANSLATION 12.2.2
product: AP - Payables , meaning: Nls Translation , description: Words/phrases that need to be NLS ,
Lookup Type: OIE_POL_OPTIONAL_RULES 12.1.1
product: AP - Payables , meaning: Policy Compliance Optional Rules , description: Policy Compliance Optional Rules ,
Lookup Type: NLS TRANSLATION 12.1.1
product: AP - Payables , meaning: Nls Translation , description: Words/phrases that need to be NLS ,
Lookup Type: OIE_DATA_CAPTURE_TYPE 12.2.2
product: AP - Payables , meaning: Data Capture Type for Expense Types , description: Lookup for the three types of data capture that can be enabled for expense types ,
Lookup Type: HOLD TYPE 12.1.1
product: AP - Payables , meaning: Hold Type , description: The hold types are also stored as lookups for NLS translations ,
Lookup Type: OIE_DATA_CAPTURE_TYPE 12.1.1
product: AP - Payables , meaning: Data Capture Type for Expense Types , description: Lookup for the three types of data capture that can be enabled for expense types ,
Lookup Type: HOLD TYPE 12.2.2
product: AP - Payables , meaning: Hold Type , description: The hold types are also stored as lookups for NLS translations ,