CLOSE ACCOUNTING PERIOD STATUS IS STUCK IN PROCESSING-CSTVWORP RECEIVES ERROR: ORA-01422 (Doc ID 1062863.1)

Last updated on NOVEMBER 05, 2016

Applies to:

Oracle Cost Management - Version 11.5.10.0 to 11.5.10.3 [Release 11.5]
Information in this document applies to any platform.
***Checked for relevance on 07-AUG-2015***

Symptoms

Customer is trying to close Feb-06 Accounting Periods for several organizations, but the Periods are stuck in status = Processing. CSTVWORP - Wait on GL transfer request logfile shows the following error: 

ORACLE error 1086 in FDPSTP
Cause: FDPSTP failed due to ORA-01086: savepoint 'WAITON_REQUEST_PVT' never established
ORA-06512: at "APPS.CST_PERIODSUMMARY_PVT", line 400
ORA-01422: exact fetch returns more than requested number of rows


NAVIGATION
------------------
Inventory Super User -> Accounting Close Cycle ->Inventory Accounting Periods

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