Table Changes in Oracle General Ledger Tables Release 12 from 11i

Introduction

This article is about the changes which have been done to existing General Ledger tables in Release R12 as compared to 11i.

GL_BALANCES 

Added quarter_to_date_dr_beq, quarter_to_date_cr_beq, project_to_date_dr_beq and project_to_date_cr_beq columns as extra in r12 to store entered ledger currency balances 

GL_CODE_COMBINATIONS 

Added alternate_code_combination_id column to support replacement for disabled accounts functionality implemented by Journal Import 

GL_INTERFACE 

Added ledger_id and retain set_of_books_id in r12 for backward compatibility 

GL_JE_BATCHES 

Dropped set_of_books_id and add chart_of_accounts_id, period_set_name and accounting_period_type to support batches containing journals for multiple ledgers sharing the same chart of accounts and calendar 

GL_JE_HEADERS 

Added columns to store the accounting and reporting sequences

GL_PERIOD_STATUSES 

Added ledger_id and retain set_of_books_id for backward compatibility 

MISC

GL_SETS_OF_BOOKS is replaced in R12 as GL_LEDGERS 

GL_TRANSLATION_RATES is replaced in R12 as GL_DAILY_RATES 

The set_of_books_id column has been renamed to ledger_id in all tables with some exceptions.