Transactions

• Oracle Interface Tables — Oracle provides the following Interface Tables for Transactions:

  • mtl_transactions_interface

  • mtl_transaction_lots_interface

  • mtl_serial_numbers_interface

• Sun Staging Tables — The Oracle Applications Adapter sets up the following staging tables, corresponding to the Oracle Open Interface Tables listed above:

  • sb_mtl_transactions_interface

  • sb_mtl_transaction_lots_inter

  • sb_mtl_serial_numbers_interface

• Pre-Validation Scripts — The scripts corresponding to the Sun Staging Tables listed above are packaged within the following files:

  • sb_validate_trans_pkg.sql

  • sb_validate_trans_lots_pkg.sql

  • sb_validate_serial_nos_pkg.sql

  These files are controlled by the following master validation file:

  sb_validate_tran_all_pkg.sql