My Oracle Support Banner

Unable to Close Period - No Error Listed in Subledger Exception Report (Doc ID 2868784.1)

Last updated on MAY 20, 2022

Applies to:

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

Symptoms

 When attempting to close the period, the following error message is raised:

"There are pending transactions to be posted to GL"

Below is an example of how the data may look like in the XLA_EVENTS table for a specific event_id, showing that the event is processed/posted as EVENT_STATUS_CODE and PROCESS_STATUS_CODE both have value 'P':

EVENT_ID  APPLICATION_ID   EVENT_STATUS_CODE  PROCESS_STATUS_CODE

1234567     222                            P                              P

However, the same event_id is listed as unposted in the AR tables (i.e. POSTING_CONTROL_ID = -3). The below example is using the AR_CASH_RECEIPT_HISTORY_ALL table:

CASH_RECEIPT_HISTORY_ID   POSTING_CONTROL_ID    EVENT_ID

6249043                                    -3                                1234567

6249057                                    -3                                1234567

Although the above is an example for the AR_CASH_RECEIPT_HISTORY_ALL table, similar issue may be found in the AR_RECEIVABLE_APPLICATIONS_ALL table (for CASH receipts) or in the AR_MISC_CASH_DISTRIBUTIONS_ALL table (for MISC receipts).

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.