1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

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

Discussion in 'Oracle Apps Technical' started by abhi, Dec 30, 2011.

  1. abhi

    abhi Active Member

    Messages:
    6
    Likes Received:
    1
    Trophy Points:
    85
    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.
     
  2. Thanks Abhi, its really good.
     
  3. club

    club Active Member

    Messages:
    31
    Likes Received:
    1
    Trophy Points:
    185
    Thanks Abhi for sharing such a useful information:p
     
  4. nareshkuma

    nareshkuma Active Member

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    75
    Thank you for sharing doc.
     
  5. naresh.apps

    naresh.apps Active Member

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    75
    Location:
    Hyderabad
    Thanks Abhi...