My Oracle Support Banner

R12: AP: Control Payables Periods form (APXSUMPS): ORA-01403 error message trying to sweep during AP period closing (Doc ID 1298755.1)

Last updated on FEBRUARY 17, 2019

Applies to:

Oracle Payables - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
Control Payables Periods form - APXSUMPS


Symptoms

Control Payables Periods form (APXSUMPS)
Trying to close AP period the below standard message arises:
     --- --- ---
     APP-SQLAP-10304: You cannot close this period because exceptions exist
     --- --- ---

After running the AP Closing Exceptions Report user realizes it is caused by a specific invoice. Reviewing the causing invoice discovers that a DIST VARIANCE hold has been placed at Invoice Cancellation time.  This was an expected message, but after click on Exceptions and then try to review or sweep these exceptions using the relevant two buttons the following error message arises:
     --- --- ---
     ORA-01403: no data found
     --- --- ---

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
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.