My Oracle Support Banner

Common Problems and Solutions Fusion Receivables Troubleshooting Guide Month End (Doc ID 1390469.1)

Last updated on JULY 31, 2020

Applies to:

Oracle Fusion Receivables - Version 11.1.1.5.1 and later
Information in this document applies to any platform.
Receivables Month End


Purpose

Summary:

As part of the month end closure process, when users close the AR period, the period close program may not always allow you to close the period due to unprocessed transactions or accounting events in the system. The period close program will report exception messages in the output file indicating what kind of unprocessed transactions and accounting events exist in the system for given period which is preventing the period close. In this document we will provide SQLs for each category of unprocessed transactions reported by the period close program

Dependent Technologies:

Oracle ADF Business Component
Oracle PL/SQL

Problem Catalog:

1. After attempting to close the AR period, the period does not close and the Period Close ESS program is completing with the following warning message in log file: You must run revenue recognition before you can close this period. How do you find the set of transactions in AR which are causing this issue?

2. After attempting to close the AR period, the period does not close and the Period Close ESS program is completing with the following warning message in the log file: You must post all transactions in this period before you can close the period. I have run the run he Create Accounting program. How do you find the set of AR transactions which remain un-posted?

3. After attempting to close the AR period, the period does not close and the Period Close ESS program is completing with the following warning message in log file: You must post all transactions in this period before you can close the period. I have run the Create Accounting program. There are no unaccounted AR transactions in the AR Sub Ledger Exceptions Report. How do you find the set of AR transactions which remain un-posted?.


4. After attempting to close the AR period, the period does not close and the Period Close ESS program is completing with the following warning message in log file: You have un-posted receipts. You must post all receipts before closing your accounting period. How do you find the set of transactions in AR which are leading to this issue.

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

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


In this Document
Purpose
 Summary:
 Dependent Technologies:
 Problem Catalog:
Troubleshooting Steps
 Problems & Solutions:
 1. After attempting to close the AR period, the period does not close and the Period Close ESS program is completing with the following warning message in log file: You must run revenue recognition before you can close this period. How do I find the set of transactions in AR which are leading to this issue.
  Following SQL can identify such transactions:
 Solution:
 2. After attempting to close the AR period, the period does not close and the Period Close ESS program is completing with the following warning message in log file: You must post all transactions in this period before you can close the period. Having run the Create Accounting program, How do you find the set of AR transactions which remain un-posted?
 Technical description of the Problem:
 Solution:
 3. After attempting to close the AR period, the period does not close and the Period Close ESS program is completing with the following warning message in log file: You must post all transactions in this period before you can close the period. I have run the Create Accounting program. There are no unaccounted AR transactions in the AR Sub Ledger Exceptions Report. How do you find the set of AR transactions which remain un-posted?.
 Technical description of the Problem:
 Solution:
 4. After attempting to close the AR period, the period does not close and the Period Close ESS program is completing with the following warning message in log file: You have un-posted receipts. You must post all receipts before closing your accounting period. How doyou find the set of transactions in AR which are leading to this issue.
 Technical description of the Problem:
 Solution:
 

5.The period closure exception report does not show any records but you are not able to close the period.

 6.How to find posted transactions.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.