OPM Subledger Transactions have been transferred to GL

OPM Subledger Transactions have been transferred to GL

In order to transfer transactions to GL if this hasn't be done in Create Accounting itself, don't re-run Create Accounting but the concurrent program 'Transfer Journal Entries to GL'.

This can be done using the Standard Report Submission form :
  OPM Financials > Reports > Standard > Run >> Single Request
  Select 'Transfer Journal Entries to GL' from the LOV

In order to check whether all the transactions have been transferred to GL once Create Accounting has been run in Final Mode and the Transfer to GL program has also been run then run scripts similar to these and check the results.

select EVENT_TYPE_CODE, GL_TRANSFER_STATUS_CODE, count(*) from xla_ae_headers
where ACCOUNTING_DATE>='01-JAN-2011'
and ACCOUNTING_DATE <'01-FEB-2011'
and GL_TRANSFER_STATUS_CODE <>'Y'
and application_id=555
group by EVENT_TYPE_CODE, GL_TRANSFER_STATUS_CODE


select * from xla_ae_headers
where ACCOUNTING_DATE>='01-JAN-2011'
and ACCOUNTING_DATE <'01-FEB-2011'
and GL_TRANSFER_STATUS_CODE <>'Y'
and application_id=555