R12 EBS Enterprise Command Center (ECC) No Data Available In Oracle Projects Command Center Dashboard - Projects Costing Budgetary Control ECC Data Load Program Completes in Error for Balances DataseORA-01427: Single-Row Subquery Returns More Than One Row (Doc ID 2794971.1)

Last updated on OCTOBER 17, 2023

Applies to:

Symptoms

Run the Projects Costing Budgetary Control ECC Data Load concurrent program to load data for Budgetary Control dashboard. Run the Projects Costing and Billing ECC Data Load concurrent program to load data for the Costing, Capital, and Billing dashboards. You can navigate to these concurrent programs from the Requests page in Oracle Projects.

Projects Costing Budgetary Control EBS Enterprise Command Center (ECC) Data Load

ECC - Data Load For Projects Costing Budgetary Control (ECC Run Data Load)
--Failed with ORA-01427: single-row subquery returns more than one row

Projects Costing Budgetary Control ECC Data Load program completes in error for Balances dataset, because of which the information is not available in Budgetary Control Dashboard.

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.