EAP: Inconsistent Error (7000,1111) when Saving Procurement Control Page (Doc ID 1941170.1)

Last updated on MARCH 18, 2016

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When changing the effective date on the Withholding tab of the Procurement Control page for a business unit that does not have withholding setup, the system is firing the following error on saving:

"The row with withholding entity, type, jurisdiction, class is not consistent. (7000,1111)"

However, this is not the case when saving after navigating to any of the other tabs. The system does not fire the error and saves the page.

The error should fire in all cases, to prevent saving effective dated row when there is no withholding information.

STEPS
1. Query PS_WTHD_BU_HDR for BU with no withholding info
2. Navigate to Set Up Financials/Supply Chain > Business Unit Related > Procurement > Procurement Control, and change the effective date on the Withholding tab and do not give any detail information: Getting error on save
4. Go to another tab (ERS Options for example) and it saves successfully with the new date
5. Query PS_WTHD_BU_HDR

The new date is reflected there.

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