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!
maheshku

R12 ar - xla - gl 2015-04-09

R12 ar - xla - gl

  1. maheshku
    AR - GL
    When you run the Create Accounting program :
    to create draft or final sub ledger accounting, the program uses the predefined data to determine how to create the accounting. Receivables predefine setup for Sub ledger accounting so that the Create Accounting program accepts the default accounting information from Auto Accounting without change.

    Tables from where data is going:

    • RA_CUST_TRX_LINE_GL_DIST_ALL
    • AR_DISTRIBUTIONS_ALL
    • AR_MISC_CASH_DISTRIBUTIONS_ALL
    AND from here data will hit the XLA tables

    • XLA_EVENTS
    • XLA_AE_HEADERS
    • XLA_AE_LINES
    • XLA_DISTRIBUTION_LINKS
    MAPPING OF TABLES – AR TO GL WITH AR TO SLA TO GL
    ACTION: COMPLETE TRANSACTION:

    RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID= RA_CUST_TRX_LINE_GL_DIST_ALL.CUSTOMER_TRX_ID
    RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID = XLA_TRANSACTION_ENTITIES.SOURCE_ID_INT_1
    XLA_TRANSACTION_ENTITIES.ENTITY_ID = XLA_EVENTS.ENTITY_ID

    ACTION: RUN CREATE ACCOUNTING:

    RA_CUST_TRX_LINE_GL_DIST_ALL.CUST_TRX_LINE_GL_DIST_ID = XLA_DISTRIBUTION_LINKS.SOURCE_DISTRIBUTION_ID_NUM_1
    XLA_AE_LINES.AE_HEADER_ID = XLA_DISTRIBUTION_LINKS.AE_HEADER_ID
    XLA_AE_HEADERS.AE_HEADER_ID = XLA_DISTRIBUTION_LINKS.AE_HEADER_ID

    ACTION: RUN TRANSFER TO GL:
    • GL_JE_BATCHES
    • GL_JE_HEADERS
    • GL_JE_LINES
    XLA_AE_LINES.GL_SL_LINE_ID = GL_JE_LINES.GL_SL_LINK_ID
    XLA_AE_LINES.GL_SL_LINK_ID = GL_IMPORT_REFERENCES.GL_SL_LINK_ID
    GL_IMPORT_REFERENCES.JE_HEADER_ID = GL_JE_LINES.JE_HEADER_ID
    GL_IMPORT_REFERENCES.HE_HEADER_ID = GL_JE_HEADERS.JE_HEADER_ID
    GL_JE_BATCHES (je_batch_id) => GL_JE_HEADERS (je_batch_id)
    GL_JE_HEADERS (je_header_id) => GL_JE_LINES (je_header_id)
    GL_JE_LINES (je_header_id, je_line_num) => GL_IMPORT_REFERENCES (je_header_id, je_line_num)
    GL_IMPORT_REFERENCES(gl_sl_link_table,gl_sl_link_id) => XLA_AE_LINES(gl_sl_link_table, gl_sl_link_id)
    XLA_AE_LINES (application_id, ae_header_id) => XLA_AE_HEADERS (application_id, ae_header_id)
    XLA_AE_HEADERS (application_id, event_id) => XLA_EVENTS (application_id, event_id)
    XLA_EVENTS (application_id, entity_id) => XLA.XLA_TRANSACTION_ENTITIES (application_id, entity_id)

    ACTION: POST JOURNALS: GL_BALANCES
    4. Create accounting in Oracle Subledger Accounting and transfer the accounting entries to Oracle General Ledger. Depending on the parameter values you select, the create accounting process performs the following tasks:
    • Creates subledger accounting entries for unaccounted accounting events.
    Note: If you define your own detailed accounting rules in Oracle Subledger Accounting, then Oracle Subledger Accounting overwrites default accounts, or individual segments of accounts, that Oracle Receviables derives using AutoAccounting.
    • Transfers accounting entries to the Oracle General Ledger interface tables.
    • Initiates the journal import process in Oracle General Ledger. The journal import process uses the summary interface information stored in the Oracle
    General Ledger interface tables and automatically creates journal entries for posting in Oracle General Ledger.
    • Initiates posting of journal entries in Oracle General Ledger. Note: You can optionally run the Subledger Period Close Exceptions Report to view information about unprocessed accounting events,
    accounting events in error, and transactions that are successfully accounted in final mode in Oracle Subledger Accounting, but not posted in Oracle General Ledger. This report provides you with the
    ability to separately tie back and determine whether accounting entries are posted in Oracle General Ledger.

    The program creates and, optionally, transfers and posts journal entries to General Ledger. If you do not transfer the journals to General Ledger immediately, you can later submit Transfer Journal Entries to GL concurrent program.
    Important: Final journal entries cannot be further modified in Cash Management. Please make sure you are satisfied with the draft journal entries before creating final accounting. In addition to creating final accounting entries, the program can be run in a draft mode, in which case draft journal entries will be created. Such journals cannot be transferred or posted to GL.
    Creating Journal Entries Manually
    Accounting entries for Bank Account Transfers and Bank Statement Cash Flows are created automatically. However, if you would like to create a journal entry that is not related to Bank Account Transfers or Bank Statement Cash Flows, you can do so manually using the Create Subledger Journal Entry page.
    To create journal entries manually:
    1. Navigate to the Subledger Journal Entries page.
    2. Click Create Journal Entry.
    3. Enter Balance Type, GL Date, Ledger, Category, Description and other attributes as needed.
    4. Select GL accounts and enter debit and credit amounts.
    5. Click Save as Incomplete, if you plan to return to this entry and finalize it at a later date, or click Continue.
    6. Review your journal entry, select completion status and click Finish to validate and finalize your entry.
    Transferring Journal Entries to General Ledger
    You can transfer automatically created journal entries to General Ledger at the same time as you execute Create Accounting concurrent program. However, if have not done so or if you have created manual journals, you can submit Transfer Journal Entries to GL concurrent program.
    Viewing Journal Entries
    You can view journal entry created in Cash Management in the Subledger Journal Entries page.
    To view journal entries:
    1. Navigate to the Subledger Journal Entries page.
    2. Enter search criteria and click Go.
    3. Review search results.
    Updating Manual Journal Entries
    You can only update manual journal entries in status Draft, Incomplete, or Error.
    To update manual journal entries:
    1. Navigate to the Subledger Journal Entries page.
    2. Enter search criteria and click Go.
    3. Select journal entry and click Update.
    4. Modify journal entry as necessary.
    5. Click Save as Incomplete, if you plan to return to this entry and finalize it at a later
    date, or click Continue.
    6. Review your journal entry, select completion status and click Finish to validate and
    finalize your entry.
    Deleting Manual Journal Entries
    You can only delete manual journal entries in status Draft, Incomplete, or Error.
    To delete manual journal entries:
    1. Navigate to the Subledger Journal Entries page.
    2. Enter search criteria and click Go.
    3. Select journal entry and click Delete.
    4. Click Yes to confirm your choice or No to keep the journal entry.