XLA_EVENTS Status Not Being Updated On Manual Subledger Accounting Journals (Doc ID 1119736.1)

Last updated on AUGUST 10, 2017

Applies to:

Oracle Receivables - Version 12.0.6 and later
Information in this document applies to any platform.

Symptoms

MANUAL journals, when created through SLA UI page remain in U statuses, even though the header/lines are transferred to GL.

When creating a Journal of ENTITY_CODE = 'MANUAL' in SLA the Manual journal will stay in Unprocessed status after Create Accounting is run.

The application lets you proceed and complete and post the journal.

The system submits Create Accounting and Transfer to GL  successfully.

When viewing the XLA_EVENTS table, both EVENT_STATUS_CODE and PROCESS_STATUS_CODE are still displaying Status = "U."
The corresponding header record in the XLA_AE_HEADERS table displays GL_TRANSFER_STATUS_CODE = "Y."

This is causing a problem for closing periods in that it sees the "U" on xla_events table and will not let the Close of the period.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms