Bug Fix 21890707 Applied But Still Receiving PC_AP_TO_PC ABENDED at Step PC_AP_TO_PC.MAIN.40000000 (SQL) -- RC = 805 (Doc ID 2221542.1)

Last updated on JULY 25, 2017

Applies to:

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

Symptoms

On : 9.2 version, AP Integration

When attempting to PC_AP_TO_PC, the following error occurs in the scenario listed below

ERROR
-----------------------
Process 52581 ABENDED at Step PC_AP_TO_PC.MAIN.40000000 (SQL) -- RC = 805

REPLICATION STEPS
-----------------------------------
Earlier replication steps reported in bug 21890707

1. The frequency of the problem happening depends on the length of process_instance
2. Create a Project and Activity
3. Create a Voucher with an account and Project Info.
4. Post the voucher
5. Run PC_AP_TO_PC
6. Table PROJ_RESOURCE is populated with voucher information
7. Unpost the voucher, Change the account to a different account and repost it
8. Run PC_AP_TO_PC
9. See that the process abends with the above error message


Related to <Bug 21890707> - PC_AP_TO_PC PROCESS ABENDED AT STEP PC_AP_TO_PC.MAIN.40000000 -- RC = 805

Earlier <Bug 21890707> attempted to resolve when process_instance is < 6

But the problem seems happening more frequently when the length of process instance becomes a 7 digit number.

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