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