EGL9.2: Commitment Control Budget Checking Process (FS_BP) Abends At Step FS_BP_FSRC.iFSLqdTO.uFSLqdTO With 'ORA-01427: Single-row Subquery Returns More Than One Row' Error

(Doc ID 2356004.1)

Last updated on FEBRUARY 03, 2018

Applies to:

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

Symptoms

Issue:
-------

Commitment control budget checking process (FS_BP) abends at FS_BP_FSRC.iFSLqdTO.uFSLqdTO.

Steps to Replicate:
---------------------

  1. Create a PO with two lines. Set the Receiving Required as Optional. Set the GL BU.Populate the PC BU, Project ,Activity and Budget Check and Dispatch the PO.
  2. Create a Voucher by copying the first PO line with partial quantity.
  3. Again add a line by copying the first PO line with the remaining quantity. Thus voucher is created with two lines.
  4. Budget check the voucher.
  5. Now delete the second line on the voucher
  6. Add a new line by copying the second PO line.
  7. Save the Voucher.
  8. Run Budget Check.


See the replication screenshots for more details.

Error:
------
Process 1549873 ABENDED at Step FS_BP_FSRC.iFSLqdTO.uFSLqdTO (Action SQL)
ORA - 01427: single-row subquery returns more than once row

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