EAP: Step DCAP24941462.MAIN.STEP01 abends - Cannot update ("SYSADM"."PS_VCHR_LINE_WTHD"."WTHD_RULE") to NULL
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.
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.
Cannot update ("SYSADM"."PS_VCHR_LINE_WTHD"."WTHD_RULE") to NULL
1. Apply Image #23
2. Run the conversion program for DCAP24941462
3. Step DCAP24941462.MAIN.Step01 abends with the above error.
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