EAP: AP_WTHDRPT Process Fails at Step AP_WTHDRPT.MAIN.000013 With Unique Constraint Error on PS_WTHD_RPT_TBL (Doc ID 2039292.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

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

Symptoms

AP_WTHDRPT process fails at step AP_WTHDRPT.MAIN.000013 with the following error

Error
------
SQL Error: ORA-01400: cannot insert NULL into ("SYSADM"."PS_WTHD_RPT_TBL"."BOND_PREMIUM")

Steps
------
1. On Vendor Address tab of the Vendor for USA1099001, under Payment/Withholding Alt Names section, enter name for Name1 and Withholding Name 1 and save the Vendor.
2. Create a Voucher for US001 BU for Vendor USA1099001.
3. Post the Voucher.
4. Record the Payment.
5. Post the Payment.
6. Post the Withholding which populates data into WTD_TRXN_TBL.
7. Navigate to Suppliers > 1099/Global Withholding > Global Withholding reports > Create Report Information and run the process which abends with the above error.



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