Search Results period

The AP_INTEREST_PERIODS table in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 is a critical repository for managing interest calculation periods within the Accounts Payable (AP) module. This table stores configuration details that determine how late payment interest is computed for supplier invoices, ensuring compliance with contractual or regulatory requirements. Below is a detailed summary of its structure, functionality, and integration within Oracle EBS.

1. Purpose and Functional Overview

The AP_INTEREST_PERIODS table defines the time intervals (periods) during which interest rates are applied to overdue invoices. It supports:

Interest Calculation Rules: Configures start/end dates, rate types (fixed/variable), and compounding logic.
Regulatory Compliance: Aligns with tax or legal mandates for late payment interest.
Multi-Currency Support: Stores rates specific to currencies or jurisdictions.

2. Key Columns and Structure

The table includes columns such as:

INTEREST_PERIOD_ID: Primary key, uniquely identifying each period.
INTEREST_RATE_NAME: Links to AP_INTEREST_RATES for rate details.
START_DATE/END_DATE: Defines the active period for the rate.
RATE: The interest percentage applied (fixed) or a reference to variable rates.
CREATED_BY/LAST_UPDATE_DATE: Audit columns tracking record changes.

3. Integration with Other Modules/Tables

The table interacts with:

AP_INTEREST_RATES: Master table for rate definitions referenced by INTEREST_RATE_NAME.
AP_INVOICES: Invoices flagged for interest calculation use periods from this table.
GL_DATE_HIERARCHIES: Validates period dates against fiscal calendars.

4. Technical Considerations

Indexing: Typically indexed on INTEREST_PERIOD_ID and INTEREST_RATE_NAME for performance.
Partitioning: In high-volume environments, partitions by date ranges may optimize queries.
API Dependencies: Managed via AP_INTEREST_CALC_PUB PL/SQL package for CRUD operations.

5. Customization and Extensions

Common extensions include:

Custom Rate Logic: Overrides default calculations via triggers or hooks.
Audit Enhancements: Additional columns to track approval workflows.
Multi-Org Support: Data partitioned by ORG_ID in multi-org deployments.

6. Upgrade Implications (12.1.1 to 12.2.2)

Changes between versions are minimal, but notable in:

Data Model: Added columns for cloud compatibility in 12.2.2.
Performance: Optimized queries in later versions reduce lock contention.

7. Best Practices

Archive obsolete periods to maintain performance.
Validate date overlaps during configuration to prevent rate conflicts.
Leverage Oracle's seeded rates for common regulatory requirements.

In summary, AP_INTEREST_PERIODS is a foundational table for accurate interest management in Oracle EBS AP. Its design ensures flexibility for global deployments while maintaining tight integration with core financial modules.

