EAP: FIN2025 process aborts with Error:'Cannot Insert Null into PS_EFT_BANK_TMP.EFT_LAYOUT_CD' (Doc ID 1347141.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

PeopleSoft Enterprise CS Student Financials - Version 9 to 9 [Release 9]
PeopleSoft Enterprise FIN Payables - Version 9 to 9.1 [Release 9]
PeopleSoft Enterprise FIN Global Components - Version 9 to 9 [Release 9]
Information in this document applies to any platform.

Symptoms

While paying Single Payment vouchers which was created by Voucher build process from the Student Financials staged data, FIN2025 sqr process abends with error. However, the Single Payment vouchers created through Regular entry page will go through all the processes successfully.

ERROR
FIN2025.SQR,Update-Bank-Rpt,Insert,PS_EFT_BANK_TMP
SQL Status = 1400, SQL Error = ORA-01400: cannot insert NULL into ("SYSADM"."PS_EFT_BANK_TMP"."EFT_LAYOUT_CD")

ISSUE: 1
1. Verify that EFT related information are properly set up in Single Payment vendor in 'EFT Options' link in 'Single Payment Vendor' tab in the navigation: Vendors > Vendor Information > Add/Update > Vendor.
2. In Student Financials, Post Refund and create a Direct Deposit voucher.
3. Run the voucher build process to create a Single Payment voucher with payment method: EFT from the staged data.
4. Navigate to the Voucher Entry page and verify 'Transfer to EFT Options' link in the 'Single Payment Vendor' tab (Accounts Payable > Vouchers > Add/Update > Regular Entry).
5. 'Payment Format' and 'Transaction Handling' fields have NULL value.
6. Approve, Budget check and Post the voucher.
7. Pay the voucher through paycycle.
8. Run FIN2025 process from 'Pay cycle Results' group box in the 'Pay Cycle Manager' page.
9. The process will abend with an error.

ISSUE: 2
1. Verify that EFT/ACH related information are properly set up in Single Payment vendor in 'EFT Options' link in 'Single Payment Vendor' tab in the navigation: Vendors > Vendor Information > Add/Update > Vendor.
     Payment Method: ACH
     Payment Format: Pay & Dep
     Transaction Handling: Pymnt Only
2. External Bank Account Setup in Navigation: Banking > Bank Accounts > External Accounts.
     Payment Method: ACH
     Layout: PPD
3. In Student Financials, Post Refund and create a Direct Deposit voucher.
4. Run the voucher build process to create a Single Payment voucher with payment method: ACH from the staged data.
5. Navigate to the Voucher Entry page and verify 'Transfer to EFT Options' link in the 'Single Payment Vendor' tab (Accounts Payable > Vouchers > Add/Update > Regular Entry).
    Payment Format: Blank
    Transaction Handling: Pay+Advice.
7. Approve, Budget check and Post the voucher.
8. Pay the voucher through paycycle.
9. Run FIN2025 process from 'Pay cycle Results' group box in the 'Pay Cycle Manager' page.
10. The process will abend with an error.

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