Payables Purge Process (APXPGSUB) Throws Error APP-SQLAP-10014 (Doc ID 2146232.1)

Last updated on JUNE 29, 2016

Applies to:

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

Symptoms

On : 12.1.3 version, Purge and PurgeReports

Payables Purge Process throws Error (APXPGSUB)

When attempting to Abort/Restart/Confirm the Submit Purge (Payables Purge) two errors are thrown:
FRM-40657: Record changed or deleted by another user
APP-SQLAP-10014: You cannot commit before you enter values in all required fields.

A review of the FRD Trace showed the following error:

FRM-40212: Invalid value for field OPERATING_UNIT.

ERROR
-----------------------
FRM-40657: Record changed or deleted by another user
APP-SQLAP-10014: You cannot commit before you enter values in all required fields.
FRM-40212: Invalid value for field OPERATING_UNIT.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. In the Payables Purge responsibility, create a purge
2. Select Initiate


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