Search Results interface




The RA_CUST_PAY_METHOD_INT_ALL table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a critical interface table within the Receivables (AR) module. It serves as a staging area for importing or processing customer payment method data before it is validated and transferred to the base tables. This table is primarily used in scenarios involving bulk data uploads, integrations with third-party systems, or data migration activities. Below is a detailed breakdown of its structure, purpose, and usage in Oracle EBS.

Purpose and Functionality

The RA_CUST_PAY_METHOD_INT_ALL table acts as an intermediary repository for payment method data associated with customers. It allows organizations to validate and process payment method records before they are committed to the permanent tables, such as RA_CUSTOMER_PAY_METHODS. This ensures data integrity and reduces errors in the transactional environment. Key functionalities include:
  • Data Validation: The table enables validation of payment method attributes (e.g., credit card details, bank accounts) before they are processed.
  • Bulk Data Loading: Facilitates the import of large volumes of payment method data from external sources (e.g., legacy systems, spreadsheets).
  • Integration Support: Serves as an interface for third-party systems (e.g., payment gateways, ERP systems) to submit payment method updates.

Table Structure

The table contains columns that store payment method details, customer references, and processing flags. Some key columns include:
  • INTERFACE_ID: Primary key identifier for each record in the interface table.
  • CUSTOMER_ID: References the customer in RA_CUSTOMERS.
  • PAYMENT_METHOD_CODE: Specifies the payment method (e.g., "CREDIT_CARD", "BANK_TRANSFER").
  • CREDIT_CARD_TYPE, CARD_NUMBER, EXPIRATION_DATE: Stores credit card details (if applicable).
  • BANK_ACCOUNT_NUMBER, BANK_ROUTING_NUMBER: Captures bank account information for direct debit methods.
  • STATUS_FLAG: Indicates the processing status (e.g., "P" for Pending, "E" for Error).
  • ERROR_MESSAGE: Stores validation errors if the record fails processing.

Data Flow and Processing

Records in RA_CUST_PAY_METHOD_INT_ALL are typically processed using Oracle's standard interface programs, such as the "Customer Interface" concurrent request. The workflow involves:
  1. Data Insertion: Records are inserted into the interface table via SQL scripts, APIs, or data loading tools like SQL*Loader.
  2. Validation: The interface program validates data against Oracle AR rules (e.g., valid customer IDs, payment method codes).
  3. Error Handling: Failed records are flagged with an error status and message for correction.
  4. Transfer to Base Tables: Valid records are moved to RA_CUSTOMER_PAY_METHODS and related tables.

Common Use Cases

  • Migration Projects: Used during upgrades or system consolidations to migrate payment methods from legacy systems.
  • Automated Payment Processing: Integrates with payment processors to update customer payment details.
  • Batch Updates: Enables bulk updates to customer payment methods (e.g., expiring credit cards).

Best Practices

  • Always validate data before loading it into the interface table to minimize errors.
  • Use the AR_PAYMENT_INTERFACE_PKG API for programmatic inserts/updates.
  • Monitor the STATUS_FLAG and ERROR_MESSAGE columns to troubleshoot failed records.
  • Archive processed records to maintain performance.
