EAP: Step DCAP24941462.MAIN.STEP01 abends - Cannot update ("SYSADM"."PS_VCHR_LINE_WTHD"."WTHD_RULE") to NULL (Doc ID 2259898.1)

Last updated on JUNE 16, 2017

Applies to:

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

Symptoms

When trying to run the conversion program for DCAP24941462, process abends at Step DCAP24941462.MAIN.Step01 with an error.

There  are about 6.8 million rows with a blank WTHD_RULE on VCHR_LINE_WTHD.

There is a scenario where some Suppliers, at one point in time, were setup for Withholding but now, they are no longer setup for Withholding.  However, these Suppliers have old Vouchers on VCHR_LINE_WTHD where the WTHD_RULE is blank.  Since these Suppliers are no longer setup for Withholding, the conversion program for DCAP24941462 will never be able to populate the WTHD_RULE with a valid value.  So, Step DCAP24941462.MAIN.Step01 will always abend for the Vouchers associated to Suppliers that are no longer setup for Withholding.

Need a way to update the blank WTHD_RULE on VCHR_LINE_WTHD where the Supplier is no longer setup for Withholding.

ERROR
Cannot update ("SYSADM"."PS_VCHR_LINE_WTHD"."WTHD_RULE") to NULL

STEPS
1.  Apply Image #23
2.  Run the conversion program for DCAP24941462
3.  Step DCAP24941462.MAIN.Step01 abends with the above error.

Changes

 

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