Skip navigation.

R12 - XLA / FAH - Difference between Draft, Final, etc in Create Accounting / Online Accounting

vamsi kasina's picture

Online Accounting: (For single entity / transaction)

Only few subledgers are providing this feature.

Draft 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. But the xla_ae_headers.accounting_entry_status_code is D and also the xla_events.process_status_code is D and 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 will create journal entries, which can be transferred to GL.
You can see the accounting in xla_ae_headers and xla_ae_lines. But the xla_ae_headers.accounting_entry_status_code is F and also the xla_events.process_status_code is P and event_status_code is P.
Once it is finally accounted, create accounting on the particular transaction can't be run again(specifically on that event).
You can transfer them to GL using Transfer Journal Entries to GL program.

Final Post 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. But the xla_ae_headers.accounting_entry_status_code is F and also the xla_events.process_status_code is P and event_status_code is P.
Once it is finally accounted you can't 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.
Now the xla_ae_headers.transfer_status_code is Y.
And also it will post to gl_balances (gl_je_headers.status is P).

Create Accounting / Offline Accounting : (For more entities)

This is a concurrent program. Few subledgers are having wrapper programs on top of this.

Accounting Mode: Draft
It is same as Draft online accounting, but in bulk.

Accounting Mode: Final, Transfer to GL: No
It is same as Final online accounting, but in bulk. Also refer the other post.

Accounting Mode: Final, Transfer to GL: Yes, Post to GL: No
It will create journal entries in final mode, transfer them to GL.
You can see the accounting in xla_ae_headers and xla_ae_lines. But the xla_ae_headers.accounting_entry_status_code is F and also the xla_events.process_status_code is P and event_status_code is P.
Once it is finally accounted you can't 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.
Now the xla_ae_headers.transfer_status_code is Y and gl_je_headers.status is U.

Accounting Mode: Final, Transfer to GL: Yes, Post to GL: Yes
It is same as Final Post online accounting, but in bulk.

Main differencesbetween Online Accounting and Offline Accounting:

1. Report Output
2. Bulk Accounting

AttachmentSize
create_accounting_offline.JPG99.5 KB

Need PA to GL flow in R12

Hi Vamsi,

I need the technical details of PA to GL flow.
Can you please help me on this.

Thanks in advance.

R12 - How to link GL data to the subledger data or vice versa

Arthi,
Please check my other blog link http://www.orafaq.com/node/2242

By
Vamsi