AP: FIN2025 Failed Cannot Insert NULL Into ("SYSADM"."PS_EFT_ADVICE_TMP"."BUS_UNIT_NAME") (Doc ID 2246404.1)

Last updated on APRIL 06, 2017

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

 

ISSUE:


FIN2025 process fails

ERROR:


SQL Error number ORA-01400: Cannot insert NULL occurred. Process request failed.
FIN2025.SQR,Update-Advice-Rpt,Insert,PS_EFT_ADVICE_TMP
SQL Status = 1400, SQL Error = ORA-01400: cannot insert NULL into ("SYSADM"."PS_EFT_ADVICE_TMP"."BUS_UNIT_NAME")

STEPS:


1. Create a new supplier
  Set payment method = ACH
  Prenotification required
2. Create a voucher for different supplier EFT Payment Method
3. Run Pay cycle > Make sure that Pre-Notification option is selected on the selection criteria
4. Process the electronic payments
5. No Success
  SQLK Error number ORA-01400: Cannot insert NULL occurred. Process request failed.
  FIN2025.SQR,Update-Advice-Rpt,Insert,PS_EFT_ADVICE_TMP
  SQL Status = 1400, SQL Error = ORA-01400: cannot insert NULL into ("SYSADM"."PS_EFT_ADVICE_TMP"."BUS_UNIT_NAME")

 

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