11i: ARXSUMPS Unable To Close Period Due To Unposted Items In Cash Basis Accounting (Doc ID 334332.1)

Last updated on APRIL 17, 2017

Applies to:

Oracle Receivables - Version 11.5.8 to 11.5.10.3 [Release 11.5.8 to 11.5.10]
Information in this document applies to any platform.
FORM:ARXSUMPS.FMB - Open/Close Accounting Periods


Symptoms

Unable to close period due to unposted adjustments.

Cash Basis Accounting method is used.

It is normal to have unposted items in Cash Basis Accounting as transactions are posted only when receipt application occurs.

The unposted items report does not show any unposted items.

They are using ARGLTP standard transfer to GL program.

The period close diagnostic from <Note 255941.1> shows there are 674 unposted items in RA_CUST_TRX_LINE_GL_DIST_ALL and there are 3 unposted items in AR_ADJUSTMENTS_ALL
These transactions are either unpaid invoices or invoices where they have entered an adjustment to cancel the invoice.        

The invoice and the adjustment will never be posted to GL since there will never be any receipt applied.

Cash Basis Accounting already ignores the records in RA_CUST_TRX_LINE_GL_DIST_ALL, but it does not ignore the records in AR_ADJUSTMENTS_ALL.

The following script will identify if there are any records in these 2 tables that would prevent the period being closed when Cash Basis Accounting is used.

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