EAP: AP_PAYBANK Application Engine Fails With Error PS_PYCYCL_02_TMP.SEQ_NBR Invalid Identifier

(Doc ID 2343907.1)

Last updated on DECEMBER 28, 2017

Applies to:

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

Symptoms

AP_PAYBANK application engine fails with error PS_PYCYCL_02_TMP.SEQ_NBR invalid identifier

Steps:

1. Enter and save a deal that will be paid as a manual wire (Method Wire, Layout: Blank) (Deal Management> Capture Deals> Deals);
2. Make sure the status is in open;
3. Pick a pay cycle(Accounts Payable> Payments> Pay Cycle Processing> Payment Selection Criteria) , or setup a pay cycle that will pay Treasury Settlements (TR) as the source checked. Ensure that the BU and the bank account/payment method used in the deal is included in the pay cycle criteria;
4. Run "select" the payment option from pay cycle manager. The following error occurs:

"

AP_PAYBANK.BANK0001.Step07 failed with SQL Error: ORA-00904: "A"."SEQ_NBR": invalid identifier

UPDATE PS_CASH_FLOW_TR SET PAY_CYCLE = ' ', PAY_CYCLE_SEQ_NUM = 0,
PYMNT_SELCT_STATUS = 'N' WHERE PAY_CYCLE = 'GLOWIR' AND PAY_CYCLE_SEQ_NUM =
3033 AND PYMNT_SELCT_STATUS = 'R' AND SOURCE_BUS_UNIT IN ( SELECT
BUSINESS_UNIT FROM PS_PYCYCL_02_TMP A WHERE A.PAY_CYCLE = 'GLOWIR' AND
A.PAY_CYCLE_SEQ_NUM = 3033 AND A.SOURCE_TXN = 'TR' AND
PS_CASH_FLOW_TR.SOURCE_BUS_UNIT = A.BUSINESS_UNIT AND
PS_CASH_FLOW_TR.BUSINESS_DATE = A.PAY_DOC_DT AND PS_CASH_FLOW_TR.TR_SOURCE_ID

= A.PAY_DOC_ID AND PS_CASH_FLOW_TR.CASH_FLOW_LEG = A.PAY_DOC_SEQ AND
PS_CASH_FLOW_TR.SEQ_NBR = A.SEQ_NBR AND PS_CASH_FLOW_TR.TR_SOURCE_CD =
A.PYCYCL_KEY_FIELD1 AND PS_CASH_FLOW_TR.BUSINESS_DATE = A.PYCYCL_KEY_FIELD2
AND PS_CASH_FLOW_TR.CASH_FLOW_LINE = A.PYCYCL_KEY_FIELD3)
/
-- Row(s) affected: 0
-- 10:53:56.474 Process 3770278 ABENDED at Step AP_PAYBANK.BANK0001.Step07
(Action SQL) -- RC = 904
ROLLBACK
/
-- 10:53:56.481 SQL Error: ORA-00904: "A"."SEQ_NBR": invalid identifier

"

 

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