My Oracle Support Banner

Cost Rollup Stuck In Retrying Status With Error Message (Doc ID 2744979.1)

Last updated on MARCH 22, 2021

Applies to:

Oracle Fusion Manufacturing Cloud Service - Version 11.13.20.10.0 and later
Information 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


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