EAR 9.1+: ABENDED at Step AR_FG_PROC.SENDPMT.Step01 (PeopleCode) -- RC = 24 (Doc ID 1684471.1)

Last updated on MARCH 09, 2017

Applies to:

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

Symptoms

ENVIRONMENT
-------------------------
9.1 bundle 16

Statement of Issue
-----------------------------------
ABENDED at Step AR_FG_PROC.SENDPMT.Step01 (PeopleCode) -- RC = 24.
This issue happens when a customer has a different remit from customer

Error Message
-----------
ABENDED at Step AR_FG_PROC.SENDPMT.Step01 (PeopleCode) -- RC = 24
AR_FG_PROC SENDPMT Step01 PeopleCode 24
Error Position: 0 Return: 1400 - ORA-01400: cannot insert NULL into ("EMDBO"."PS_PMT_DETAIL_STG"."PYMNT_DT") Failed SQL stmt: INSERT INTO PS_PMT_DETAIL_STG (PMT_MSG_ID,PMT_SEQ_NUM,PMT_SOURCE,BUSINESS_UNIT,SRC_ REF_ID,AMOUNT,AMOUNT_CURRENCY_CD,PMT_STATUS,PMT_TYPE,BANK_SETID,BANK_CD,BANK_ACCT_KEY,FROM_BNK_ID_NB R,FROM_BNK_ACCT_NUM,FROM_DFI_ID_NUM,FROM_DFI_ID_QUAL,PYMNT_METHOD,FORMAT_ID,PRENOTE_FLAG,PAY_IMMEDIA TELY,COUNTRY,BANK_ID_QUAL,BNK_ID_NBR,BRANCH_ID,BANK_ACCT_TYPE,BANK_ACCOUNT_NUM,CHECK_DIGIT,DFI_ID_QU AL,DFI_ID_NUM,BANK_NAME,BANK_NAME_AC,BRANCH_DESCR,BRANCH_NAME_AC,BIC_ID,IBAN_CHECK_DIGIT,IBAN_ID,PAR TY_ID_TYPE,PARTY_SETID,PARTY_ID,NAME1,NAME1_AC,NAME2,STD_ID_NUM,STD_ID_NUM_QUAL,EFT_PYMNT_FMT_CD,EFT _RTNG_FLG,EFT_RTNG_STATUS,EFT_TRANS_HANDLING,EFT_DOM_COSTS_CD,EFT_CORR_COSTS_CD,EFT_CROSSED_CHECK,EF

Steps to Replicate
----------------------------
1. Set up customer that has a different remit from customer
2. Post Direct Debit Item
3. Create Direct Debit and Remit
4. Run AR_FG_PROC

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