Supply Chain Cost Rollup Performance Error Out With Status 3 (Doc ID 364169.1)

Last updated on FEBRUARY 11, 2017

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.

Symptoms

Supply Chain Cost Rollup concurrent Program, CSTRSCCRN, has severely degraded over the last
week. Supply Chain Cost Rollup is now taking up to 4-5 hours to complete for a range of items.
Sometimes the Request will Error out.
When run for a specific item, the Request can take anywhere from 20 minutes to 2 hours. Normally,
for 1 item, it only takes a few minutes.
When it does error out, the log file states: Program exited with status 3.

ERROR
Enter Username: kgepop: no error frame to pop to for error 600
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
Program exited with status 3
Concurrent Manager encountered an error while running Oracle*Report for your concurrent request
92884947.
Review your concurrent request log and/or report output file for more detailed information.


EXPECTATION
Expect the rollup to take only a few minutes and complete without error.

NAVIGATION
-ACP MFG SuperUser Query Only
-Change Organization to GKJ
-Other->Requests->Run
Single Request: Supply Chain Cost Rollup - No Report
Parameters:
Description:
Cost Type:Supply_Chn
Organization: (leave blank)
Assignment Set: DEFAULT ASSIGNMENT SET
Buy Cost Type: Supply_Chn
Preserve Buy Cost Details:No
Conversion Type:Corporate
Rollup Option:Full cost Rollup
Range: Range of Items
Effective Date: (leave default)
Include Unimplemented ECO's: No
Engineering Bills:No
Lot Size Option: Use Existing Lot Size
Item From: 50010000
Item To: 50030000
All other parameters not listed are left blank.


BUSINESS IMPACT
Thousands of New Items need to be recosted. At 20 minutes to 2 hours for cost rollup of one item,
this is unacceptable, and impacts production since item costs cannot be updated to reflect the
current cost.



Verified the issue via uploaded logfile for CSTRSCCRN in file
92884947_req_Completed_with_Errors.txt - which shows the error -
Enter Username: kgepop: no error frame to pop to for error 600
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
Program exited with status 3
Concurrent Manager encountered an error while running Oracle*Report for your concurrent request
92884947.

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