Oracle Applications Financial Module

The Financial module is divided into the following sub-modules:

• Accounts Payable Module.

• Accounts Receivable Module.

• Cash Management Module.

• Fixed Assets Module.

• General Ledger Module.

Accounts Payable Module

The Oracle Accounts Payable module works with other Oracle Financial modules to provide a complete set of transactions and reports for maintaining accounts payable control.

Accounts Payable Module

• Oracle Interface Tables — Oracle provides the following Interface Table for Requisitions:

  • ap_invoices_interface

  • ap_invoice_lines_interface

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

  • sb_ap_invoices_interface

  • sb_ap_invoice_lines_interface

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

  • sb_validate_ap_inv_pkg.sql

  • sb_validate_ap_inv_lines_pkg.sql

  These files are controlled by the following master validation file:

  sb_validate_payable_pkg.sql

Accounts Receivable Module

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.

Auto Invoice

• 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

Auto Lock

• 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

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

Cash Management Module

The Oracle Cash Management module works with other Oracle Financial modules to provide a complete set of transactions and reports for maintaining cash management control.

Bank Statement

• Oracle Interface Tables — Oracle provides the following Interface Table for Requisitions:

  • ce_statement_headers_int_all

  • ce_statement_lines_interface

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

  • sb_ce_statement_headers_int_all

  • sb_ce_statement_lines_interface

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

  • sb_validate_stmt_headers_pkg.sql

  • sb_validate_stmt_lines_pkg.sql

  These files are controlled by the following master validation file:

  sb_validate_bank_stmt_pkg.sql

Fixed Assets Module

The Oracle Fixed Assets module works with other Oracle Financial modules to provide a complete set of transactions and reports for maintaining fixed asset control.

Categories

• Oracle Interface Tables — Oracle provides the following Interface Table for Requisitions:

  • fa_categories_b

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

  • sb_fa_categories_b

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

  • sb_validate_cat_pkg.sql

  This file is controlled by the following master validation file:

  sb_validate_fa_categories_pkg.sql

Locations

• Oracle Interface Tables — Oracle provides the following Interface Table for Requisitions:

  • fa_locations

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

  • sb_fa_locations

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

  • sb_validate_loc_pkg.sql

  These files are controlled by the following master validation file:

  sb_validate_fa_locations_pkg.sql

Mass Additions

• Oracle Interface Tables — Oracle provides the following Interface Table for Requisitions:

  • fa_mass_additions

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

  • sb_fa_mass_additions

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

  • sb_validate_additions_pkg.sql

  These files are controlled by the following master validation file:

  sb_validate_fa_mass_add_pkg.sql

General Ledger Module

The Oracle General Ledger module works with other Oracle Financial modules to provide a complete set of transactions and reports for maintaining general ledger control.

Budget

• Oracle Interface Tables — Oracle provides the following Interface Table for Requisitions:

  • gl_budget_interface

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

  • sb_gl_budget_interface

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

  • sb_validate_gl_budget_pkg.sql

  These files are controlled by the following master validation file:

  sb_validate_budget_pkg.sql

Daily Rates

• Oracle Interface Tables — Oracle provides the following Interface Table for Requisitions:

  • gl_daily_rates_interface

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

  • sb_gl_daily_rates_interface

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

  • sb_validate_gl_daily_rates_pkg.sql

  These files are controlled by the following master validation file:

  sb_validate_dailyrates_pkg.sql

Journal

• Oracle Interface Tables — Oracle provides the following Interface Table for Requisitions:

  • gl_interface

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

  • sb_gl_interface

• Oracle Applications Adapter — The scripts corresponding to the Sun Staging Tables listed above are packaged within the following files:

  • sb_validate_gl_int_pkg.sql

  These files are controlled by the following master validation file:

  sb_validate_journal_pkg.sql