EAP: AP_FG_PROC Fails With Cannot Insert Null Error When Bank_Acct_Seq_Nbr=0 For Wire (Doc ID 2038440.1)

Last updated on MARCH 01, 2017

Applies to:

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

Symptoms

AP_FG_PROC fails with cannot insert NULL Error when BANK_ACCT_SEQ_NBR = 0 for Wire Transfer.

Steps:
------------
1) Ensure that 'Supplier Bank Accounts' is blank for a Supplier.
2) Create a Voucher for the Supplier - Payment Method = WIRE and Settle By = Financials Gateway.
3) Click the 'Supplier Bank' link on the Payments tab, and Blank out the Bank Account Sequence Number. Click OK.
3) Save the Voucher.
4) Run Pay Cycle and execute AP_FG_PROC.


Error message:
------------------------
SQL error. Function: Record.Insert Error Position: 0 Return: 1400 - ORA-01400: cannot insert NULL into ("SYSADM"."PS_PMT_DETAIL_STG"."PYMNT_DT") Statement: 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_NBR,F ROM_BNK_ACCT_NUM,FROM_DFI_ID_NUM,FROM_DFI_ID_QUAL,PYMNT_METHOD,FORMAT_ID,PRENOTE_FLAG,PAY_IMMEDIATEL Y,COUNTRY,BANK_ID_QUAL,BNK_ID_NBR,BRANCH_ID,BANK_ACCT_TYPE,BANK_ACCOUNT_NUM,CHECK_DIGIT,DFI_ID_QUAL, DFI_ID_NUM,BANK_NAME,BANK_NAME_AC,BRANCH_DESCR,BRANCH_NAME_AC,BIC_ID,IBAN_CHECK_DIGIT,IBAN_ID,PARTY_ ID_TYPE,PARTY_SETID,PARTY_ID,NAME1,NAME1_AC,NAME2,STD_ID_NUM,STD_ID_NUM_QUAL,EFT_PYMNT_FMT_CD,EFT_RT

Fatal SQL error occurred. (2,125) PMT_LOAD.Payment.PaymentHandler.OnExecute Name:InsertRowsetAndChi ldren PCPC:8187 Statement:129 Called from:PMT_LOAD.Payment.PaymentHandler.OnExecute Name:InsertRowsetAndChildren Statement:135 Called from:PMT_LOAD.Payment.PaymentHandler.OnExecute Name:ValidateAndInsert Statement:315 Called from:PMT_LOAD.Payment.PaymentHandler.OnExecute Name:ProcessSyncPayment Statement:15 Called from:PMT_LOAD.Interface.PaymentRequestSync.OnExecute Name:Process Statement:7 Cal

Process 145491 ABENDED at Step AP_FG_PROC.SENDPMT.Step01 (PeopleCode) -- RC = 24



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