My Oracle Support Banner

AP9.2.Pay Cycle Process (AP_APY2015) Has Abended at Step AP_PAYSELECT.A0009000.Step01( SQL)-RC=805 With Error "The paycycle has not processed successfully (7250,155).The paycycle payment selection of Payment creation has failed.Check message log for any. (Doc ID 2804614.1)

Last updated on SEPTEMBER 03, 2021

Applies to:

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

Symptoms

Pay Cycle process (AP_APY2015) is running to No Success for pay cycles with selection criteria having 'Use Supplier Pay Group' checkbox unchecked. This issue started appearing post recent Image Upgrade (From Image 28 to Image 40).


ERROR
-----------------------

 The paycycle has not processed successfully (7250,155).The paycycle payment selection of Payment creation has failed.Check message log for any messages.Once the problem has been resolved , reset your paycycle and resume processing.
ORA-0001:unique constraint( SYSADM.PS_PYMNT_STG_TMP) violated.Failed SQL stmt :INSERT INTO PS_PYMNT_STG_TMP (...
PROCESS ABENDED at STEP AP_PAYSELECT.A0009000.Step01( SQL) --RC=805


STEPS
-----------------------
The issue can be reproduced at will with the following steps:


1. Setup paycycle with Use Supplier Pay Group' checkbox unchecked using the navigation : Account Payables>Payment>Paycycle Manager
2. Run paycycle select process
3. Error appears


 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.