My Oracle Support Banner

APP-SQLAP-10304 Cannot Close Period And No Data On Period Exception Report (Doc ID 1479903.1)

Last updated on JULY 30, 2024

Applies to:

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

Symptoms

Cannot close Payables period.

Invoice is not accounting and preventing the period from closing

The following error raises when attempting to closing the accounts payable (AP) period:

APP-SQLAP-10304: You cannot close this period because
exceptions exist

Please review and resolve all exceptions that are listed in
the Period Close Exceptions Report.  Choose the Exceptions
button to submit this report.

This is message code AP_SET_CANNOT_CLOSED_PERIOD.

A FND Debug Log of the issue reproduced shows the following:

Total records inserted in ap_period_close_excps_gt for source_type=LINES_WITHOUT_DISTS is:3
get_unposted_transactions: return value: lv_exists=Y
AP_UNACCT_TRXS_EXISTS - Unaccounted Invoices and/or payments

 

The output of the "Period Close Exceptions Report" executed for the same period attempted to close, shows "No Data Found"

 

Steps to reproduce:

  1. Log into Oracle Applications using a Payables responsibility.
  2. Access the option "Accounting -> Control Payables Period" (Form executable APXSUMPS.fmb/fmx)
  3. Place the cursor on the Period to close
  4. Select "Close" from the List of Values (LOV) for "Period Status".
    You get the popup error message described.
     
  5. Run the Period Close Exceptions Report for the same Period.
    The report output shows "No Data Found".

 

Changes

 

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!

In this Document
Symptoms
Changes
Cause
Solution
References


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