My Oracle Support Banner

EAP: SQL Error When Creating Manual Payment through Build Worksheet: "Error 805 - ORA-00001: unique constraint (SYSADM.PS_APD_MANDFT_WS) violated on APD_MANDFT_WRK.BUILD_WORKSHEET" (Doc ID 2754025.1)

Last updated on FEBRUARY 28, 2021

Applies to:

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

Symptoms

When attempting to create a manual payment for one particular vendor by clicking on Build Worksheet, below SQL error occurs:

Steps:

  1. Create withholding voucher.
  2. Try to pay it manually, by creating a manual payment.
  3. Uncheck withholding calculated.
  4. When clicking on Build Worksheet, the above error is triggered.

 

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


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