When Processing Projects Expenditures to the General Ledger, the Journal Import Errors with EP01 (Doc ID 3031877.1)

Last updated on FEBRUARY 03, 2025

Applies to:

Symptoms

When processing Projects Expenditures to the General Ledger, the Journal Import errors with EP01:

In Projects, the Subledger Accounting data shows the items are transferred to GL (xla_ae_headers ACCOUNTING_ENTRY_STATUS_CODE = F (final accounted) and the GL_TRANSFER_STATUS_CODE = N). 

Reporting query:

select xah.event_id,xah.ae_header_id, glp.period_name,
xah.parent_ae_header_id, xah.ledger_id, xah.accounting_date, xah.JE_CATEGORY_NAME
from xla_ae_headers xah, gl_period_statuses glp
where xah.ledger_id = 1
and xah.application_id=275
and xah.gl_transfer_status_code ='N'
and xah.upg_batch_id is NULL
and xah.period_name = glp.period_name
and glp.application_id = 101
and glp.set_of_books_id= xah.ledger_id
and glp.closing_status IN ('C','P');

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.