Search Results oracle shipping execution technical reference manual
The AP_R115_UPGRADE
table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a critical data structure within the Accounts Payable (AP) module, specifically designed to support the upgrade and migration processes related to payment formats, payment instructions, and bank-related configurations. This table plays a pivotal role during system upgrades, patches, or transitions between EBS versions, ensuring data integrity and consistency while accommodating new features or regulatory requirements.
Purpose and Functionality
The primary purpose ofAP_R115_UPGRADE
is to facilitate the seamless transition of payment-related data when upgrading from earlier versions of Oracle EBS to Release 12.1.1 or 12.2.2. It acts as a staging or intermediary table that temporarily holds payment instructions, bank account details, and payment format mappings during the upgrade process. This ensures that existing payment setups remain functional while aligning with the enhanced capabilities of the newer EBS release.
Key Attributes
The table typically includes columns such as:- UPGRADE_ID: A unique identifier for each upgrade record.
- PAYMENT_INSTRUCTION_ID: References the payment instruction being upgraded.
- BANK_ACCOUNT_ID: Links to the bank account details.
- OLD_FORMAT_CODE and NEW_FORMAT_CODE: Tracks changes in payment formats.
- STATUS: Indicates the progress of the upgrade (e.g., PENDING, COMPLETED, ERROR).
- CREATION_DATE and LAST_UPDATE_DATE: Timestamps for audit trails.
Upgrade Scenarios
During an upgrade to EBS 12.1.1 or 12.2.2, theAP_R115_UPGRADE
table is utilized in scenarios such as:
- Payment Format Standardization: Converts legacy payment formats (e.g., BACS, SEPA) to the new standards supported in R12.
- Bank Account Validation: Ensures bank account details comply with updated validation rules.
- Payment Instruction Migration: Transforms payment instructions to leverage new features like XML-based payment files or enhanced approval workflows.
Technical Integration
The table interacts with other AP tables likeAP_PAYMENT_INSTRUCTIONS
, AP_BANK_ACCOUNTS
, and IBY_PAYMENT_FORMATS
. Upgrade scripts or concurrent programs (e.g., "Payment Format Upgrade") populate and process data in AP_R115_UPGRADE
, often invoking PL/SQL APIs to validate and transform records before committing them to production tables.
Post-Upgrade Considerations
After the upgrade, the table may retain historical data for rollback purposes or be purged during cleanup routines. Administrators should verify theSTATUS
column to identify failed records and address discrepancies. In EBS 12.2.2, the table may also integrate with Online Patching (ADOP) to minimize downtime during upgrades.
Conclusion
TheAP_R115_UPGRADE
table is a cornerstone of Oracle EBS upgrades, ensuring continuity in payment processing while adapting to new regulatory and functional demands. Its structured approach to data migration reduces risks and enhances the reliability of Accounts Payable operations post-upgrade.
-
Lookup Type: MANUAL VENDOR NUMBER
12.2.2
product: AP - Payables , meaning: Manual Vendor Number , description: Type of vendor number for manual number entry ,
-
Lookup Type: MANUAL VENDOR NUMBER
12.1.1
product: AP - Payables , meaning: Manual Vendor Number , description: Type of vendor number for manual number entry ,
-
Lookup Type: VENDOR NUMBER ENTRY
12.2.2
product: AP - Payables , meaning: Vendor Number Entry , description: Vendor number entry methods ,
-
Lookup Type: VENDOR NUMBER ENTRY
12.1.1
product: AP - Payables , meaning: Vendor Number Entry , description: Vendor number entry methods ,
-
Lookup Type: PURGE CATEGORY
12.2.2
product: AP - Payables , meaning: Purge Category , description: Categories determine the type of items that will be purged ,
-
Lookup Type: PURGE CATEGORY
12.1.1
product: AP - Payables , meaning: Purge Category , description: Categories determine the type of items that will be purged ,
-
Lookup Type: DISBURSEMENT TYPE
12.1.1
product: AP - Payables , meaning: Disbursement Type , description: Modes of payment ,
-
Lookup Type: DISBURSEMENT TYPE
12.2.2
product: AP - Payables , meaning: Disbursement Type , description: Modes of payment ,
-
Lookup Type: PAYMENT TYPE
12.1.1
product: AP - Payables , meaning: Meaning N/A for : PAYMENT TYPE , description: Payment Type ,
-
Lookup Type: PAYMENT TYPE
12.2.2
product: AP - Payables , meaning: Meaning N/A for : PAYMENT TYPE , description: Payment Type ,
-
Lookup Type: SOURCE
12.2.2
product: AP - Payables , meaning: Source , description: Source of invoice data to import from the Payables Open Interface ,
-
Lookup Type: SOURCE
12.1.1
product: AP - Payables , meaning: Source , description: Source of invoice data to import from the Payables Open Interface ,
-
Lookup Type: DOCUMENT_SEQUENCE_METHOD_CODE
12.1.1
product: AP - Payables , meaning: document sequence method code ,
-
Lookup Type: DOCUMENT_SEQUENCE_METHOD_CODE
12.2.2
product: AP - Payables , meaning: document sequence method code ,
-
Table: AP_R115_UPGRADE
12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_R115_UPGRADE, object_name:AP_R115_UPGRADE, status:VALID, product: AP - Payables , description: Release 11i upgrade values for FUTURE DATED and MANUAL FUTURE DATED payment methods , implementation_dba_data: AP.AP_R115_UPGRADE ,
-
Table: AP_R115_UPGRADE
12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_R115_UPGRADE, object_name:AP_R115_UPGRADE, status:VALID, product: AP - Payables , description: Release 11i upgrade values for FUTURE DATED and MANUAL FUTURE DATED payment methods , implementation_dba_data: AP.AP_R115_UPGRADE ,
-
Lookup Type: LINE SOURCE
12.1.1
product: AP - Payables , meaning: Line Source , description: Defines possible sources to capture source of creation of a line ,
-
Lookup Type: LINE SOURCE
12.2.2
product: AP - Payables , meaning: Line Source , description: Defines possible sources to capture source of creation of a line ,
-
Lookup Type: AWT FLAG
12.1.1
product: AP - Payables , meaning: Awt Flag , description: Withholding tax calculation types ,
-
Lookup Type: AWT FLAG
12.2.2
product: AP - Payables , meaning: Awt Flag , description: Withholding tax calculation types ,
-
Lookup Type: BANK CHARGE PAYMENT TYPE
12.1.1
product: AP - Payables , meaning: Bank Charge Payment Type , description: Payment type options when using bank charges ,
-
Lookup Type: BANK CHARGE PAYMENT TYPE
12.2.2
product: AP - Payables , meaning: Bank Charge Payment Type , description: Payment type options when using bank charges ,
-
Lookup Type: PREPAY DETAILS
12.1.1
product: AP - Payables , meaning: Prepay Details , description: Prepayment Entry detail regions and special functions ,
-
Lookup Type: PREPAY DETAILS
12.2.2
product: AP - Payables , meaning: Prepay Details , description: Prepayment Entry detail regions and special functions ,
-
Lookup Type: INVOICE MORE
12.2.2
product: AP - Payables , meaning: Invoice More , description: More options for invoice zone of invoice entry ,
-
Lookup Type: INVOICE MORE
12.1.1
product: AP - Payables , meaning: Invoice More , description: More options for invoice zone of invoice entry ,
-
View: AP_PAYMENT_EXTRACT_DETAILS_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:FND.AP_PAYMENT_EXTRACT_DETAILS_V SQLAP.AP_PAYMENT_EXTRACT_DETAILS_V, object_name:AP_PAYMENT_EXTRACT_DETAILS_V, status:VALID, product: AP - Payables , implementation_dba_data: APPS.AP_PAYMENT_EXTRACT_DETAILS_V ,
-
Lookup Type: NEXT STEP EXEC STATE
12.1.1
product: AP - Payables , meaning: Next Step Exec State , description: Values for the next step for a payment batch ,
-
Lookup Type: NEXT STEP EXEC STATE
12.2.2
product: AP - Payables , meaning: Next Step Exec State , description: Values for the next step for a payment batch ,
-
Concurrent Program: APXPBFOR
12.2.2
execution_filename: APXPBFOR , product: AP - Payables , user_name: APXPBFOR , description: Format Payments (Standard Oracle) , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
-
Concurrent Program: APXPBFOR
12.1.1
execution_filename: APXPBFOR , product: AP - Payables , user_name: APXPBFOR , description: Format Payments (Standard Oracle) , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
-
Concurrent Program: APXPBFOF
12.1.1
execution_filename: APXPBFOR , product: AP - Payables , user_name: APXPBFOR , description: Format Payments (Standard Oracle) , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
-
Concurrent Program: APXPBFOF
12.2.2
execution_filename: APXPBFOR , product: AP - Payables , user_name: APXPBFOR , description: Format Payments (Standard Oracle) , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
-
Concurrent Program: APXAPRST
12.1.1
execution_filename: APXAPRST , product: AP - Payables , user_name: APXAPRST , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
-
Concurrent Program: APXMPUPR
12.1.1
execution_filename: APXMPUPR , product: AP - Payables , user_name: APXMPUPR , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
-
Concurrent Program: APXIAWRE
12.1.1
execution_filename: APXIAWRE , product: AP - Payables , user_name: APXIAWRE , description: Invoice Approval Workflow , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
-
Concurrent Program: APTCMT
12.1.1
execution_filename: APXT7CMT , product: AP - Payables , user_name: APXT7CMT , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
-
Concurrent Program: APXTRRVT
12.1.1
execution_filename: APXT7RVT , product: AP - Payables , user_name: APXT7RVT , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
-
Concurrent Program: APXPBBLD
12.1.1
execution_filename: APXPBBLD , product: AP - Payables , user_name: APXPBBLD , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
-
Concurrent Program: APXVDVSR
12.2.2
execution_filename: APXVDVSR , product: AP - Payables , user_name: APXVDVSR , description: Suppliers Report , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
-
Concurrent Program: APXMTDCR
12.2.2
execution_filename: APXMTDCR , product: AP - Payables , user_name: APXMTDCR , description: Payment Register , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
-
Concurrent Program: APXTRRVT
12.2.2
execution_filename: APXT7RVT , product: AP - Payables , user_name: APXT7RVT , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
-
Concurrent Program: APXT7F99P
12.1.1
execution_filename: APXT7F99 , product: AP - Payables , user_name: APXT7F99 , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
-
Concurrent Program: APXQCQCL
12.2.2
execution_filename: APXQCQCL , product: AP - Payables , user_name: APXQCQCL , description: QuickCode Listing , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
-
Concurrent Program: APXATR
12.1.1
execution_filename: APXARATE , product: AP - Payables , user_name: APXARATE , description: AutoRate Program , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
-
Concurrent Program: APINVSEL
12.1.1
execution_filename: APINVSEL , product: AP - Payables , user_name: APINVSEL , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
-
Concurrent Program: APXTRF96
12.1.1
execution_filename: APXT7F96 , product: AP - Payables , user_name: APXT7F96 , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
-
Concurrent Program: APXMPUPR
12.2.2
execution_filename: APXMPUPR , product: AP - Payables , user_name: APXMPUPR , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
-
Concurrent Program: APXATR
12.2.2
execution_filename: APXARATE , product: AP - Payables , user_name: APXARATE , description: AutoRate Program , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
-
Concurrent Program: APXINDIA
12.1.1
execution_filename: APXINDIA , product: AP - Payables , user_name: APXINDIA , description: Discounts Available Report , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,