My Oracle Support Banner

EAP: FIN2025.SQR errors out, "Cannot insert NULL into ("EMDBO"."PS_EFT_ADVICE_TMP"."BUS_UNIT_NAME")" (Doc ID 1342996.1)

Last updated on MARCH 22, 2019

Applies to:

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

Symptoms

When paying a Bank Account Transfer, from an account where a GL Business Unit is not also defined as an AP Business Unit , Fin2025.SQR errors out.

ERROR
SQL Error = ORA-01400: cannot insert NULL into ("EMDBO"."PS_EFT_ADVICE_TMP"."BUS_UNIT_NAME")

STEPS

  1. Use GL BU US003 and USLE1. USLE1 is not defined also as a AP BU.
  2. Setup 2 External Accounts, with payment method EFT and layout PPD.  One account has associated as GL BU USLE1 and the other one US003.
  3. Define an internal account for the above GL BU's 
  4. Create a bank account transfer from BU USLE1.   FROM account is the one which has as the GL BU USLE1 and TO account is the one which has as the GL BU US003.
  5. Select and approve (if necessary) the settlement 
  6. Create and run Pay Cycle .  Payment is created.
  7. Run FIN2025
  8. Above error will occur

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.