Customers

• 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