Value Chain Planning - EBS (MOSC)

MOSC Banner

Archive Summary Program runs for long time.

edited Sep 15, 2016 5:00AM in Value Chain Planning - EBS (MOSC) 2 commentsAnswered

Hi All,

Archive Summary Program is running for long time.

we ran GSS 100% on MSC schema, table stats for 10% on all problematic tables, but still Archive Summary Program (child program 'Archive One Package') is running for long time (5+ hrs).

Statements like - INTO MSC_ST_DEMANDS_F, INTO MSC_ST_SUPPLIERS_F, INTO MSC_ST_SUPPLIES_F keeps running. This is on 12.2.5.

I can see many document IDs related to this, but all bugs must have been fixed in latest version.

Appears to be performance is poor on APCC tables. Anyone have any suggestions to fine tune this, please suggest.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS VCP Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center