EEX 9.2: Payment Selection and Payment Creation (AP_APY2015 AE Program) Abends at Step AP_APY2015.V_INIT.Step01 for DB2 Database Platform
(Doc ID 2711562.1)
Last updated on SEPTEMBER 16, 2020
Applies to:PeopleSoft Enterprise FIN Expenses - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
Having completed a systems upgrade to PeopleSoft Enterprise FSCM 9.2 Image #36, the Pay Cycle process (AP_APY2015 AE Program) is abending at Step AP_APY2015.V_INIT.Step01 with in Error Message stating that the SQL Statement is out of range. This problem happens when the below criteria are met:
1) The FSCM 9.2 environment must be a DB2 Database Platform, as this is a platform specific problem
2) The Pay Cycle abended is trying to process Expense Reports and/or Cash Advances (Any transaction source different than Accounts Payable Vouchers)
1.- Upgrade a DB2 system to PeopleSoft Enterprise FSCM 9.2 Image #36
2.- Create a new Expense Report, and submit it for approval
3.- Approve the submitted Expense Report
4.- Run the Expense Processing program with the options of 'Post Liabilities', and 'Stage Payments' for the newly created Expense Report
5.- Create a new Pay Cycle that will target the Expense Report transaction just staged
6.- Launch Payment Selection and Payment Creation for the new Pay Cycle created
7.- Confirm that the Pay Cycle program is abending in Error Message
" File: e:\pt85517b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1723 Error Position: 0 Return: 8631 - [IBM][CLI Driver][DB2] SQL0302N The value of a host variable in the EXECUTE or OPEN statement is out of range for its corresponding use. SQLSTATE=22001
(SQLSTATE 22001) -302
Failed SQL stmt: SELECT A.VENDOR_ID , A.ORIGIN FROM PS_VOUCHER A WHERE A.BUSINESS_UNIT = :1 AND A.VOUCHER_ID = :2 AND :3 = 'VCHR'
Process 524522 ABENDED at Step AP_APY2015.V_INIT.Step01 (SQL) -- RC = 8631 (108,524) "
At this stage, Expenses transactions, (Expense Reports, or Cash Advances), cannot be fully processed by Accounts Payable Pay Cycle, which prevents them from getting the needed Payments to reimburse the Employee's and Supplier's expenses.
Regardless of the Database Platform being used in the PeopleSoft systems, (DB2, MSSQL, Oracle, etc...), the Pay Cycle process (AP_APY2015 AE Program) should be able to handle all eligible transactions to generate the needed Payments, (Vouchers, Expense Reports, and/or Cash Advances).
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