EAP: Withholding Reporting (AP_WTHDRPT) process abends at Step AP_WTHDRPT.MAIN.00007

(Doc ID 2303537.1)

Last updated on OCTOBER 03, 2017

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

 
ISSUE:
 
AP_WTHDRPT ran to no success with the following error.


ERROR:
 
cannot insert NULL into (""SYSADM"".""PS_WTHD_RPT_TBL"".""REPORT_BOND_PREM"")

Error Position: 0 Return: 1400 - ORA-01400: cannot insert NULL into (""SYSADM"".""PS_WTHD_RPT_TBL"".""REPORT_BOND_PREM"")

Process 2685016 ABENDED at Step AP_WTHDRPT.MAIN.00007 (SQL) -- RC = 1400 (108,524)

 
STEPS:

1. Create vouchers for withholding vendors
2. Pay the vouchers
3. Post the payments
4. Run Post withholding
5. Run Withholding post
6. Run Withholding Report.

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