The Oracle Accounts Receivable module works with other Oracle Financial modules to provide a complete set of transactions and reports for maintaining accounts receivable control.
Oracle Interface Tables — Oracle provides the following Interface Table for Requisitions:
ra_interface_distributions
ra_interface_lines_all
ra_interface_salescredits_all
Sun Staging Tables — The Oracle Applications Adapter sets up the following staging table, corresponding to the Oracle Open Interface Table listed above:
sb_ra_interface_distributions
sb_ra_interface_lines_all
sb_ra_interface_salescredits_all
Pre-Validation Scripts — The scripts corresponding to the Sun Staging Tables listed above are packaged within the following files:
sb_validate_ra_dist_pkg.sql
sb_validate_ra_lines_pkg.sql
sb_validate_ra_sales_cr_pkg.sql
This file is controlled by the following master validation file:
sb_validate_auto_inv_pkg.sql
Oracle Interface Tables — Oracle provides the following Interface Table for Requisitions:
ar_payments_interface_all
Sun Staging Tables — The Oracle Applications Adapter sets up the following staging table, corresponding to the Oracle Open Interface Table listed above:
sb_ar_payments_interface_all
Pre-Validation Scripts — The scripts corresponding to the Sun Staging Tables listed above are packaged within the following file:
sb_validate_ar_payments_pkg.sql
This file is controlled by the following master validation file:
sb_validate_auto_lock_pkg.sql
Oracle Interface Tables — Oracle provides the following Interface Table for Requisitions:
ra_customers_interface
ra_contact_phones_int_all
ra_cust_pay_method_interface
ra_customer_banks_int_all
ra_customer_profiles_interface
Sun Staging Tables — The Oracle Applications Adapter sets up the following staging table, corresponding to the Oracle Open Interface Table listed above:
sb_ra_customers_interface
sb_ra_contact_phones_int_all
sb_ra_cust_pay_method_interface
sb_ra_customer_banks_int_all
sb_ra_customer_profiles_interface
Pre-Validation Scripts — The scripts corresponding to the Sun Staging Tables listed above are packaged within the following files:
sb_validate_cust_pkg.sql
sb_validate_contact_phones_pkg.sql
sb_validate_cust_pay_mtd_pkg.sql
sb_validate_cust_banks_pkg.sql
sb_validate_cust_profiles_pkg.sql
This file is controlled by the following master validation file:
sb_validate_customers_pkg.sql