EEX9.1: Pay Cycle Payment Selection is Failing at AP_PAYSELECT.A0012000.Step01 (SQL) as EMPL_RCD Field is Not Found in PS_EX_SUMM_PYMNT Record. (Doc ID 1917136.1)

Last updated on JUNE 19, 2017

Applies to:

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

Symptoms

Pay Cycle fails when processing Expense Report payments. It works fine for Cash Advance and Voucher payments.

Steps:
---------
1) Create and approve an expense report.
2) Stage the expense report for payment.
3) Run Pay Cycle to create payment

Error Message:
----------------------

ORA-00904: "EMPL_RCD": identificador no válido

INSERT INTO PS_PYCYCL_01_TMP (ADDRESS1 ,ADDRESS2 ,ADDRESS3 ,ADDRESS4 ,ADDRESS_SEQ_NUM ,ADDR_FIELD1 ,ADDR_FIELD2 ,ADDR_FIELD3 ,APPL_CREDIT_STATUS ,BANK_ACCT_KEY ,BANK_ACCT_SEQ_NBR ,BANK_CD ,BANK_RPL_STATUS ,BANK_SETID ,BASE_CURRENCY ,BASE_CURRENCY_BNK ,BNK_RATE_DIV ,BNK_RATE_MULT ,BUSINESS_UNIT ,BUSINESS_UNIT_GL ,BUS_UNIT_RELATED ,CITY ,COUNTRY ,COUNTY ,CURRENCY_PYMNT ,CUR_RT_TYPE ,CUR_RT_TYPE_BNK ,CUR_RT_TYPE_PAID ,CUR_RT_TYPE_PYMNT ,DESCR254_MIXED ,DFT_CREATE_KEY ,DFT_GROUP_CD ,DFT_MASTER_ID ,DFT_SIGHT_CD ,DOC_SEQ_NBR ,DOC_SEQ_STATUS ,DOC_TYPE ,DSCNT_AMT_BSE ,DSCNT_PAY_AMT ,DUE_DT ,ECN_DSCNT_DNIE_FLG ,EFT_CHECK_DRAW_CD ,EFT_CHECK_FWRD_CD ,EFT_CORR_COSTS_CD ,EFT_CROSSED_CHECK ,EFT_DOM_COSTS_CD ,EFT_KEY_FIELD1 ,EFT_KEY_FIELD2 ,EFT_KEY_FIELD3 ,EFT_KEY_FIELD5 ,EFT_KEY_FIELD6 ,EFT_LAYOUT_CD ,EFT_PAY_INST_CD1 ,EFT_PAY_INST_CD2 ,EFT_PAY_INST_CD3 ,EFT_PAY_INST_CD4 ,EFT_PAY_INST_REF1 ,EFT_PAY_INST_REF2 ,EFT_PYMNT_FMT_CD ,EFT_RTNG_FLG ,EFT_RTNG_STATUS ,EFT_TRANS_HANDLING ,EMPLID ,EXCEPTION_FLAG ,GEO_CODE ,GROSS_AMT_BSE ,GRP_AP_ID ,GRP_PYMNT_DT ,HOL_PROC_DAYS ,HOL_PROC_OPT ,HOL_PROC_OVERFL ,HOUSE_TYPE ,INFO_ONLY_FLG ,INVOICE_ID ,IN_CITY_LIMIT ,IPAC_PYMNT_FLG ,LATE_CHRG_AMT ,LATE_CHRG_AMT_BSE ,LATE_CHRG_CD ,LATE_CHRG_DNIE ,LATE_CHRG_DNIE_BSE ,LATE_CHRG_OPT ,LATE_CHRG_PAID ,LATE_CHRG_PAID_BSE ,LC_ID ,NAME1 ,NAME1_AC ,NAME2 ,NAME2_AC ,NUM1 ,NUM2 ,PAID_AMT ,PAID_AMT_BNK_BSE ,PAID_AMT_BSE ,PAID_AMT_DSCNT ,PAID_AMT_DSCNT_BSE ,PAID_AMT_GROSS ,PAID_AMT_GROSS_BSE ,PAID_RATE_DIV ,PAID_RATE_MULT ,PAY_CYCLE ,PAY_CYCLE_SEQ_NUM ,PAY_DOC_DT ,PAY_DOC_ID ,PAY_DOC_SEQ ,PAY_SCHEDULE_TYPE ,POSTAL ,PREFERRED_LANGUAGE ,PRENOTE_STATUS ,PROCESS_INSTANCE ,PYCYCL_FIELD1 ,PYCYCL_FIELD10 ,PYCYCL_FIELD2 ,PYCYCL_FIELD3 ,PYCYCL_FIELD4 ,PYCYCL_FIELD5 ,PYCYCL_FIELD6 ,PYCYCL_FIELD7 ,PYCYCL_FIELD8 ,PYCYCL_FIELD9 ,PYCYCL_KEY_FIELD1 ,PYCYCL_KEY_FIELD3 ,PYMNT_CNT_RELATED ,PYMNT_GROSS_AMT ,PYMNT_GROUP_CD ,PYMNT_HANDLING_CD ,PYMNT_ID ,PYMNT_IMAGE_ID ,PYMNT_MESSAGE ,PYMNT_METHOD ,PYMNT_RATE_DIV ,PYMNT_RATE_MULT ,PYMNT_REASON_CD ,PYMNT_SELCT_STATUS ,PYMNT_SEPARATE ,PYMNT_SORT_CD ,RATE_DIV ,RATE_MULT ,REBATE_MAX_PERCENT ,REBATE_PERCENT ,REBATE_TERM_FLG ,REMIT_BANK_CD ,REMIT_BANK_SETID ,REMIT_BNK_ACCT_KEY ,REMIT_SETID ,REMIT_VENDOR ,SCHEDULED_PAY_DT ,SCHEDULE_ID ,SINGLE_PYMNT_FLG ,SOURCE_TXN ,SPEC_PYMNT_EX_RT ,STATE ,STL_THROUGH ,STTLMNT_DT_EST ,TXN_CURRENCY_CD ,VENDOR_NAME_SHORT ,VNDR_LOC ,VNDR_SERVICE_TYPE ,VOUCHER_ID ,VOUCHER_ID_RELATED ,WTHD_SW) SELECT ADDRESS1 ,ADDRESS2 ,ADDRESS3 ,ADDRESS4 ,ADDRESS_SEQ_NUM ,' ' ,' ' ,' ' ,'N' ,BANK_ACCT_KEY ,0 ,BANK_CD ,' ' ,BANK_SETID ,BASE_CURRENCY ,' ' ,0 ,0 ,BUSINESS_UNIT_GL ,' ' ,' ' ,CITY ,COUNTRY ,COUNTY ,' ' ,RT_TYPE ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,0 ,0 ,DUE_DT ,'N' ,EFT_CHECK_DRAW_CD ,EFT_CHECK_FWRD_CD ,EFT_CORR_COSTS_CD ,EFT_CROSSED_CHECK ,EFT_DOM_COSTS_CD ,' ' ,' ' ,' ' ,EMPL_RCD ,0 ,' ' ,EFT_PAY_INST_CD1 ,EFT_PAY_INST_CD2 ,EFT_PAY_INST_CD3 ,EFT_PAY_INST_CD4 ,EFT_PAY_INST_REF1 ,EFT_PAY_INST_REF2 ,EFT_PYMNT_FMT_CD ,'D' ,EFT_RTNG_STATUS ,EFT_TRANS_HANDLING ,EMPLID ,' ' ,GEO_CODE ,GROSS_AMT_BSE ,' ' ,'N' ,0 ,' ' ,' ' ,HOUSE_TYPE ,'N' ,INVOICE_ID ,IN_CITY_LIMIT ,' ' ,0 ,0 ,' ' ,0 ,0 ,'N' ,0 ,0 ,' ' ,NAME1 ,NAME1_AC ,NAME2 ,NAME2_AC ,NUM1 ,NUM2 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,'PA001' ,13 ,TRANS_DT ,SHEET_ID ,LINE_NBR ,' ' ,POSTAL ,PREFERRED_LANGUAGE ,' ' ,0 ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,SEQ_NBR ,0 ,PYMNT_GROSS_AMT ,' ' ,' ' ,' ' ,0 ,REFERENCE_ID ,PYMNT_METHOD ,0 ,0 ,' ' ,PYMNT_SELCT_STATUS ,'N' ,0 ,RATE_DIV ,RATE_MULT ,0 ,0 ,' ' ,REMIT_BANK_CD ,REMIT_BANK_SETID ,REMIT_BNK_ACCT_KEY ,REMIT_SETID ,REMIT_VENDOR ,SCHEDULED_PAY_DT ,' ' ,'N' ,'EXPN' ,'N' ,STATE ,' ' ,STTLMNT_DT_EST ,TXN_CURRENCY_CD ,VENDOR_NAME_SHORT ,VNDR_LOC ,' ' ,' ' ,' ' ,' ' FROM PS_EX_SUMM_PYMNT WHERE PYMNT_SELCT_STATUS = 'N' AND PYMNT_HOLD = 'N' AND PS_EX_SUMM_PYMNT.SEQ_NBR = ( SELECT MAX(A.SEQ_NBR) FROM PS_EX_SUMM_PYMNT A WHERE A.SHEET_ID=PS_EX_SUMM_PYMNT.SHEET_ID AND A.LINE_NBR=PS_EX_SUMM_PYMNT.LINE_NBR) AND EX_PYMNT_DEST='A'

Proceso 636684 interrumpido en paso AP_PAYSELECT.A0012000.Step01 (SQL); cd retorno = 904 (108,524)

Business impact:
----------------------
Further testing related to expense report payment is impacted.

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