How to Change Inventory Accouting Period status from Closed Not Summary to Closed

Applies to:

Oracle Cost Management - Version: 12.0.4 and later   [Release: 12 and later]
Information in this document applies to any platform.
CSTRPCRE

Symptoms

On : 12.0.4 version,
When attempting to close a period the following error was received and Inventory Accounting status changed to Closed not summary.

ERROR in CSTRPCRE module: Period Close Reconciliation Report
-----------------------
MSG-00000: Run to date is unspecified. Defaulting to 03-APR-10
MSG-00000: calling summarization package
MSG-02000: Failure in summarization package.
MSG-00999: 100: User-Defined Exception
MSG-00999: CSTRPCRE >X Wed Apr 21 14:3:41 2010
REP-0771: After Form trigger failed.
 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Inventory --> Accounting Close Cycle --> Inventory Accounting Periods

Cause

Period of March (prior period) needed to be summarized so April period could be closed.

The reason why the Period Close Reconciliation Report completes with error when the same is fired automatically during period close is that the period rec report has not yet run successfully for prior period(s) and the prior period(s) are still unsummarized. So you have to run the period reconciliation report for the first unsummarized period and then the second then the third in sequence.

Solution

1) Run the Period Close Reconciliation Report manually (separately) from Cost Responsibility. Navigate to Cost responsibility > Reports > Cost > Value. Select the Period Close Reconciliation Report and run the report for the accounting period to be summarized.

2) The reason why the Period Close Reconciliation Report completes with error when the same is fired automatically during period close is that the period rec report has not yet run successfully for prior
period(s) and the prior period(s) are still unsummarized. So the customer has to run the period reconciliation report for the first unsummarized period and then the second then the third in sequence.

By running the Period Close Recon Report in TEST to close the months with "Closed Not Summarized" periods - and closing the next open period, customer was able to close normally (no more errors).

3) The request is failing because there is no space left in the tablespace APPS_TS_SUMMARY.
Extend this tablespace APPS_TS_SUMMARY and re-run the process and verify if the issue is resolved

Diagnostic script for table space issue, output should not contain any errors.

References

NOTE:1218043.1 - Period Close Reconciliation Report MSG-00999: CSTRPCRE
NOTE:459669.1 - CSTRPCRE PERIOD CLOSE RECONCILIATION REPORT ERR MSG-02000 MSG-00999
NOTE:469856.1 - Running Certain Reports Fails With Error "APP-FND-01242" or Enter a value for Organization id parameter or Profile MFG_ORGANIZATION_ID
SUNBUG:4964512