In summary, RA_CUST_PAY_METHOD_INT_ALL is a pivotal component in Oracle EBS for managing customer payment method data efficiently and securely. Its design supports high-volume data operations while ensuring compliance with Oracle AR's business rules.

  • Lookup Type: AR_MATCH_DATE_OPTIONS 12.2.2

    product: AR - Receivables ,  meaning: AR Match Date Options ,  description: AR Match Date Options , 

  • Lookup Type: TAX_INTERFACE_CONTROL 12.2.2

    product: AR - Receivables ,  meaning: Tax Interface Control ,  description: Tax Interface Upload Control Option , 

  • Lookup Type: TAX_INTERFACE_CONTROL 12.1.1

    product: AR - Receivables ,  meaning: Tax Interface Control ,  description: Tax Interface Upload Control Option , 

  • Concurrent Program: ARHDIDIW 12.1.1

    execution_filename: HZ_IMP_DQM_STAGE.interface_dup_id_worker ,  product: AR - Receivables ,  user_name: Interface Duplicate Identification Worker ,  description: Interface Duplicate Identification Worker ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: ARHDIDIP 12.1.1

    execution_filename: HZ_IMP_DQM_STAGE.interface_dup_id ,  product: AR - Receivables ,  user_name: Interface Duplicate Identification Parent ,  description: Interface Duplicate Identification Parent ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: ARHDIDIW 12.2.2

    execution_filename: HZ_IMP_DQM_STAGE.interface_dup_id_worker ,  product: AR - Receivables ,  user_name: Interface Duplicate Identification Worker ,  description: Interface Duplicate Identification Worker ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: AREXCUSP 12.1.1

    execution_filename: ar_exchange_interface.ar_customer_interface ,  product: AR - Receivables ,  user_name: Exchange Customer Interface ,  description: Oracle Exchange Customer Interface Data Feeder Program ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: AREXINVP 12.1.1

    execution_filename: ar_exchange_interface.ar_invoice_interface ,  product: AR - Receivables ,  user_name: Exchange Invoice Interface ,  description: Oracle Exchange Invoice Interface Data Feeder Program ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: AREXCUSP 12.2.2

    execution_filename: ar_exchange_interface.ar_customer_interface ,  product: AR - Receivables ,  user_name: Exchange Customer Interface ,  description: Oracle Exchange Customer Interface Data Feeder Program ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: ARHDIDIP 12.2.2

    execution_filename: HZ_IMP_DQM_STAGE.interface_dup_id ,  product: AR - Receivables ,  user_name: Interface Duplicate Identification Parent ,  description: Interface Duplicate Identification Parent ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: AREXINVP 12.2.2

    execution_filename: ar_exchange_interface.ar_invoice_interface ,  product: AR - Receivables ,  user_name: Exchange Invoice Interface ,  description: Oracle Exchange Invoice Interface Data Feeder Program ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: RACUST 12.1.1

    execution_filename: RACUST ,  product: AR - Receivables ,  user_name: RACUST ,  description: Customer Interface ,  argument_method: Database fetch ,  enabled: Yes ,  execution_method: Spawned , 

  • Concurrent Program: ARITXI 12.2.2

    execution_filename: ARITXI ,  product: AR - Receivables ,  user_name: ARITXI ,  description: Sales Tax Rate Interface ,  argument_method: Standard ,  enabled: No ,  execution_method: Oracle Reports , 

  • Concurrent Program: ARGCGP 12.1.1

    execution_filename: ARGCGP ,  product: AR - Receivables ,  user_name: ARGCGP ,  description: Clear AR Entries from GL Interface ,  argument_method: Database fetch ,  enabled: Yes ,  execution_method: Spawned , 

  • Concurrent Program: RACUST 12.2.2

    execution_filename: RACUST ,  product: AR - Receivables ,  user_name: RACUST ,  description: Customer Interface ,  argument_method: Database fetch ,  enabled: Yes ,  execution_method: Spawned , 

  • Concurrent Program: RACUSTMA 12.1.1

    execution_filename: hz_customer_int.conc_main ,  product: AR - Receivables ,  user_name: RACUSTMA ,  description: Customer Interface Master Conc Program ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: RACUSTMA 12.2.2

    execution_filename: hz_customer_int.conc_main ,  product: AR - Receivables ,  user_name: RACUSTMA ,  description: Customer Interface Master Conc Program ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: ARGCGP 12.2.2

    execution_filename: ARGCGP ,  product: AR - Receivables ,  user_name: ARGCGP ,  description: Clear AR Entries from GL Interface ,  argument_method: Database fetch ,  enabled: Yes ,  execution_method: Spawned , 

  • Concurrent Program: RACUSTSB 12.1.1

    execution_filename: RACUST ,  product: AR - Receivables ,  user_name: RACUST ,  description: Customer Interface ,  argument_method: Database fetch ,  enabled: Yes ,  execution_method: Spawned , 

  • Concurrent Program: RACUSTSB 12.2.2

    execution_filename: RACUST ,  product: AR - Receivables ,  user_name: RACUST ,  description: Customer Interface ,  argument_method: Database fetch ,  enabled: Yes ,  execution_method: Spawned , 

  • Concurrent Program: ARITXI 12.1.1

    execution_filename: ARITXI ,  product: AR - Receivables ,  user_name: ARITXI ,  description: Sales Tax Rate Interface ,  argument_method: Standard ,  enabled: No ,  execution_method: Oracle Reports , 

  • Lookup Type: PMT_INTERFACE_STATUS 12.1.1

    product: AR - Receivables ,  meaning: Pmt Interface Status ,  description: Payment Interface Status , 

  • Lookup Type: PMT_INTERFACE_STATUS 12.2.2

    product: AR - Receivables ,  meaning: Pmt Interface Status ,  description: Payment Interface Status , 

  • Lookup Type: TAX_INTERFACE_PRINT_OPTION 12.1.1

    product: AR - Receivables ,  meaning: Tax Interface Print Option ,  description: Tax Interface Printing Control Option , 

  • Lookup Type: TAX_INTERFACE_PRINT_OPTION 12.2.2

    product: AR - Receivables ,  meaning: Tax Interface Print Option ,  description: Tax Interface Printing Control Option , 

  • Concurrent Program: RAXMTR 12.2.2

    execution_filename: RAXMTR ,  product: AR - Receivables ,  user_name: RAXMTR ,  description: Interface your transactions to Oracle Receivables ,  argument_method: Database fetch ,  enabled: Yes ,  execution_method: Spawned , 

  • Concurrent Program: RAXTRX 12.2.2

    execution_filename: RAXTRX ,  product: AR - Receivables ,  user_name: RAXTRX ,  description: Interface your transactions to Oracle Receivables ,  argument_method: Database fetch ,  enabled: Yes ,  execution_method: Spawned , 

  • Concurrent Program: ARGLTP 12.2.2

    execution_filename: ARGLTP ,  product: AR - Receivables ,  user_name: ARGLTP ,  description: Oracle Receivables Interface to Oracle General Ledger ,  argument_method: Database fetch ,  enabled: Yes ,  execution_method: Spawned , 

  • Concurrent Program: ARGLTP 12.1.1

    execution_filename: ARGLTP ,  product: AR - Receivables ,  user_name: ARGLTP ,  description: Oracle Receivables Interface to Oracle General Ledger ,  argument_method: Database fetch ,  enabled: Yes ,  execution_method: Spawned , 

  • Concurrent Program: RAXMTR 12.1.1

    execution_filename: RAXMTR ,  product: AR - Receivables ,  user_name: RAXMTR ,  description: Interface your transactions to Oracle Receivables ,  argument_method: Database fetch ,  enabled: Yes ,  execution_method: Spawned , 

  • Concurrent Program: RAXTRX 12.1.1

    execution_filename: RAXTRX ,  product: AR - Receivables ,  user_name: RAXTRX ,  description: Interface your transactions to Oracle Receivables ,  argument_method: Database fetch ,  enabled: Yes ,  execution_method: Spawned , 

  • Concurrent Program: RAXDEL 12.2.2

    execution_filename: RAXDEL ,  product: AR - Receivables ,  user_name: AutoInvoice Purge Program ,  description: Purge processed transactions in the AutoInvoice Interface tables ,  argument_method: Database fetch ,  enabled: Yes ,  execution_method: Spawned , 

  • Concurrent Program: RAXDEL 12.1.1

    execution_filename: RAXDEL ,  product: AR - Receivables ,  user_name: AutoInvoice Purge Program ,  description: Purge processed transactions in the AutoInvoice Interface tables ,  argument_method: Database fetch ,  enabled: Yes ,  execution_method: Spawned , 

  • Concurrent Program: ARHLDDNB2 12.1.1

    execution_filename: arhldnb2 ,  product: AR - Receivables ,  user_name: ARHLDDNB2 ,  description: Load D&B Batch flat file into HZ interface tables - second pass ,  argument_method: Standard ,  enabled: Yes ,  execution_method: SQL*Plus , 

  • Concurrent Program: ARHLDDNB1 12.2.2

    execution_filename: arhldnb1 ,  product: AR - Receivables ,  user_name: ARHLDDNB1 ,  description: Load D&B Batch flat file into HZ interface tables - first pass ,  argument_method: Standard ,  enabled: Yes ,  execution_method: SQL*Plus , 

  • Concurrent Program: ARHLDDNB2 12.2.2

    execution_filename: arhldnb2 ,  product: AR - Receivables ,  user_name: ARHLDDNB2 ,  description: Load D&B Batch flat file into HZ interface tables - second pass ,  argument_method: Standard ,  enabled: Yes ,  execution_method: SQL*Plus , 

  • Concurrent Program: ARHLDDNB1 12.1.1

    execution_filename: arhldnb1 ,  product: AR - Receivables ,  user_name: ARHLDDNB1 ,  description: Load D&B Batch flat file into HZ interface tables - first pass ,  argument_method: Standard ,  enabled: Yes ,  execution_method: SQL*Plus , 

  • Lookup Type: TAX_INTERFACE_ACTION 12.2.2

    product: AR - Receivables ,  meaning: Tax Interface Action ,  description: Tax Interface Actions , 

  • Lookup Type: TAX_INTERFACE_ACTION 12.1.1

    product: AR - Receivables ,  meaning: Tax Interface Action ,  description: Tax Interface Actions , 

  • Table: RA_CUST_PAY_METHOD_INT_ALL 12.2.2

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.RA_CUST_PAY_METHOD_INT_ALL,  object_name:RA_CUST_PAY_METHOD_INT_ALL,  status:VALID,  product: AR - Receivables ,  description: Customer Interface table for Payment Methods ,  implementation_dba_data: AR.RA_CUST_PAY_METHOD_INT_ALL , 

  • Table: RA_CUSTOMER_PROFILES_INT_ALL 12.2.2

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.RA_CUSTOMER_PROFILES_INT_ALL,  object_name:RA_CUSTOMER_PROFILES_INT_ALL,  status:VALID,  product: AR - Receivables ,  description: Customer Interface table for customer profile information ,  implementation_dba_data: AR.RA_CUSTOMER_PROFILES_INT_ALL , 

  • Table: RA_CONTACT_PHONES_INT_ALL 12.2.2

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.RA_CONTACT_PHONES_INT_ALL,  object_name:RA_CONTACT_PHONES_INT_ALL,  status:VALID,  product: AR - Receivables ,  description: Used by Customer Interface to import contact and telephone information ,  implementation_dba_data: AR.RA_CONTACT_PHONES_INT_ALL , 

  • Table: RA_CUSTOMER_PROFILES_INT_ALL 12.1.1

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.RA_CUSTOMER_PROFILES_INT_ALL,  object_name:RA_CUSTOMER_PROFILES_INT_ALL,  status:VALID,  product: AR - Receivables ,  description: Customer Interface table for customer profile information ,  implementation_dba_data: AR.RA_CUSTOMER_PROFILES_INT_ALL , 

  • Table: RA_CUSTOMERS_INTERFACE_ALL 12.2.2

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.RA_CUSTOMERS_INTERFACE_ALL,  object_name:RA_CUSTOMERS_INTERFACE_ALL,  status:VALID,  product: AR - Receivables ,  description: Customer Interface table ,  implementation_dba_data: AR.RA_CUSTOMERS_INTERFACE_ALL , 

  • Table: AR_BR_STATUS_SUM_ITF 12.2.2

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.AR_BR_STATUS_SUM_ITF,  object_name:AR_BR_STATUS_SUM_ITF,  status:VALID,  product: AR - Receivables ,  description: RXi report interface table for the Bills Receivable by Status report ,  implementation_dba_data: AR.AR_BR_STATUS_SUM_ITF , 

  • Table: AR_BR_STATUS_REP_ITF 12.2.2

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.AR_BR_STATUS_REP_ITF,  object_name:AR_BR_STATUS_REP_ITF,  status:VALID,  product: AR - Receivables ,  description: RXi report interface table for the Bills Receivable by Status report ,  implementation_dba_data: AR.AR_BR_STATUS_REP_ITF , 

  • Table: RA_CUST_PAY_METHOD_INT_ALL 12.1.1

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.RA_CUST_PAY_METHOD_INT_ALL,  object_name:RA_CUST_PAY_METHOD_INT_ALL,  status:VALID,  product: AR - Receivables ,  description: Customer Interface table for Payment Methods ,  implementation_dba_data: AR.RA_CUST_PAY_METHOD_INT_ALL , 

  • Table: AR_SALES_TAX_REP_ITF 12.1.1

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.AR_SALES_TAX_REP_ITF,  object_name:AR_SALES_TAX_REP_ITF,  status:VALID,  product: AR - Receivables ,  description: Report Exchange interface table for the US Sales Tax report ,  implementation_dba_data: AR.AR_SALES_TAX_REP_ITF , 

  • Table: RA_CONTACT_PHONES_INT_ALL 12.1.1

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.RA_CONTACT_PHONES_INT_ALL,  object_name:RA_CONTACT_PHONES_INT_ALL,  status:VALID,  product: AR - Receivables ,  description: Used by Customer Interface to import contact and telephone information ,  implementation_dba_data: AR.RA_CONTACT_PHONES_INT_ALL , 

  • Table: AR_BR_STATUS_SUM_ITF 12.1.1

    owner:AR,  object_type:TABLE,  fnd_design_data:AR.AR_BR_STATUS_SUM_ITF,  object_name:AR_BR_STATUS_SUM_ITF,  status:VALID,  product: AR - Receivables ,  description: RXi report interface table for the Bills Receivable by Status report ,  implementation_dba_data: AR.AR_BR_STATUS_SUM_ITF ,