Saturday, 15 November 2014

Difference between Draft, Final and Final Post in Create Accounting (R12)

 Create Accounting for Single Entity

DRAFT :  It will create Journal Entries, which are NOT final, which means they are NOT ready to be transferred to GL.
·         You can see the accounting in XLA_AE_HEADERS and XLA_AE_LINES.
XLA_AE_HEADERS.accounting_entry_status_code is 'D'
XLA_EVENTS.process_status_code is 'D'
XLA_EVENTS.event_status_code is 'U'

·         You can run create accounting on this transaction again and again, which will delete the old journal entries and create new ones.
·         You can't transfer these journal entries to GL.

FINAL: It will create journal entries, which can be transferred to GL.

·         You can see the accounting in XLA_AE_HEADERS and XLA_AE_LINES.
              XLA_AE_HEADERS.accounting_entry_status_code is 'F'
              XLA_EVENTS.process_status_code is 'P'
              XLA_EVENTS.event_status_code is 'P'

·         Once it is finally accounted you can NOT run create accounting on the particular transaction (specifically on that event).
·         You can transfer them to GL using Transfer Journal Entries to GL program.

FINAL POST: It will create journal entries in Final Mode, Transfer them to GL and Post them.
·         You can see the accounting in XLA_AE_HEADERS and XLA_AE_LINES.
             XLA_AE_HEADERS.accounting_entry_status_code is 'F'
             XLA_EVENTS.process_status_code is 'P'
             XLA_EVENTS.event_status_code is 'P'

·         Once it is finally accounted you can NOT run create accounting on the particular transaction (specifically on that event).
·         It will transfer the journal entries to GL using Journal Import and you can find the data in GL_JE_HEADERS and GL_JE_LINES.
         XLA_AE_HEADERS.transfer_status_code is Y.
         It will post to gl_balances i.e. GL_JE_HEADERS.status is 'P'

1 comment:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, BI Publisher, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete