Cost Rollup Stuck In Retrying Status With Error Message
(Doc ID 2744979.1)
Last updated on AUGUST 16, 2022
Applies to:
Oracle Fusion Manufacturing Cloud Service - Version 11.13.20.10.0 and laterInformation in this document applies to any platform.
Symptoms
On : 11.13.20.10.0 version, Cost Management
Cost rollup stuck in retrying status with error message
While attempting to roll up costs for the new period, the cost rollup process is stuck in retrying with the following error message in the UI:
The process ID 3746323 rollup ended in status error: errors and/or warnings encountered while Build RollupPreprocessing: Could not Restore the Rollup Data Process rolled back and aborted due to SQL Exception on RebuildRollupData/updateResourceCosts: ORA-01427: single-row subquery returns more than one row .
ERROR
-----------------------
ORA-01427
The process ID 3746323 rollup ended in status error: errors and/or warnings encountered while Build RollupPreprocessing: Could not Restore the Rollup Data Process rolled back and aborted due to SQL Exception on RebuildRollupData/updateResourceCosts: ORA-01427: single-row subquery returns more than one row .
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Run the cost rollup program
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
unable to do the standard cost calculation which will impact on period close
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 |
| References |