PO_REQLOAD - Requisition Load Process Abends Step PO_REQLOAD.CF_EDITS.LED_GRP (Doc ID 1663147.1)

Last updated on SEPTEMBER 06, 2022

Applies to:

Symptoms

PO Reqload process is abending when Book Code is selected and Ledgers for a Unit is set to "By Ledger Code". 


Environment Setup:
1.Select "Book Code" on the Installation Option page - Overall 
2.Setup multiple Book Codes on Chartfield values - Ledger Codes 
3.Set "By Ledger Code" on the Ledger for A Unit page - Definition tab 
4.Set Transaction Type "DEF" on Open Periods page for all Ledger Codes 
5.Select "By Combo Edits" for ChartField Status on Requisition Loader Defaults page - Overrides and Options 

Steps to Reproduce the Issue:
1. Add Requisition records from Stage For Loading page. 
2. Run Load Requisition process 

Error:

UPDATE PS_RQLD_BU1_T4 SET LEDGER_GROUP = ( SELECT LED.LEDGER_GROUP FROM PS_BU_LED_GRP_VW2 LED WHERE LED.BUSINESS_UNIT_GL =
PS_RQLD_BU1_T4.BUSINESS_UNIT_GL AND LED.DEFAULT_LEDGER_GRP = 'Y') WHERE PROCESS_INSTANCE = xxxxx
/
-- Row(s) affected: 0
Process 11065 ABENDED at Step PO_REQLOAD.CF_EDITS.LED_GRP (Action SQL) -- RC = XXXX
ROLLBACK

SQL Error: ORA-01427: single-row subquery returns more than one row

Cause

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