My Oracle Support Banner

Subledger Period Close Exceptions Report Completes In Error (Doc ID 1341621.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Financials Accounting Hub - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Subledger Period Close Exceptions Report ends in error




XLAPEXRPT module: Subledger Period Close Exceptions Report
+---------------------------------------------------------------------------+
Current system time is 14-JUL-2011 13:11:20
+---------------------------------------------------------------------------+
XDO Data Engine Version No: 5.6.3
Resp: 50679
Org ID : 81
Request ID: 471307
All Parameters: P_APPLICATION_ID=20003:P_JE_SOURCE=MMA:P_LEDGER_ID=2022:P_LEDGER=MAR_US_52:P_PERIOD_FROM=APR-11:P_PERIOD_TO=APR-11:P_DUMMY_PARAM_1=1:P_EVENT_CLASS_CODE=:P_EVENT_CLASS=:P_DUMMY_PARAM_2=1:P_JE_CATEGORY_NAME=:P_JE_CATEGORY=:P_MODE=S
Data Template Code: XLAPEXRPT
Data Template Application Short Name: XLA
Debug Flag: N
{P_JE_CATEGORY=, P_EVENT_CLASS=, P_JE_CATEGORY_NAME=, P_PERIOD_TO=APR-11, P_MODE=S, P_DUMMY_PARAM_2=1, P_DUMMY_PARAM_1=1, P_EVENT_CLASS_CODE=, P_LEDGER_ID=2022, P_PERIOD_FROM=APR-11, P_APPLICATION_ID=20003, P_LEDGER=MAR_US_52, P_JE_SOURCE=MMA}
Calling XDO Data Engine...
--SQLException
java.sql.SQLException: ORA-01427: single-row subquery returns more than one row

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


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