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

Last updated on SEPTEMBER 06, 2016

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

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