Lookup Type: PERIOD BASIS OPTIONS 12.1.1
product: AP - Payables , meaning: Period Basis Options , description: Period basis options for Withholding tax amount ranges ,
Lookup Type: PERIOD BASIS OPTIONS 12.2.2
product: AP - Payables , meaning: Period Basis Options , description: Period basis options for Withholding tax amount ranges ,
Lookup Type: FUNDS CONTROL PERIOD 12.2.2
product: AP - Payables , meaning: Period for which to perform funds control , description: Period for which to perform funds control ,
Lookup Type: FUNDS CONTROL PERIOD 12.1.1
product: AP - Payables , meaning: Period for which to perform funds control , description: Period for which to perform funds control ,
Lookup Type: MODULE 12.2.2
product: AP - Payables , meaning: Module , description: Module ,
Lookup Type: MODULE 12.1.1
product: AP - Payables , meaning: Module , description: Module ,
Lookup Type: AWT ERROR 12.1.1
product: AP - Payables , meaning: Awt Error , description: Automatic Withholding Tax Errors ,
Lookup Type: AWT ERROR 12.2.2
product: AP - Payables , meaning: Awt Error , description: Automatic Withholding Tax Errors ,
Lookup Type: OIE_REIMB_PERCENT_RULE 12.2.2
product: AP - Payables , meaning: Reimbursement Percentage Rule , description: Determines whether reimbursement percentage is defined on the policy line or period. ,
Lookup Type: OIE_POL_PASSENGER_RATE_TYPE 12.2.2
product: AP - Payables , meaning: Passenger Rate Type , description: Type of passenger rate defined in mileage policy ,
Lookup Type: OIE_TOLERANCE_LIMIT_RULE 12.1.1
product: AP - Payables , meaning: Tolerance Limit Rule , description: Determines whether tolerance limit is defined on the policy line or period ,
Lookup Type: OIE_TOLERANCE_LIMIT_RULE 12.2.2
product: AP - Payables , meaning: Tolerance Limit Rule , description: Determines whether tolerance limit is defined on the policy line or period ,
Lookup Type: OIE_POL_PASSENGER_RATE_TYPE 12.1.1
product: AP - Payables , meaning: Passenger Rate Type , description: Type of passenger rate defined in mileage policy ,
Lookup Type: EXCHANGE RATE TYPE 12.2.2
product: AP - Payables , meaning: Exchange Rate Type , description: Foreign currency exchange rate types ,
Lookup Type: EXCHANGE RATE TYPE 12.1.1
product: AP - Payables , meaning: Exchange Rate Type , description: Foreign currency exchange rate types ,
Lookup Type: OIE_PER_DIEM_RATE_TYPES 12.1.1
product: AP - Payables , meaning: Per Diem Rate Types , description: The type of rate periods for time threshold option ,
Lookup Type: OIE_PER_DIEM_RATE_TYPES 12.2.2
product: AP - Payables , meaning: Per Diem Rate Types , description: The type of rate periods for time threshold option ,
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: TIME UNIT 12.1.1
product: AP - Payables , meaning: Time Unit , description: Time unit used for credit card profile limit ,
Lookup Type: TIME UNIT 12.2.2
product: AP - Payables , meaning: Time Unit , description: Time unit used for credit card profile limit ,
Lookup Type: APXINREV_RATE_TYPE 12.2.2
product: AP - Payables , meaning: Open Items Revaluation report Rate Type parameter , description: Lookup Type added for Open Items Revaluation report Rate Type parameter values ,
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 ,
Lookup Type: APXINREV_RATE_TYPE 12.1.1
product: AP - Payables , meaning: Open Items Revaluation report Rate Type parameter , description: Lookup Type added for Open Items Revaluation report Rate Type parameter values ,
Lookup Type: OIE_PERDIEM_RATE_PERIOD_TYPES 12.2.2
product: AP - Payables , meaning: Per Diem Rate Period Types , description: Type of rate periods used to define a per diem policy ,
Lookup Type: OIE_PERDIEM_RATE_PERIOD_TYPES 12.1.1
product: AP - Payables , meaning: Per Diem Rate Period Types , description: Type of rate periods used to define a per diem policy ,
Lookup Type: OIE_APWUPDM_PERIOD_TYPE 12.1.1
product: AP - Payables , meaning: Expenses Upload Rates Period Type , description: Expenses Upload Rates Period Type ,
Lookup Type: OIE_POLICY_PERIOD_STATUS 12.1.1
product: AP - Payables , meaning: Policy Period Status , description: Policy Period Status ,
Lookup Type: OIE_POLICY_PERIOD_STATUS 12.2.2
product: AP - Payables , meaning: Policy Period Status , description: Policy Period Status ,
Concurrent Program: APXPCER_XMLP 12.1.1
product: AP - Payables , user_name: Period Close Exceptions Report (XML) , description: Period Close Exceptions Report (XML) , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Concurrent Program: APXPCER_XMLP 12.2.2
product: AP - Payables , user_name: Period Close Exceptions Report (XML) , description: Period Close Exceptions Report (XML) , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Lookup Type: OIE_APWUPDM_PERIOD_TYPE 12.2.2
product: AP - Payables , meaning: Expenses Upload Rates Period Type , description: Expenses Upload Rates Period Type ,
Concurrent Program: APXCLEXP_XML 12.2.2
product: AP - Payables , user_name: Period Close Exceptions Report (XML) - Delete - Not Supported: Reserved For Future Use , description: Period Close Exceptions Report , argument_method: Standard , enabled: No , execution_method: Java Concurrent Program ,
Concurrent Program: APXCLEXP_XML 12.1.1
product: AP - Payables , user_name: Period Close Exceptions Report (XML) - Delete - Not Supported: Reserved For Future Use , description: Period Close Exceptions Report , argument_method: Standard , enabled: No , execution_method: Java Concurrent Program ,
Lookup Type: POSTING EXCEPTIONS 12.2.2
product: AP - Payables , meaning: Posting Exceptions , description: Posting exceptions for the invoices ,
Concurrent Program: APXCLEXP 12.1.1
execution_filename: APXTRSWP , product: AP - Payables , user_name: APXTRSWP , description: Payables Unaccounted Transactions Report , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
Lookup Type: OIE_POL_DIST_THRESHOLD_TYPE 12.1.1
product: AP - Payables , meaning: Distance Threshold Type , description: Type of distance threshold defined in mileage policy ,
Lookup Type: POSTING EXCEPTIONS 12.1.1
product: AP - Payables , meaning: Posting Exceptions , description: Posting exceptions for the invoices ,
Lookup Type: OIE_POL_DIST_THRESHOLD_TYPE 12.2.2
product: AP - Payables , meaning: Distance Threshold Type , description: Type of distance threshold defined in mileage policy ,
Concurrent Program: APXCLEXP 12.2.2
execution_filename: APXTRSWP , product: AP - Payables , user_name: APXTRSWP , description: Payables Unaccounted Transactions Report , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
Concurrent Program: APXPPHIS 12.1.1
execution_filename: APXPPHIS , product: AP - Payables , user_name: APXPPHIS , description: Payments made to a supplier over a given time period , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: APXPPHIS 12.2.2
execution_filename: APXPPHIS , product: AP - Payables , user_name: APXPPHIS , description: Payments made to a supplier over a given time period , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Lookup Type: OIE_PER_DIEM_DETAIL_PROMPTS 12.1.1
product: AP - Payables , meaning: Per Diem line detail prompts , description: Per Diem line detail prompts ,
View: AP_ENCUMBRANCE_LINES_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:SQLAP.AP_ENCUMBRANCE_LINES_V, object_name:AP_ENCUMBRANCE_LINES_V, status:VALID, product: AP - Payables , implementation_dba_data: APPS.AP_ENCUMBRANCE_LINES_V ,
Lookup Type: OIE_PER_DIEM_DETAIL_PROMPTS 12.2.2
product: AP - Payables , meaning: Per Diem line detail prompts , description: Per Diem line detail prompts ,
View: AP_ENCUMBRANCE_LINES_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:SQLAP.AP_ENCUMBRANCE_LINES_V, object_name:AP_ENCUMBRANCE_LINES_V, status:VALID, product: AP - Payables , implementation_dba_data: APPS.AP_ENCUMBRANCE_LINES_V ,
Table: AP_INTEREST_PERIODS 12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_INTEREST_PERIODS, object_name:AP_INTEREST_PERIODS, status:VALID, product: AP - Payables , description: Interest rates and period information used to create Interest invoices , implementation_dba_data: AP.AP_INTEREST_PERIODS ,
Table: AP_OTHER_PERIOD_TYPES 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_OTHER_PERIOD_TYPES, object_name:AP_OTHER_PERIOD_TYPES, status:VALID, product: AP - Payables , description: Recurring invoice, key indicator, and withholding tax period type definitions , implementation_dba_data: AP.AP_OTHER_PERIOD_TYPES ,
Table: AP_OTHER_PERIOD_TYPES 12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_OTHER_PERIOD_TYPES, object_name:AP_OTHER_PERIOD_TYPES, status:VALID, product: AP - Payables , description: Recurring invoice, key indicator, and withholding tax period type definitions , implementation_dba_data: AP.AP_OTHER_PERIOD_TYPES ,
Table: AP_INTEREST_PERIODS 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_INTEREST_PERIODS, object_name:AP_INTEREST_PERIODS, status:VALID, product: AP - Payables , description: Interest rates and period information used to create Interest invoices , implementation_dba_data: AP.AP_INTEREST_PERIODS ,
Table: AP_AGING_PERIOD_LINES 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_AGING_PERIOD_LINES, object_name:AP_AGING_PERIOD_LINES, status:VALID, product: AP - Payables , description: Individual aging period information , implementation_dba_data: AP.AP_AGING_PERIOD_LINES ,