Opening "View Funds Check Balances" Page For Some Projects Gives Error ORA-01427 (Doc ID 2944553.1)

Last updated on APRIL 24, 2023

Applies to:

Symptoms

On : 12.2.10 version, Funds Check

ORA-01427 error occurs when opening "View Funds Check Balances" page for some projects.

ERROR
-----------------------
Exception Details.
 oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT
summary_type
,t.project_id
,transaction_id
,pt.task_number
..
..
,document_name
,document_line_num
,document_distribution_number
,(select PV.SEGMENT1 from PO_VENDORS PV where VENDOR_NAME = a.supplier_name)
,supplier_name
,nvl(quantity,0)
,gl_period_name
,pa_period_name
,project_currency_code
,projfunc_curr_code
,denom_currency_code
,0 project_commitment_cost
,nvl(PROJECT_RAW_COST,0) project_raw_cost
,NVL(PROJECT_BURDENED_COST,0) project_burdened_cost
FROM pa_fc_actual_dtls_v a
WHERE a.project_id = :2
) t
,pa_tasks pt
WHERE t.task_number = pt.task_number
AND t.project_id = pt.project_id
ORDER BY transaction_id, TRANSACTION_DATE desc
..
..
at oracle.apps.pa.finplan.server.FpViewBudDetVOImpl.initQuery(FpViewBudDetVOImpl.java:51)
at oracle.apps.pa.finplan.webui.FpViewBudgetBalCO.processRequest(FpViewBudgetBalCO.java:313)
..
..
## Detail 0 ##
java.sql.SQLException: ORA-01427: single-row subquery returns more than one ro

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Project Super User > Projects: Delivery > Search. Search for a project
2. Open the project and navigate to Financial tab> Budgets and Forecasts
3. For plan type 'Approved Cost Budget', select Maintain Versions
4. Select the Baselines Version and execute the action 'View Funds Check Balances'
    Click on 'Go' and the next error page is displayed.

Changes

Cause

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