My Oracle Support Banner

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

Last updated on FEBRUARY 15, 2019

Applies to:

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


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.




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.