Last updated on SEPTEMBER 08, 2014
Applies to:PeopleSoft Enterprise SCM Purchasing - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.
PO Reqload process is abending when Book Code is selected and Ledgers for a Unit is set to "By Ledger Code".
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
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
SQL Error: ORA-01427: single-row subquery returns more than one row
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