Oracle Apps Finance Functional Training and Certification

Oracle Applications comprise the applications software or business software of the Oracle Corporation. The term refers to the non-database and non-middleware parts of Oracle's software portfolio.

Oracle sells many functional modules which use the Oracle RDBMS as a back-end, notably Oracle Financials, Oracle HRMS, Oracle SCM, Oracle Projects, Oracle CRM, Oracle Procurement, etc.

Oracle initially launched its application suite with financials software in the late 1980s. The offering as of 2009 extends to supply-chain management, human-resource management, warehouse-management, customer-relationship management, call-center services, product

Oracle Applications Financial Module

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

• Accounts Payable Module.

• Oracle Applications Accounts Receivable Module.

• Oracle Applications Cash Management Module.

• Oracle Applications Fixed Assets Module.

• Oracle Applications General Ledger Module.

Oracle Applications 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

• Java CAPS 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 Java CAPS 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

Oracle Applications 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. If anyone want to get oracle apps finance functional training in Chennai, Please visit Greens Technologies oracle apps finance functional training located at Chennai Adyar which offer Best oracle apps Finance functional training in Chennai, Best oracle apps finance functional training in Chennai.

Auto Invoice

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

  • ra_interface_distributions

  • ra_interface_lines_all

  • ra_interface_salescredits_all

• Java CAPS 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 Java CAPS 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

• Java CAPS 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 Java CAPS 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

• Java CAPS 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 Java CAPS 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

Oracle Applications 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

• Java CAPS 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 Java CAPS 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

Oracle Applications 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

• Java CAPS 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 Java CAPS 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

• Java CAPS 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 Java CAPS 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

• Java CAPS 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 Java CAPS 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

Oracle Applications 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

• Java CAPS 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 Java CAPS 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

• Java CAPS 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 Java CAPS 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

• Java CAPS 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 Java CAPS 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