XLA_EVENTS Status Not Being Updated On Manual Subledger Accounting Journals
Last updated on AUGUST 10, 2017
Applies to:Oracle Receivables - Version 12.0.6 and later
Information in this document applies to any platform.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms