Subledger Period Close Exceptions Report Completes In Error

(Doc ID 1341621.1)

Last updated on MARCH 10, 2016

Applies to:

Oracle Financials Accounting Hub - Version: 12.1.3 and later   [Release: 12.1 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

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