EPY: PSPPFUND abends when processing reversal after 9.1 upgrade (Doc ID 1205554.1)

Last updated on AUGUST 01, 2014

Applies to:

PeopleSoft Enterprise HRMS Payroll for North America - Version: 9.1 to 9.1 - Release: 9 to 9
Information in this document applies to any platform.

Symptoms

PSPPFUND is ending in error for any check reversal where the employee moved from the COMPANY/PAYROUP on the original check to a different COMPANY/PAYGROUP before the upgrade process was run.

This is caused by PeopleCode in UPG_PY90.HCPYP10C.Step1 GET_COMPANY_PAYGROUP_BUSUGL().

This PeopleCode in the upgrade process grabs the employee's current COMPANY/PAYGROUP on JOB when converting BUDGET_ACTUALS, rather than the COMPANY/PAYGROUP in effect when the check was produced. As a result a proper row for the original COMPANY/PAYGROUP doesn't exist in BUDGET_ACTUALS or HP_DOC_ID_XREF, causing PSPPFUND to crash with the following message:

Application Program Failed
In Pgm Section : PSPPFUND - GET-DOC-ID(FETCH)
With Return Code: 00001
Error Message : ORA-00942: table or view does not exist
at pos 00021
at pos 00021
at pos 00021

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